<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Syed,<div>Thank you for reporting this issue. We are currently looking into the cause of the problem. In the meantime, you can get the downstream sequences for Fly from the Ensembl Genomes BioMart databases here:</div><div><br></div><div><a href="http://metazoa.ensembl.org/biomart/martview/">http://metazoa.ensembl.org/biomart/martview/</a></div><div><br></div><div>I hope that helps,</div><div>Regards</div><div>Rhoda</div><div><br></div><div><br></div><div><br></div><div><div><div>On 16 Apr 2014, at 21:45, "Bukhari, Syed Abbas" <<a href="mailto:sbukhar@illinois.edu">sbukhar@illinois.edu</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Hi I am trying to extract 2MB downstream sequence of a genes using biomart, but it is not allowing to do that on the ensembl biomart website. Is there any problem extracting downstream sequences for fly? Or should i consider extracting sequences using R? <br><br>Thanks<br>On Apr 16, 2014, at 10:07 AM, <a href="mailto:dev-request@ensembl.org">dev-request@ensembl.org</a> wrote:<br><br><blockquote type="cite">Send Dev mailing list submissions to<br><span class="Apple-tab-span" style="white-space:pre"> </span><a href="mailto:dev@ensembl.org">dev@ensembl.org</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br><span class="Apple-tab-span" style="white-space:pre"> </span>http://lists.ensembl.org/mailman/listinfo/dev<br>or, via email, send a message with subject or body 'help' to<br><span class="Apple-tab-span" style="white-space:pre"> </span>dev-request@ensembl.org<br><br>You can reach the person managing the list at<br><span class="Apple-tab-span" style="white-space:pre"> </span>dev-owner@ensembl.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Dev digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Gene and RS (Igo Medeiros)<br> 2. Re: Gene and RS (Igo Medeiros)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Wed, 16 Apr 2014 11:52:28 -0300<br>From: Igo Medeiros <igo701@gmail.com><br>Subject: Re: [ensembl-dev] Gene and RS<br>To: Ensembl developers list <dev@ensembl.org><br>Message-ID:<br><span class="Apple-tab-span" style="white-space:pre"> </span><CAE5otB=oA=uC+9RT=a0P7NUqfSAD3BgXvAeCNyYxjhJyS1gmrA@mail.gmail.com><br>Content-Type: text/plain; charset="utf-8"<br><br>I am study the documentation about VEP too.<br><br><br>2014-04-16 11:52 GMT-03:00 Igo Medeiros <igo701@gmail.com>:<br><br><blockquote type="cite">How can I access gene table?<br>I saw VEP, but i need study more about.<br><br><br>2014-04-16 11:16 GMT-03:00 Will McLaren <wm2@ebi.ac.uk>:<br><br>Have you considered using our Variant Effect Predictor tool (VEP)?<br><blockquote type="cite"><br>http://www.ensembl.org/info/docs/tools/vep/index.html<br><br>It's very useful for investigating novel variations found in sequencing<br>experiments and the like, and can probably give you a lot of the<br>information you need without having to write any code.<br><br>The gene name is found in the xref (external reference) table, linked via<br>the display_xref_id column in the gene table:<br><br>SELECT display_label<br>FROM gene g, xref x<br>WHERE g.display_xref_id = x.xref_id<br>AND g.stable_id = 'ENSG00000196218';<br><br><br>On 16 April 2014 14:55, Igo Medeiros <igo701@gmail.com> wrote:<br><br><blockquote type="cite">Thank you,<br>both are help me.<br>I was looking just in schema homo_sapiens_variation_75_37, not in<br>homo_sapiens_core_75_37 too. Now I understand better why a lot of bases.<br>I am usuing PHP ang JQuery, but I would like to change the project, that<br>i am doing, to Perl and BioJS.<br><br>There is a other thing. How can I find for gene name? I am looking for<br>all schema, but until now not found.<br><br>All this is because If don't exist the variation found in lab, in UFPA,<br>in the schemas, I have to find all things connected with that area of<br>sequence. And publications.<br><br><br><br>2014-04-16 10:02 GMT-03:00 Will McLaren <wm2@ebi.ac.uk>:<br><br>If you do want a quick way to get all rsIDs that fall in a gene, this<br><blockquote type="cite">query should work:<br><br>SELECT vf.variation_name<br>FROM homo_sapiens_variation_75_37.variation_feature vf,<br>homo_sapiens_core_75_37.gene g<br>WHERE g.seq_region_id = vf.seq_region_id<br>AND vf.seq_region_end >= g.seq_region_start<br>AND vf.seq_region_start <= g.seq_region_end<br>AND vf.source_id = 1<br>AND g.stable_id = 'ENSG00000196218'<br><br>Replace ENSG00000196218 with the stable identifier of your gene of<br>interest. Remove "AND vf.source_id = 1" if you also want variation features<br>from sources that aren't dbSNP.<br><br>As Kieron says, we would encourage you to use our perl API, REST API or<br>BioMart, all of which can accomplish this same task without the risks of<br>schema changes.<br><br>The REST API is particularly suited to this sort of task; the following<br>URL retrieves all variants in a gene with ID ENSG00000157764:<br><br><br>http://beta.rest.ensembl.org/feature/id/ENSG00000157764?feature=variation;content-type=application/json<br><br>See http://beta.rest.ensembl.org/documentation/info/feature_id for<br>more details.<br><br>Regards<br><br>Will McLaren<br>Ensembl Variation<br><br><br>On 16 April 2014 13:46, Kieron Taylor <ktaylor@ebi.ac.uk> wrote:<br><br><blockquote type="cite">Ensembl has a table for each genetic feature type, hence we have a<br>Transcript table, a Gene table, and one for each class of variation. Each<br>table shares a common set of fields, plus more that are specific to that<br>feature. This is slightly contrary to a traditionally normalised schema.<br><br>It is not clear to me what you mean by "RS inside a Gene". If you wish<br>to understand our schema, please take a look at the following link.<br><br>http://www.ensembl.org/info/docs/api/core/core_schema.html<br><br>I urge you to find another way to access our data if at all possible.<br>Direct SQL queries against our schema is sometimes the right solution, but<br>suffers when we have to make changes in later releases. Our API and other<br>services insulate you from these changes. Also, some commonly required data<br>is computed and therefore cannot be found in the database at all.<br><br>Regards,<br><br>Kieron Taylor<br>Ensembl Core<br><br><br>On 16/04/2014 13:17, Igo Medeiros wrote:<br><br><blockquote type="cite">Hi,<br>how can I found relation, in DB, between Gene and all RS inside Gene?<br>there are columns like seq_region_start, seq_region_end ans<br>seq_region_id those repeat in three tables(variation_feature,<br>structural_variation_feature and phenotype_feature), what the diferent<br>between them?<br>Sorry for my english, its not so good. And thank you for help.<br><br>--<br>Igo Paix?o de Medeiros<br><br><br></blockquote><br>_______________________________________________<br>Dev mailing list Dev@ensembl.org<br>Posting guidelines and subscribe/unsubscribe info:<br>http://lists.ensembl.org/mailman/listinfo/dev<br>Ensembl Blog: http://www.ensembl.info/<br><br></blockquote><br><br>_______________________________________________<br>Dev mailing list Dev@ensembl.org<br>Posting guidelines and subscribe/unsubscribe info:<br>http://lists.ensembl.org/mailman/listinfo/dev<br>Ensembl Blog: http://www.ensembl.info/<br><br><br></blockquote><br><br>--<br>Igo Paix?o de Medeiros<br><br>_______________________________________________<br>Dev mailing list Dev@ensembl.org<br>Posting guidelines and subscribe/unsubscribe info:<br>http://lists.ensembl.org/mailman/listinfo/dev<br>Ensembl Blog: http://www.ensembl.info/<br><br><br></blockquote><br>_______________________________________________<br>Dev mailing list Dev@ensembl.org<br>Posting guidelines and subscribe/unsubscribe info:<br>http://lists.ensembl.org/mailman/listinfo/dev<br>Ensembl Blog: http://www.ensembl.info/<br><br><br></blockquote><br><br>--<br>Igo Paix?o de Medeiros<br><br></blockquote><br><br><br>-- <br>Igo Paix?o de Medeiros<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.ensembl.org/pipermail/dev/attachments/20140416/2a4c6d30/attachment-0001.htm><br><br>------------------------------<br><br>Message: 2<br>Date: Wed, 16 Apr 2014 12:07:28 -0300<br>From: Igo Medeiros <igo701@gmail.com><br>Subject: Re: [ensembl-dev] Gene and RS<br>To: Ensembl developers list <dev@ensembl.org><br>Message-ID:<br><span class="Apple-tab-span" style="white-space:pre"> </span><CAE5otB=+zH1v9hjJ-n+anyvHnN87OYK91XSs43TV4q3hF+4XMw@mail.gmail.com><br>Content-Type: text/plain; charset="utf-8"<br><br>Sorry for my lack of attention. I saw the table.<br>Thank you for help.<br><br><br><br>2014-04-16 11:52 GMT-03:00 Igo Medeiros <igo701@gmail.com>:<br><br><blockquote type="cite">I am study the documentation about VEP too.<br><br><br>2014-04-16 11:52 GMT-03:00 Igo Medeiros <igo701@gmail.com>:<br><br>How can I access gene table?<br><blockquote type="cite">I saw VEP, but i need study more about.<br><br><br>2014-04-16 11:16 GMT-03:00 Will McLaren <wm2@ebi.ac.uk>:<br><br>Have you considered using our Variant Effect Predictor tool (VEP)?<br><blockquote type="cite"><br>http://www.ensembl.org/info/docs/tools/vep/index.html<br><br>It's very useful for investigating novel variations found in sequencing<br>experiments and the like, and can probably give you a lot of the<br>information you need without having to write any code.<br><br>The gene name is found in the xref (external reference) table, linked<br>via the display_xref_id column in the gene table:<br><br>SELECT display_label<br>FROM gene g, xref x<br>WHERE g.display_xref_id = x.xref_id<br>AND g.stable_id = 'ENSG00000196218';<br><br><br>On 16 April 2014 14:55, Igo Medeiros <igo701@gmail.com> wrote:<br><br><blockquote type="cite">Thank you,<br>both are help me.<br>I was looking just in schema homo_sapiens_variation_75_37, not in<br>homo_sapiens_core_75_37 too. Now I understand better why a lot of bases.<br>I am usuing PHP ang JQuery, but I would like to change the project,<br>that i am doing, to Perl and BioJS.<br><br>There is a other thing. How can I find for gene name? I am looking for<br>all schema, but until now not found.<br><br>All this is because If don't exist the variation found in lab, in UFPA,<br>in the schemas, I have to find all things connected with that area of<br>sequence. And publications.<br><br><br><br>2014-04-16 10:02 GMT-03:00 Will McLaren <wm2@ebi.ac.uk>:<br><br>If you do want a quick way to get all rsIDs that fall in a gene, this<br><blockquote type="cite">query should work:<br><br>SELECT vf.variation_name<br>FROM homo_sapiens_variation_75_37.variation_feature vf,<br>homo_sapiens_core_75_37.gene g<br>WHERE g.seq_region_id = vf.seq_region_id<br>AND vf.seq_region_end >= g.seq_region_start<br>AND vf.seq_region_start <= g.seq_region_end<br>AND vf.source_id = 1<br>AND g.stable_id = 'ENSG00000196218'<br><br>Replace ENSG00000196218 with the stable identifier of your gene of<br>interest. Remove "AND vf.source_id = 1" if you also want variation features<br>from sources that aren't dbSNP.<br><br>As Kieron says, we would encourage you to use our perl API, REST API<br>or BioMart, all of which can accomplish this same task without the risks of<br>schema changes.<br><br>The REST API is particularly suited to this sort of task; the<br>following URL retrieves all variants in a gene with ID ENSG00000157764:<br><br><br>http://beta.rest.ensembl.org/feature/id/ENSG00000157764?feature=variation;content-type=application/json<br><br>See http://beta.rest.ensembl.org/documentation/info/feature_id for<br>more details.<br><br>Regards<br><br>Will McLaren<br>Ensembl Variation<br><br><br>On 16 April 2014 13:46, Kieron Taylor <ktaylor@ebi.ac.uk> wrote:<br><br><blockquote type="cite">Ensembl has a table for each genetic feature type, hence we have a<br>Transcript table, a Gene table, and one for each class of variation. Each<br>table shares a common set of fields, plus more that are specific to that<br>feature. This is slightly contrary to a traditionally normalised schema.<br><br>It is not clear to me what you mean by "RS inside a Gene". If you<br>wish to understand our schema, please take a look at the following link.<br><br>http://www.ensembl.org/info/docs/api/core/core_schema.html<br><br>I urge you to find another way to access our data if at all possible.<br>Direct SQL queries against our schema is sometimes the right solution, but<br>suffers when we have to make changes in later releases. Our API and other<br>services insulate you from these changes. Also, some commonly required data<br>is computed and therefore cannot be found in the database at all.<br><br>Regards,<br><br>Kieron Taylor<br>Ensembl Core<br><br><br>On 16/04/2014 13:17, Igo Medeiros wrote:<br><br><blockquote type="cite">Hi,<br>how can I found relation, in DB, between Gene and all RS inside Gene?<br>there are columns like seq_region_start, seq_region_end ans<br>seq_region_id those repeat in three tables(variation_feature,<br>structural_variation_feature and phenotype_feature), what the<br>diferent<br>between them?<br>Sorry for my english, its not so good. And thank you for help.<br><br>--<br>Igo Paix?o de Medeiros<br><br><br></blockquote><br>_______________________________________________<br>Dev mailing list Dev@ensembl.org<br>Posting guidelines and subscribe/unsubscribe info:<br>http://lists.ensembl.org/mailman/listinfo/dev<br>Ensembl Blog: http://www.ensembl.info/<br><br></blockquote><br><br>_______________________________________________<br>Dev mailing list Dev@ensembl.org<br>Posting guidelines and subscribe/unsubscribe info:<br>http://lists.ensembl.org/mailman/listinfo/dev<br>Ensembl Blog: http://www.ensembl.info/<br><br><br></blockquote><br><br>--<br>Igo Paix?o de Medeiros<br><br>_______________________________________________<br>Dev mailing list Dev@ensembl.org<br>Posting guidelines and subscribe/unsubscribe info:<br>http://lists.ensembl.org/mailman/listinfo/dev<br>Ensembl Blog: http://www.ensembl.info/<br><br><br></blockquote><br>_______________________________________________<br>Dev mailing list Dev@ensembl.org<br>Posting guidelines and subscribe/unsubscribe info:<br>http://lists.ensembl.org/mailman/listinfo/dev<br>Ensembl Blog: http://www.ensembl.info/<br><br><br></blockquote><br><br>--<br>Igo Paix?o de Medeiros<br><br></blockquote><br><br><br>--<br>Igo Paix?o de Medeiros<br><br></blockquote><br><br><br>-- <br>Igo Paix?o de Medeiros<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.ensembl.org/pipermail/dev/attachments/20140416/b619196f/attachment.htm><br><br>------------------------------<br><br>_______________________________________________<br>Dev mailing list Dev@ensembl.org<br>Posting guidelines and subscribe/unsubscribe info: http://lists.ensembl.org/mailman/listinfo/dev<br>Ensembl Blog: http://www.ensembl.info/<br><br><br>End of Dev Digest, Vol 46, Issue 20<br>***********************************<br></blockquote><br><br>_______________________________________________<br>Dev mailing list <a href="mailto:Dev@ensembl.org">Dev@ensembl.org</a><br>Posting guidelines and subscribe/unsubscribe info: <a href="http://lists.ensembl.org/mailman/listinfo/dev">http://lists.ensembl.org/mailman/listinfo/dev</a><br>Ensembl Blog: <a href="http://www.ensembl.info/">http://www.ensembl.info/</a><br></blockquote></div><br><div>
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Rhoda Kinsella Ph.D.</div><div>Ensembl Production Project Leader</div><div>European Bioinformatics Institute (EMBL-EBI)</div><div>European Molecular Biology Laboratory</div><div>Wellcome Trust Genome Campus</div><div>Hinxton,</div><div>Cambridge</div><div>CB10 1SD</div><div><br></div></div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<br></div></body></html>