Schema for wgEncodeGencodeExonSupportV50

Database: hg38 Primary Table: wgEncodeGencodeExonSupportV50 Row Count: 37,953,734 Data last updated: 2026-04-24
Format description: GENCODE exon support from other datasets
On download server: MariaDB table dump directory

field	example	SQL type	description
`transcriptId`	ENST00000564261.1	`varchar(255)`	GENCODE transcript identifier
`seqId`	BC042499.1	`varchar(255)`	Identifier of sequence supporting transcript
`seqSrc`	EMBL	`varchar(255)`	Source of supporting sequence
`exonId`	ENSE00002600197.1	`varchar(255)`	GENCODE exon identifier (not stable)
`chrom`	chr1	`varchar(255)`	Chromosome
`chromStart`	5492977	`int(10) unsigned`	Start position in chromosome
`chromEnd`	5494674	`int(10) unsigned`	End position in chromosome

Connected Tables and Joining Fields


	hg38.wgEncodeGencodeAttrsV50.transcriptId (via wgEncodeGencodeExonSupportV50.transcriptId)

Sample Rows

transcriptId	seqId	seqSrc	exonId	chrom	chromStart	chromEnd
ENST00000564261.1	BC042499.1	EMBL	ENSE00002600197.1	chr1	5492977	5494674
ENST00000635556.1	BX111285.1	EMBL	ENSE00001754951.1	chr1	4572469	4572592
ENST00000635556.1	BX111285.1	EMBL	ENSE00001690743.1	chr1	4582276	4582574
ENST00000420522.1	BX111285.1	EMBL	ENSE00001696075.1	chr1	4571547	4571629
ENST00000420522.1	BX111285.1	EMBL	ENSE00001754951.1	chr1	4572469	4572592
ENST00000420522.1	BX111285.1	EMBL	ENSE00001690743.1	chr1	4582276	4582574
ENST00000420522.1	BX111285.1	EMBL	ENSE00001622561.1	chr1	4583082	4583178
ENST00000420522.1	BX111285.1	EMBL	ENSE00001801330.1	chr1	4583338	4583421
ENST00000659059.1	BX111285.1	EMBL	ENSE00001754951.1	chr1	4572469	4572592
ENST00000667354.1	BX111285.1	EMBL	ENSE00001754951.1	chr1	4572469	4572592

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