Schema for ensemblSource
  Database: dm6    Primary Table: ensemblSource    Row Count: 41,200   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 FBgn0013687_df_ptvarchar(255) values Ensembl transcript ID
source pseudogenevarchar(255) values gene source classification

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

Sample Rows
 
namesource
FBgn0013687_df_ptpseudogene
FBti0015567-RAtransposable_element
FBti0018861-RAtransposable_element
FBti0018862-RAtransposable_element
FBti0018865-RAtransposable_element
FBti0018866-RAtransposable_element
FBti0018867-RAtransposable_element
FBti0018868-RAtransposable_element
FBti0018869-RAtransposable_element
FBti0018871-RAtransposable_element

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