x
M+P

Spreadsheet Interactive table of clinical fields. Manually define cohorts.

x

Overview

Spreadsheet provides users with an interactive table of clinical fields. Cohorts that are created and saved in other tools can be transferred to spreadsheet to find additional clinical factors.

M+P
  • Selected Columns: List of column names in that particular collection.
  • Selected: Clickable button to show all the current selections.
  • Clinical Collections: Various database collections
  • Cohorts: Give the users the ability to save and push cohorts through the various tools. To learn more visit Oncoscape
x

Use Cases

Define patient cohorts with multiple clincial factors.

Save and view cohorts using spreadsheets to select different clincial factors.

  1. Spreadsheets allows users to see all clincial tables provided in the TCGA datasets.
  2. Tables can be viewed in the Clinical Collections dropdowns
x

Navigation

Clinical Collections
Export

Provides users the ability to select a particular clinical collections to view. Selections can vary by disease set. Collections from TCGA include:

Users can export cohort selections into a csv format that will be downloaded to the desktop.



Selected
Columns

Sorts by the selected items putting all the selected (checked) rows on the top of the list.

Each column in the spreadsheet can be sorted ASC/DESC, hidden or pinned to the left/right.


x

Methods

Oncoscape hosts level 3 public TCGA datasets representing gene and patient data downloaded from UCSC Xena. To review this data in depth visit our data API. User planning to publish on the provided data must adhere to all publishing guideline set by the NIH. Datasets in Oncoscape are classified by disease type according to TCGA studies.

x

Frequently Asked Questions

How do I find a particular value in the spreadsheet?

Start by entering the value of choice into the Highlight box on the control bar, selections will automatically begin to highlight in blue.


How do I export or print my graphs?

Users can push saved cohorts to the spreadsheet tool by clicking the the Analysis Tool button at the top of the screen. Once there click the Export: CSV button. An Excel file will be generated and downloaded to your computer.


How do I save my data for a return visit?

All data for selections and cohorts will be automatically saved for a return visit assuming users are on the same computer to login. User logins that allow stored sessions from any device will be deployed in a future release.


How do I view other clinical selections, like drug tables?

Tables other than the default (patient) can be view by clicking the dropdown menu Clinical Collections. Tables in include: Patient, Drug, Follow-up, New Tumor and Other Malignancy.