Filtering samples from metadata

Hey! :wave: :qiime2:
I'm trying to filter some samples off my metadata (it worked just fine with other samples) but I got the following error:

Plugin error from feature-table:

Selection of IDs failed with query:
SELECT "#SampleID" FROM metadata WHERE "#SampleID" NOT IN ('33C','20C','17C','21C','11C','26C','12C','49A','38A','31A','16A','51A','52A','12A','29A','10A','36A','34A','28A',25A','18A','46A') GROUP BY "#SampleID" ORDER BY "#SampleID";

If one of the metadata column names specified in the where statement is on this list of reserved keywords (SQLite Keywords), please ensure it is quoted appropriately in the where statement.

Debug info has been saved to /tmp/qiime2-q2cli-err-2a2j11ed.log

I don't understand what is the problem (I looked at the link - and the "SampleID" isn't there so I'm not sure).

Thank you! :blush:

Hi @Tina_Khone - it looks like you forgot to include the following information in your post:

  • the version of QIIME 2 used
  • the exact command or commands you are running

We need all of that information in order to effectively help you. Thanks!



I'm using Qiime2-2021.4 and the command is:

qiime feature-table filter-samples
--i-table OK147na_AC_pairwise.qza
--m-metadata-file metadata_OK147na.tsv
--p-where ""#SampleID" NOT IN ('33C','20C','17C','21C','11C','26C','12C','49A','38A','31A','16A','51A','52A','12A','29A','10A','36A','34A','28A',25A','18A','46A')"
--o-filtered-table OK147na_AC_pairwise_filtered.qza

1 Like

Perfect, thanks for that @Tina_Khone!

You have a very small typo in your command, right here:

It looks like you're missing a ' in there, it should be


Give that a shot and let us know how it goes!

1 Like

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.