Schema for ensGtp
  Database: rn4    Primary Table: ensGtp    Row Count: 39,549   Data last updated: 2012-08-24
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSRNOG00000005665char(20) values Ensembl gene ID
transcript ENSRNOT00000007474char(20) values Ensembl transcript ID
protein ENSRNOP00000007474char(24) values Ensembl protein ID

Connected Tables and Joining Fields
        rn4.sfAssign.seqID (via ensGtp.protein)
      knownGeneV39.knownToEnsembl.value (via ensGtp.transcript)
      rn4.ensGene.name (via ensGtp.transcript)
      rn4.ensPep.name (via ensGtp.transcript)
      rn4.ensemblSource.name (via ensGtp.transcript)
      rn4.ensemblToGeneName.name (via ensGtp.transcript)

Sample Rows
 
genetranscriptprotein
ENSRNOG00000005665ENSRNOT00000007474ENSRNOP00000007474
ENSRNOG00000023458ENSRNOT00000038653ENSRNOP00000038146
ENSRNOG00000031533ENSRNOT00000047171ENSRNOP00000046551
ENSRNOG00000032223ENSRNOT00000047042ENSRNOP00000046526
ENSRNOG00000041810ENSRNOT00000063563
ENSRNOG00000030589ENSRNOT00000061852
ENSRNOG00000040189ENSRNOT00000061851ENSRNOP00000058566
ENSRNOG00000005894ENSRNOT00000061721ENSRNOP00000058433
ENSRNOG00000040884ENSRNOT00000062637
ENSRNOG00000006263ENSRNOT00000008444ENSRNOP00000008444

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