Schema for wgEncodeGencodeExonSupportV47
  Database: hg38    Primary Table: wgEncodeGencodeExonSupportV47    Row Count: 12,441,510   Data last updated: 2024-10-17
Format description: GENCODE exon support from other datasets
On download server: MariaDB table dump directory
fieldexampleSQL type description
transcriptId ENST00000511072.5varchar(255) GENCODE transcript identifier
seqId BC059838.1varchar(255) Identifier of sequence supporting transcript
seqSrc EMBLvarchar(255) Source of supporting sequence
exonId ENSE00002048533.1varchar(255) GENCODE exon identifier (not stable)
chrom chr1varchar(255) Chromosome
chromStart 3069167int(10) unsigned Start position in chromosome
chromEnd 3069296int(10) unsigned End position in chromosome

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeAttrsV47.transcriptId (via wgEncodeGencodeExonSupportV47.transcriptId)

Sample Rows
 
transcriptIdseqIdseqSrcexonIdchromchromStartchromEnd
ENST00000511072.5BC059838.1EMBLENSE00002048533.1chr130691673069296
ENST00000511072.5AB078876.1EMBLENSE00001754112.1chr131861243186474
ENST00000511072.5AB051462.2EMBLENSE00001754112.1chr131861243186474
ENST00000511072.5NM_022114.3RefSeq_dnaENSE00001754112.1chr131861243186474
ENST00000511072.5BC161614.1EMBLENSE00001754112.1chr131861243186474
ENST00000511072.5NM_199454.2RefSeq_dnaENSE00001754112.1chr131861243186474
ENST00000511072.5BC110593.2EMBLENSE00001754112.1chr131861243186474
ENST00000511072.5AF294278.1EMBLENSE00001754112.1chr131861243186474
ENST00000511072.5Q9HAZ2.3Uniprot/SWISSPROTENSE00001754112.1chr131861243186474
ENST00000511072.5NM_022114.3RefSeq_dnaENSE00003480863.1chr132440863244137

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