Schema for ensGtp
  Database: panTro2    Primary Table: ensGtp    Row Count: 41,488   Data last updated: 2011-10-25
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSPTRG00000029886char(20) values Ensembl gene ID
transcript ENSPTRT00000057728char(20) values Ensembl transcript ID
protein ENSPTRP00000050649char(24) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
ENSPTRG00000029886ENSPTRT00000057728ENSPTRP00000050649
ENSPTRG00000017654ENSPTRT00000032636ENSPTRP00000030157
ENSPTRG00000017656ENSPTRT00000032642ENSPTRP00000030162
ENSPTRG00000017657ENSPTRT00000032644ENSPTRP00000030163
ENSPTRG00000034290ENSPTRT00000064193ENSPTRP00000055742
ENSPTRG00000017660ENSPTRT00000032649ENSPTRP00000030168
ENSPTRG00000038294ENSPTRT00000071896
ENSPTRG00000029883ENSPTRT00000057724ENSPTRP00000050646
ENSPTRG00000017662ENSPTRT00000032651ENSPTRP00000050645
ENSPTRG00000038266ENSPTRT00000071868

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