Schema for ensGtp
  Database: mm7    Primary Table: ensGtp    Row Count: 35,004   Data last updated: 2006-05-11
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSMUSG00000058140char(20) values Ensembl gene ID
transcript ENSMUST00000071829char(20) values Ensembl transcript ID
protein ENSMUSP00000071732char(20) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
ENSMUSG00000058140ENSMUST00000071829ENSMUSP00000071732
ENSMUSG00000023764ENSMUST00000066391ENSMUSP00000067261
ENSMUSG00000023764ENSMUST00000081318ENSMUSP00000080066
ENSMUSG00000023764ENSMUST00000093406ENSMUSP00000091110
ENSMUSG00000023764ENSMUST00000093407ENSMUSP00000091113
ENSMUSG00000023764ENSMUST00000072704ENSMUSP00000072488
ENSMUSG00000020454ENSMUST00000020734ENSMUSP00000020734
ENSMUSG00000020454ENSMUST00000093405ENSMUSP00000091109
ENSMUSG00000020457ENSMUST00000020741ENSMUSP00000020741
ENSMUSG00000020453ENSMUST00000020731ENSMUSP00000020731

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