Schema for hgBlastTab
  Database: rn4    Primary Table: hgBlastTab    Row Count: 10,397   Data last updated: 2015-06-23
Format description: Blast alignments of Human genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query RGD:1302933varchar(255) values Name of sequence in this assembly (query)
target uc001wpp.2varchar(255) values Name of sequence in other assembly (target)
identity 61.82float range Percent identity
aliLength 220int(10) unsigned range Length of alignment
mismatch 82int(10) unsigned range Number of mismatches
gapOpen 1int(10) unsigned range Number of gap openings
qStart 28int(10) unsigned range Start in query (0 based)
qEnd 248int(10) unsigned range End in query (non-inclusive)
tStart 29int(10) unsigned range Start in target (0 based)
tEnd 247int(10) unsigned range End in target (non-inclusive)
eValue 2e-75double range Expectation value
bitScore 279double range Bit score

Connected Tables and Joining Fields
        rn4.affyExonTissuesGsMedianDistRgdGene2.query (via hgBlastTab.query)
      rn4.affyExonTissuesGsMedianDistRgdGene2.target (via hgBlastTab.query)
      rn4.affyExonTissuesGsMedianRgdGene2.name (via hgBlastTab.query)
      rn4.affyExonTissuesGsRgdGene2.name (via hgBlastTab.query)
      rn4.ceBlastTab.query (via hgBlastTab.query)
      rn4.dmBlastTab.query (via hgBlastTab.query)
      rn4.drBlastTab.query (via hgBlastTab.query)
      rn4.gnfAtlas2RgdGene2Distance.query (via hgBlastTab.query)
      rn4.gnfAtlas2RgdGene2Distance.target (via hgBlastTab.query)
      rn4.mmBlastTab.query (via hgBlastTab.query)
      rn4.rgdGene2.name (via hgBlastTab.query)
      rn4.rgdGene2BlastTab.query (via hgBlastTab.query)
      rn4.rgdGene2BlastTab.target (via hgBlastTab.query)
      rn4.rgdGene2Canonical.transcript (via hgBlastTab.query)
      rn4.rgdGene2Isoforms.transcript (via hgBlastTab.query)
      rn4.rgdGene2KeggPathway.rgdId (via hgBlastTab.query)
      rn4.rgdGene2Pep.name (via hgBlastTab.query)
      rn4.rgdGene2ToDescription.name (via hgBlastTab.query)
      rn4.rgdGene2ToDisplayId.name (via hgBlastTab.query)
      rn4.rgdGene2ToEnsembl.name (via hgBlastTab.query)
      rn4.rgdGene2ToGenbank.name (via hgBlastTab.query)
      rn4.rgdGene2ToGenbankAll.name (via hgBlastTab.query)
      rn4.rgdGene2ToGnfAtlas2.name (via hgBlastTab.query)
      rn4.rgdGene2ToKeggEntrez.name (via hgBlastTab.query)
      rn4.rgdGene2ToLocusLink.name (via hgBlastTab.query)
      rn4.rgdGene2ToPDB.name (via hgBlastTab.query)
      rn4.rgdGene2ToPfam.name (via hgBlastTab.query)
      rn4.rgdGene2ToRAE230.name (via hgBlastTab.query)
      rn4.rgdGene2ToRefSeq.name (via hgBlastTab.query)
      rn4.rgdGene2ToSymbol.rgdId (via hgBlastTab.query)
      rn4.rgdGene2ToU34A.name (via hgBlastTab.query)
      rn4.rgdGene2ToUniProt.name (via hgBlastTab.query)
      rn4.rgdGene2Xref.rgdGeneId (via hgBlastTab.query)
      rn4.rgdGenePathway.geneId (via hgBlastTab.query)
      rn4.scBlastTab.query (via hgBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
RGD:1302933uc001wpp.261.8222082128248292472e-75279
RGD:1302935uc010edf.364.483661144235273731e-127454
RGD:1302936uc001qsn.474.3546411130456234870726
RGD:1302937uc002hwu.292.99314220944081024164e-151532
RGD:1302937uc002hwu.278.9538800380380.0000000000467.4
RGD:1302938uc001wpq.450.21239114312247122503e-61233
RGD:1302939uc001ntm.297.71437100043704370856
RGD:1302941uc003eyv.379.463366631335183535e-154541
RGD:1302945uc003yym.681.65534980053405340818
RGD:1302946uc003owt.173.1710188377163173901077

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