Schema for wgEncodeGencodeExonSupportV27
  Database: hg38    Primary Table: wgEncodeGencodeExonSupportV27    Row Count: 12,087,633   Data last updated: 2017-09-15
Format description: GENCODE exon support from other datasets
fieldexampleSQL type description
transcriptId ENST00000456328.2varchar(255) GENCODE transcript identifier
seqId BM920887.1varchar(255) Identifier of sequence supporting transcript
seqSrc EMBLvarchar(255) Source of supporting sequence
exonId ENSE00002234944.1varchar(255) GENCODE exon identifier (not stable)
chrom chr1varchar(255) Chromosome
chromStart 11868int(10) unsigned Start position in chromosome
chromEnd 12227int(10) unsigned End position in chromosome

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeAttrsV27.transcriptId (via wgEncodeGencodeExonSupportV27.transcriptId)

Sample Rows
 
transcriptIdseqIdseqSrcexonIdchromchromStartchromEnd
ENST00000456328.2BM920887.1EMBLENSE00002234944.1chr11186812227
ENST00000456328.2BM920886.1EMBLENSE00002234944.1chr11186812227
ENST00000456328.2AM992871.1EMBLENSE00002234944.1chr11186812227
ENST00000456328.2AM992872.1EMBLENSE00002234944.1chr11186812227
ENST00000456328.2AM992875.1EMBLENSE00002234944.1chr11186812227
ENST00000456328.2BM920887.1EMBLENSE00003582793.1chr11261212721
ENST00000456328.2BM920886.1EMBLENSE00003582793.1chr11261212721
ENST00000456328.2AM992871.1EMBLENSE00003582793.1chr11261212721
ENST00000456328.2AM992872.1EMBLENSE00003582793.1chr11261212721
ENST00000456328.2AM992875.1EMBLENSE00003582793.1chr11261212721

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