Schema for ensemblSource
  Database: saiBol1    Primary Table: ensemblSource    Row Count: 49,034   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 ENSSBOT00000000038.1varchar(255) values Ensembl transcript ID
source pseudogenevarchar(255) values gene source classification

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

Sample Rows
 
namesource
ENSSBOT00000000038.1pseudogene
ENSSBOT00000000039.1protein_coding
ENSSBOT00000000040.1protein_coding
ENSSBOT00000000041.1protein_coding
ENSSBOT00000000042.1protein_coding
ENSSBOT00000000043.1protein_coding
ENSSBOT00000000044.1rRNA
ENSSBOT00000000045.1protein_coding
ENSSBOT00000000046.1miRNA
ENSSBOT00000000047.1protein_coding

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