Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select name, cvterm_id from cvterm where name in ('assembly','tRNA','name','rRNA');+----------+-----------+
- | name | cvterm_id |
- +----------+-----------+
- | assembly | 23493 |
- | name | 334 |
- | Name | 5259 |
- | rRNA | 23392 |
- | tRNA | 23393 |
- +----------+-----------+
- 5 rows in set (0.02 sec)
- mysql> select name, cvterm_id from cvterm where name in ('assembly','transcript','CDS','derives_from','polypeptide','SO','part_of','gene','tRNA','rRNA','name') ORDER BY name;
- +--------------+-----------+
- | name | cvterm_id |
- +--------------+-----------+
- | assembly | 23493 |
- | CDS | 23456 |
- | derives_from | 7 |
- | Derives_from | 5264 |
- | gene | 23844 |
- | name | 334 |
- | Name | 5259 |
- | part_of | 16 |
- | polypeptide | 23244 |
- | rRNA | 23392 |
- | transcript | 23813 |
- | tRNA | 23393 |
- +--------------+-----------+
- 12 rows in set (0.05 sec)
- mysql>
Add Comment
Please, Sign In to add comment