Schema for ensGtp
  Database: ailMel1    Primary Table: ensGtp    Row Count: 25,055   Data last updated: 2020-08-31
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSAMEG00000016232.1char(21) values Ensembl gene ID
transcript ENSAMET00000017883.1char(21) values Ensembl transcript ID
protein ENSAMEP00000017178.1char(24) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
ENSAMEG00000016232.1ENSAMET00000017883.1ENSAMEP00000017178.1
ENSAMEG00000016277.1ENSAMET00000017960.1ENSAMEP00000017253.1
ENSAMEG00000016345.1ENSAMET00000017981.1ENSAMEP00000017272.1
ENSAMEG00000016363.1ENSAMET00000018009.1ENSAMEP00000017300.1
ENSAMEG00000016388.1ENSAMET00000018031.1ENSAMEP00000017321.1
ENSAMEG00000022303.1ENSAMET00000024126.1
ENSAMEG00000016409.1ENSAMET00000018032.1ENSAMEP00000017322.1
ENSAMEG00000016410.1ENSAMET00000018037.1ENSAMEP00000017327.1
ENSAMEG00000022204.1ENSAMET00000024027.1
ENSAMEG00000022801.1ENSAMET00000024624.1

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