-- Database schema
| Classification : GeneID [ TEXT ] primary_key , Localization [ TEXT ] | Genes : GeneID [ TEXT ] Genes.GeneID = Classification.GeneID , Essential [ TEXT ] , Class [ TEXT ] , Complex [ TEXT ] , Phenotype [ TEXT ] , Motif [ TEXT ] , Chromosome [ INTEGER ] , Function [ TEXT ] , Localization [ TEXT ] | Interactions : GeneID1 [ TEXT ] Interactions.GeneID1 = Classification.GeneID , GeneID2 [ TEXT ] Interactions.GeneID2 = Classification.GeneID , Type [ TEXT ] , Expression_Corr [ REAL ] |
-- -- Lists all genes by identifier number located in the cytoplasm and whose function is metabolism.

SELECT DISTINCT GeneID FROM Genes WHERE Localization = 'cytoplasm' AND Function = 'METABOLISM';