Schema for wgEncodeGencodeExonSupportV28

JavaScript is disabled in your web browser

You must have JavaScript enabled in your web browser to use the Genome Browser

Schema for wgEncodeGencodeExonSupportV28

Database: hg38 Primary Table: wgEncodeGencodeExonSupportV28 Row Count: 12,454,712 Data last updated: 2020-06-30

field	example	SQL type
`transcriptId`	ENST00000456328.2	`varchar(255)`
`seqId`	BM920887.1	`varchar(255)`
`seqSrc`	EMBL	`varchar(255)`
`exonId`	ENSE00002234944.1	`varchar(255)`
`chrom`	chr1	`varchar(255)`
`chromStart`	11868	`int(10) unsigned`
`chromEnd`	12227	`int(10) unsigned`

Connected Tables and Joining Fields


	hg38.wgEncodeGencodeAttrsV28.transcriptId (via wgEncodeGencodeExonSupportV28.transcriptId)

Sample Rows

transcriptId	seqId	seqSrc	exonId	chrom	chromStart	chromEnd
ENST00000456328.2	BM920887.1	EMBL	ENSE00002234944.1	chr1	11868	12227
ENST00000456328.2	BM920886.1	EMBL	ENSE00002234944.1	chr1	11868	12227
ENST00000456328.2	AM992871.1	EMBL	ENSE00002234944.1	chr1	11868	12227
ENST00000456328.2	AM992872.1	EMBL	ENSE00002234944.1	chr1	11868	12227
ENST00000456328.2	AM992875.1	EMBL	ENSE00002234944.1	chr1	11868	12227
ENST00000456328.2	BM920887.1	EMBL	ENSE00003582793.1	chr1	12612	12721
ENST00000456328.2	BM920886.1	EMBL	ENSE00003582793.1	chr1	12612	12721
ENST00000456328.2	AM992871.1	EMBL	ENSE00003582793.1	chr1	12612	12721
ENST00000456328.2	AM992872.1	EMBL	ENSE00003582793.1	chr1	12612	12721
ENST00000456328.2	AM992875.1	EMBL	ENSE00003582793.1	chr1	12612	12721

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