Schema for ensemblSource
  Database: chlSab2    Primary Table: ensemblSource    Row Count: 28,078   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 ENSCSAT00000000001.1varchar(255) values Ensembl transcript ID
source Mt_tRNAvarchar(255) values gene source classification

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

Sample Rows
 
namesource
ENSCSAT00000000001.1Mt_tRNA
ENSCSAT00000000002.1Mt_rRNA
ENSCSAT00000000003.1Mt_tRNA
ENSCSAT00000000004.1Mt_rRNA
ENSCSAT00000000005.1Mt_tRNA
ENSCSAT00000000006.1protein_coding
ENSCSAT00000000007.1Mt_tRNA
ENSCSAT00000000008.1Mt_tRNA
ENSCSAT00000000009.1Mt_tRNA
ENSCSAT00000000010.1protein_coding

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