Query the Lipase Engineering Database using SQL (database schema)
SQL statement
Sample queries
How to find definitions of position specific sequence features	select description_id, description from descriptions
How to find proteins associated with a function	select h_family_name, protein_name, ac, db_entry from proteins p join h_fam h on h.h_family_id = p.h_family_id join sequences s on s.protein_id = p.protein_id join db_entries db on db.sequence_id = s.sequence_id where protein_name containing 'thioesterase'
How to find amino acid features for an accession code	select aa, aa_position, description from descriptions d join seq_annotations sa on sa.description_id = d.description_id join positions p on p.position_id = sa.position_id join db_entries db on db.sequence_id = p.sequence_id where ac = 'P19515'
How to find proteins from Homo sapiens in family abH01.02	select protein_name, genus || ' ' || species as organism from proteins p join h_fam h on h.h_family_id = p.h_family_id join species s on s.species_id = p.species_id join genera g on g.genus_id = s.genus_id where h_family_name containing 'abH01.02' and genus containing 'homo'