An overview of the Cohort Browser's key features and how to use them.
DNAnexus Apollo builds on the technological foundation of the core DNAnexus Platform to offer scientists and bioinformaticians an environment to store and query large sets of genomic, phenotypic, multi-omic, and other structured data. Researchers can bring their data to the Platform and leverage DNAnexus apps to ingest the data into queryable databases.
These databases can then be explored using the Cohort Browser. Scientists can filter the dataset by any data field and save these filtered samples as cohorts. These cohorts can be shared with other scientists and also can be used as inputs to analysis apps to perform such tasks as calculating allele frequencies or performing a GWAS analysis.
The Cohort Browser dashboard can show up to three tabs based on the configuration of the dataset: Overview, Data Preview, and Genomics. Tabs are loaded as the user clicks on them, so if there is no change in filtering, the tabs will stay cached and will not need to reload.
From the project where a dataset is located, go to Manage tab and select your dataset of interest. Click on the Explore Data action to open this dataset in Cohort Browser.
Selecting a dataset of interest to open
You can also access datasets via the Datasets page, which is located under the Projects menu. The Datasets page displays all datasets you have access to, and enables you to browse and find a specific dataset without navigating through projects.
You can use the optional information panel to view further information about a selected dataset, including creator, sponsorship, etc.
The Overview tab in the Cohort Browser provides insights on the data through the visualization of various data fields.
Dashboard with multiple tiles configured
- 1.To add a field as a chart, click on Add Tile button. The Add Tile dialog shows a hierarchical view of all the data fields available in the dataset.
- 2.Browse the list or search an item by its title to narrow down the list.
- 3.Select a data field from the list. In the Data Field Details panel, you can see metadata on the selected data field, visualization preview, as well as options to customize chart types.
- 4.Confirm selection via the Add as Tile action. Now this tile will appear on your dashboard.
Adding a tile to your dashboard
Once you have selected a primary data field in the Add Tile dialogue, you can add a secondary data field by clicking on the + icon next to an eligible secondary data field.
Adding grouped box plot by combining two data fields
Since each tile adds more data queries, dashboards with over 10 tiles on complex data can impact overall browser performance.
This video provides a detailed overview of exploring new datasets using the Cohort Browser:
When you start exploration on a dataset, an empty cohort is created automatically in the cohort browser. You can further narrow down your cohort by adding cohort filters. Cohorts created can be saved and exported for later use.
- 1.From the cohort which you wish to edit, click on Add Filter button.
- 2.Select a data field you want to filter by, confirm by clicking on Add as Filter.
- 3.Select operators and enter values to filter by. Click on Apply Filter to confirm.
- 4.Filters added are displayed in corresponding cohort panels. You can edit a specific filter any time by clicking on it, which would bring up the Edit Filter dialogue.
- 5.The default logical operator is 'AND'. To switch the operator to 'OR', click on the operator. For a filter group (a set of filters tied to 1 specific entity), all operators will be the same: all 'OR' or all 'AND'.
Adding a filter and toggling 'AND' 'OR' functionality.
Once filters are added or edited, an updated cohort size will appear under name of the affected cohort. The dashboard will also auto-refresh to fetch updated results basing on latest cohort selection.
Cohort size updates after filters are edited
If your dataset includes genomic data, then you will have the option to add a genomic filter to your cohort.
- 1.From the cohort you wish to edit, click on Add Filter button.
- 2.Toggle to Geno tab.
- 3.Edit filter in Edit Genomic Filter dialogue by one of the following criteria:
- 1.Filter by genes and variant effects: Filter your dataset by variants of certain types and consequences within specified genes and/or genomic ranges. A maximum of 5 genes/ranges can be entered.
- 2.Filter by a list of variant IDs. A maximum of 100 variants can be entered.
- 3.If more than 1 range, gene, or variant is added, the values should be comma separated or each value must be on a new line.
- 4.Confirm edit by clicking on Apply Geno Filter button.
When working with datasets that have multiple data entities, you can create a Join Filter by selecting data fields from a secondary entity and adding them as filters. An entity is a grouping of data around a unique item, event, or a concept: e.g. patient, visit, medication, laboratory tests.
Join Filters are displayed as subrows deriving from the main entity. Depending on the entity to which your selected data field belongs, a join filter that reflects the relationship between those entities will be automatically created. To create a new cohort criteria using the join filters, click + Add filter or the Filter > Add filter on a tile. To add additional criteria to an existing criteria in a join click the Add additional criteria inline on the row of the chosen filter.
You can choose between the 'AND' or 'OR' logical operators when creating a cohort and comparing join filters. To switch between them, click on the logical operator. For a specific level of join filtering, joins are either all 'AND' or all 'OR'. Note that even when using 'OR' for two join filters, the implication that "this criteria exists" precedes the join level, i.e. “where exists, join 1 or join 2”.
Example of 'OR' and 'AND' filtering.
Once a join filter is created, you can further define the secondary entity by adding additional criteria to the branch, or adding more layers of join filters deriving from the current branch. As you add more layers, the field selector automatically hides fields that are ineligible to be added based on the join.
For an example of interpreting join filters, consider the following:
The First Example cohort identifies all patients with a "high" or "medium" risk level who have a first (visit instance = 1) hospital visit and who also have had a lab test that was a "nasal swab". This lab test does not necessarily have to be conducted at the time of the patient’s first hospital visit. In the Second Example, the cohort includes all patients with a "high" or "medium" risk level who had the "nasal swab" test performed on the first visit.
This video provides an overview of setting up your dashboard as part of defining and refining a cohort:
You can create complex cohorts by combining existing cohorts from the same dataset. Cohort combine can be accessed via the “Compare / Combine Cohorts” menu located at the top of the page.
Compare / Combine menu
Combine cohorts from a comparison view
The Cohort Browser supports the following combination logic:
Once a combined cohort is created, you can inspect the combination logic and its original cohorts in the cohort filters section.
Inspect combination logic on a combined cohort
In the Data Preview tab, the Cohort Table shows records that are within your current cohort selection split up by the entity they are on. You can add or remove data fields as columns via the column customization menu, which is located in the top-right corner of the table. As you add fields, entities are automatically split out. You can have up to 5 different entities showing at a time. In the entity drop down, you can toggle between various entities you’ve added and remove them outright.
Adding a data field as a column
Click on table column headers to access more functionalities including sorting and searching in a specific column and the data field information. From the data field information, you can quickly add the field as a tile or a filter if it has not been added yet.
Sorting a column and adding the field as a filter
You can export table information either as a list of record IDs or a CSV file. Export options are available on the top-right corner of the table once you have selected a number of table rows.
In the Genomics tab, the Variant Browser shows variants that are present in current cohort selection. This section includes a lollipop chart displaying allele frequencies for variants in a specified genomic region.
You can modify the genomic region via the search bar on the top-right corner of the variant section. This genomic region will update information in both lollipop chart and table.
Genomic Variant Browser and Details
The table below the lollipop chart lists the same variants in tabular format, along with further annotation information including:
- Type: whether the variant is a SNP, deletion, insertion, or mixed.
- Population Allele Frequency: Allele frequency calculated across entire dataset from which the cohort is created.
- Cohort Allele Frequency: Allele frequency calculated across current cohort selection.
To view further annotation information, you can go to the detail page of a given variant by clicking on the link in the Location column .
You can export selected variants in the table as a list of variant IDs or a CSV file. Export options will appear at the top-right corner of the table once you have items selected.
Cohorts will be saved with the filters applied, along with the latest set of visualizations and dashboard layout information. Similar to Dataset objects, Cohort objects can be found under the Manage tab in your selected projects, and can be re-opened via the Explore Data option.
Save cohort action
Cohort object in project folders
You can export a list of main entity IDs in your current cohort selection as a CSV file. This action can be found next to the Save Cohort button, on the top-right corner of cohort panel.
Dashboard views contain layout and configuration information that can be re-used during cohort browsing. You can save or load a dashboard view via the Dashboard Actions menu located at the top-right corner of the header area.
Dashboard Actions menu
Dashboard views are saved as "Type: DashboardView" objects, which once saved also show up in selected project folders.
You can compare two cohorts by adding both cohorts into the Cohort Browser. In cohort compare mode, all visualizations are converted to show data from both cohorts.
The Compare Cohort action can be found in the header area next to the cohort title. You can create a new cohort, duplicate the current cohort, or load a previously saved cohort.
In compare mode, you can continue to edit both cohorts and visualize the results dynamically.
You can compare a cohort with its complement in the dataset by selecting the “Not In …” option in the Compare / Combine menu. Similar to combining cohorts, you must first save your current cohort before creating its not-in counterpart.
Creating Comparison Using “Not In” logic
- 1.If a database is in a project that has a restricted
downloadPolicy,then a Cohort Browser that shows a dataset, cohorts, or dashboards pointing to that database should not allow downloads, regardless of project.
- 2.If all copies of the dataset are in a project that has a restricted
downloadPolicy,then a Cohort Browser that shows a dataset, cohorts, or dashboards pointing to that dataset should not allow downloads, regardless of project.
- 1.Check all copies of the dataset.
- 2.If at least one copy is in a "download allowed" then the download will be allowed.
- 3.If the cohort or dashboard you are launching has a restricted
downloadPolicy, then a Cohort Browser that shows the cohort/dashboard should not allow downloads.