Yes. It works now. Thank you.
• 0 views
•
link
written
by
zhaolin20042008 •
Find The Number Of Simple Repeats On The Y Chromosome
I am trying to find the number of simple repeats on the Y chromosome using UCSC mysql query.
use hg19;
select count (sequence) as Numberofrepeats
from simpleRepeat where chrom = 'chrY';
The result showed "ERROR1630(4200): Function hg19.count does not exist. check the 'Funciton Name Parsing and Resolution' section in the reference manual".
If select count doesn't work, what is the commander used for replacement? Is the the reference manual online? Could anyone give me a link? Thank you.
• 2,021 views
•
link
updated
by
Sean Davis
•
written
by
zhaolin20042008 •
•
written
by
zhaolin20042008 •
1 answer
You have a space between count and the parentheses. This works fine for me:
select count(sequence) as Numberofrepeats from simpleRepeat where chrom='chrY';
• 185 views
•
link
written
by
Sean Davis
Log in to answer this question.
More posts like this
-
Snakemake + singularity fails to locate bwa index files.
written by jkim •
-
Query UCSC Browser
written by FGV
-
UCSC MySQL query to find gene symbols for all RefSeq IDs?
written by edsouza •
-
Simulating rna-seq data using Polyester package
written by statfa
-
Tutorial: InsideDNA: How to use GATK and Picard to filter low quality variants?
written by shilparaopradeep •
-
rsID from VCF
written by abdulbenissa •
-
A simple question regarding homozygous and heterozygous variation.
written by mangfu100
-
Bed File Of Mapq Sliding Window On A Bam File?
written by 14134125465346445
-
Variant Effect And The Impact Of Samples
written by User 1933 •
-
Problems Running Gkno Fastq-Tangram
written by Masaki •
