Schema for hgBlastTab
  Database: dm2    Primary Table: hgBlastTab    Row Count: 5,833   Data last updated: 2007-04-03
Format description: Blast alignments of Human genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query CG10354-RAvarchar(255) values Name of sequence in this assembly (query)
target uc002wsf.1varchar(255) values Name of sequence in other assembly (target)
identity 56.59float range Percent identity
aliLength 827int(10) unsigned range Length of alignment
mismatch 316int(10) unsigned range Number of mismatches
gapOpen 11int(10) unsigned range Number of gap openings
qStart 0int(10) unsigned range Start in query (0 based)
qEnd 789int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 822int(10) unsigned range End in target (non-inclusive)
eValue 0double range Expectation value
bitScore 889double range Bit score

Connected Tables and Joining Fields
        dm2.arbExpDistance.query (via hgBlastTab.query)
      dm2.arbExpDistance.target (via hgBlastTab.query)
      dm2.ceBlastTab.query (via hgBlastTab.query)
      dm2.drBlastTab.query (via hgBlastTab.query)
      dm2.flyBase2004Xref.name (via hgBlastTab.query)
      dm2.flyBaseBlastTab.query (via hgBlastTab.query)
      dm2.flyBaseBlastTab.target (via hgBlastTab.query)
      dm2.flyBaseCanonical.transcript (via hgBlastTab.query)
      dm2.flyBaseGene.name (via hgBlastTab.query)
      dm2.flyBaseIsoforms.transcript (via hgBlastTab.query)
      dm2.flyBaseNoncoding.name (via hgBlastTab.query)
      dm2.flyBasePep.name (via hgBlastTab.query)
      dm2.flyBaseToCG.name (via hgBlastTab.query)
      dm2.flyBaseToDescription.name (via hgBlastTab.query)
      dm2.flyBaseToPfam.name (via hgBlastTab.query)
      dm2.flyBaseToRefSeq.name (via hgBlastTab.query)
      dm2.flyBaseToUniProt.name (via hgBlastTab.query)
      dm2.flyP2P.query (via hgBlastTab.query)
      dm2.flyP2P.target (via hgBlastTab.query)
      dm2.mmBlastTab.query (via hgBlastTab.query)
      dm2.rnBlastTab.query (via hgBlastTab.query)
      dm2.scBlastTab.query (via hgBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
CG10354-RAuc002wsf.156.5982731611078908220889
CG9773-RAuc002szd.156.65233100142274422752e-70263
CG13761-RBuc001ibl.128.9429267734459234183e-51200
CG8344-RAuc001tlp.169.021117340524113716113101524
CG5826-RAuc001lec.163.920572127232502534e-74275
CG14749-RAuc004bvj.132.5328918443956774116965e-43173
CG14750-RAuc002ibi.143.02172971317441764e-41164
CG3408-RAuc002iqt.144.51173922017301697.0000000000000006e-34142
CG32555-RAuc002pfv.134.65961581183935139562.0000000000000002e-162572
CG9333-RAuc003fdc.135.437314481030748167369e-135478

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