Schema for knownToSuper
  Database: hg17    Primary Table: knownToSuper    Row Count: 32,906   Data last updated: 2005-06-04
Format description: Map protein superfamilies to known genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene NM_000184varchar(255) values Known gene ID
superfamily 46458int(11) range Superfamily ID
start 2int(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
        hg17.bioCycPathway.kgID (via knownToSuper.gene)
      hg17.ccdsKgMap.geneId (via knownToSuper.gene)
      hg17.ceBlastTab.query (via knownToSuper.gene)
      hg17.dmBlastTab.query (via knownToSuper.gene)
      hg17.drBlastTab.query (via knownToSuper.gene)
      hg17.dupSpMrna.mrnaID (via knownToSuper.gene)
      hg17.foldUtr3.name (via knownToSuper.gene)
      hg17.foldUtr5.name (via knownToSuper.gene)
      hg17.gladHumESDistance.query (via knownToSuper.gene)
      hg17.gladHumESDistance.target (via knownToSuper.gene)
      hg17.gnfAtlas2Distance.query (via knownToSuper.gene)
      hg17.gnfAtlas2Distance.target (via knownToSuper.gene)
      hg17.gnfU95Distance.query (via knownToSuper.gene)
      hg17.gnfU95Distance.target (via knownToSuper.gene)
      hg17.humanHprdP2P.query (via knownToSuper.gene)
      hg17.humanHprdP2P.target (via knownToSuper.gene)
      hg17.humanVidalP2P.query (via knownToSuper.gene)
      hg17.humanVidalP2P.target (via knownToSuper.gene)
      hg17.humanWankerP2P.query (via knownToSuper.gene)
      hg17.humanWankerP2P.target (via knownToSuper.gene)
      hg17.keggPathway.kgID (via knownToSuper.gene)
      hg17.kgAlias.kgID (via knownToSuper.gene)
      hg17.kgProtAlias.kgID (via knownToSuper.gene)
      hg17.kgSpAlias.kgID (via knownToSuper.gene)
      hg17.kgTargetAli.qName (via knownToSuper.gene)
      hg17.kgXref.kgID (via knownToSuper.gene)
      hg17.knownBlastTab.query (via knownToSuper.gene)
      hg17.knownBlastTab.target (via knownToSuper.gene)
      hg17.knownCanonical.transcript (via knownToSuper.gene)
      hg17.knownExpDistance.query (via knownToSuper.gene)
      hg17.knownExpDistance.target (via knownToSuper.gene)
      hg17.knownGene.name (via knownToSuper.gene)
      hg17.knownGeneLink.name (via knownToSuper.gene)
      hg17.knownGeneMrna.name (via knownToSuper.gene)
      hg17.knownGenePep.name (via knownToSuper.gene)
      hg17.knownIsoforms.transcript (via knownToSuper.gene)
      hg17.knownToAllenBrain.name (via knownToSuper.gene)
      hg17.knownToEnsembl.name (via knownToSuper.gene)
      hg17.knownToGnf1h.name (via knownToSuper.gene)
      hg17.knownToGnfAtlas2.name (via knownToSuper.gene)
      hg17.knownToHInv.name (via knownToSuper.gene)
      hg17.knownToHprd.name (via knownToSuper.gene)
      hg17.knownToKeggEntrez.name (via knownToSuper.gene)
      hg17.knownToLocusLink.name (via knownToSuper.gene)
      hg17.knownToPfam.name (via knownToSuper.gene)
      hg17.knownToRefSeq.name (via knownToSuper.gene)
      hg17.knownToU133.name (via knownToSuper.gene)
      hg17.knownToU133Plus2.name (via knownToSuper.gene)
      hg17.knownToU95.name (via knownToSuper.gene)
      hg17.knownToVisiGene.name (via knownToSuper.gene)
      hg17.mmBlastTab.query (via knownToSuper.gene)
      hg17.rankProp.query (via knownToSuper.gene)
      hg17.rankProp.target (via knownToSuper.gene)
      hg17.rnBlastTab.query (via knownToSuper.gene)
      hg17.scBlastTab.query (via knownToSuper.gene)
      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)

Sample Rows
 
genesuperfamilystartendeVal
NM_0001844645821470
NM_0005594645821470
NM_0053304645821470
NM_0005184645821470
NM_0053324645811420
NM_0005174645811420
NM_0005584645811420
NM_0053314645821426.50202e-43
NM_0005194645821354.79945e-42
NM_13426846458181671.2e-39

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