Schema for ensGtp
  Database: danRer7    Primary Table: ensGtp    Row Count: 56,754   Data last updated: 2014-03-04
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSDARG00000076051char(20) values Ensembl gene ID
transcript ENSDART00000113409char(20) values Ensembl transcript ID
protein ENSDARP00000102942char(24) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
ENSDARG00000076051ENSDART00000113409ENSDARP00000102942
ENSDARG00000088691ENSDART00000129330ENSDARP00000107190
ENSDARG00000096571ENSDART00000152265ENSDARP00000126897
ENSDARG00000090143ENSDART00000129013ENSDARP00000110950
ENSDARG00000063606ENSDART00000131050ENSDARP00000107929
ENSDARG00000063150ENSDART00000091955ENSDARP00000086388
ENSDARG00000084364ENSDART00000119764
ENSDARG00000021907ENSDART00000126388ENSDARP00000104876
ENSDARG00000021907ENSDART00000152715ENSDARP00000127082
ENSDARG00000021907ENSDART00000152686ENSDARP00000126682

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