Schema for ensGtp
  Database: galGal3    Primary Table: ensGtp    Row Count: 23,392   Data last updated: 2012-08-24
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSGALG00000009771char(20) values Ensembl gene ID
transcript ENSGALT00000015891char(20) values Ensembl transcript ID
protein ENSGALP00000015874char(24) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
ENSGALG00000009771ENSGALT00000015891ENSGALP00000015874
ENSGALG00000009783ENSGALT00000015914ENSGALP00000015897
ENSGALG00000023990ENSGALT00000040454ENSGALP00000039656
ENSGALG00000009778ENSGALT00000015903ENSGALP00000015886
ENSGALG00000009775ENSGALT00000015896ENSGALP00000015879
ENSGALG00000009772ENSGALT00000015892ENSGALP00000015875
ENSGALG00000009770ENSGALT00000015890ENSGALP00000015873
ENSGALG00000023986ENSGALT00000040436ENSGALP00000039638
ENSGALG00000023985ENSGALT00000040434ENSGALP00000039636
ENSGALG00000009746ENSGALT00000015860ENSGALP00000015844

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