Skip to content

Instantly share code, notes, and snippets.

@kalvari

kalvari/mammal_annotation.sql

Created March 31, 2016 14:53
Show Gist options
  • Save kalvari/6f88ae990000a0efe4a039a50f997d7f to your computer and use it in GitHub Desktop.
Save kalvari/6f88ae990000a0efe4a039a50f997d7f to your computer and use it in GitHub Desktop.
Download ZIP
Fetch all annotations for mammals
Raw
mammal_annotation.sql
SELECT f.rfam_acc
from family f, family_ncbi fn, taxonomy tx
where f.rfam_acc=fn.rfam_acc
AND fn.ncbi_id=tx.ncbi_id
AND tax_string like '%Mammal%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment