v40_sql = SELECT v40.gene_id, v40.gene_name, SUBSTRING(v40.transcript_id, 1, 15) as transcriptID, v40.transcript_name, count(v40.exon_id), sum(v40.End-v40.Start) as Tx_len , sum(CDS_End-CDS_Start) as cds_len, (select SUBSTRING(M.Ensembl_nuc, 1, 15) from `MANE.GRCh38.v1.0.summary` as M where SUBSTRING(M.Ensembl_Gene, 1, 15) = 'ENSG00000173614' and SUBSTRING(M.Ensembl_nuc, 1, 15) = SUBSTRING(v40.transcript_id, 1, 15) and MANE_status = 'MANE Select') as Ensembl_transcript, v40pc.gene_name, SUBSTRING(v40pc.gene_id, 1, 15) v40_gene_id, v40pc.Start, v40pc.End , (select distinct `APPRIS Annotation` from APPRIS_Gencode40 as A where SUBSTRING(A.`Transcript ID`, 1, 15) = SUBSTRING(v40.transcript_id, 1, 15) limit 1) as APPRIS FROM gencode_v40_proteincoding_exon_cds v40 left join gencode_v40_protein_coding_gene v40pc on SUBSTRING(v40.gene_id, 1, 15) = SUBSTRING(v40pc.gene_id, 1, 15) where SUBSTRING(v40.gene_id, 1, 15) = 'ENSG00000173614' group by v40.transcript_id;