[Genome] taxonomy ID
Fan Hsu
fanhsu at soe.ucsc.edu
Tue May 27 21:49:50 PDT 2008
mysql> select * from proteome.taxonNames where id='9606';
+------+--------------+------+---------------------+
| id | name | info | nameType |
+------+--------------+------+---------------------+
| 9606 | Homo sapiens | | scientific name |
| 9606 | human | | genbank common name |
| 9606 | man | | common name |
+------+--------------+------+---------------------+
3 rows in set (0.00 sec)
mysql> select * from proteome.taxonNames where id='10116';
+-------+--------------------------+--------------------------+-------------
--------+
| id | name | info | nameType
|
+-------+--------------------------+--------------------------+-------------
--------+
| 10116 | Buffalo rat | | includes
|
| 10116 | Gunn rats | | misnomer
|
| 10116 | Norway rat | | genbank
common name |
| 10116 | Rattus PC12 clone IS | | includes
|
| 10116 | Rattus norvegicus | | scientific
name |
| 10116 | Rattus norvegicus8 | | misspelling
|
| 10116 | Rattus norwegicus | | misspelling
|
| 10116 | Rattus rattiscus | | misnomer
|
| 10116 | Rattus sp. strain Wistar | | equivalent
name |
| 10116 | Sprague-Dawley rat | | includes
|
| 10116 | Wistar rats | | includes
|
| 10116 | brown rat | | common name
|
| 10116 | laboratory rat | | includes
|
| 10116 | rat | rat <Rattus norvegicus> | common name
|
| 10116 | rats | rats <Rattus norvegicus> | common name
|
| 10116 | zitter rats | | includes
|
+-------+--------------------------+--------------------------+-------------
--------+
16 rows in set (0.00 sec)
mysql> select * from proteome.taxonNames where id='10116';
+-------+--------------------------+--------------------------+-------------
--------+
| id | name | info | nameType
|
+-------+--------------------------+--------------------------+-------------
--------+
| 10116 | Buffalo rat | | includes
|
| 10116 | Gunn rats | | misnomer
|
| 10116 | Norway rat | | genbank
common name |
| 10116 | Rattus PC12 clone IS | | includes
|
| 10116 | Rattus norvegicus | | scientific
name |
| 10116 | Rattus norvegicus8 | | misspelling
|
| 10116 | Rattus norwegicus | | misspelling
|
| 10116 | Rattus rattiscus | | misnomer
|
| 10116 | Rattus sp. strain Wistar | | equivalent
name |
| 10116 | Sprague-Dawley rat | | includes
|
| 10116 | Wistar rats | | includes
|
| 10116 | brown rat | | common name
|
| 10116 | laboratory rat | | includes
|
| 10116 | rat | rat <Rattus norvegicus> | common name
|
| 10116 | rats | rats <Rattus norvegicus> | common name
|
| 10116 | zitter rats | | includes
|
+-------+--------------------------+--------------------------+-------------
--------+
_____
From: Yuan Jian [mailto:jayuan2008 at yahoo.com]
Sent: Tuesday, 27 May, 2008 8:22 PM
To: genome at soe.ucsc.edu; Fan Hsu
Subject: RE: [Genome] taxonomy ID
there are no taxon id that I wanted in the table taxonNames.
such as:
human 9606
mouse 10090
rat 10116
--- On Wed, 5/28/08, Fan Hsu <fanhsu at soe.ucsc.edu> wrote:
From: Fan Hsu <fanhsu at soe.ucsc.edu>
Subject: RE: [Genome] taxonomy ID
To: jayuan2008 at yahoo.com, genome at soe.ucsc.edu
Date: Wednesday, May 28, 2008, 2:38 AM
The proteome database has a table called taxonNames.
Fan.
-----Original Message-----
From: genome-bounces at soe.ucsc.edu [mailto:genome-bounces at soe.ucsc.edu] On
Behalf Of Yuan Jian
Sent: Tuesday, 27 May, 2008 5:11 PM
To: genome at soe.ucsc.edu
Subject: [Genome] taxonomy ID
Hello UCSC,
is it possible to get toxonomy id from UCSC? such as:
human 9606
mouse 10090
rat 10116
.....
Yu
_______________________________________________
Genome maillist - Genome at soe.ucsc.edu
http://www.soe.ucsc.edu/mailman/listinfo/genome
More information about the Genome
mailing list