Could someone please post a more specific solution for this problem? I’m having the same issue with a different tool. Can’t seem to get Galaxy to recognize the header in a sensible way. @Amalie how did you solve it?
This FAQ covers the most common problems with differential expression tools/analysis. Please review to see if it helps.
If you cannot determine the problem, please clarify your issue a bit more. I did move it into a new topic since you stated that you are using a different tool.
- Where are you working? If a public server, share the base URL
- What tool are you using? Copy the full name, including version, from the top of the tool form.
- Which option on that tool form are you submitting the input file to?
- What is the currently assigned datatype of your input?
- Did you assign the datatype yourself or did you allow Galaxy to “autodetect” when uploading?
- What datatype is assigned if you redetect by clicking on the pencil icon (upper right corner of the dataset), go to the Edit Attributes forms, tab into “Datatypes” and use the button to “Auto-detect” again?
- If you want to share a few lines of your file, including the header, that would be helpful.
Let’s start there, thanks!
Thanks for the response:
- MaxQuant (Galaxy Version 126.96.36.199+galaxy1)
- I’m submitting an experimental design to the Search Options form
- I assigned it myself
- autodetect doesn’t change it from tsv
- The file is below. I cut and pasted from my history:
The original file was:
Name Fraction Experiment PTM 2047_fin_1 1 2047_fin_2 2 2047_fin_21 21 2047_fin_22 22
The import added an extra line that creates an error when I run:
Template of the MaxQuant parameter file ‘/data/dnb02/galaxy_db/job_working_directory/006/194/6194111/working/mqpar.xml’ is created.
Traceback (most recent call last):
File “/opt/galaxy/shed_tools/toolshed.g2.bx.psu.edu/repos/galaxyp/maxquant/175e062b6a17/maxquant/mqwrapper.py”, line 110, in
m.add_infiles([os.path.join(os.getcwd(), name) for name in fnames_with_ext], True)
File “/opt/galaxy/shed_tools/toolshed.g2.bx.psu.edu/repos/galaxyp/maxquant/175e062b6a17/maxquant/mqparam.py”, line 186, in add_infiles
design = self._make_exp_design(infiles)
File “/opt/galaxy/shed_tools/toolshed.g2.bx.psu.edu/repos/galaxyp/maxquant/175e062b6a17/maxquant/mqparam.py”, line 147, in _make_exp_design
File “/opt/galaxy/shed_tools/toolshed.g2.bx.psu.edu/repos/galaxyp/maxquant/175e062b6a17/maxquant/mqparam.py”, line 80, in _check_validity
raise Exception(msg + " Name or Experiment is empty.")
Exception: Error in line 2 of experimental design: Name or Experiment is empty.
Valid input according to MaxQuant is below:
Currently four columns are needed: Name, Fraction, Experiment and PTM. The headers must have this exact naming. Name and Experiment are abitrary strings, Fraction is an integer or emtpy, PTM is either ‘True’, ‘False’ or empty. Consider you uploaded files named File1.mzxml, …, File5.mzxml. This is a (syntactically) correct experimental design template:
Name Fraction Experiment PTM File1 1 E1 False File2 2 E1 False
tabular data, not
tsv. Using “autodetect” is guessing the wrong type, probably because of the internal blank values. Assign
tabular directly. BUT – Upload it again to get rid of the extra line at the end. Or, try the tool Select using “not matching” and one of these regular expressions:
When pasting data into the Upload tool, it loads exactly what you enter. Avoid extra trailing whitespace on lines or extra empty lines at the end.
If you can’t get that right, then skip the “paste” option, and create the file locally first, confirm format in a tool that allows you to inspect whitespace in a clear way (vi, vim, emacs are best IMO; possibly “TextEdit” but it won’t be as precise), and Upload that file directly.
As far as I know, in the Galaxy wrapped version of the tool only
Experiment are required values in data lines, but the header should include all.