Hi Li,

If you go to the table browser (http://genome.ucsc.edu/cgi-bin/hgTables) 
select the knownGene table and click the "describe table schema" it will 
show you how many records (genes) are in the table. There are no 
duplicates in this table:

mysql> SELECT name, COUNT(*) AS Count
     -> FROM knownGene
     -> GROUP BY name
     -> HAVING Count > 1;
Empty set (0.03 sec)

Keep in mind that this is not necessarily the complete set of genes in 
humans. UCSC Genes is a fairly conservative set of "known" genes. Other 
gene sets may contain greater or fewer numbers of genes.

Please let us know if you have any additional questions: [email protected]

-
Greg Roe
UCSC Genome Bioinformatics Group



On 1/7/12 1:24 AM, yuanf li wrote:
> Dear Project:
> I just want to know how many genes are in UCSC known gene database? Removing 
> duplications? Thank you!
>
> Li Yuanfeng
> _______________________________________________
> Genome maillist  -  [email protected]
> https://lists.soe.ucsc.edu/mailman/listinfo/genome
_______________________________________________
Genome maillist  -  [email protected]
https://lists.soe.ucsc.edu/mailman/listinfo/genome

Reply via email to