Schema for ensemblSource
  Database: myoLuc2    Primary Table: ensemblSource    Row Count: 26,840   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 ENSMLUT00000000002.2varchar(255) values Ensembl transcript ID
source protein_codingvarchar(255) values gene source classification

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

Sample Rows
 
namesource
ENSMLUT00000000002.2protein_coding
ENSMLUT00000000003.2protein_coding
ENSMLUT00000000004.2protein_coding
ENSMLUT00000000005.2protein_coding
ENSMLUT00000000006.2protein_coding
ENSMLUT00000000007.2protein_coding
ENSMLUT00000000008.2protein_coding
ENSMLUT00000000009.2protein_coding
ENSMLUT00000000012.2protein_coding
ENSMLUT00000000013.2protein_coding

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