Schema for ensGtp
  Database: mm9    Primary Table: ensGtp    Row Count: 95,883   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 ENSMUSG00000090025char(20) values Ensembl gene ID
transcript ENSMUST00000160944char(20) values Ensembl transcript ID
protein  char(24) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
ENSMUSG00000090025ENSMUST00000160944
ENSMUSG00000064842ENSMUST00000082908
ENSMUSG00000051951ENSMUST00000162897
ENSMUSG00000051951ENSMUST00000159265
ENSMUSG00000051951ENSMUST00000070533ENSMUSP00000070648
ENSMUSG00000089699ENSMUST00000161581
ENSMUSG00000088390ENSMUST00000157765
ENSMUSG00000089420ENSMUST00000158795
ENSMUSG00000025900ENSMUST00000027032ENSMUSP00000027032
ENSMUSG00000025900ENSMUST00000115540ENSMUSP00000111202

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