Guest User

Untitled

a guest
Jun 19th, 2018
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. mysql> select name, cvterm_id from cvterm where name in ('assembly','tRNA','name','rRNA');+----------+-----------+
  2. | name | cvterm_id |
  3. +----------+-----------+
  4. | assembly | 23493 |
  5. | name | 334 |
  6. | Name | 5259 |
  7. | rRNA | 23392 |
  8. | tRNA | 23393 |
  9. +----------+-----------+
  10. 5 rows in set (0.02 sec)
  11.  
  12. 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;
  13. +--------------+-----------+
  14. | name | cvterm_id |
  15. +--------------+-----------+
  16. | assembly | 23493 |
  17. | CDS | 23456 |
  18. | derives_from | 7 |
  19. | Derives_from | 5264 |
  20. | gene | 23844 |
  21. | name | 334 |
  22. | Name | 5259 |
  23. | part_of | 16 |
  24. | polypeptide | 23244 |
  25. | rRNA | 23392 |
  26. | transcript | 23813 |
  27. | tRNA | 23393 |
  28. +--------------+-----------+
  29. 12 rows in set (0.05 sec)
  30.  
  31. mysql>
Add Comment
Please, Sign In to add comment