Schema for ensGtp
  Database: canFam2    Primary Table: ensGtp    Row Count: 30,914   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 ENSCAFG00000027223char(20) values Ensembl gene ID
transcript ENSCAFT00000041506char(20) values Ensembl transcript ID
protein  char(24) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
ENSCAFG00000027223ENSCAFT00000041506
ENSCAFG00000025619ENSCAFT00000039894ENSCAFP00000035809
ENSCAFG00000025619ENSCAFT00000039893ENSCAFP00000035808
ENSCAFG00000013492ENSCAFT00000021396ENSCAFP00000019865
ENSCAFG00000025615ENSCAFT00000039890ENSCAFP00000035805
ENSCAFG00000025614ENSCAFT00000039889ENSCAFP00000035804
ENSCAFG00000025612ENSCAFT00000039888ENSCAFP00000035803
ENSCAFG00000015496ENSCAFT00000024574
ENSCAFG00000013116ENSCAFT00000020814
ENSCAFG00000013199ENSCAFT00000021056ENSCAFP00000035798

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