Schema for ensGtp
  Database: dm3    Primary Table: ensGtp    Row Count: 29,173   Data last updated: 2014-03-04
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene FBgn0264003char(20) values Ensembl gene ID
transcript FBtr0330361char(20) values Ensembl transcript ID
protein  char(24) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
FBgn0264003FBtr0330361
FBgn0264003FBtr0330363
FBgn0264003FBtr0330362
FBgn0037213FBtr0078961FBpp0078601
FBgn0037213FBtr0078962FBpp0078602
FBgn0053294FBtr0308946
FBgn0053294FBtr0308945
FBgn0000500FBtr0078989FBpp0078628
FBgn0037215FBtr0306022FBpp0297164
FBgn0037215FBtr0078964FBpp0078603

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