Schema for knownToSuper
Database: hg19    Primary Table: knownToSuper    Row Count: 91,188
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.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.kg4ToKg5.newId (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.knownCanonical.protein (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.knownIsoforms.transcript (via knownToSuper.gene)
      hg19.knownToAllenBrain.name (via knownToSuper.gene)
      hg19.knownToEnsembl.name (via knownToSuper.gene)
      hg19.knownToGnfAtlas2.name (via knownToSuper.gene)
      hg19.knownToHprd.name (via knownToSuper.gene)
      hg19.knownToLocusLink.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.knownToVisiGene.name (via knownToSuper.gene)
      hg19.mmBlastTab.query (via knownToSuper.gene)
      hg19.rnBlastTab.query (via knownToSuper.gene)
      hg19.scBlastTab.query (via knownToSuper.gene)
Sample Rows
genesuperfamilystartendeVal
uc001aal.18132102970
uc010nxu.18132103040
uc010nxv.18132103040
uc001abw.1477695136192.7e-19
uc001abx.1477693764822.7e-19
uc001aca.1509523826030.0000061
uc001aca.1638253406060.00000019
uc001aca.11018983166050.0000000000084
uc001aca.1509653066040
uc001aca.1509693346060.0000000000084

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