Schema for ensemblSource
  Database: cavPor3    Primary Table: ensemblSource    Row Count: 34,846   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 ENSCPOT00000000007.3varchar(255) values Ensembl transcript ID
source protein_codingvarchar(255) values gene source classification

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

Sample Rows
 
namesource
ENSCPOT00000000007.3protein_coding
ENSCPOT00000000011.3protein_coding
ENSCPOT00000000012.3protein_coding
ENSCPOT00000000013.3protein_coding
ENSCPOT00000000014.3protein_coding
ENSCPOT00000000015.3protein_coding
ENSCPOT00000000016.3protein_coding
ENSCPOT00000000018.3protein_coding
ENSCPOT00000000020.3protein_coding
ENSCPOT00000000022.3protein_coding

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