<div dir="ltr"><span style="font-size:13px">Dear EnsEMBL Dev,</span><div dir="ltr" style="font-size:13px"><div><br></div><div>I'm trying to write a raw SQL query to retrieve the sequence for the human BRCA2 gene to compare different methods of accessing EnsEMBL data. I'm currently doing the following, but getting an empty set.</div><div><br></div><div><div>SELECT SUBSTRING(sequence, g.seq_region_start, g.seq_region_end)</div><div>FROM dna d</div><div>JOIN gene g</div><div>ON d.seq_region_id = g.seq_region_id</div><div>WHERE g.stable_id="ENSG00000139618"</div></div><div><br></div><div>What am I missing? I think I'm falling short on working out the coord. system mapping stuff. Any pointers to help in fixing please?</div><div><br></div><div>Cheers,</div><div><br>Steve</div></div><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><a href="http://about.me/gawbul" style="margin:0px;padding:0px;border:0px;outline:0px;font-size:14px;vertical-align:baseline;color:rgb(43,130,173);text-decoration:none;line-height:18px" target="_blank"><font face="tahoma, sans-serif"></font><table border="0" cellpadding="0" cellspacing="0" style="margin:0px;padding:0px;border:0px;outline:0px;font-style:inherit;vertical-align:baseline;border-spacing:0px"><tbody style="margin:0px;padding:0px;border:0px;outline:0px;font-style:inherit;vertical-align:baseline"><tr style="margin:0px;padding:0px;border:0px;outline:0px;font-style:inherit;vertical-align:baseline"><td style="padding:0px;border:0px;outline:0px;font-style:inherit;font-size:0px;vertical-align:baseline;height:30px"> </td></tr><tr style="margin:0px;padding:0px;border:0px;outline:0px;font-style:inherit;vertical-align:baseline"><td align="left" valign="top" style="padding:0px;border:0px;outline:0px;font-style:inherit;vertical-align:top;line-height:1"><div style="margin:0px;padding:0px;border:0px;outline:0px;font-weight:bold;font-style:inherit;font-size:18px;vertical-align:baseline;line-height:1;color:rgb(51,51,51)">Steve Moss</div><div style="margin:3px 0px 0px;padding:0px;border:0px;outline:0px;font-style:inherit;font-size:12px;vertical-align:baseline">about.me/gawbul</div></td></tr><tr style="margin:0px;padding:0px;border:0px;outline:0px;font-style:inherit;vertical-align:baseline"><td align="left" valign="top" style="padding:8px 0px 0px;border:0px;outline:0px;font-style:inherit;vertical-align:top;line-height:1"><div style="margin:0px;padding:0px;border:0px;outline:0px;font-style:inherit;vertical-align:baseline;text-align:right;height:4px;background-color:rgb(197,208,224)"><img src="http://d13pix9kaak6wt.cloudfront.net/signature/colorbar.png" alt="Steve Moss on about.me" width="88" height="4" style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-style: inherit; vertical-align: baseline; float: right; display: block;"></div></td></tr><tr style="margin:0px;padding:0px;border:0px;outline:0px;font-style:inherit;vertical-align:baseline"><td style="padding:0px;border:0px;outline:0px;font-style:inherit;font-size:0px;vertical-align:baseline;height:20px"> </td></tr></tbody></table></a></div></div>
</div>