Hi Aminah,<div><br></div><div>Thanks so much for writing this. I will attempt to get it transfered to the wiki in the next week or so. I will let you know if I have any questions.</div><div><br></div><div>Thanks again,</div>
<div><br></div><div>Dave C<br><br><div class="gmail_quote">On Tue, Apr 20, 2010 at 2:13 AM, Aminah Keliet <span dir="ltr"><<a href="mailto:aminah-olivia.keliet@versailles.inra.fr">aminah-olivia.keliet@versailles.inra.fr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi,<br>
<br>
The document "how to load chado database into BioMart" is attached. If informations is missing, please let me know. If the English translation is not correct, you can edit this document (.doc format).<br>
<br>
In the hope that it serves Chado users,<br>
<br>
Best regards,<br><font color="#888888">
<br>
Aminah,</font><div><div></div><div class="h5"><br>
<br>
Aminah Keliet wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
I am in charge of biomart in lab URGI, and i am ready to translate document describing how to load a Chado database into BioMart, in english, it is done in french.<br>
It is not difficult to load it, on following the steps to load dataset in BioMart.<br>
I will make quickly this document, to be useful to a lot of Chado users.<br>
<br>
<br>
Best regards,<br>
<br>
Aminah,<br>
<br>
<br>
Joelle Amselem wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Dear Dave,<br>
<br>
First of a ll, sorry for the delay of my answer (I was out of office without network for 8 days)<br>
<br>
I guess that we have some technical documentation written in french, but it will be probably possible to translate and to send something useful for the GMOD community<br>
Concerning the biomart on chado, it has to be configured to be compliant with the chado schema and Gbrowse for the output result link, but also with the data you insert in chado via GFF3 and particularly the field 9 with data inserted in featureproperty table.<br>
For exemple if biomart find a result associated with a feature which is Target, you cannot serach it via GBrowse, we have to add in biomart, SQL request to find all the reference features on which these target are located.<br>
You can try on our website: <a href="http://urgi.versailles.inra.fr/gnpis/" target="_blank">http://urgi.versailles.inra.fr/gnpis/</a> -> Advanced Search -> Biomart<br>
Request exemples: CHOOSE DATABASE: Query local single mart: GnpGenome (annotations) for Botrytis<br>
Description (% for wildcard) : %kinase%<br>
Program : blastx<br>
Library : uniprot_sprot<br>
<br>
CHOOSE DATABASE: Query local single mart: GnpGenome (annotations) for Poplar<br>
Feature Type : gene<br>
Program : eugene<br>
<br>
<br>
Aminah Keliet (in charge of Biomart at the lab) and Delphine Steinbach(responsible of the GnpIS and interoperability) are copy of this mail and will give you more information.<br>
<br>
Best regards<br>
Joelle<br>
------------------------------------------------------------------------- <br>
Joelle Amselem<br>
INRA-URGI<br>
Fungal genomic annotation platform<br>
Bat 18, Route de Saint-Cyr, 78026 Versailles cedex<br>
Tel: +33 1 30 83 33 95, Fax: +33 1 30 83 38 99<br>
<a href="http://urgi.versailles.inra.fr" target="_blank">http://urgi.versailles.inra.fr</a><br>
email: <a href="mailto:joelle.amselem@versailles.inra.fr" target="_blank">joelle.amselem@versailles.inra.fr</a><br>
------------------------------------------------------------------------- <br>
<br>
<br>
Le 19 févr. 2010 à 19:28, Dave Clements, GMOD Help Desk a écrit :<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi Nathaniel, Joelle, Michael, and the BioMart team,<br>
<br>
At the January 2010 GMOD Meeting (<a href="http://gmod.org/wiki/January_2010_GMOD_Meeting" target="_blank">http://gmod.org/wiki/January_2010_GMOD_Meeting</a>) Joelle Amselem and Michael Alaux of INRA-URGI gave a talk on the GNPAnnot project. They mentioned that they had successfully ported their Chado database (<a href="http://gmod.org/wiki/Chado" target="_blank">http://gmod.org/wiki/Chado</a>) to BioMart. Documenting how this is done has been on my TODO list since.<br>
<br>
<br>
Nathaniel, going from Chado to BioMart is not exactly what you are looking for, but it is close (it adds the extra step of loading your GFF3 into Chado). If we could document this path, would you be interested in using it?<br>
<br>
<br>
Joelle and Michael: Would you be interesting in helping document how to load a Chado database into BioMart? If you could send me notes* I could wikify and prettify them and post them to the GMOD web site. This would be useful to a lot of Chado users.<br>
<br>
<br>
Thanks,<br>
<br>
<br>
Dave C.<br>
<br>
<br>
* In English, as I can't read French. :-(<br>
<br>
On Thu, Feb 18, 2010 at 11:27 PM, Nathaniel Street <<a href="mailto:nathaniel.street@plantphys.umu.se" target="_blank">nathaniel.street@plantphys.umu.se</a>> wrote:<br>
Hi<br>
<br>
We are setting up a web resource for a draft genome. We have GBrowse up and running no problem but now want the same data (sequence and basic annotation) to be available via BioMart. I am not a computer/bioinformatics 'expert'. I'm a biologist learning to use computers so I am at the hands of the quality of available documentation for resources. Pointing me to an existing Mart doesn't really help me know how to go from a starting point of nothing to a working Mart.<br>
<br>
I have searched the mailing list for anything relevant I can think of. I have even found *identical* requests to this one but nothing has come of those posts (other than 'look at one of our existing ensembl marts').<br>
<br>
What I want is to know how to go from a starting point of having a)genomic, transcript and protein FASTA files b)a GFF3 file for transcripts c)a table of gene annotation information to setting up BioMart. I imagine this has to be a common task so I am surprised there is no documentation on this. As part of the GMOD project it would be great to see an integrated tutorial on setting up GBrowse and getting the same data into a working Mart.<br>
<br>
I have looked at and tried to use the gff2biomart script (various versions of it) but after much effort got nowhere. I have also asked someone far more familiar with mysql and perl to have a go. They got a lot further than me but still not to a working Mart. We both managed to get simple tables structures for location and annotation information working but the sequence side of things is a complete mystery.<br>
<br>
So, is there any documentation available and if not can anyone help me go from FASTA+GFF3+annotation table to a working Mart? If someone can help I am more than willing to write up the end process into a walk-through guide so that others benefit.<br>
<br>
Thanks<br>
<br>
Nathaniel<br>
-- <br>
Nathaniel Street<br>
Umeå Plant Science Centre<br>
Department of Plant Physiology<br>
University of Umeå<br>
SE-901 87 Umeå<br>
SWEDEN<br>
<br>
email: <a href="mailto:nathaniel.street@plantphys.umu.se" target="_blank">nathaniel.street@plantphys.umu.se</a><br>
tel: +46-90-786 5473<br>
fax: +46-90-786 6676<br>
<br>
<a href="http://www.popgenie.org" target="_blank">www.popgenie.org</a><br>
<br>
<br>
<br>
-- <br>
===> PLEASE KEEP RESPONSES ON THE LIST <===<br>
<a href="http://gmod.org/wiki/2010_GMOD_Summer_School_-_Americas" target="_blank">http://gmod.org/wiki/2010_GMOD_Summer_School_-_Americas</a><br>
<a href="http://gmod.org/wiki/GMOD_Logo_Program" target="_blank">http://gmod.org/wiki/GMOD_Logo_Program</a><br>
<a href="http://gmod.org/wiki/GMOD_News" target="_blank">http://gmod.org/wiki/GMOD_News</a><br>
Was this helpful? <a href="http://gmod.org/wiki/Help_Desk_Feedback" target="_blank">http://gmod.org/wiki/Help_Desk_Feedback</a><br>
<br>
<br>
</blockquote>
<br>
<br>
</blockquote>
<br>
<br>
</blockquote>
<br>
<br>
-- <br>
Aminah Olivia KELIET<br>
Ingenieur d'études en Bio-informatique<br>
<br>
Unité de recherche en Génomique-Info<br>
INRA Centre de Versailles<br>
Route de Saint Cyr<br>
78026 Versailles Cedex<br>
<br>
email: <a href="mailto:Aminah-Olivia.keliet@versailles.inra.fr" target="_blank">Aminah-Olivia.keliet@versailles.inra.fr</a><br>
url:<a href="http://urgi.versailles.inra.fr" target="_blank">http://urgi.versailles.inra.fr</a><br>
tel: 01.30.83.37.74<br>
<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>===> PLEASE KEEP RESPONSES ON THE LIST <===<br><a href="http://gmod.org/wiki/GMOD_Logo_Program">http://gmod.org/wiki/GMOD_Logo_Program</a><br><a href="http://gmod.org/wiki/GMOD_News">http://gmod.org/wiki/GMOD_News</a><br>
Was this helpful? <a href="http://gmod.org/wiki/Help_Desk_Feedback">http://gmod.org/wiki/Help_Desk_Feedback</a><br><br>
</div>