Schema for scBlastTab
Database: hg19    Primary Table: scBlastTab    Row Count: 2,223
Format description: Tab-delimited blast output file
fieldexampleSQL type info description
query uc003szn.2varchar(255) values Name of sequence in this assembly (query)
target YLR403Wvarchar(255) values Name of sequence in other assembly (target)
identity 37.5float range Percent identity
aliLength 88int(10) unsigned range Length of alignment
mismatch 28int(10) unsigned range Number of mismatches
gapOpen 2int(10) unsigned range Number of gap openings
qStart 164int(10) unsigned range Start in query (0 based)
qEnd 225int(10) unsigned range End in query (non-inclusive)
tStart 589int(10) unsigned range Start in target (0 based)
tEnd 677int(10) unsigned range End in target (non-inclusive)
eValue 0.000000000026double range Expectation value
bitScore 63.54double range Bit score
Connected Tables and Joining Fields
      hg19.bioCycPathway.kgID (via scBlastTab.query)
      hg19.ccdsKgMap.geneId (via scBlastTab.query)
      hg19.ceBlastTab.query (via scBlastTab.query)
      hg19.dmBlastTab.query (via scBlastTab.query)
      hg19.drBlastTab.query (via scBlastTab.query)
      hg19.foldUtr3.name (via scBlastTab.query)
      hg19.foldUtr5.name (via scBlastTab.query)
      hg19.gnfAtlas2Distance.query (via scBlastTab.query)
      hg19.gnfAtlas2Distance.target (via scBlastTab.query)
      hg19.humanHprdP2P.query (via scBlastTab.query)
      hg19.humanHprdP2P.target (via scBlastTab.query)
      hg19.humanVidalP2P.query (via scBlastTab.query)
      hg19.humanVidalP2P.target (via scBlastTab.query)
      hg19.humanWankerP2P.query (via scBlastTab.query)
      hg19.humanWankerP2P.target (via scBlastTab.query)
      hg19.keggPathway.kgID (via scBlastTab.query)
      hg19.kg4ToKg5.newId (via scBlastTab.query)
      hg19.kgAlias.kgID (via scBlastTab.query)
      hg19.kgColor.kgID (via scBlastTab.query)
      hg19.kgProtAlias.kgID (via scBlastTab.query)
      hg19.kgProtMap2.qName (via scBlastTab.query)
      hg19.kgSpAlias.kgID (via scBlastTab.query)
      hg19.kgTargetAli.qName (via scBlastTab.query)
      hg19.kgTxInfo.name (via scBlastTab.query)
      hg19.kgXref.kgID (via scBlastTab.query)
      hg19.knownBlastTab.query (via scBlastTab.query)
      hg19.knownBlastTab.target (via scBlastTab.query)
      hg19.knownCanonical.protein (via scBlastTab.query)
      hg19.knownCanonical.transcript (via scBlastTab.query)
      hg19.knownGene.name (via scBlastTab.query)
      hg19.knownGeneMrna.name (via scBlastTab.query)
      hg19.knownGenePep.name (via scBlastTab.query)
      hg19.knownIsoforms.transcript (via scBlastTab.query)
      hg19.knownToAllenBrain.name (via scBlastTab.query)
      hg19.knownToEnsembl.name (via scBlastTab.query)
      hg19.knownToGnfAtlas2.name (via scBlastTab.query)
      hg19.knownToHprd.name (via scBlastTab.query)
      hg19.knownToLocusLink.name (via scBlastTab.query)
      hg19.knownToPfam.name (via scBlastTab.query)
      hg19.knownToRefSeq.name (via scBlastTab.query)
      hg19.knownToSuper.gene (via scBlastTab.query)
      hg19.knownToTreefam.name (via scBlastTab.query)
      hg19.knownToU133.name (via scBlastTab.query)
      hg19.knownToVisiGene.name (via scBlastTab.query)
      hg19.mmBlastTab.query (via scBlastTab.query)
      hg19.rnBlastTab.query (via scBlastTab.query)
Sample Rows
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
uc003szn.2YLR403W37.5882821642255896770.00000000002663.54
uc003tqg.2YDR086C35.386535016615800.0000003847.37
uc010eyh.2YMR212C24.2710375212113101120.00000150.45
uc010ggh.2YMR165C47.7424311235908213465862.8e-63238.4
uc003uhb.1YER020W43.93281764313531214473e-76280
uc010exo.2YLR383W23.161075716194510727911067.3e-88320.5
uc010gfm.2YPL098C34.62784400780780.00001242.36
uc010ewt.2YIR029W29.92371205110366223431.3e-43171.8
uc010ges.2YPL237W44.77239114737268522857.8e-47181.8
uc003sxl.2YJR048W64.36101360110261076.1e-37146.4

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