The bioBakery help forum

Hi there,

I tried to merge metaphlan outputs into a table, however I’ve gotten this error. I’m not sure what went wrong.
The script that I input here was: *.tsv > merged_abundance_table.tsv

The metaphlan version that I was using is: MetaPhlAn version 3.0.13 (27 Jul 2021)
The error was as follows: *.tsv > merged_abundance_table.tsvTraceback (most recent call last):
File “/home/suetli/miniconda3/envs/mpa/bin/”, line 10, in
File “/home/suetli/miniconda3/envs/mpa/lib/python3.7/site-packages/metaphlan/utils/”, line 78, in main
merge(args.aistms, sys.stdout)
File “/home/suetli/miniconda3/envs/mpa/lib/python3.7/site-packages/metaphlan/utils/”, line 47, in merge
File “/home/suetli/miniconda3/envs/mpa/lib/python3.7/site-packages/pandas/util/”, line 311, in wrapper
return func(*args, **kwargs)
File “/home/suetli/miniconda3/envs/mpa/lib/python3.7/site-packages/pandas/io/parsers/”, line 586, in read_csv
return _read(filepath_or_buffer, kwds)
File “/home/suetli/miniconda3/envs/mpa/lib/python3.7/site-packages/pandas/io/parsers/”, line 482, in _read
parser = TextFileReader(filepath_or_buffer, **kwds)
File “/home/suetli/miniconda3/envs/mpa/lib/python3.7/site-packages/pandas/io/parsers/”, line 811, in init
self._engine = self._make_engine(self.engine)
File “/home/suetli/miniconda3/envs/mpa/lib/python3.7/site-packages/pandas/io/parsers/”, line 1040, in _make_engine
return mapping[engine](self.f, **self.options) # type: ignore[call-arg]
File “/home/suetli/miniconda3/envs/mpa/lib/python3.7/site-packages/pandas/io/parsers/”, line 152, in init
self.names, # type: ignore[has-type]
File “/home/suetli/miniconda3/envs/mpa/lib/python3.7/site-packages/pandas/io/parsers/”, line 867, in _validate_usecols_names
f"Usecols do not match columns, columns expected but not found: "
ValueError: Usecols do not match columns, columns expected but not found: [0, 1, 2]

And here’s the input metaphlan table files that I am trying to merge:
metaphlan_taxonomic_profiles_donor.tsv (29.9 KB)
metaphlan_taxonomic_profiles_postFMT.tsv (29.0 KB)
metaphlan_taxonomic_profiles_preFMT.tsv (19.4 KB)

Any help will be much appreciated! Thanks!