Example Question

Suppose you are managing a dataset focused on Parkinson's disease. Researchers may be interested in analyzing the relationship between certain genetic pathways and patient demographics. You can set up a question that allows them to filter by sex, age, or other participant characteristics.

SQL Query Example

Unset
SELECT *
FROM subject_metadata s
INNER JOIN enterotypes e
ON s.sample_name = e.sample_name
WHERE s.sex = {{sex}}

Variable Configuration

• ID: sex

• Name: Sex

• Type: Dropdown (values: M, F)

• Description: Select the sex of the participants you want to include in your analysis.

This setup will enable researchers to easily filter data by participant sex, tailoring their analysis to their specific research needs.