Schema for esRegGeneToMotif
  Database: sacCer2    Primary Table: esRegGeneToMotif    Row Count: 4,002   Data last updated: 2009-02-17
Format description: arCOG Information
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chrIvarchar(255) values chromosome
chromStart 9322int(11) range Start position in chromosome
chromEnd 9337int(11) range End position in chromosome
name Motif_499varchar(255) values hit name
score 1000int(11) range Score from 900-1000. 1000 is best
strand +char(1) values Value should be + or -
gene YAL067Cvarchar(255) values standard name

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

Sample Rows
 
binchromchromStartchromEndnamescorestrandgene
585chrI93229337Motif_4991000+YAL067C
585chrI94629468ADR1_011000+YAL067C
585chrI3487034885Motif_5051000-YAL060W
585chrI3487034885Motif_5651000-YAL060W
585chrI3487034885Motif_5711000-YAL060W
585chrI3487034885Motif_5831000-YAL060W
585chrI3487134886Motif_5651000-YAL060W
585chrI3487134886Motif_5831000-YAL060W
585chrI3487134886Motif_6071000+YAL060W
585chrI3487234887Motif_4151000+YAL060W

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