Schema for ensemblSource
  Database: proCap1    Primary Table: ensemblSource    Row Count: 18,917   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 ENSPCAT00000000002.1varchar(255) values Ensembl transcript ID
source pseudogenevarchar(255) values gene source classification

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

Sample Rows
 
namesource
ENSPCAT00000000002.1pseudogene
ENSPCAT00000000003.1protein_coding
ENSPCAT00000000004.1protein_coding
ENSPCAT00000000005.1protein_coding
ENSPCAT00000000006.1protein_coding
ENSPCAT00000000007.1protein_coding
ENSPCAT00000000008.1protein_coding
ENSPCAT00000000009.1protein_coding
ENSPCAT00000000010.1protein_coding
ENSPCAT00000000011.1protein_coding

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