Schema for wgEncodeGencodeExonSupportV23
  Database: hg38    Primary Table: wgEncodeGencodeExonSupportV23    Row Count: 19,014,570   Data last updated: 2015-10-02
Format description: GENCODE exon support from other datasets
On download server: MariaDB table dump directory
fieldexampleSQL type description
transcriptId ENST00000619975.1varchar(255) GENCODE transcript identifier
seqId MI0015254varchar(255) Identifier of sequence supporting transcript
seqSrc miRBasevarchar(255) Source of supporting sequence
exonId ENSE00003718460.1varchar(255) GENCODE exon identifier (not stable)
chrom chrUn_KI270741v1varchar(255) Chromosome
chromStart 68655int(10) unsigned Start position in chromosome
chromEnd 68737int(10) unsigned End position in chromosome

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeAttrsV23.transcriptId (via wgEncodeGencodeExonSupportV23.transcriptId)

Sample Rows
 
transcriptIdseqIdseqSrcexonIdchromchromStartchromEnd
ENST00000619975.1MI0015254miRBaseENSE00003718460.1chrUn_KI270741v16865568737
ENST00000615758.1MI0006359miRBaseENSE00003732225.1chrUn_KI270741v17912679202
ENST00000622088.1MI0015254miRBaseENSE00003743770.1chrUn_KI270741v1107172107255
ENST00000621264.1MI0008503miRBaseENSE00003741023.1chrUn_KI270741v1108769108850
ENST00000612361.1MI0006359miRBaseENSE00003747618.1chrUn_KI270741v1118230118313
ENST00000613409.1MI0015254miRBaseENSE00003752199.1chrUn_KI270741v1121284121368
ENST00000611690.1RF00002-CABD02136542.1/3526-3677RFAMENSE00003723209.1chrUn_KI270442v1217249217401
ENST00000617274.1MI0006336miRBaseENSE00003717919.1chrUn_KI270442v1221097221212
ENST00000620974.1MI0016829miRBaseENSE00003750850.1chrUn_KI270442v1241501241574
ENST00000620265.1RF00001-AADB02147542.1/1024-1143RFAMENSE00003736125.1chrUn_KI270442v1380607380726

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