Schema for wgEncodeGencodeExonSupportVM31
  Database: mm39    Primary Table: wgEncodeGencodeExonSupportVM31    Row Count: 7,146,835   Data last updated: 2022-11-03
Format description: GENCODE exon support from other datasets
On download server: MariaDB table dump directory
fieldexampleSQL type description
transcriptId ENSMUST00000191430.2varchar(255) GENCODE transcript identifier
seqId Q9QZB7.2varchar(255) Identifier of sequence supporting transcript
seqSrc Uniprot/SWISSPROTvarchar(255) Source of supporting sequence
exonId ENSMUSE00001324949.2varchar(255) GENCODE exon identifier (not stable)
chrom chr1varchar(255) Chromosome
chromStart 150983665int(10) unsigned Start position in chromosome
chromEnd 150984611int(10) unsigned End position in chromosome

Connected Tables and Joining Fields
        mm39.wgEncodeGencodeAttrsVM31.transcriptId (via wgEncodeGencodeExonSupportVM31.transcriptId)

Sample Rows
 
transcriptIdseqIdseqSrcexonIdchromchromStartchromEnd
ENSMUST00000191430.2Q9QZB7.2Uniprot/SWISSPROTENSMUSE00001324949.2chr1150983665150984611
ENSMUST00000181451.2P16858.2Uniprot/SWISSPROTENSMUSE00001158900.2chr1151012257151012971
ENSMUST00000181451.2Q5R2J2.1Uniprot/SWISSPROTENSMUSE00001158900.2chr1151012257151012971
ENSMUST00000181451.2P04797.3Uniprot/SWISSPROTENSMUSE00001158900.2chr1151012257151012971
ENSMUST00000181451.2Q4KYY3.3Uniprot/SWISSPROTENSMUSE00001158900.2chr1151012257151012971
ENSMUST00000181451.2P16858.2Uniprot/SWISSPROTENSMUSE00001115039.2chr1151013346151013531
ENSMUST00000181451.2Q4KYY3.3Uniprot/SWISSPROTENSMUSE00001115039.2chr1151013346151013531
ENSMUST00000181451.2Q5R2J2.1Uniprot/SWISSPROTENSMUSE00001115039.2chr1151013346151013531
ENSMUST00000181451.2P04797.3Uniprot/SWISSPROTENSMUSE00001115039.2chr1151013346151013531
ENSMUST00000194081.2AK038167.1EMBLENSMUSE00001337335.2chr1108344806108347562

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