Query Commands
Single-Result Source Queries:
describe: allows user to see the distribution of their data columns
relate: allows user to associate connections between and amongst data
Paired Source Queries
diff: shows the difference between baseline and test results
absdiff: returns absolute values of diff
[GUI representation?]
corr: returns correlation between two sets of values
[leaving out for now due to a bug in plotting]
stat:
precision: ratio between baseline positives and test positives
recall: ratio of test correctly identifying true positives from baseline
f1: harmonic mean between precision and recall
concordance: percent of matching entries from baseline to test
compare: compares stats of columns against one another on x and y axes
Query Modifiers
Filter clauses: find under Advanced for various widgets by typing a results filter
where: filter sorting what amount of criteria is met when a condition is set
e.g. concordance where pos > 0
rwhere: works like where but only applies to test dataset
Groupby: groups matching results together
Gatediff: considers results a match only if field X is less than a value Y
e.g. if all columns match, but gatediff criteria is VF<0.1 and two results have a difference of VF of 0.2, concordance between the two results is 0
Limiting: limit the returned results from the query
e.g. groupby chr:0,5 ← groups by chromosome, returning only the 5 top results
