Schema for ensemblSource
  Database: vicPac1    Primary Table: ensemblSource    Row Count: 15,199   Data last updated: 2019-01-11
Format description: Ensembl gene source classification, coding/non-coding status
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSVPAT00000000002.1varchar(255) values Ensembl transcript ID
source pseudogenevarchar(255) values gene source classification

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

Sample Rows
 
namesource
ENSVPAT00000000002.1pseudogene
ENSVPAT00000000003.1pseudogene
ENSVPAT00000000004.1protein_coding
ENSVPAT00000000005.1protein_coding
ENSVPAT00000000006.1pseudogene
ENSVPAT00000000007.1protein_coding
ENSVPAT00000000008.1protein_coding
ENSVPAT00000000009.1protein_coding
ENSVPAT00000000010.1protein_coding
ENSVPAT00000000011.1protein_coding

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