Schema for ensGtp
  Database: sacCer3    Primary Table: ensGtp    Row Count: 7,127   Data last updated: 2021-05-25
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene YDL246Cchar(28) values Ensembl gene ID
transcript YDL246C_mRNAchar(31) values Ensembl transcript ID
protein YDL246Cchar(24) values Ensembl protein ID

Connected Tables and Joining Fields
        knownGeneV39.knownToEnsembl.value (via ensGtp.transcript)
      sacCer3.ensGene.name (via ensGtp.transcript)
      sacCer3.ensPep.name (via ensGtp.transcript)
      sacCer3.ensemblSource.name (via ensGtp.transcript)
      sacCer3.ensemblToGeneName.name (via ensGtp.transcript)

Sample Rows
 
genetranscriptprotein
YDL246CYDL246C_mRNAYDL246C
YDL243CYDL243C_mRNAYDL243C
YDR387CYDR387C_mRNAYDR387C
YDL094CYDL094C_mRNAYDL094C
YDR438WYDR438W_mRNAYDR438W
YDR523CYDR523C_mRNAYDR523C
YDR542WYDR542W_mRNAYDR542W
YDR492WYDR492W_mRNAYDR492W
YDR018CYDR018C_mRNAYDR018C
YDL189WYDL189W_mRNAYDL189W

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.