<p>I have a list of gene symbols. </p>

<blockquote>
  <p>APOB, TTC39B, ATF3, RGS1, LIPG, </p>
</blockquote>

<p>I am trying to get the genomic coordinates (as in bp) with +/-5KB position of these genes via UCSC TableBrowser / MySQL server  using NCBI 36/hg18 build. I have tried to get this information via <a href='http://genome.ucsc.edu/cgi-bin/hgTables'>TableBrowser</a>, but I can't find the chromStart and chromEnd field in the given table. Am I missing something ? </p>

<p>Also, please share your favorite tutorial / docs that explain the schema/tables in UCSC MySQL server. </p>

<p>Thanks in advance. </p>

<p>We used to love the annotation database overview here: <a href="http://genome.ucsc.edu/goldenPath/gbdDescriptionsOld.html">http://genome.ucsc.edu/goldenPath/gbdDescriptionsOld.html</a> And we used to show it to people in trainings all the time. They loved it.  It was much easier to scan through and get a sense of what was available.</p>
<p>But it went away a few years back the upgrade that gave use the "describe table schema" button. We've been asking for a page like it again, but haven't come across it yet.</p>