Schema for dmBlastTab
  Database: hg19    Primary Table: dmBlastTab    Row Count: 6,031   Data last updated: 2024-08-23
Format description: Blast alignments of Drosophila genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENST00000524756.5_4varchar(255) values Name of sequence in this assembly (query)
target FBtr0075569varchar(255) values Name of sequence in other assembly (target)
identity 32.23float range Percent identity
aliLength 211int(10) unsigned range Length of alignment
mismatch 135int(10) unsigned range Number of mismatches
gapOpen 5int(10) unsigned range Number of gap openings
qStart 339int(10) unsigned range Start in query (0 based)
qEnd 542int(10) unsigned range End in query (non-inclusive)
tStart 39int(10) unsigned range Start in target (0 based)
tEnd 250int(10) unsigned range End in target (non-inclusive)
eValue 5e-21double range Expectation value
bitScore 101double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
ENST00000524756.5_4FBtr007556932.232111355339542392505e-21101
ENST00000229633.7_4FBtr010007041.541307334417421293e-25112
ENST00000367963.8_7FBtr033359933.274993061122499415358e-75279
ENST00000374606.10_4FBtr033018149.09110560611691192e-22101
ENST00000581777.2_9FBtr030086925.632381477742902805100.0000000455.8
ENST00000354862.4_8FBtr008213437.9613777481216121430.000000000000472.8
ENST00000253329.3_7FBtr008473862.813201190032003202e-110397
ENST00000681046.1_5FBtr007031557.07198811982922824808e-50195
ENST00000639544.1_6FBtr010063857.9911264081784117946113801214
ENST00000451613.5_5FBtr034024332.13445240121915991705902e-49195

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