Schema for ensemblSource
  Database: anoGam3    Primary Table: ensemblSource    Row Count: 15,656   Data last updated: 2018-01-06
Format description: Ensembl gene source classification, coding/non-coding status
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name AGAP000002-RAvarchar(255) values Ensembl transcript ID
source protein_codingvarchar(255) values gene source classification

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

Sample Rows
 
namesource
AGAP000002-RAprotein_coding
AGAP000005-RAprotein_coding
AGAP000007-RAprotein_coding
AGAP000008-RAprotein_coding
AGAP000009-RAprotein_coding
AGAP000009-RBprotein_coding
AGAP000009-RCprotein_coding
AGAP000010-RAprotein_coding
AGAP000011-RAprotein_coding
AGAP000012-RAprotein_coding

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