# Advanced Tutorial: Section 1

## Description <a href="#description" id="description"></a>

This tutorial is made for those who have basic knowledge of how to use Xena. We will cover how to view whole chromosome and how to use the advanced dataset menu to access datasets such as exon expression.

## Prerequisites <a href="#prerequisites" id="prerequisites"></a>

This tutorial assumes basic knowledge of how to build and read a [Visual Spreadsheet](https://ucsc-xena.gitbook.io/project/overview-of-features/visual-spreadsheet). To get this, go through [Basic Tutorial: Section 1](https://ucsc-xena.gitbook.io/project/tutorials/basic-tutorial-section-1).

## Estimated time needed <a href="#estimated-time-needed" id="estimated-time-needed"></a>

10 min‌

## Learning goals <a href="#learning-goals" id="learning-goals"></a>

Create a visual spreadsheet that with a chromosome-wide column and data from the advanced dataset menu.

## Tutorial <a href="#tutorial" id="tutorial"></a>

We will look at the *ERG-TMPRSS2* gene fusion in patients from the TCGA Prostate Cancer study.

*ERG* is an oncogene that expressed at low levels in normal prostate tissue. Some patient's prostate cancer samples have higher expression of *ERG*. These samples tend to have an intra-chromosomal deletion that fuses *ERG* to *TMPRSS2*. *TMPRSS2* is expressed at high levels in normal prostate tissue. This allows *ERG* to use the *TMPRSS2* promoter to increase *ERG* expression.

{% embed url="<https://docs.google.com/presentation/d/1kiGz-L6Z2Qm4PwMs3Sbtvtr1tF-xd3PXOUAetamt_6k/edit?usp=sharing>" %}

#### [​Ending Screenshot​](https://xenabrowser.net/?bookmark=6ea137951fb4ddad4c8a6baaac3914f4) <a href="#ending-screenshot" id="ending-screenshot"></a>

{% hint style="info" %}
Note that column D may look slightly different, depending on how you resize and zoom the column.
{% endhint %}

![](https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LAsF1Wuj3-Bs3YBFd7f%2F-Mbr7G41jLxIYeIBRnNO%2F-MbrScpIGFmdJrvuDfce%2FScreen%20Shot%202021-06-10%20at%2012.46.32%20PM.png?alt=media\&token=84fe6019-527a-4d0b-a67c-7a1514871613)

We can now see that there are many patient's samples with relatively high expression of *ERG* (column B). This relatively high expression is not uniform across the exons of *ERG*, but instead is in the exons closer to the 3' end of the gene (column C). Looking at column D, we can see that these samples also have an intra-chromosomal deletion of part of chromosome 21. If we hover over the genes at either end of the deletion, we can see that the end points fall within *ERG* and *TMPRSS2*.&#x20;

#### Steps <a href="#steps" id="steps"></a>

1. Start at <https://xenabrowser.net/>
2. Type 'TCGA Prostate Cancer (PRAD)', select this study from the drop down menu, and click 'To first variable'.
3. Type '*ERG*', select the checkbox for Gene Expression and click 'To second variable'.
4. Type '*ERG*', click 'Show Advanced', select the checkbox for 'IlluminaHiSeq' under 'exon expression RNAseq', and click 'Done'.
5. Click the text 'Click to insert a column' after column C. Type 'chr21', select the checkbox for Copy Number and click 'Done'.
6. Click on the filter menu and select 'Remove samples with nulls'
7. Click on the  handle in the lower right corner of column E, copy number for chromosome 21. Move it to the right to make the column bigger.&#x20;
8. Click and drag within column E, copy number for chromosome 21 to zoom into the intra-chromosomal deletion.

#### Video of steps 1-4 <a href="#video-of-steps" id="video-of-steps"></a>

<figure><img src="https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LAsF1Wuj3-Bs3YBFd7f%2Fuploads%2FoLXrWO0ZslZvRvcGjZZr%2FProstateERGbeginning.gif?alt=media&#x26;token=b99e7055-ba38-4ce8-960c-d5064a969f91" alt=""><figcaption></figcaption></figure>

#### ‌**Video of steps 5-8**

<figure><img src="https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LAsF1Wuj3-Bs3YBFd7f%2Fuploads%2F0dh2g1BOQpM006SiVSj7%2FprostateERGsecond.gif?alt=media&#x26;token=59261765-72fc-4396-9126-18227de285bc" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
More information:

* [Advanced dataset menu](https://ucsc-xena.gitbook.io/project/overview-of-features/visual-spreadsheet#advanced-datasets)
* [Visual Spreadsheet](https://ucsc-xena.gitbook.io/project/overview-of-features/visual-spreadsheet)
  {% endhint %}

## Test your knowledge <a href="#test-your-knowledge" id="test-your-knowledge"></a>

{% tabs %}
{% tab title="Question 1" %}
Add copy number data for chromosome 1.
{% endtab %}

{% tab title="Answer 1" %}
[**Ending Screenshot**](https://xenabrowser.net/?bookmark=95d77b2d3107653fa2a7be51424f0a04)

![](https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LAsF1Wuj3-Bs3YBFd7f%2F-MbrVdqgHpoT3CcZ3WGc%2F-Mbs6ccB3CH4IXijwjUC%2FScreen%20Shot%202021-06-10%20at%203.49.57%20PM.png?alt=media\&token=ed173a16-5af1-488a-a098-c1d853c5c5fc)
{% endtab %}
{% endtabs %}

{% tabs %}
{% tab title="Question 2" %}
Add DNA Methylation data for *ERG*.
{% endtab %}

{% tab title="Answer 2" %}
[**Ending Screenshot**](https://xenabrowser.net/?bookmark=3b8cf8fa103e5fe2d718337551af34a4)

![](https://3676322134-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LAsF1Wuj3-Bs3YBFd7f%2F-MbrVdqgHpoT3CcZ3WGc%2F-Mbs6GXta-IB5Yz3nIff%2FScreen%20Shot%202021-06-10%20at%203.48.18%20PM.png?alt=media\&token=c3f5d9bb-da65-4569-86f4-0a29001aa6c5)
{% endtab %}
{% endtabs %}
