[Genome] regarding UCSC genes (Human)

[Ann Zweig]

Hello Vinay,

	The table you should use is the kgXref table.  It contains (among other things) 
the UCSC ID, the Gene Symbol, and the short description you are looking for. 
For example, for the GABRA3 gene:

mysql> select  * from kgXref where geneSymbol='GABRA3'\G
*************************** 1. row ***************************
        kgID: uc004ffn.1
        mRNA: NM_000808
        spID: P34903
spDisplayID: GBRA3_HUMAN
  geneSymbol: GABRA3
      refseq: NM_000808
     protAcc: NP_000799
description: gamma-aminobutyric acid A receptor, alpha 3


Regards,

----------
Ann Zweig
UCSC Genome Bioinformatics Group
http://genome.ucsc.edu

Please feel free to search the Genome mailing list archives by visiting our home 
page, clicking on "Contact Us", then typing a word or phrase into the search 
box.  On that same page
(http://genome.ucsc.edu/contacts.html), you can subscribe to the Genome mailing 
list.


Vinay Kumar Mittal wrote:
> Hi,
> 
> I have downloaded known UCSC gene table (for Humans) from table browser. Is
> there anyway to find description for all these genes in a tabular format. I
> know about refseqSummary.txt.gz, but all UCSC genes are not present in this
> description file.
> 
> Thanks
> --
> Vinay Kumar Mittal,
> School of Biology,
> Georgia Institute of Technology
> _______________________________________________
> Genome maillist  -  Genome at soe.ucsc.edu
> http://www.soe.ucsc.edu/mailman/listinfo/genome