Schema for knownToSuper
  Database: mm9    Primary Table: knownToSuper    Row Count: 62,369   Data last updated: 2011-03-03
Format description: Map protein superfamilies to known genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene uc007aew.1varchar(255) values Known gene ID
superfamily 89837int(11) range Superfamily ID
start 29int(11) range Start of superfamily domain in protein (0 based)
end 138int(11) range End (noninclusive) of superfamily domain
eVal 7.4e-31float 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)
      mm9.affyGnfU74ADistance.query (via knownToSuper.gene)
      mm9.affyGnfU74ADistance.target (via knownToSuper.gene)
      mm9.affyGnfU74BDistance.query (via knownToSuper.gene)
      mm9.affyGnfU74BDistance.target (via knownToSuper.gene)
      mm9.affyGnfU74CDistance.query (via knownToSuper.gene)
      mm9.affyGnfU74CDistance.target (via knownToSuper.gene)
      mm9.bioCycPathway.kgID (via knownToSuper.gene)
      mm9.ccdsKgMap.geneId (via knownToSuper.gene)
      mm9.ceBlastTab.query (via knownToSuper.gene)
      mm9.dmBlastTab.query (via knownToSuper.gene)
      mm9.drBlastTab.query (via knownToSuper.gene)
      mm9.foldUtr3.name (via knownToSuper.gene)
      mm9.foldUtr5.name (via knownToSuper.gene)
      mm9.gnfAtlas2Distance.query (via knownToSuper.gene)
      mm9.gnfAtlas2Distance.target (via knownToSuper.gene)
      mm9.hgBlastTab.query (via knownToSuper.gene)
      mm9.keggPathway.kgID (via knownToSuper.gene)
      mm9.kgAlias.kgID (via knownToSuper.gene)
      mm9.kgColor.kgID (via knownToSuper.gene)
      mm9.kgProtAlias.kgID (via knownToSuper.gene)
      mm9.kgProtMap2.qName (via knownToSuper.gene)
      mm9.kgSpAlias.kgID (via knownToSuper.gene)
      mm9.kgTargetAli.qName (via knownToSuper.gene)
      mm9.kgTxInfo.name (via knownToSuper.gene)
      mm9.kgXref.kgID (via knownToSuper.gene)
      mm9.knownBlastTab.query (via knownToSuper.gene)
      mm9.knownBlastTab.target (via knownToSuper.gene)
      mm9.knownCanonical.protein (via knownToSuper.gene)
      mm9.knownCanonical.transcript (via knownToSuper.gene)
      mm9.knownGene.name (via knownToSuper.gene)
      mm9.knownGeneMrna.name (via knownToSuper.gene)
      mm9.knownGenePep.name (via knownToSuper.gene)
      mm9.knownIsoforms.transcript (via knownToSuper.gene)
      mm9.knownToAllenBrain.name (via knownToSuper.gene)
      mm9.knownToEnsembl.name (via knownToSuper.gene)
      mm9.knownToGnfAtlas2.name (via knownToSuper.gene)
      mm9.knownToKeggEntrez.name (via knownToSuper.gene)
      mm9.knownToLocusLink.name (via knownToSuper.gene)
      mm9.knownToPfam.name (via knownToSuper.gene)
      mm9.knownToRefSeq.name (via knownToSuper.gene)
      mm9.knownToVisiGene.name (via knownToSuper.gene)
      mm9.rnBlastTab.query (via knownToSuper.gene)
      mm9.scBlastTab.query (via knownToSuper.gene)
      mm9.ucscScop.ucscId (via knownToSuper.gene)

Sample Rows
 
genesuperfamilystartendeVal
uc007aew.189837291387.4e-31
uc007aew.1898371512571.4e-20
uc007aex.289837191287.4e-31
uc007aex.2898371412471.4e-20
uc007aey.147095471623.4e-30
uc007aez.147095471623.4e-30
uc007afa.14709537970.00000000019
uc007afc.147095471623.4e-30
uc007aff.252080301849.5e-28
uc007afd.252080301841.5e-27

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