Schema for ensGtp
  Database: macEug1    Primary Table: ensGtp    Row Count: 18,310   Data last updated: 2012-08-24
On download server: MariaDB table dump directory
fieldexampleSQL type info
gene ENSMEUG00000000914char(20) values
transcript ENSMEUT00000000910char(20) values
protein ENSMEUP00000000840char(24) values

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

Sample Rows
 
genetranscriptprotein
ENSMEUG00000000914ENSMEUT00000000910ENSMEUP00000000840
ENSMEUG00000012679ENSMEUT00000012704ENSMEUP00000011551
ENSMEUG00000004085ENSMEUT00000004098ENSMEUP00000003722
ENSMEUG00000011591ENSMEUT00000011627
ENSMEUG00000003722ENSMEUT00000003730ENSMEUP00000003393
ENSMEUG00000011912ENSMEUT00000011934
ENSMEUG00000012009ENSMEUT00000012046ENSMEUP00000010943
ENSMEUG00000013202ENSMEUT00000013257
ENSMEUG00000004480ENSMEUT00000004486ENSMEUP00000004074
ENSMEUG00000017109ENSMEUT00000017161

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