Schema for hgBlastTab
  Database: sacCer2    Primary Table: hgBlastTab    Row Count: 2,214   Data last updated: 2010-08-18
Format description: Blast alignments of Human genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query YMR315Wvarchar(255) values Name of sequence in this assembly (query)
target uc002ple.1varchar(255) values Name of sequence in other assembly (target)
identity 27.69float range Percent identity
aliLength 242int(10) unsigned range Length of alignment
mismatch 148int(10) unsigned range Number of mismatches
gapOpen 11int(10) unsigned range Number of gap openings
qStart 3int(10) unsigned range Start in query (0 based)
qEnd 235int(10) unsigned range End in query (non-inclusive)
tStart 2int(10) unsigned range Start in target (0 based)
tEnd 227int(10) unsigned range End in target (non-inclusive)
eValue 0.000001double range Expectation value
bitScore 52double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
YMR315Wuc002ple.127.6924214811323522270.00000152
YMR314Wuc001mlk.252.772351082023402336.999999999999999e-64241
YMR309Cuc002dqu.328.25701428191177942098595e-60231
YHR072W-Auc001zie.160.34582300580580.000000000000172.8
YMR308Cuc001vne.229.671038675182010283710509e-107386
YMR304Wuc002czl.229.721154612293811726710423.9999999999999997e-122437
YMR296Cuc004arl.133.83467258883547474668.999999999999999e-70262
YMR293Cuc003prm.233.41437252943457674882e-54211
YMR288Wuc002uue.250.9891843247197138613040879
YMR301Cuc011mqn.149.75593287489674926824.9999999999999994e-166582

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