Schema for ensemblSource
  Database: melGal1    Primary Table: ensemblSource    Row Count: 17,373   Data last updated: 2020-08-31
Format description: Ensembl gene source classification, coding/non-coding status
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSMGAT00000000001.1varchar(255) values Ensembl transcript ID
source rRNAvarchar(255) values gene source classification

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

Sample Rows
 
namesource
ENSMGAT00000000001.1rRNA
ENSMGAT00000000002.1miRNA
ENSMGAT00000000003.1misc_RNA
ENSMGAT00000000004.1miRNA
ENSMGAT00000000005.1miRNA
ENSMGAT00000000006.1miRNA
ENSMGAT00000000009.1miRNA
ENSMGAT00000000010.1snoRNA
ENSMGAT00000000012.1snoRNA
ENSMGAT00000000013.1snoRNA

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