--p-where doesn't work

User Support
, , ,
4

Thanks for sending your data in a DM. A few comments:

  1. Quoting is hard, and we would like to make this easier in the future, but for now, we are stuck reading the sqlite.org docs to understand what to do. If you use double quotes around your column, this works as expected:
qiime feature-table filter-samples \
  --i-table table_stool-only-noNC_freqFilt100_minFreq100.qza \
  --m-metadata-file metadata.tsv \
  --o-filtered-table test \
  --p-where "\"Beating-time-min\"='10'"
  1. Your table you provided is already filtered to only have a subset of the Beating-time-min=10 samples, interrogating your provenance it looks like this is a side-effect of all the frequency filtering you applied (looks like you did that 4 times, two filter-samples and two filter-features). Anyway, the table you sent has 88 samples, and all of them are Beating-time-min=10. I mention this so that when you run the command and the table appears to be unchanged, this is why. After filtering, I see 88 samples and 131 features.
2 Likes