Example: User wants to search for female participants with lung cancer who have lung tumour specimens with RNA > 5 ug AND DNA > 5 ug . For queries that have child and parent samples, you need to create subqueries. Refer to wiki page for more details.
The example query file can be imported by downloading this file- Query File
Here are the steps how to create a query for this task:
Specify the number of required samples, click on Specimen, select `concentration`, and select `Greater than for the `Operator` field.
To add DNA, you will need to create another subquery where you select `Type` under the Specimen. Click on `Equals` for the operator and select DNA as value.
Follow the same steps as 7 to specify DNA concentration.
To get the results from both DNA and RNA samples, create a query combining query created in steps 6 and 8 with the 'AND' operator.
Now, use the query created in step 10 as a subquery in the main query created. Since RNA and DNA samples (child samples) are derived from the original tumour tissue (parent sample), the user needs to use the 'Hierarchical' operator between the parent and the children. Keep all the filters of the children in one set of parenthesis.