Mysql backend setup
by Stein, Olaf
Hi all,
Very new to galaxy and trying to setup an instance here with mysql as the backend database.
I added this line:
mysql:///galaxy?unix_socket=/var/run/mysqld/mysqld.sock
To the universe_wsgi.ini file
Where do I define the dbuser, password and database that I want to use?
And what else do I need to do, for instance create the schema, etc?
Thanks
Olaf
-------------------------
Olaf Stein
DBA
Battelle Center for Mathematical Medicine
Nationwide Children's Hospital, The Research Institute
700 Children's Drive
43205 Columbus, OH
phone: 1-614-355-5685
cell: 1-614-843-0432
email: olaf.stein(a)nationwidechildrens.org
"I consider that the golden rule requires that if I like a program I must share it with other people who like it."
Richard M. Stallman
12 years, 5 months
problem with getting the tables up in Profile Annotations
by CHAN Chee Seng
Hi,
I have configured and built my own galaxy server. I have set up most of the genome databases but I have a problem with the getting the "Tables to Use" to be displayed on the web interface.
I have looked at the following files.
1. annotation_profiler_options.xml
2. annotation_profiler_valid_builds.txt
I did not change the annotation_profiler_options.xml file (used as is) and annotation_profiler_valid_builds.txt contains just one line,
hg18
which is fine since I am starting with human.
Where do I specify the location of my hg18?
Please let me know if you need more information.
Thanks for your help.
Best regards,
Chee Seng, Chan
Genome Institute of Singapore
60 Biopolis Street, Genome
#02-01 Singapore 138672
DID 64788065
-------------------------------
This email is confidential and may be privileged. If you are not the intended recipient, please delete it and notify us immediately. Please do not copy or use it for any purpose, or disclose its contents to any other person. Thank you.
-------------------------------
12 years, 5 months
Fwd: [galaxy-dev] Fwd: Protein names
by Anton Nekrutenko
Begin forwarded message:
> From: Yu Lin <linikujp(a)gmail.com>
> Date: March 5, 2010 7:21:09 PM EST
> To: Anton Nekrutenko <anton(a)bx.psu.edu>
> Subject: Re: [galaxy-dev] Fwd: [galaxy-user] Protein names
>
> Hi,
>
> "My assumption was that people would load their favorite gene
> annotations "
> from the ontology's point of view: "favorite gene annotations" will be
> dangerous.
> "use an "interval" join to attach the desired names".... what dose
> it mean?
>
> Dangerous means that later there will be a lot misunderstandings,
> which is not convenient for biologist.
> I think it's better to use a standard.
> OR
> favorite gene annotations
> always bound to
> a standard gene annotations.
>
> Thanks,
> Lin.
>
> *************************************************
> Yu Lin
> Ph.D.,M.D.
>
> Genome Resource and Analysis Unit,
> Genomics Laboratory,
> Center for Developmental Biology,
> RIKEN
>
> TEL&FAX 0081-78-3063048
> Extension:4232
> Email: linyu(a)cdb.riken.jp
> *************************************************
>
>
>
> 2010/3/6 Anton Nekrutenko <anton(a)bx.psu.edu>:
>>
>>
>> Begin forwarded message:
>>
>> From: webb(a)bx.psu.edu
>> Date: March 5, 2010 1:44:01 PM EST
>> To: Tjaart de Beer <tdebeer(a)gmail.com>
>> Cc: Anton Nekrutenko <anton(a)bx.psu.edu>, Webb Miller
>> <webb(a)bx.psu.edu>,
>> Aakrosh Ratan <ratan(a)cse.psu.edu>
>> Subject: Re: Fwd: [galaxy-user] Protein names
>> Hi,
>>
>> The gene annotations are from RefSeq. As we processed the SNPs with
>> tools
>> such as PolyPhen and Sift, we sometimes had to use other names. My
>> assumption was that people would load their favorite gene
>> annotations into
>> Galaxy and use an "interval" join to attach the desired names. Can
>> you do
>> something like that? Or is the problem that you need to deal with
>> alternate
>> splice forms?
>>
>> Please keep asking until you have everything working. If necessary,
>> I can
>> regenerate the file with other protein names. Thanks for your
>> patience.
>>
>> --Webb
>>
>>
>> Quoting Anton Nekrutenko <anton(a)bx.psu.edu>:
>>
>> Webb:
>>
>> The question here is on where the protein names come from. Can you
>> elaborate, so I send him a reply.
>>
>> Thanks,
>>
>> anton
>>
>>
>>
>> Begin forwarded message:
>>
>> From: Tjaart de Beer <tdebeer(a)gmail.com>
>>
>> Date: March 5, 2010 7:34:13 AM EST
>>
>> To: galaxy-user(a)bx.psu.edu
>>
>> Subject: [galaxy-user] Protein names
>>
>> Hi
>>
>> I am trying to parse some data from the Bushmen dataset and have a
>> question.
>>
>> Where do you get the protein names from? It does not correspond 100%
>>
>> to the UniProt ID field in Uniprot entries nor is it Uniprot AC
>>
>> numbers. Is there some kind of mapping I can use to get the
>>
>> appropriate names or Uniprot entries? Would you be able to provide
>>
>> with this mapping? I have been going through the Uniprot website
>>
>> rather extensively and have failed to find any such downloadable
>>
>> mapping. Hope you can help!
>>
>> Thanks!
>>
>> Dr. Tjaart de Beer
>>
>> Thornton group
>>
>> EMBL-EBI
>>
>> Cambridge
>>
>> _______________________________________________
>>
>> galaxy-user mailing list
>>
>> galaxy-user(a)lists.bx.psu.edu
>>
>> http://lists.bx.psu.edu/listinfo/galaxy-user
>>
>> Anton Nekrutenko
>>
>> http://nekrut.bx.psu.edu
>>
>> http://usegalaxy.org
>>
>>
>>
>>
>>
>>
>>
>>
>> Anton Nekrutenko
>> http://nekrut.bx.psu.edu
>> http://usegalaxy.org
>>
>>
>>
>> _______________________________________________
>> galaxy-dev mailing list
>> galaxy-dev(a)lists.bx.psu.edu
>> http://lists.bx.psu.edu/listinfo/galaxy-dev
>>
>>
>
>
>
> --
> Yu LIN.
>
Anton Nekrutenko
http://nekrut.bx.psu.edu
http://usegalaxy.org
12 years, 5 months
Fwd: Protein names
by Anton Nekrutenko
Begin forwarded message:
> From: webb(a)bx.psu.edu
> Date: March 5, 2010 1:44:01 PM EST
> To: Tjaart de Beer <tdebeer(a)gmail.com>
> Cc: Anton Nekrutenko <anton(a)bx.psu.edu>, Webb Miller
> <webb(a)bx.psu.edu>, Aakrosh Ratan <ratan(a)cse.psu.edu>
> Subject: Re: Fwd: [galaxy-user] Protein names
>
> Hi,
>
> The gene annotations are from RefSeq. As we processed the SNPs with
> tools such as PolyPhen and Sift, we sometimes had to use other
> names. My assumption was that people would load their favorite gene
> annotations into Galaxy and use an "interval" join to attach the
> desired names. Can you do something like that? Or is the problem
> that you need to deal with alternate splice forms?
>
> Please keep asking until you have everything working. If necessary,
> I can regenerate the file with other protein names. Thanks for your
> patience.
>
> --Webb
>
>
> Quoting Anton Nekrutenko <anton(a)bx.psu.edu>:
>
>> Webb:
>>
>> The question here is on where the protein names come from. Can you
>> elaborate, so I send him a reply.
>>
>> Thanks,
>>
>> anton
>>
>>
>>
>> Begin forwarded message:
>>
>>> From: Tjaart de Beer <tdebeer(a)gmail.com>
>>> Date: March 5, 2010 7:34:13 AM EST
>>> To: galaxy-user(a)bx.psu.edu
>>> Subject: [galaxy-user] Protein names
>>>
>>> Hi
>>>
>>> I am trying to parse some data from the Bushmen dataset and have
>>> a question.
>>>
>>> Where do you get the protein names from? It does not correspond 100%
>>> to the UniProt ID field in Uniprot entries nor is it Uniprot AC
>>> numbers. Is there some kind of mapping I can use to get the
>>> appropriate names or Uniprot entries? Would you be able to provide
>>> with this mapping? I have been going through the Uniprot website
>>> rather extensively and have failed to find any such downloadable
>>> mapping. Hope you can help!
>>>
>>> Thanks!
>>>
>>> Dr. Tjaart de Beer
>>> Thornton group
>>> EMBL-EBI
>>> Cambridge
>>> _______________________________________________
>>> galaxy-user mailing list
>>> galaxy-user(a)lists.bx.psu.edu
>>> http://lists.bx.psu.edu/listinfo/galaxy-user
>>
>> Anton Nekrutenko
>> http://nekrut.bx.psu.edu
>> http://usegalaxy.org
>>
>>
>>
>>
>
>
>
Anton Nekrutenko
http://nekrut.bx.psu.edu
http://usegalaxy.org
12 years, 5 months
Protein names
by Tjaart de Beer
Hi
I am trying to parse some data from the Bushmen dataset and have a question.
Where do you get the protein names from? It does not correspond 100%
to the UniProt ID field in Uniprot entries nor is it Uniprot AC
numbers. Is there some kind of mapping I can use to get the
appropriate names or Uniprot entries? Would you be able to provide
with this mapping? I have been going through the Uniprot website
rather extensively and have failed to find any such downloadable
mapping. Hope you can help!
Thanks!
Dr. Tjaart de Beer
Thornton group
EMBL-EBI
Cambridge
12 years, 5 months
