Schema for knownToSuper
  Database: mm10    Primary Table: knownToSuper    Row Count: 212,704   Data last updated: 2019-09-20
Format description: Map protein superfamilies to known genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSMUST00000000001.4varchar(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)
      mm10.bioCycPathway.kgID (via knownToSuper.gene)
      mm10.ccdsKgMap.geneId (via knownToSuper.gene)
      mm10.ceBlastTab.query (via knownToSuper.gene)
      mm10.dmBlastTab.query (via knownToSuper.gene)
      mm10.drBlastTab.query (via knownToSuper.gene)
      mm10.foldUtr3.name (via knownToSuper.gene)
      mm10.foldUtr5.name (via knownToSuper.gene)
      mm10.hgBlastTab.query (via knownToSuper.gene)
      mm10.keggPathway.kgID (via knownToSuper.gene)
      mm10.kgAlias.kgID (via knownToSuper.gene)
      mm10.kgColor.kgID (via knownToSuper.gene)
      mm10.kgProtAlias.kgID (via knownToSuper.gene)
      mm10.kgProtMap2.qName (via knownToSuper.gene)
      mm10.kgSpAlias.kgID (via knownToSuper.gene)
      mm10.kgTargetAli.qName (via knownToSuper.gene)
      mm10.kgTxInfo.name (via knownToSuper.gene)
      mm10.kgXref.kgID (via knownToSuper.gene)
      mm10.knownAttrs.kgID (via knownToSuper.gene)
      mm10.knownBlastTab.query (via knownToSuper.gene)
      mm10.knownBlastTab.target (via knownToSuper.gene)
      mm10.knownCanonical.transcript (via knownToSuper.gene)
      mm10.knownCds.name (via knownToSuper.gene)
      mm10.knownGene.name (via knownToSuper.gene)
      mm10.knownGeneMrna.name (via knownToSuper.gene)
      mm10.knownGenePep.name (via knownToSuper.gene)
      mm10.knownIsoforms.transcript (via knownToSuper.gene)
      mm10.knownToEnsembl.name (via knownToSuper.gene)
      mm10.knownToKeggEntrez.name (via knownToSuper.gene)
      mm10.knownToLocusLink.name (via knownToSuper.gene)
      mm10.knownToLynx.name (via knownToSuper.gene)
      mm10.knownToMrna.name (via knownToSuper.gene)
      mm10.knownToMrnaSingle.name (via knownToSuper.gene)
      mm10.knownToPfam.name (via knownToSuper.gene)
      mm10.knownToRefSeq.name (via knownToSuper.gene)
      mm10.knownToTag.name (via knownToSuper.gene)
      mm10.knownToVisiGene.name (via knownToSuper.gene)
      mm10.knownToWikipedia.name (via knownToSuper.gene)
      mm10.rnBlastTab.query (via knownToSuper.gene)
      mm10.scBlastTab.query (via knownToSuper.gene)
      mm10.ucscScop.ucscId (via knownToSuper.gene)

Sample Rows
 
genesuperfamilystartendeVal
ENSMUST00000000001.447895601810
ENSMUST00000000001.452540143520
ENSMUST00000000003.135081461710
ENSMUST00000000010.8466891712478.6e-30
ENSMUST00000000010.8886592002470.000033
ENSMUST00000000028.1364182141040.000005
ENSMUST00000000028.13641821892260.000005
ENSMUST00000000033.115699416912.1e-21
ENSMUST00000000049.5821852743080.000082
ENSMUST00000000049.557535203450

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