Schema for ensGtp
  Database: hg18    Primary Table: ensGtp    Row Count: 63,280   Data last updated: 2009-08-05
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSG00000215719char(20) values Ensembl gene ID
transcript ENST00000369958char(20) values Ensembl transcript ID
protein ENSP00000358974char(20) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
ENSG00000215719ENST00000369958ENSP00000358974
ENSG00000215718ENST00000400794ENSP00000383599
ENSG00000215715ENST00000400791AC011645.3-1
ENSG00000215717ENST00000338272ENSP00000342148
ENSG00000215716ENST00000400793ENSP00000383598
ENSG00000212878ENST00000391567ENSP00000385894
ENSG00000220474ENST00000407899ENSP00000384472
ENSG00000215744ENST00000400830ENSP00000383631
ENSG00000220454ENST00000404192ENSP00000384236
ENSG00000215737ENST00000400823ENSP00000383624

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