Schema for esRegUpstreamRegion
  Database: sacCer2    Primary Table: esRegUpstreamRegion    Row Count: 1,670   Data last updated: 2009-02-17
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 9017int(11) range Start position in chromosome
chromEnd 9517int(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
        sacCer2.ceBlastTab.query (via esRegUpstreamRegion.name)
      sacCer2.choExpDistance.query (via esRegUpstreamRegion.name)
      sacCer2.choExpDistance.target (via esRegUpstreamRegion.name)
      sacCer2.dmBlastTab.query (via esRegUpstreamRegion.name)
      sacCer2.drBlastTab.query (via esRegUpstreamRegion.name)
      sacCer2.esRegGeneToModule.gene (via esRegUpstreamRegion.name)
      sacCer2.esRegGeneToMotif.gene (via esRegUpstreamRegion.name)
      sacCer2.hgBlastTab.query (via esRegUpstreamRegion.name)
      sacCer2.mmBlastTab.query (via esRegUpstreamRegion.name)
      sacCer2.rnBlastTab.query (via esRegUpstreamRegion.name)
      sacCer2.sgdAbundance.name (via esRegUpstreamRegion.name)
      sacCer2.sgdBlastTab.query (via esRegUpstreamRegion.name)
      sacCer2.sgdBlastTab.target (via esRegUpstreamRegion.name)
      sacCer2.sgdCanonical.transcript (via esRegUpstreamRegion.name)
      sacCer2.sgdDescription.name (via esRegUpstreamRegion.name)
      sacCer2.sgdGene.name (via esRegUpstreamRegion.name)
      sacCer2.sgdIsoforms.transcript (via esRegUpstreamRegion.name)
      sacCer2.sgdLocalization.name (via esRegUpstreamRegion.name)
      sacCer2.sgdPep.name (via esRegUpstreamRegion.name)
      sacCer2.sgdToName.name (via esRegUpstreamRegion.name)
      sacCer2.sgdToPfam.name (via esRegUpstreamRegion.name)
      sacCer2.sgdToSwissProt.name (via esRegUpstreamRegion.name)

Sample Rows
 
binchromchromStartchromEndnamescorestrand
585chrI90179517YAL067C0-
585chrI3465535155YAL060W0+
585chrI4167642177YAL055W0+
585chrI4502345523YAL054C0-
585chrI5846358963YAL044C0-
585chrI7615376653YAL036C0-
585chrI8195282452YAL034C0-
585chrI8678687286YAL030W0+
585chrI9227192771YAL029C0-
585chrI130301130801YAL012W0+

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