Schema for ensGtp
  Database: mm8    Primary Table: ensGtp    Row Count: 34,831   Data last updated: 2006-06-22
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSMUSG00000000001char(20) values Ensembl gene ID
transcript ENSMUST00000000001char(20) values Ensembl transcript ID
protein ENSMUSP00000000001char(20) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
ENSMUSG00000000001ENSMUST00000000001ENSMUSP00000000001
ENSMUSG00000000003ENSMUST00000000003ENSMUSP00000000003
ENSMUSG00000000028ENSMUST00000000028ENSMUSP00000000028
ENSMUSG00000000028ENSMUST00000096990ENSMUSP00000094753
ENSMUSG00000000031ENSMUST00000000031ENSMUSP00000000031
ENSMUSG00000000037ENSMUST00000019101ENSMUSP00000019101
ENSMUSG00000000037ENSMUST00000074802ENSMUSP00000074356
ENSMUSG00000000037ENSMUST00000077375ENSMUSP00000076593
ENSMUSG00000000037ENSMUST00000087090ENSMUSP00000084325
ENSMUSG00000000037ENSMUST00000087091ENSMUSP00000084326

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