Schema for wgEncodeGencodeExonSupportV42
  Database: hg38    Primary Table: wgEncodeGencodeExonSupportV42    Row Count: 12,257,694   Data last updated: 2022-11-04
Format description: GENCODE exon support from other datasets
On download server: MariaDB table dump directory
fieldexampleSQL type description
transcriptId ENST00000673477.1varchar(255) GENCODE transcript identifier
seqId BC014101.2varchar(255) Identifier of sequence supporting transcript
seqSrc EMBLvarchar(255) Source of supporting sequence
exonId ENSE00003889014.1varchar(255) GENCODE exon identifier (not stable)
chrom chr1varchar(255) Chromosome
chromStart 1471764int(10) unsigned Start position in chromosome
chromEnd 1472089int(10) unsigned End position in chromosome

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeAttrsV42.transcriptId (via wgEncodeGencodeExonSupportV42.transcriptId)

Sample Rows
 
transcriptIdseqIdseqSrcexonIdchromchromStartchromEnd
ENST00000673477.1BC014101.2EMBLENSE00003889014.1chr114717641472089
ENST00000673477.1NM_031921.4RefSeq_dnaENSE00003889014.1chr114717641472089
ENST00000673477.1BC018701.1EMBLENSE00003889014.1chr114717641472089
ENST00000673477.1Q96T67.1Uniprot/SPTREMBLENSE00003889014.1chr114717641472089
ENST00000673477.1Q5T9A4.1Uniprot/SWISSPROTENSE00003889014.1chr114717641472089
ENST00000673477.1BC014101.2EMBLENSE00003467707.1chr114772731477350
ENST00000673477.1NM_031921.4RefSeq_dnaENSE00003467707.1chr114772731477350
ENST00000673477.1BC018701.1EMBLENSE00003467707.1chr114772731477350
ENST00000673477.1GU189416.1EMBLENSE00003467707.1chr114772731477350
ENST00000673477.1BC002542.2EMBLENSE00003467707.1chr114772731477350

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