human
Schema:
building (building_id, Name, Street_address, Years_as_tallest, Height_feet, Floors)
Institution (Institution_id, Institution, Location, Founded, Type, Enrollment, Team, Primary_Conference, building_id)
protein (common_name, protein_name, divergence_from_human_lineage, accession_number, sequence_length, sequence_identity_to_human_protein, Institution_id)
Please answer with SQL.
assistant
Sure, I understand.
human
Show institution names along with the number of proteins for each institution
assistant
SELECT T1.institution , COUNT( * ) FROM institution AS T1 JOIN protein AS T2 ON T1.institution_id = T2.institution_id GROUP BY T1.institution_id;
human
What proteins are associated with Lindenwood University-Belleville?
assistant
SELECT T2.protein_name FROM institution AS T1 JOIN protein AS T2 ON T1.institution_id = T2.institution_id WHERE T1.institution = 'Lindenwood University Belleville';
human
Between Centromeric protein E, putative and conserved hypothetical protein, which has the highest divergence from human lineage?
assistant
SELECT divergence_from_human_lineage FROM protein WHERE protein_name = 'Centromeric protein E, putative' OR protein_name = 'conserved hypothetical protein';
human
What is the accession number for Centromeric protein E?
assistant
SELECT accession_number FROM protein WHERE protein_name = 'Centromeric protein E, putative';
human
What is the sequence identity to human protein value associated with accession number XP_002429877.1
assistant
SELECT sequence_identity_to_human_protein FROM protein WHERE accession_number = "XP_002429877.1" ;