Guest User

Untitled

a guest
Jul 12th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. SELECT f.uniquename, ec.accession
  2. FROM dbxref ec
  3. JOIN feature_dbxref fdbx ON ec.dbxref_id=fdbx.dbxref_id
  4. JOIN feature f ON fdbx.feature_id=f.feature_id
  5. JOIN dbxref ON fdbx.dbxref_id=dbxref.dbxref_id
  6. JOIN db ON dbxref.db_id=db.db_id
  7. WHERE db.name = 'EC';
Add Comment
Please, Sign In to add comment