TAXON.DOMAIN = Archaea, AND PHENOTYPECV.PHENOTYPE_TERM = Aerobe
 TAXON.PHYLUM = Actinobacteria, AND TAXON.SEQ_STATUS = Finished, AND NOT COG.COG_ID = COG0135
 (select distinct(taxon.taxon_oid) from taxon, img_pathway_taxons where img_pathway_taxons.PATHWAY_OID = '138' and taxon.taxon_oid = img_pathway_taxons.taxon) intersect (select distinct(taxon.taxon_oid) from taxon, img_pathway_taxons where img_pathway_taxons.pathway_oid = '235')
 IMG_PATHWAY.PATHWAY_OID = 337, AND PHENOTYPECV.PHENOTYPE_TERM = Thermophile
 TAXON.IR_CLASS = Gammaproteobacteria, AND TAXON_INFO.COUNT_CDS > 3000
 TAXON.DOMAIN = Archaea, AND TAXON_INFO.GC_PERCENT > .5
 SELECT * FROM TAXON WHERE TAXON.TAXON_OID < 1000