Hi Schraga, The organism id number is stored in the gbCdnaInfo table, the id-to-organism name mapping is in the organism table. To get the organism name for a particular id you can use this SQL query...
select organism.name from gbCdnaInfo,organism where gbCdnaInfo.acc = 'NM_001193784' and gbCdnaInfo.organism = organism.id; Or using the Table Browser, try: clear cart hit "Tables" on blue bar choose "Other Refseq" track choose "selected fields from primary and related tables" hit "get output" hit the check mark next to gbCdnaInfo in linked tables press "allow selection from checked tables" check the organism table press "allow selection from checked tables" press "check all" to get all fields from xenoRefSeq table put a check mark next to "name" in organism table press "get output" Please let us know if you have any additional questions: [email protected] - Greg Roe UCSC Genome Bioinformatics Group On 6/25/12 12:12 PM, Schragi Schwartz wrote: > Hi, > I'm interested in obtaining xenoRefFlat tables for various organisms, > containing information about alignment. The issue I'm having is that > although these files contain many transcript structure (from various > organisms) there is not a column indicating which organism the different > gene structures correspond to. Is there any way I can directly get this > information? > Thank you very much, > Schraga Schwartz > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
