Show institution names along with the number of proteins for each institution
select t1.institution, count ( * ) from institution as t1 join protein as t2 on t1.institution_id = t2.institution_id group by t1.institution_id
What proteins are associated with Lindenwood University-Belleville?
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"
Between Centromeric protein E, putative and conserved hypothetical protein, which has the highest divergence from human lineage?
select divergence_from_human_lineage from protein where protein_name = "Centromeric protein e, putative" or protein_name = "conserved hypothetical protein"
What is the accession number for Centromeric protein E?
select accession_number from protein where protein_name = "Centromeric protein e, putative"
What is the sequence identity to human protein value associated with accession number XP_002429877.1
select sequence_identity_to_human_protein from protein where accession_number = "XP_002429877.1"
Which protein has the highest sequence identity to human protein value?
select protein_name from protein order by sequence_identity_to_human_protein desc limit 1