---
description: >-
  Learn how to view your own data using data from the Chinese Glioma Genome
  Atlas (CGGA)
---

# Tutorial: Viewing your own data

Description

This tutorial is made for those who have basic knowledge of how to use Xena. We will cover how to load your own data into a Xena hub on your computer. We will then view the data in the Xena Browser

We will be viewing RNAseq and clinical data from the Chinese Glioma Genome Atlas (CGGA).

{% embed url="http://www.cgga.org.cn/index.jsp" %}

## Prerequisites

To format the datasets you will need access to a spreadsheet application, such as Microsoft Excel.

To load the data into a Local Xena Hub you will need a computer where you have installation privileges.&#x20;

To visualize the data, you will need basic knowledge of how to build and read a [Visual Spreadsheet](../overview-of-features/visual-spreadsheet), how to [filter samples](../overview-of-features/filter-and-subgrouping), how to [create a box plot in Chart View](../overview-of-features/chart-view), and how to [run a Kaplan Meier Analysis](../overview-of-features/kaplan-meier-plots). To get this go through the Basic Tutorials, starting with [Basic Tutorial: Section 1](basic-tutorial-section-1).

## Estimated time needed

**Part A**: 10 min

**Part B:** 15 min

**Part C**: 10 min

## Learning goals

**Part A**

* Download data from CGGA
* Use Microsoft Excel or another spreadsheet application to make small formatting adjustments. These adjustments are only to enable Kaplan Meier analyses. Data can be visualized as is.

**Part B**

* Download and install a Local Xena Hub
* Load data into the Xena Hub on your computer

**Part C**

* Make a visual spreadsheet from the data in the Xena Hub on your computer
* Create a box plot
* Run a Kaplan Meier Analysis

## Tutorial

### Part A

We will start with downloading the files from the CGGA. These files already conform to our data file requirements. This is because they are matrices that have sample IDs along one axis and probe, gene, or clinical data names along the other. Additionally, the files are tab-delimited.&#x20;

For more information see:

{% content-ref url="../local-xena-hub/data-format-specifications" %}
[data-format-specifications](../local-xena-hub/data-format-specifications)
{% endcontent-ref %}

While we can load the files exactly as is, we will perform a small format adjustment so that we can create a Kaplan Meier plot. Our Kaplan Meier analyses need two columns of clinical data to create a plot: the event/censor column and the time to that event/censor.  These columns need to be specially named so that our Kaplan Meier analysis recognizes them. For Overall Survival, the column names need to be 'OS' and 'OS.time'.&#x20;

For more information on other supported columns for our Kaplan Meier analysis see:

{% content-ref url="../local-xena-hub/km-plots-using-data-from-a-local-xena-hub" %}
[km-plots-using-data-from-a-local-xena-hub](../local-xena-hub/km-plots-using-data-from-a-local-xena-hub)
{% endcontent-ref %}

