Grouping samples with 'group'

Hi all,
I am trying to group my replicates as 1 samples. I want the categories in the 'Group' column to be treated as one sample. So all the JB_Gut replicates will be one sample, etc. There are a few more categories I did not include in the screenshot.

I am am using the following code and metadata:

qiime feature-table group
--i-table table.qza
--p-axis sample
--m-metadata-file metadata2.txt
--m-metadata-column Group
--p-mode 'mean-ceiling'
--o-grouped-table table2.qza

I tried making a barplot using the following:

qiime taxa barplot
--i-table table2.qza
--i-taxonomy taxonomy.qza
--m-metadata-file metadata2.txt
--o-visualization taxa-bar-plots-grouped.qzv

and receive this error:

I read on another forum that I need to create another metadata called metadata_grouped table so them I created the following and ran the code below:

qiime taxa barplot
--i-table table2.qza
--i-taxonomy taxonomy.qza
--m-metadata-file metadata_grouped.txt
--o-visualization taxa-bar-plots-grouped.qzv

This still did not work:

I'm obviously doing something wrong with the metadata but just don't know how to fix it. Any advice?

Thanks!

Hi!
Welcome to the forum.
You almost found the solution - all you need is to remove duplicated ids from your second metadata file.