Schema for ensGtp
  Database: dm6    Primary Table: ensGtp    Row Count: 41,200   Data last updated: 2021-05-25
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene FBgn0250732char(28) values Ensembl gene ID
transcript FBtr0091512char(31) values Ensembl transcript ID
protein FBpp0290855char(24) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
FBgn0250732FBtr0091512FBpp0290855
FBgn0250732FBtr0334671FBpp0306732
FBgn0250732FBtr0114531FBpp0113023
FBti0060344FBti0060344-RA
FBgn0286036FBtr0473385
FBgn0037409FBtr0078591FBpp0078240
FBgn0027948FBtr0301479FBpp0290694
FBgn0027948FBtr0304801FBpp0293341
FBgn0027948FBtr0304803FBpp0293343
FBgn0027948FBtr0304802FBpp0293342

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