select gene.stable_id, transcript.stable_id, transcript.seq_region_start, transcript.seq_region_end, transcript.seq_region_strand AS str, seq_region.name AS chr, (transcript.seq_region_end - transcript.seq_region_start + 1) AS trlen FROM seq_region INNER JOIN gene USING(seq_region_id) INNER JOIN transcript USING (gene_id) WHERE gene.stable_id='ENSG00000277117' ORDER BY trlen ASC LIMIT 1;



select gene.stable_id, xref.display_label FROM gene INNER JOIN object_xref ON(gene.gene_id = object_xref.ensembl_id) INNER JOIN xref USING (xref_id) WHERE gene.stable_id='ENSG00000277117' AND object_xref.ensembl_object_type='Gene';