Schema for knownToSuper
  Database: mm8    Primary Table: knownToSuper    Row Count: 26,547   Data last updated: 2006-06-22
Format description: Map protein superfamilies to known genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene NM_008221varchar(255) values Known gene ID
superfamily 46458int(11) range Superfamily ID
start 1int(11) range Start of superfamily domain in protein (0 based)
end 147int(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)
      mm8.affyGnfU74ADistance.query (via knownToSuper.gene)
      mm8.affyGnfU74ADistance.target (via knownToSuper.gene)
      mm8.affyGnfU74BDistance.query (via knownToSuper.gene)
      mm8.affyGnfU74BDistance.target (via knownToSuper.gene)
      mm8.affyGnfU74CDistance.query (via knownToSuper.gene)
      mm8.affyGnfU74CDistance.target (via knownToSuper.gene)
      mm8.ccdsKgMap.geneId (via knownToSuper.gene)
      mm8.ceBlastTab.query (via knownToSuper.gene)
      mm8.dmBlastTab.query (via knownToSuper.gene)
      mm8.drBlastTab.query (via knownToSuper.gene)
      mm8.dupSpMrna.mrnaID (via knownToSuper.gene)
      mm8.foldUtr3.name (via knownToSuper.gene)
      mm8.foldUtr5.name (via knownToSuper.gene)
      mm8.gnfAtlas2Distance.query (via knownToSuper.gene)
      mm8.gnfAtlas2Distance.target (via knownToSuper.gene)
      mm8.hgBlastTab.query (via knownToSuper.gene)
      mm8.keggPathway.kgID (via knownToSuper.gene)
      mm8.kgAlias.kgID (via knownToSuper.gene)
      mm8.kgProtAlias.kgID (via knownToSuper.gene)
      mm8.kgSpAlias.kgID (via knownToSuper.gene)
      mm8.kgTargetAli.qName (via knownToSuper.gene)
      mm8.kgXref.kgID (via knownToSuper.gene)
      mm8.knownBlastTab.query (via knownToSuper.gene)
      mm8.knownBlastTab.target (via knownToSuper.gene)
      mm8.knownCanonical.transcript (via knownToSuper.gene)
      mm8.knownGene.name (via knownToSuper.gene)
      mm8.knownGeneMrna.name (via knownToSuper.gene)
      mm8.knownGenePep.name (via knownToSuper.gene)
      mm8.knownIsoforms.transcript (via knownToSuper.gene)
      mm8.knownToAllenBrain.name (via knownToSuper.gene)
      mm8.knownToEnsembl.name (via knownToSuper.gene)
      mm8.knownToGnfAtlas2.name (via knownToSuper.gene)
      mm8.knownToKeggEntrez.name (via knownToSuper.gene)
      mm8.knownToLocusLink.name (via knownToSuper.gene)
      mm8.knownToPfam.name (via knownToSuper.gene)
      mm8.knownToRefSeq.name (via knownToSuper.gene)
      mm8.knownToVisiGene.name (via knownToSuper.gene)
      mm8.rnBlastTab.query (via knownToSuper.gene)
      mm8.scBlastTab.query (via knownToSuper.gene)

Sample Rows
 
genesuperfamilystartendeVal
NM_0082214645811470
BC0894564645811470
AK0110534645811470
NM_0104054645811420
NM_0082184645811420
BC0430204645811420
NM_03020646458181721.6e-39
NM_0135934645811541.1e-38
NM_0224144645821502.1e-35
NM_1750004645831396.8e-31

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