Schema for ensGtp
  Database: ci2    Primary Table: ensGtp    Row Count: 20,225   Data last updated: 2011-10-25
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSCING00000015180char(20) values Ensembl gene ID
transcript ENSCINT00000027313char(20) values Ensembl transcript ID
protein ENSCINP00000027067char(24) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
ENSCING00000015180ENSCINT00000027313ENSCINP00000027067
ENSCING00000010240ENSCINT00000020405ENSCINP00000020405
ENSCING00000010240ENSCINT00000020407ENSCINP00000020407
ENSCING00000007570ENSCINT00000015514ENSCINP00000015514
ENSCING00000007570ENSCINT00000015518ENSCINP00000015518
ENSCING00000007570ENSCINT00000015517ENSCINP00000015517
ENSCING00000000277ENSCINT00000000506ENSCINP00000000506
ENSCING00000007569ENSCINT00000015501ENSCINP00000015501
ENSCING00000015113ENSCINT00000027244ENSCINP00000026998
ENSCING00000005250ENSCINT00000010826ENSCINP00000010826

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