Searching

The Search page on Timur allows you to search and retrieve records in bulk.

Select a model and Search to retrieve records in table form. You may also download records as a TSV (tab-separated value) file to open in Excel, R, Python, etc.

Filtering

You may subset records by specifying a filter string of space-separated terms. For example, the filter:

foo bar

will only display records where at least one string column contains 'foo' and at least one string column contains 'bar'.

You may indicate the column you wish to search in each query term:

column_1=foo column_2=bar

Here we only wish to show records where the value of column_1 is exactly 'foo' (case sensitive) and the value of column_2 is exactly 'bar'

There are several column comparison operators:

= exact string match or numeric equality
< or > alphabetic, numeric or date comparison
~ case-sensitive regular expression match

This last is extremely powerful (if you know regular expressions), but is most often useful for doing case-sensitive matches within a column (i.e., not exact strings), for example, column_1~foo.

NOTE: since string filters are case-sensitive, you will get different results for column_1~foo and column_1~Foo.

Dates are in this format: 2015-01-01@23:00

By combining terms we can generate more precise subsets of the table for export. For example the query:

sample_name~CRC date_of_surgery>2012-01-06@12:20

can reduce a set of sample records to a given date and indication.