Cohort Browser
An overview of the Cohort Browser's key features and how to use them.
The Cohort Browser is accessible to all users of the UK Biobank Research Analysis Platform and the Our Future Health Trusted Research Environment.
For DNAnexus Platform users, an Apollo license is required to access the Cohort Browser. Contact DNAnexus Sales for more information.
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.
Bioinformaticians who wish to perform ad hoc statistical analysis are able to create JupyterLab environments backed by Spark clusters to directly query their data and create dataframes within a Python or R environment for further analysis.
Datasets need to be prepared and ingested in order to be used by Cohort Browser. See the Ingesting Data page for further information on how to ingest datasets on the DNAnexus Platform,
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
Chart types available per each data field is dependent on their data field types. See Chart Types pages for more information on how each chart type can be built. A max of 15 tiles can be added to the 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.
The +” icon only appears when at least one chart type is supported for the specified combination. See Chart Types - Multi-Variable Charts for more details.
For certain chart types - such as Stacked Row Chart and Scatter Plot - you can re-order the primary and secondary data fields by dragging on the data field in the Data Field Details section.
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.
Similarly to the other cohort filters, a genomic filter is applied to the main entity of your dataset (in most cases, patients or participants).
For datasets with canonical transcript information available, an additional toggle will appear in the Genomic Filter dialogue titled "Match effects for canonical transcript only" which may be set to YES initially in order to restrict the results only to variants that have canonical information available.
Canonical transcripts, as defined by Ensembl, will be indicated with a blue marker next to their
"Ensembl Transcript ID" in the Transcript column in the Genes/Transcripts table.
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.
Note that “Entity” in the Cohort Browser can refer either to a data model object (examples given above), or to the specific input parameter in the Table Exporter app. See the Table Exporter documentation here.
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:
Logic | Description | Number of Cohorts Supported |
|---|---|---|
Intersection | Select members that are present in ALL selected cohorts. Example: intersection of cohort A, B and C would be A∩B∩C | Up to 5 cohorts |
Union | Select members that are present in ANY of the selected cohorts. Example: union of cohort A, B and C would be A∪B∪C | Up to 5 cohorts |
Subtraction | Select members that are present only in the first selected cohort and not in the second. Example: Subtraction of cohort A, B would be A-B | 2 cohorts |
Unique | Select members that appear in exactly one of the selected cohorts. Example: Unique of cohort A, B would be (A-B) ∪ (B-A) | 2 cohorts |
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
Cohorts already combined cannot be combined a second time.
The Cohort Table can visualize up to 30 columns of data per tab. Tables with over 30 columns but under 200 will still show the column names and allow the user to save the cohort but data will not be queried. Tables with over 200 columns are not supported.
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.
The cohort table can display a maximum number of 30,000 records. If your cohort size is larger than this number, the table may not show the full data. Exporting a table larger than 30,000 can be done with the Table Exporter app.
Note that your view may contain more than one table (e.g. a participants table and a hospital records table). When you export the view to a CSV or TSV, doing so will yield a separate file for each table.
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.
- Consequences: The impact of variant according to SNPEff. For variants with multiple gene annotations, this column displays the most severe consequence per gene.
- 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.
If canonical transcript information is available, the following three columns with additional annotation information will appear in the Allele Table:
- Consequences (Canonical Transcript): Canonical effects per each associated gene, according to SnpEff.
- HGVS DNA (Canonical Transcript): HGVS (DNA) standard terminology per each associated gene with this variant
- HGVS Protein (Canonical Transcript): HGVS (Protein) standard terminology per each associated gene with this variant
Example of canonical transcript columns
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 .
Downloading genomic data via visualization UI is not suitable for large datasets. You can use the SQL Runner app to download data in a more efficient way.
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.
You can save your cohort selection to a project as a Class: Record object by clicking the Save icon in the top-right corner of the cohort panel.
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 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.
Compare mode is supported only for cohorts created from the same dataset. Certain cohort browser sections and chart types are not supported in compare mode.
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.
Logic | Description |
|---|---|
Not In | Select members that are present in the dataset, but not in the current cohort. Example: In dataset U, the result of “Not In” A would be U-A |
Creating Comparison Using “Not In” logic
Similar to combined cohorts, cohorts created using Not In cannot be used further for the creation of combined / not-in cohorts.
“Not In” cohorts are linked to the cohort they are originally based upon. Once a not-in cohort is created, further changes to the original cohort definition will no longer be reflected.
- 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.
Last modified 1mo ago