Schema for ensGtp
  Database: hg17    Primary Table: ensGtp    Row Count: 33,869   Data last updated: 2005-05-24
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSG00000198888char(20) values Ensembl gene ID
transcript ENST00000361390char(20) values Ensembl transcript ID
protein ENSP00000354687char(20) values Ensembl protein ID

Connected Tables and Joining Fields
        hg17.sfAssign.seqID (via ensGtp.protein)
      hg17.ensGene.name (via ensGtp.transcript)
      hg17.ensPep.name (via ensGtp.transcript)
      hg17.knownToEnsembl.value (via ensGtp.transcript)
      knownGeneV39.knownToEnsembl.value (via ensGtp.transcript)

Sample Rows
 
genetranscriptprotein
ENSG00000198888ENST00000361390ENSP00000354687
ENSG00000198763ENST00000361453ENSP00000355046
ENSG00000198804ENST00000361624ENSP00000354499
ENSG00000198712ENST00000361739ENSP00000354876
ENSG00000198744ENST00000361851ENSP00000355265
ENSG00000198899ENST00000361899ENSP00000354632
ENSG00000198938ENST00000362079ENSP00000354982
ENSG00000198840ENST00000361227ENSP00000355206
ENSG00000198868ENST00000361335ENSP00000354728
ENSG00000198886ENST00000361381ENSP00000354961

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