Schema for wgEncodeGencodeExonSupportV40
  Database: hg38    Primary Table: wgEncodeGencodeExonSupportV40    Row Count: 12,024,182   Data last updated: 2022-04-21
Format description: GENCODE exon support from other datasets
On download server: MariaDB table dump directory
fieldexampleSQL type description
transcriptId ENST00000379236.4varchar(255) GENCODE transcript identifier
seqId BM918500.1varchar(255) Identifier of sequence supporting transcript
seqSrc EMBLvarchar(255) Source of supporting sequence
exonId ENSE00001832731.2varchar(255) GENCODE exon identifier (not stable)
chrom chr1varchar(255) Chromosome
chromStart 1213982int(10) unsigned Start position in chromosome
chromEnd 1214153int(10) unsigned End position in chromosome

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeAttrsV40.transcriptId (via wgEncodeGencodeExonSupportV40.transcriptId)

Sample Rows
 
transcriptIdseqIdseqSrcexonIdchromchromStartchromEnd
ENST00000379236.4BM918500.1EMBLENSE00001832731.2chr112139821214153
ENST00000379236.4S76792.1EMBLENSE00001832731.2chr112139821214153
ENST00000379236.4X75962.1EMBLENSE00001832731.2chr112139821214153
ENST00000379236.4BC105070.1EMBLENSE00001832731.2chr112139821214153
ENST00000379236.4NM_003327.3RefSeq_dnaENSE00001832731.2chr112139821214153
ENST00000379236.4BC105072.1EMBLENSE00001832731.2chr112139821214153
ENST00000379236.4P43489.1Uniprot/SWISSPROTENSE00001832731.2chr112139821214153
ENST00000379236.4S76792.1EMBLENSE00001333068.1chr112136621213785
ENST00000379236.4BC105070.1EMBLENSE00001333068.1chr112136621213785
ENST00000379236.4X75962.1EMBLENSE00001333068.1chr112136621213785

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