Schema for esRegUpstreamRegion
  Database: sacCer1    Primary Table: esRegUpstreamRegion    Row Count: 1,670   Data last updated: 2004-03-27
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 chr1varchar(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
        sacCer1.choExpDistance.query (via esRegUpstreamRegion.name)
      sacCer1.choExpDistance.target (via esRegUpstreamRegion.name)
      sacCer1.dmBlastTab.query (via esRegUpstreamRegion.name)
      sacCer1.esRegGeneToModule.gene (via esRegUpstreamRegion.name)
      sacCer1.esRegGeneToMotif.gene (via esRegUpstreamRegion.name)
      sacCer1.hgBlastTab.query (via esRegUpstreamRegion.name)
      sacCer1.mmBlastTab.query (via esRegUpstreamRegion.name)
      sacCer1.rnBlastTab.query (via esRegUpstreamRegion.name)
      sacCer1.sgdAbundance.name (via esRegUpstreamRegion.name)
      sacCer1.sgdBlastTab.query (via esRegUpstreamRegion.name)
      sacCer1.sgdBlastTab.target (via esRegUpstreamRegion.name)
      sacCer1.sgdCanonical.transcript (via esRegUpstreamRegion.name)
      sacCer1.sgdDescription.name (via esRegUpstreamRegion.name)
      sacCer1.sgdGene.name (via esRegUpstreamRegion.name)
      sacCer1.sgdIsoforms.transcript (via esRegUpstreamRegion.name)
      sacCer1.sgdLocalization.name (via esRegUpstreamRegion.name)
      sacCer1.sgdPep.name (via esRegUpstreamRegion.name)
      sacCer1.sgdToName.name (via esRegUpstreamRegion.name)
      sacCer1.sgdToPfam.name (via esRegUpstreamRegion.name)
      sacCer1.sgdToSwissProt.name (via esRegUpstreamRegion.name)

Sample Rows
 
binchromchromStartchromEndnamescorestrand
585chr190179517YAL067C0-
585chr13465535155YAL060W0+
585chr14167642176YAL055W0+
585chr14502245522YAL054C0-
585chr15846458964YAL044C0-
585chr17615476654YAL036C0-
585chr18195382453YAL034C0-
585chr18678787287YAL030W0+
585chr19227292772YAL029C0-
585chr1130301130801YAL012W0+

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