Failure when attempting to filter samples

Hi @John! We are using sqlite for the where SQL-style filtering --- Group is a reserved keyword in sqlite, so the error message you are seeing is a complaint from sqlite, which is confused about why it is seeing the word group there!

You have two options moving forward:

  1. Rename your metadata column to something else (e.g. SubjectGroup)
    or
  2. Use some aggressive quotes in your where clause to tell sqlite that you really do have a category named group: --p-where "\""Group"\"='NTC'"'

Good luck! :t_rex:

3 Likes