<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="background-color: transparent;">Hi Kiran,</span><div><span class="Apple-style-span" style="background-color: transparent;"><br></span></div><div><span class="Apple-style-span" style="background-color: transparent;">I am sorry, I forgot to mention that we are now using these MTMP tables to help us build the ensembl, snp and functional genomics marts.</span></div><div><span class="Apple-style-span" style="background-color: transparent;">You will have to create them before updating the mart schema.</span></div><div><span class="Apple-style-span" style="background-color: transparent;"><br></span></div><div><span class="Apple-style-span" style="background-color: transparent;">1) <span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; ">MTMP_probestuff_helper tables for the Ensembl mart: </span></span></div><div><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: transparent;">This table need to be built for all the funcgen databases.</span></div><div><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; background-color: transparent;">You can use the iterate_tables.ksh script to iterate over multiple species databases and use the probestuff_helper.sql file to create this table in each database.</span></span></div><div><span class="Apple-style-span" style="background-color: transparent;"><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; ">2) </span><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; ">Variation views for snp mart and Ensembl mart :</span></span></div><div><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; background-color: transparent;">You will need to run the variation_views.sql and the structural_variation.sql files for all the variation databases using the iterate_tables.ksh script.</span></span></div><div><span class="Apple-style-span" style="background-color: transparent;"><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; ">3) </span><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; ">eFG views for Functional genomics mart:</span></span></div><div><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: transparent;">The functional genomics views and tables are created for all the funcgen databases </span><span class="Apple-style-span" style="line-height: 17px; ">using the iterate_tables.ksh script.</span></div><div><span class="Apple-style-span" style="line-height: 17px; "><br></span></div><div><div style="text-align: left;">Please find the<span class="Apple-style-span" style="background-color: transparent;"><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; "> sql files and the </span><span class="Apple-style-span" style="line-height: 17px; "><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; ">iterate_tables.ksh script</span></span><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; "> </span></span>at the following location: <span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; "> </span><a href="http://www.ebi.ac.uk/~maurel/mart_prebuild_patches/">http://www.ebi.ac.uk/~maurel/mart_prebuild_patches/</a></div><div style="text-align: left;"><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; background-color: transparent;"><br></span></div><div style="text-align: left;"><span style="font-variant: normal; letter-spacing: normal; line-height: 17px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; background-color: transparent;">Hope this helps,</span></div><div style="text-align: left;"><span class="Apple-style-span" style="line-height: 17px; ">Regards,</span></div><div style="text-align: left;"><span class="Apple-style-span" style="line-height: 17px; background-color: transparent;">Thomas</span></div><div><div>On 9 Jul 2012, at 06:40, Kiran Mukhyala wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Thanks Thomas for the mart builder files.<br><br>It looks like the Ensembl Mart building process has introduced usage of new tables like MTMP_transcript_variation and MTMP_probestuff_helper, etc.<br>Would you please explain how to generate these tables? If its documented anywhere, please do point me to it.<br>
<br>Thanks,<br>-Kiran<br><br><div class="gmail_quote">On Sat, Jun 30, 2012 at 1:59 AM, Thomas Maurel <span dir="ltr"><<a href="mailto:maurel@ebi.ac.uk" target="_blank">maurel@ebi.ac.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204, 204); border-left-style: solid; padding-left: 1ex; position: static; z-index: auto; ">
<div style="word-wrap:break-word">Hi Kiran,<div><br></div><div>Please find the martbuilder xmls for release 67 at the following location : </div><div><a href="http://www.ebi.ac.uk/%7Emaurel/v67_xml/" target="_blank">http://www.ebi.ac.uk/~maurel/v67_xml/</a></div>
<div><br></div><div>Regards,</div><div>Thomas</div><div><br><div><div><div class="h5"><div>On 29 Jun 2012, at 18:28, Kiran Mukhyala wrote:</div><br></div></div><blockquote type="cite"><div><div class="h5">Hi Rhoda,<br>
<br>
Could you please provide the e67 core, funcgen and variation martbuilder files?<br>
<br>
Thanks,<br>
-Kiran<br><br><div class="gmail_quote">On Wed, Jan 11, 2012 at 3:16 AM, Rhoda Kinsella <span dir="ltr"><<a href="mailto:rhoda@ebi.ac.uk" target="_blank">rhoda@ebi.ac.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">Hi Kiran<div>I have provided the files you requested for release 64 and release 65 at the following location:</div><div><br></div><div><a href="http://www.ebi.ac.uk/%7Erhoda/v64_v65_xml/" target="_blank">http://www.ebi.ac.uk/~rhoda/v64_v65_xml/</a></div>
<div><br></div><div>Regards</div><div>Rhoda</div><div><br></div><div><div><div><br><div><div>On 9 Jan 2012, at 19:46, Kiran Mukhyala wrote:</div><br><blockquote type="cite">Hello Ensembl BioMart Team,<br> <br> Could you please provide the e64 core, funcgen and variation martbuilder files?<br>
<br> Thanks,<br> -Kiran<br><br><div class="gmail_quote">On Mon, May 9, 2011 at 5:38 AM, Rhoda Kinsella <span dir="ltr"><<a href="mailto:rhoda@ebi.ac.uk" target="_blank">rhoda@ebi.ac.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi Kiran<br> You can find the files you need at:<br> <br> <a href="http://www.ebi.ac.uk/%7Erhoda/v62_xml/" target="_blank">http://www.ebi.ac.uk/~rhoda/<u></u>v62_xml/</a><br> <br> Regards<br> Rhoda<div><div><br> <br> On 7 May 2011, at 04:08, Kiran Mukhyala wrote:<br>
<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> Hello,<br> <br> I'd like to upgrade my mart to e62, could you please provide the e62 core, funcgen and variation mart builder files?<br>
<br> Thanks,<br> -Kiran<br> </blockquote> <br></div></div><span><font color="#888888"> Rhoda Kinsella Ph.D.<br> Ensembl Bioinformatician,<br> European Bioinformatics Institute (EMBL-EBI),<br> Wellcome Trust Genome Campus,<br>
Hinxton<br> Cambridge CB10 1SD,<br> UK.<br> <br> </font></span></blockquote></div><br></blockquote></div><br></div></div><div> <div style="word-wrap:break-word"><span style="text-indent:0px;letter-spacing:normal;font-variant:normal;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:12px;white-space:normal;font-family:Helvetica;word-spacing:0px"><div style="word-wrap:break-word">
<span style="text-indent:0px;letter-spacing:normal;font-variant:normal;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:12px;white-space:normal;font-family:Helvetica;word-spacing:0px"><div style="word-wrap:break-word">
<div>Rhoda Kinsella Ph.D.</div><div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;font:normal normal normal 12px/normal Helvetica">Ensembl Production Project Leader,</div></div><div>
<div>European Bioinformatics Institute (EMBL-EBI),<br>Wellcome Trust Genome Campus, </div><div>Hinxton<br>Cambridge CB10 1SD,</div><div>UK.</div></div></div></span></div></span></div> </div><br></div></div></blockquote></div>
<br></div></div>
_______________________________________________<br>Dev mailing list <a href="mailto:Dev@ensembl.org" target="_blank">Dev@ensembl.org</a><br>List admin (including subscribe/unsubscribe): <a href="http://lists.ensembl.org/mailman/listinfo/dev" target="_blank">http://lists.ensembl.org/mailman/listinfo/dev</a><br>
Ensembl Blog: <a href="http://www.ensembl.info/" target="_blank">http://www.ensembl.info/</a><br></blockquote></div><br></div><br><br><div>
<span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:-webkit-auto;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-spacing:0px"><span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:-webkit-auto;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-spacing:0px"><div style="word-wrap:break-word">
<span style="text-indent:0px;letter-spacing:normal;font-variant:normal;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-spacing:0px"><div style="word-wrap:break-word">
<span style="text-indent:0px;letter-spacing:normal;font-variant:normal;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-spacing:0px"><div style="word-wrap:break-word">
<div>--</div><div>Thomas Maurel<br>Bioinformatician - Ensembl Production Team<br>European Bioinformatics Institute (EMBL-EBI)<div class="im"><br>Wellcome Trust Genome Campus, Hinxton<br></div>Cambridge - CB10 1SD - UK</div>
</div></span></div></span></div></span></span>
</div>
<br></div><br>_______________________________________________<br>
Dev mailing list <a href="mailto:Dev@ensembl.org">Dev@ensembl.org</a><br>
List admin (including subscribe/unsubscribe): <a href="http://lists.ensembl.org/mailman/listinfo/dev" target="_blank">http://lists.ensembl.org/mailman/listinfo/dev</a><br>
Ensembl Blog: <a href="http://www.ensembl.info/" target="_blank">http://www.ensembl.info/</a><br>
<br></blockquote></div><br>
</blockquote></div><br><div apple-content-edited="true">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>--</div><div>Thomas Maurel<br>Bioinformatician - Ensembl Production Team<br>European Bioinformatics Institute (EMBL-EBI)<br>Wellcome Trust Genome Campus, Hinxton<br>Cambridge - CB10 1SD - UK</div></div></div></div>
</div>
<br></div><br><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; 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-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; 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-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>--</div><div>Thomas Maurel<br>Bioinformatician - Ensembl Production Team<br>European Bioinformatics Institute (EMBL-EBI)<br>Wellcome Trust Genome Campus, Hinxton<br>Cambridge - CB10 1SD - UK</div></div></span></div></span></div></span></span>
</div>
<br></body></html>