Schema for wgEncodeGencodeExonSupportVM26
  Database: mm39    Primary Table: wgEncodeGencodeExonSupportVM26    Row Count: 1,684,420   Data last updated: 2021-03-13
Format description: GENCODE exon support from other datasets
On download server: MariaDB table dump directory
fieldexampleSQL type description
transcriptId ENSMUST00000070533.5varchar(255) GENCODE transcript identifier
seqId Q5GH67.1varchar(255) Identifier of sequence supporting transcript
seqSrc Uniprot/SWISSPROTvarchar(255) Source of supporting sequence
exonId ENSMUSE00000485541.4varchar(255) GENCODE exon identifier (not stable)
chrom chr1varchar(255) Chromosome
chromStart 3740774int(10) unsigned Start position in chromosome
chromEnd 3741721int(10) unsigned End position in chromosome

Connected Tables and Joining Fields
        mm39.wgEncodeGencodeAttrsVM26.transcriptId (via wgEncodeGencodeExonSupportVM26.transcriptId)

Sample Rows
 
transcriptIdseqIdseqSrcexonIdchromchromStartchromEnd
ENSMUST00000070533.5Q5GH67.1Uniprot/SWISSPROTENSMUSE00000485541.4chr137407743741721
ENSMUST00000070533.5Q5GH67Uniprot/SWISSPROTENSMUSE00000485541.4chr137407743741721
ENSMUST00000070533.5NP_001011874RefSeq_peptideENSMUSE00000485541.4chr137407743741721
ENSMUST00000070533.5BC103806.1ENSMUSE00000449517.4chr134919243492124
ENSMUST00000070533.5Q5GH67.1Uniprot/SWISSPROTENSMUSE00000449517.4chr134919243492124
ENSMUST00000070533.5Q5GH67Uniprot/SWISSPROTENSMUSE00000449517.4chr134919243492124
ENSMUST00000070533.5NP_001011874RefSeq_peptideENSMUSE00000449517.4chr134919243492124
ENSMUST00000070533.5Q5GH67Uniprot/SWISSPROTENSMUSE00000448840.3chr132847043287191
ENSMUST00000070533.5NP_001011874RefSeq_peptideENSMUSE00000448840.3chr132847043287191
ENSMUST00000070533.5Q5GH67.1Uniprot/SWISSPROTENSMUSE00000448840.3chr132847043287191

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