Schema for esRegGeneToMotif
  Database: sacCer3    Primary Table: esRegGeneToMotif    Row Count: 3,993   Data last updated: 2011-09-06
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 9321int(11) range Start position in chromosome
chromEnd 9336int(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
        sacCer3.ceBlastTab.query (via esRegGeneToMotif.gene)
      sacCer3.choExpDistance.query (via esRegGeneToMotif.gene)
      sacCer3.choExpDistance.target (via esRegGeneToMotif.gene)
      sacCer3.dmBlastTab.query (via esRegGeneToMotif.gene)
      sacCer3.drBlastTab.query (via esRegGeneToMotif.gene)
      sacCer3.esRegGeneToModule.gene (via esRegGeneToMotif.gene)
      sacCer3.esRegUpstreamRegion.name (via esRegGeneToMotif.gene)
      sacCer3.hgBlastTab.query (via esRegGeneToMotif.gene)
      sacCer3.mmBlastTab.query (via esRegGeneToMotif.gene)
      sacCer3.rnBlastTab.query (via esRegGeneToMotif.gene)
      sacCer3.sgdBlastTab.query (via esRegGeneToMotif.gene)
      sacCer3.sgdBlastTab.target (via esRegGeneToMotif.gene)
      sacCer3.sgdCanonical.transcript (via esRegGeneToMotif.gene)
      sacCer3.sgdDescription.name (via esRegGeneToMotif.gene)
      sacCer3.sgdGene.name (via esRegGeneToMotif.gene)
      sacCer3.sgdIsoforms.transcript (via esRegGeneToMotif.gene)
      sacCer3.sgdPep.name (via esRegGeneToMotif.gene)
      sacCer3.sgdToName.name (via esRegGeneToMotif.gene)
      sacCer3.sgdToSwissProt.name (via esRegGeneToMotif.gene)
      sacCer3.esRegMotif.name (via esRegGeneToMotif.name)

Sample Rows
 
binchromchromStartchromEndnamescorestrandgene
585chrI93219336Motif_4991000+YAL067C
585chrI94619467ADR1_011000+YAL067C
585chrI3486934884Motif_5051000-YAL060W
585chrI3486934884Motif_5651000-YAL060W
585chrI3486934884Motif_5711000-YAL060W
585chrI3486934884Motif_5831000-YAL060W
585chrI3487034885Motif_5651000-YAL060W
585chrI3487034885Motif_5831000-YAL060W
585chrI3487034885Motif_6071000+YAL060W
585chrI3487134886Motif_4151000+YAL060W

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