[**Genomic and Clinical data to load into Xena**](https://drive.google.com/file/d/1iiu0yM-XHV2KVHW1ixIMLSvHvTAkXF5l/view)

#### Steps to format the file

1. Go to [http://www.cgga.org.cn/download.jsp](http://www.cgga.org.cn/download.jsp) and scroll to the DataSet ID mRNAseq\_693.
2. Click to download the 'Clinical Data' and 'Expression Data from STAR+RSEM'. Unzip the files. The resulting files should be named 'CGGA.mRNAseq\_693.RSEM-genes.20200506.txt' and 'CGGA.mRNAseq\_693\_clinical.20200506.txt'.
3.  Open CGGA.mRNAseq\_693\_clinical.20200506.txt

    &#x20;in a spreadsheet application like Microsoft Excel. If the spreadsheet application asks, these files are tab-delimited.
4. Rename the column header 'OS' to be 'OS.time'.
5. Rename the column header 'Censor (alive=0; dead=1)' to be 'OS'.
6. Save and close the file.

{% hint style="success" %}
There is no need to open CGGA.mRNAseq\_693.RSEM-genes.20200506.txt since it is ready to be loaded into the Local Xena Hub on your computer as is. This will also help prevent Microsoft Excel from automatically converting some gene names into dates. For more information see: [https://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7](https://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7)
{% endhint %}

{% hint style="info" %}
[**Copy of genomic and clinical data to load into Xena** ](https://drive.google.com/file/d/1iiu0yM-XHV2KVHW1ixIMLSvHvTAkXF5l/view)
{% endhint %}

### Part B

#### **Steps**

#### **If this is your first time viewing your own data**

1\. Click '[VIEW MY DATA](https://xenabrowser.net/datapages/?addHub=http%3A%2F%2F127.0.0.1%3A7222\&host=http%3A%2F%2F127.0.0.1%3A7222)' at the top of the screen. You should see a screen similar to this:

![](https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LAsF1Wuj3-Bs3YBFd7f%2F-McBs7_t2x_zTskSqpU_%2F-McG79k0rc7_R6snjJOp%2FScreen%20Shot%202021-06-15%20at%2012.17.07%20PM.png?alt=media\&token=2df408cf-a12c-438f-bc4e-241cd04b0175)

2\. Click 'Open UCSC Xena' to set your computer up to automatically open the Xena Hub when you come to this page in the future.&#x20;

3\. Click on 'download & run a Local Xena Hub' to download the correct installer for your computer.

4\. Double-click the installer to install the Xena Hub on your computer. Follow onscreen instructions, which vary by operating system.&#x20;

Please see our [FAQ/Troubleshooting Guide](../local-xena-hub/faq-troubleshooting-guide) or [contact us](../contact-us) if you encounter any problems.

#### **If you already have viewed your own data**

1\. Click '[VIEW MY DATA](https://xenabrowser.net/datapages/?addHub=http%3A%2F%2F127.0.0.1%3A7222\&host=http%3A%2F%2F127.0.0.1%3A7222)' at the top of the screen. You should see a screen similar to this:

![](https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LAsF1Wuj3-Bs3YBFd7f%2F-McBs7_t2x_zTskSqpU_%2F-McG84w7wRbbJxXq8fhT%2FScreen%20Shot%202021-06-15%20at%2012.17.19%20PM.png?alt=media\&token=1024c5ef-74c8-40b2-a1ce-156eeb6cbe5d)

2\. Wait for 30 seconds. If you allowed your browser to open the Xena Hub every time you come to this screen, then it will open the Xena Hub and this dialog box will close. If you did not, you will need to go to your Applications Folder and open UCSC Xena yourself

Whether you have viewed your own data before or not, you should arrive at a screen like this:

![](https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LAsF1Wuj3-Bs3YBFd7f%2F-McL9JuLY88qyhv2ATW0%2F-McL9fdqS8zObc0lOn3K%2FScreen%20Shot%202021-06-16%20at%2011.51.59%20AM.png?alt=media\&token=e28c2d20-c323-4b40-b106-279476cf9885)

{% hint style="info" %}
If you have already loaded data previously, you may see datasets and cohorts listed at the bottom of the screen
{% endhint %}

#### Steps to load the data files

1. Click the 'Load Data' button.
2. Click 'Select Data File', choose 'CGGA.mRNAseq\_693\_**clinical.**&#x32;0200506.txt', and click 'Next'.
3. Choose 'Phenotypic Data' and click 'Next'.
4. Choose 'The first column is sample IDs' and click 'Next'
5. Choose 'These are the first data on these samples.', change the study name to 'CGGA', and click 'Import'.
6. Choose 'Load more data'
7.  Click 'Select Data File', choose&#x20;

    'CGGA.mRNAseq\_693.**RSEM-genes**.20200506.txt', and click 'Next'.
8. Choose 'Genomic Data' and click 'Next'.
9. Confirm selection of 'The first row is sample IDs' and click 'Next'
10. Choose 'I have loaded other data on these samples and want to connect to it.', select 'CGGA' from the drop down, and click 'Import'.

#### Video of steps 1-6

![](https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LAsF1Wuj3-Bs3YBFd7f%2F-McL9JuLY88qyhv2ATW0%2F-McLAkjJvPPfq58_jozK%2FLoad_clinical_CGGA.gif?alt=media\&token=ff1e15ed-084a-40d9-a150-0ee39a75c5db)

#### Video of steps 7-10

![](https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LAsF1Wuj3-Bs3YBFd7f%2F-McL9JuLY88qyhv2ATW0%2F-McLBQmZTTxW4D-DOWOy%2FLoad_rnaseq_CGGA.gif?alt=media\&token=022fdba4-4849-405a-b4f2-489420c0b295)

{% hint style="info" %}
Note that it can take several minutes for the RNAseq data to load since it is larger.
{% endhint %}

### Part C

We will look at the chromosome 1p-19q co-deletion in Chinese glioma patients and compare this to IDH1 expression.

#### Ending Screenshot for Visual Spreadsheet (end of step 5)

![](https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LAsF1Wuj3-Bs3YBFd7f%2F-McLWS_7WvlF0Bw7DxuA%2F-McLXU6eg9j_Oo37_NyR%2FScreen%20Shot%202021-06-16%20at%201.35.57%20PM.png?alt=media\&token=91a7e087-893d-4b50-8207-ef649f1e14ba)

#### Ending Screenshot for Box plot (end of step 11)

<figure><img src="https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LAsF1Wuj3-Bs3YBFd7f%2Fuploads%2FaSRcdAnPSuiqGa9d3gRf%2FScreenshot%202025-04-07%20at%203.57.39%E2%80%AFPM.png?alt=media&#x26;token=9a1bd876-27ca-4c18-a4db-a6ebfee03a90" alt=""><figcaption></figcaption></figure>

#### Ending Screenshot for Kaplan Meier Analysis (end of step 13)

![](https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LAsF1Wuj3-Bs3YBFd7f%2F-McLWS_7WvlF0Bw7DxuA%2F-McLWzM8OFeJLYVy1YUp%2FScreen%20Shot%202021-06-16%20at%201.33.50%20PM.png?alt=media\&token=80f20432-726e-4b6d-8366-4a378cc42f1d)

{% hint style="info" %}
Note that we are unable to provide links to these ending screenshots because we do not allow users to create bookmarks when viewing data from their own Local Xena Hubs. This is to protect the privacy of your data. [For more information see our Bookmarks help section.](../overview-of-features/bookmarks)
{% endhint %}

#### Steps

1. Click on 'Visualization' in the top menu bar.
2. Type 'CGGA', choose 'CGGA' as the study and click 'To first variable'.
3. Enter the gene 'IDH1', choose 'CGGA.mRNAseq\_693.RSEM-genes.20200506.txt', and click 'To second variable'
4. Choose 'Phenotypic', click '1p19q\_codeletion\_status', and click 'Done'
5. The dataset authors annotated samples without a 1p/19q co-deletion status with 'NA'. To remove these samples, type 'NA' in the samples search bar and choose 'Remove Samples' from the filter actions menu drop down.
6. Compare IDH1 expression between samples with a 1p/19q co-deletion and those that do not. To do this, click on the column menu for column B (IDH1 expression) and choose 'Charts & Stats'.
7. Choose 'Compare Subgroups'.
8. Click the dropdown for 'Show data from' and choose 'column B: IDH1 - CGGA.mRNAseq\_693.RSEM-genes.20200506.txt'.
9. Click the dropdown for 'Subgroup samples by' and choose 'column C: 1p19q\_codeletion\_status - CGGA.mRNAseq\_693\_clinical.20200506.txt'.
10. Click 'Done'.&#x20;
11. Close the chart using the 'x' in the upper left corner.
12. Run a Kaplan Meier analysis comparing patients with high IDH1 expression to those with low IDH1 expression. To do this, click on the column menu for column B (IDH1 expression) and choose 'KM plot'

#### Video of steps 2-4

<figure><img src="https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LAsF1Wuj3-Bs3YBFd7f%2Fuploads%2F3zkHmiNw9oCC0n6ZjKTI%2Fviewowndatafirst.gif?alt=media&#x26;token=a24d2a2d-aa4f-401c-a5ea-c6b643563395" alt=""><figcaption></figcaption></figure>

#### Video of steps 5-10

<figure><img src="https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LAsF1Wuj3-Bs3YBFd7f%2Fuploads%2FqGHbnninIS3Y4e2f8LyA%2FView_own_data_tutorial_step_4.gif?alt=media&#x26;token=0dafe72b-042c-4e59-aa58-4ee9c27cbf9f" alt=""><figcaption></figcaption></figure>

#### Video of steps 11-12

![](https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LAsF1Wuj3-Bs3YBFd7f%2F-McLXq8W0RSqSBnw0PNN%2F-McMBIY1quO8plLJYObs%2Fview_own_data_3.gif?alt=media\&token=10007e0a-a693-4d27-adbe-cc50baf01f6b)
