Schema for dmBlastTab
  Database: sacCer2    Primary Table: dmBlastTab    Row Count: 2,064   Data last updated: 2010-08-19
Format description: Blast alignments of Drosophila genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query YMR315Wvarchar(255) values Name of sequence in this assembly (query)
target CG3597-RAvarchar(255) values Name of sequence in other assembly (target)
identity 29.31float range Percent identity
aliLength 116int(10) unsigned range Length of alignment
mismatch 76int(10) unsigned range Number of mismatches
gapOpen 3int(10) unsigned range Number of gap openings
qStart 3int(10) unsigned range Start in query (0 based)
qEnd 117int(10) unsigned range End in query (non-inclusive)
tStart 6int(10) unsigned range Start in target (0 based)
tEnd 118int(10) unsigned range End in target (non-inclusive)
eValue 0.0003double range Expectation value
bitScore 43.1double range Bit score

Connected Tables and Joining Fields
        sacCer2.ceBlastTab.query (via dmBlastTab.query)
      sacCer2.choExpDistance.query (via dmBlastTab.query)
      sacCer2.choExpDistance.target (via dmBlastTab.query)
      sacCer2.drBlastTab.query (via dmBlastTab.query)
      sacCer2.esRegGeneToModule.gene (via dmBlastTab.query)
      sacCer2.esRegGeneToMotif.gene (via dmBlastTab.query)
      sacCer2.esRegUpstreamRegion.name (via dmBlastTab.query)
      sacCer2.hgBlastTab.query (via dmBlastTab.query)
      sacCer2.mmBlastTab.query (via dmBlastTab.query)
      sacCer2.rnBlastTab.query (via dmBlastTab.query)
      sacCer2.sgdAbundance.name (via dmBlastTab.query)
      sacCer2.sgdBlastTab.query (via dmBlastTab.query)
      sacCer2.sgdBlastTab.target (via dmBlastTab.query)
      sacCer2.sgdCanonical.transcript (via dmBlastTab.query)
      sacCer2.sgdDescription.name (via dmBlastTab.query)
      sacCer2.sgdGene.name (via dmBlastTab.query)
      sacCer2.sgdIsoforms.transcript (via dmBlastTab.query)
      sacCer2.sgdLocalization.name (via dmBlastTab.query)
      sacCer2.sgdPep.name (via dmBlastTab.query)
      sacCer2.sgdToName.name (via dmBlastTab.query)
      sacCer2.sgdToPfam.name (via dmBlastTab.query)
      sacCer2.sgdToSwissProt.name (via dmBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
YMR315WCG3597-RA29.31116763311761180.000343.1
YMR314WCG5648-RA46.582341231023402321e-55212
YMR309CCG4954-RA26.9617394141757712228037e-55212
YMR299CCG1938-RC24.21578541582872403910.00438.9
YMR310CCG12128-RA26.563051711410290663430.000000000164.3
YHR072W-ACG7637-RA70.91551600550556.0000000000000004e-1885.5
YMR308CCG1059-RA30.76108668722131058910713e-118423
YMR304WCG1490-RB39.5851825313385511005637e-97352
YMR296CCG4016-RC33.054752601083550434687e-67251
YMR293CCG6007-RA33.41422264543457704833e-53206

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