Schema for knownToSuper
  Database: hg19    Primary Table: knownToSuper    Row Count: 92,052   Data last updated: 2013-06-16
Format description: Map protein superfamilies to known genes
fieldexampleSQL type info description
gene uc001aal.1varchar(255) values Known gene ID
superfamily 81321int(11) range Superfamily ID
start 0int(11) range Start of superfamily domain in protein (0 based)
end 297int(11) range End (noninclusive) of superfamily domain
eVal 0float range E value of superfamily assignment

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToSuper.gene)
      hg19.ccdsKgMap.geneId (via knownToSuper.gene)
      hg19.ceBlastTab.query (via knownToSuper.gene)
      hg19.dmBlastTab.query (via knownToSuper.gene)
      hg19.drBlastTab.query (via knownToSuper.gene)
      hg19.foldUtr3.name (via knownToSuper.gene)
      hg19.foldUtr5.name (via knownToSuper.gene)
      hg19.gnfAtlas2Distance.query (via knownToSuper.gene)
      hg19.gnfAtlas2Distance.target (via knownToSuper.gene)
      hg19.gnfU95Distance.query (via knownToSuper.gene)
      hg19.gnfU95Distance.target (via knownToSuper.gene)
      hg19.humanHprdP2P.query (via knownToSuper.gene)
      hg19.humanHprdP2P.target (via knownToSuper.gene)
      hg19.humanVidalP2P.query (via knownToSuper.gene)
      hg19.humanVidalP2P.target (via knownToSuper.gene)
      hg19.humanWankerP2P.query (via knownToSuper.gene)
      hg19.humanWankerP2P.target (via knownToSuper.gene)
      hg19.keggPathway.kgID (via knownToSuper.gene)
      hg19.kgAlias.kgID (via knownToSuper.gene)
      hg19.kgColor.kgID (via knownToSuper.gene)
      hg19.kgProtAlias.kgID (via knownToSuper.gene)
      hg19.kgProtMap2.qName (via knownToSuper.gene)
      hg19.kgSpAlias.kgID (via knownToSuper.gene)
      hg19.kgTargetAli.qName (via knownToSuper.gene)
      hg19.kgTxInfo.name (via knownToSuper.gene)
      hg19.kgXref.kgID (via knownToSuper.gene)
      hg19.knownBlastTab.query (via knownToSuper.gene)
      hg19.knownBlastTab.target (via knownToSuper.gene)
      hg19.knownCanonToDecipher.name (via knownToSuper.gene)
      hg19.knownCanonical.transcript (via knownToSuper.gene)
      hg19.knownGene.name (via knownToSuper.gene)
      hg19.knownGeneMrna.name (via knownToSuper.gene)
      hg19.knownGenePep.name (via knownToSuper.gene)
      hg19.knownGeneTxMrna.name (via knownToSuper.gene)
      hg19.knownGeneTxPep.name (via knownToSuper.gene)
      hg19.knownIsoforms.transcript (via knownToSuper.gene)
      hg19.knownToAllenBrain.name (via knownToSuper.gene)
      hg19.knownToDecipher.name (via knownToSuper.gene)
      hg19.knownToEnsembl.name (via knownToSuper.gene)
      hg19.knownToGnfAtlas2.name (via knownToSuper.gene)
      hg19.knownToHInv.name (via knownToSuper.gene)
      hg19.knownToHprd.name (via knownToSuper.gene)
      hg19.knownToKeggEntrez.name (via knownToSuper.gene)
      hg19.knownToLocusLink.name (via knownToSuper.gene)
      hg19.knownToLynx.name (via knownToSuper.gene)
      hg19.knownToMupit.name (via knownToSuper.gene)
      hg19.knownToNextProt.name (via knownToSuper.gene)
      hg19.knownToPfam.name (via knownToSuper.gene)
      hg19.knownToRefSeq.name (via knownToSuper.gene)
      hg19.knownToTreefam.name (via knownToSuper.gene)
      hg19.knownToU133.name (via knownToSuper.gene)
      hg19.knownToU133Plus2.name (via knownToSuper.gene)
      hg19.knownToU95.name (via knownToSuper.gene)
      hg19.knownToVisiGene.name (via knownToSuper.gene)
      hg19.knownToWikipedia.name (via knownToSuper.gene)
      hg19.mmBlastTab.query (via knownToSuper.gene)
      hg19.rnBlastTab.query (via knownToSuper.gene)
      hg19.scBlastTab.query (via knownToSuper.gene)
      hg19.ucscScop.ucscId (via knownToSuper.gene)

Sample Rows
 
genesuperfamilystartendeVal
uc001aal.18132102970
uc010nxu.28132103040
uc010nxv.28132103040
uc001abw.1477695136192.7e-19
uc031pjl.1477694986041.3e-18
uc031pjm.1477695146146.8e-19
uc031pjp.1477694045102.7e-19
uc031pjq.1477693124182.7e-19
uc031pjr.1477691742802.7e-19
uc031pjt.1477694515572.7e-19

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