<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Sunita,<br>
<br>
The genomic sequence of the assembly is stored in the dna table,
only in the core database.<br>
Generally though, features are stored on chromosomes, which
themselves are assembled from the various bits of genomic sequence
stored in the dna table.<br>
<br>
We do not recommend querying the database directly to retrieve
sequences.<br>
We provide a number of tools to do so in an easier fashion.<br>
<br>
If you are familiar with perl programming, you can use our perl API.<br>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<a
href="http://www.ensembl.org/info/docs/Doxygen/core-api/index.html">http://www.ensembl.org/info/docs/Doxygen/core-api/index.html</a><br>
<br>
The sequences can also be downloaded via our ftp site <br>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<a href="http://www.ensembl.org/info/data/ftp/index.html">http://www.ensembl.org/info/data/ftp/index.html</a><br>
<br>
Various endpoints can be retrieved using our new rest service<br>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<a href="http://beta.rest.ensembl.org/">http://beta.rest.ensembl.org/</a><br>
<br>
Or you can use our biomart server<br>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<a
href="http://www.ensembl.org/biomart/martview/07e32c2046773639dad947c91ff9ef7a">http://www.ensembl.org/biomart/martview/07e32c2046773639dad947c91ff9ef7a</a><br>
<br>
<br>
Hope that helps,<br>
Magali<br>
<br>
<br>
<div class="moz-cite-prefix">On 04/03/13 17:34, Koul, Sunita wrote:<br>
</div>
<blockquote
cite="mid:1A6A79886DDB9043A6B2A89D747ED57D3C6E8F72@pathmbx01.wusm-path.wustl.edu"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
span.EmailStyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.WordSection1
{}
-->
</style>
<div class="WordSection1">
<p class="MsoNormal">Hi,</p>
<p class="MsoNormal">I have locally setup the mysql databases
for Homo Sapiens</p>
<p class="MsoNormal">Here are the different schemas I have</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">homo_sapiens_core_69_37</p>
<p class="MsoNormal">homo_sapiens_cdna_69_37</p>
<p class="MsoNormal">homo_sapiens_coreexpressionatlas_69_37</p>
<p class="MsoNormal">….</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I am trying to figure out where the actual
sequences are stored .</p>
<p class="MsoNormal">For e.g if I am interested in a genomic
sequence of “EGFR” gene how do I get it from these tables</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks</p>
<p class="MsoNormal">Sunita</p>
</div>
<br>
<br>
<table style="font-size:11px; font-family:arial,sans-serif;
font-weight:bold; font-style:italic">
<tbody>
<tr>
<td style="border-top:1px solid #000000; padding-top:7px">The
materials in this email are private and may contain
Protected Health Information. If you are not the intended
recipient, be advised that any unauthorized use,
disclosure, copying, distribution or the taking of any
action in reliance on the contents of this information is
strictly prohibited. If you have received this email in
error, please immediately notify the sender via telephone
or return email.</td>
</tr>
</tbody>
</table>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Dev mailing list <a class="moz-txt-link-abbreviated" href="mailto:Dev@ensembl.org">Dev@ensembl.org</a>
Posting guidelines and subscribe/unsubscribe info: <a class="moz-txt-link-freetext" href="http://lists.ensembl.org/mailman/listinfo/dev">http://lists.ensembl.org/mailman/listinfo/dev</a>
Ensembl Blog: <a class="moz-txt-link-freetext" href="http://www.ensembl.info/">http://www.ensembl.info/</a>
</pre>
</blockquote>
<br>
</body>
</html>