Schema for knownToSuper
  Database: mm39    Primary Table: knownToSuper    Row Count: 210,628   Data last updated: 2024-08-15
Format description: Map protein superfamilies to known genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSMUST00000000001.5varchar(255) values Known gene ID
superfamily 47895int(11) range Superfamily ID
start 60int(11) range Start of superfamily domain in protein (0 based)
end 181int(11) range End (noninclusive) of superfamily domain
eVal 0float range E value of superfamily assignment

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via knownToSuper.gene)
      knownGeneV39.ceBlastTab.query (via knownToSuper.gene)
      knownGeneV39.dmBlastTab.query (via knownToSuper.gene)
      knownGeneV39.drBlastTab.query (via knownToSuper.gene)
      knownGeneV39.foldUtr3.name (via knownToSuper.gene)
      knownGeneV39.foldUtr5.name (via knownToSuper.gene)
      knownGeneV39.gnfAtlas2Distance.query (via knownToSuper.gene)
      knownGeneV39.gnfAtlas2Distance.target (via knownToSuper.gene)
      knownGeneV39.kgAlias.kgID (via knownToSuper.gene)
      knownGeneV39.kgColor.kgID (via knownToSuper.gene)
      knownGeneV39.kgProtAlias.kgID (via knownToSuper.gene)
      knownGeneV39.kgSpAlias.kgID (via knownToSuper.gene)
      knownGeneV39.kgTargetAli.qName (via knownToSuper.gene)
      knownGeneV39.kgXref.kgID (via knownToSuper.gene)
      knownGeneV39.knownAttrs.kgID (via knownToSuper.gene)
      knownGeneV39.knownBlastTab.query (via knownToSuper.gene)
      knownGeneV39.knownBlastTab.target (via knownToSuper.gene)
      knownGeneV39.knownCanonical.protein (via knownToSuper.gene)
      knownGeneV39.knownCanonical.transcript (via knownToSuper.gene)
      knownGeneV39.knownCds.name (via knownToSuper.gene)
      knownGeneV39.knownGene.name (via knownToSuper.gene)
      knownGeneV39.knownGeneMrna.name (via knownToSuper.gene)
      knownGeneV39.knownGenePep.name (via knownToSuper.gene)
      knownGeneV39.knownIsoforms.transcript (via knownToSuper.gene)
      knownGeneV39.knownToEnsembl.name (via knownToSuper.gene)
      knownGeneV39.knownToGnfAtlas2.name (via knownToSuper.gene)
      knownGeneV39.knownToHprd.name (via knownToSuper.gene)
      knownGeneV39.knownToLocusLink.name (via knownToSuper.gene)
      knownGeneV39.knownToMrna.name (via knownToSuper.gene)
      knownGeneV39.knownToMrnaSingle.name (via knownToSuper.gene)
      knownGeneV39.knownToMupit.name (via knownToSuper.gene)
      knownGeneV39.knownToPfam.name (via knownToSuper.gene)
      knownGeneV39.knownToRefSeq.name (via knownToSuper.gene)
      knownGeneV39.knownToSuper.gene (via knownToSuper.gene)
      knownGeneV39.knownToTag.name (via knownToSuper.gene)
      knownGeneV39.knownToU133.name (via knownToSuper.gene)
      knownGeneV39.knownToU95.name (via knownToSuper.gene)
      knownGeneV39.knownToVisiGene.name (via knownToSuper.gene)
      knownGeneV39.knownToWikipedia.name (via knownToSuper.gene)
      knownGeneV39.mmBlastTab.query (via knownToSuper.gene)
      knownGeneV39.rnBlastTab.query (via knownToSuper.gene)
      knownGeneV39.scBlastTab.query (via knownToSuper.gene)
      knownGeneV39.ucscScop.ucscId (via knownToSuper.gene)
      mm39.bioCycPathway.kgID (via knownToSuper.gene)
      mm39.ceBlastTab.query (via knownToSuper.gene)
      mm39.dmBlastTab.query (via knownToSuper.gene)
      mm39.drBlastTab.query (via knownToSuper.gene)
      mm39.foldUtr3.name (via knownToSuper.gene)
      mm39.foldUtr5.name (via knownToSuper.gene)
      mm39.hgBlastTab.query (via knownToSuper.gene)
      mm39.kgAlias.kgID (via knownToSuper.gene)
      mm39.kgColor.kgID (via knownToSuper.gene)
      mm39.kgProtAlias.kgID (via knownToSuper.gene)
      mm39.kgSpAlias.kgID (via knownToSuper.gene)
      mm39.kgTargetAli.qName (via knownToSuper.gene)
      mm39.kgXref.kgID (via knownToSuper.gene)
      mm39.knownAttrs.kgID (via knownToSuper.gene)
      mm39.knownBlastTab.query (via knownToSuper.gene)
      mm39.knownBlastTab.target (via knownToSuper.gene)
      mm39.knownCanonical.transcript (via knownToSuper.gene)
      mm39.knownCds.name (via knownToSuper.gene)
      mm39.knownGene.name (via knownToSuper.gene)
      mm39.knownGeneMrna.name (via knownToSuper.gene)
      mm39.knownIsoforms.transcript (via knownToSuper.gene)
      mm39.knownToEnsembl.name (via knownToSuper.gene)
      mm39.knownToLocusLink.name (via knownToSuper.gene)
      mm39.knownToMrna.name (via knownToSuper.gene)
      mm39.knownToMrnaSingle.name (via knownToSuper.gene)
      mm39.knownToMupit.name (via knownToSuper.gene)
      mm39.knownToNextProt.name (via knownToSuper.gene)
      mm39.knownToPfam.name (via knownToSuper.gene)
      mm39.knownToRefSeq.name (via knownToSuper.gene)
      mm39.knownToTag.name (via knownToSuper.gene)
      mm39.knownToVisiGene.name (via knownToSuper.gene)
      mm39.knownToWikipedia.name (via knownToSuper.gene)
      mm39.rnBlastTab.query (via knownToSuper.gene)
      mm39.scBlastTab.query (via knownToSuper.gene)
      mm39.ucscScop.ucscId (via knownToSuper.gene)

Sample Rows
 
genesuperfamilystartendeVal
ENSMUST00000000001.547895601810
ENSMUST00000000001.552540143520
ENSMUST00000000003.145081461710
ENSMUST00000000010.9466891712479.7e-30
ENSMUST00000000010.9886592002470.000037
ENSMUST00000000028.1464182141040.0000028
ENSMUST00000000028.14641821892260.0000028
ENSMUST00000000033.125699416912.1e-21
ENSMUST00000000049.657535203450
ENSMUST00000000080.85766781980.000000091

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