Schema for ensemblSource
  Database: ce11    Primary Table: ensemblSource    Row Count: 61,451   Data last updated: 2021-05-25
Format description: Ensembl gene source classification, coding/non-coding status
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name 2L52.1a.1varchar(255) values Ensembl transcript ID
source protein_codingvarchar(255) values gene source classification

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

Sample Rows
 
namesource
2L52.1a.1protein_coding
2L52.1b.1protein_coding
2L52.2ncRNA
2RSSE.1a.1protein_coding
2RSSE.1b.1protein_coding
2RSSE.1c.1protein_coding
2RSSE.3pseudogene
2RSSE.4ncRNA
2RSSE.5ncRNA
2RSSE.6ncRNA

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