select xref.display_label, gene.stable_id AS gsi, transcript.stable_id AS tsi, translation.stable_id AS psi, translation.translation_id AS pid, translation_attrib.value AS AA from xref INNER JOIN object_xref USING(xref_id) INNER JOIN gene ON(object_xref.ensembl_id=gene.gene_id) INNER JOIN transcript USING(gene_id) INNER JOIN translation USING(transcript_id) INNER JOIN  translation_attrib USING (translation_id) INNER JOIN attrib_type USING(attrib_type_id) WHERE xref.display_label='COX4I1' AND attrib_type.attrib_type_id=167 ORDER BY AA DESC LIMIT 1;