Schema for esRegUpstreamRegion
  Database: sacCer3    Primary Table: esRegUpstreamRegion    Row Count: 1,670   Data last updated: 2011-09-06
Format description: Browser extensible data
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 Reference sequence chromosome or scaffold
chromStart 9016int(11) range Start position in chromosome
chromEnd 9516int(11) range End position in chromosome
name YAL067Cvarchar(255) values Name of item
score 0int(11) range Optional score, nominal range 0-1000
strand -char(1) values + or -

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

Sample Rows
 
binchromchromStartchromEndnamescorestrand
585chrI90169516YAL067C0-
585chrI3465435154YAL060W0+
585chrI4167542176YAL055W0+
585chrI4502245522YAL054C0-
585chrI5846258962YAL044C0-
585chrI7615276652YAL036C0-
585chrI8195182451YAL034C0-
585chrI8678587285YAL030W0+
585chrI9227092770YAL029C0-
585chrI130300130798YAL012W0+

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