Schema for drBlastTab
  Database: hg18    Primary Table: drBlastTab    Row Count: 11,982   Data last updated: 2009-03-03
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query uc010ggu.1varchar(255) values Name of sequence in this assembly (query)
target ENSDART00000082821varchar(255) values Name of sequence in other assembly (target)
identity 83.47float range Percent identity
aliLength 236int(10) unsigned range Length of alignment
mismatch 38int(10) unsigned range Number of mismatches
gapOpen 1int(10) unsigned range Number of gap openings
qStart 34int(10) unsigned range Start in query (0 based)
qEnd 270int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 235int(10) unsigned range End in target (non-inclusive)
eValue 1e-109double range Expectation value
bitScore 393double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
uc010ggu.1ENSDART0000008282183.472363813427002351e-109393
uc003syx.1ENSDART0000000604364.29168544016711648e-57218
uc010fpt.1ENSDART0000008894383.99331482032603316e-169590
uc003szn.1ENSDART0000007934390.12243240024302432e-96348
uc003uie.1ENSDART0000000460466.927982603480019999501188
uc010ezj.1ENSDART0000009319649.684692123661111604591e-134479
uc003syv.1ENSDART0000004676645.57395148131741003303e-63239
uc003trd.1ENSDART0000007632074.44133293012901324.0000000000000005e-49189
uc003uid.1ENSDART0000004730976.51847169888451584201246
uc010fpr.1ENSDART0000008095936.84285145918946602582.9999999999999996e-42171

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