Schema for ensGtp
  Database: anoGam3    Primary Table: ensGtp    Row Count: 15,656   Data last updated: 2018-01-06
Format description: Ensembl Gene/Transcript/Protein cross-reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene AGAP001096char(21) values Ensembl gene ID
transcript AGAP001096-RAchar(21) values Ensembl transcript ID
protein AGAP001096-PA.1char(24) values Ensembl protein ID

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

Sample Rows
 
genetranscriptprotein
AGAP001096AGAP001096-RAAGAP001096-PA.1
AGAP013094AGAP013094-RAAGAP013094-PA.1
AGAP001097AGAP001097-RAAGAP001097-PA.1
AGAP001098AGAP001098-RAAGAP001098-PA.1
AGAP001099AGAP001099-RAAGAP001099-PA.1
AGAP001100AGAP001100-RAAGAP001100-PA.1
AGAP001101AGAP001101-RAAGAP001101-PA.1
AGAP001102AGAP001102-RAAGAP001102-PA.1
AGAP001103AGAP001103-RAAGAP001103-PA.1
AGAP001104AGAP001104-RAAGAP001104-PA.1

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