User Help Pages
  • Welcome to the Help Pages for UCSC Xena
  • Tutorials and webinars
    • Webinars
    • Basic Tutorial: Section 1
    • Basic Tutorial: Section 2
    • Basic Tutorial: Section 3
    • Advanced Tutorial: Section 1
    • Advanced Tutorial: Section 2
    • Tutorial: Tumor vs Normal
    • Tutorial: Viewing your own data
    • Live examples
  • How do I ...
    • How do I make a KM plot?
    • How do I compare tumor vs normal expression?
    • How do I remove null data (gray lines) from view?
    • How do I make subgroups?
    • How do I make more than 2 subgroups?
    • How do I make subgroups with geneA high and geneB high?
    • How do I compare gene expression between subgroups?
    • How do I compare gene expression between different cancer types?
    • How do I remove duplicate samples from a KM plot?
    • How do I view multiple types of cancer together?
    • How do I filter to just one cancer type
    • How do I view my data with the data from TCGA?
    • How do I change the color of a column?
    • How do I interact with the tooltip?
    • How do I cite UCSC Xena?
  • Overview of features
    • Visual Spreadsheet
      • Coloring for Mutation Columns
      • Coloring for Segmented Copy Number Columns
    • Kaplan Meier Plots
    • Chart & Statistics View
    • Filtering and subgrouping
      • Supported search terms for finding samples
    • Differential Gene Expression
    • GSEA
    • Genomic Signatures
    • Bookmarks
    • Download Data
    • Xena Single Cell
    • TumorMap
    • MuPIT
    • Accessing data through python
    • Transcript View
    • Xena Gene Set Viewer
  • Overview of public data
    • Types of data we have
    • TCGA
    • GDC
    • More studies
    • Choosing a study/cohort
  • FAQ
    • Xena Browser
    • Data and datasets
  • Viewing your own data
    • Getting Started
    • Probes/transcripts/identifiers we recognize
    • Data format specifications and supported biological data types
    • KM plots using data from a Local Xena Hub
    • Hubs for institutions, collaborations, labs, and larger projects
    • Loading data from the command line
    • FAQ/Troubleshooting Guide
  • Technical documentation
    • Setting up Xena for your institution
    • Deep Linking Into Xena
    • Metadata Specification
  • Contact us
  • Cite us
  • Data Use Agreement
Powered by GitBook
On this page
  • Description
  • Prerequisites
  • Estimated time needed
  • Learning goals
  • Tutorial
  • Part A
  • Part B
  • Test your knowledge

Was this helpful?

Export as PDF
  1. Tutorials and webinars

Basic Tutorial: Section 1

Learn to create your first views in Xena

Last updated 6 months ago

Was this helpful?

Description

This tutorial is made for those who have never used Xena. We will cover how to create a Visual Spreadsheet with gene expression, mutation, and copy number variation data.

Prerequisites

This tutorial assumes basic knowledge of

  • gene expression, copy number variation, and mutational genomic sequencing data

  • how a change in copy number variation or mutations can lead to a change in gene expression

  • The Cancer Genome Atlas (TCGA)

These resources can help you gain basic knowledge of these concepts:

Estimated time needed

Part A: 5 min

Part B: 10 min

Learning goals

Part A

  • Create a Visual Spreadsheet

  • Compare data across columns

Part B

  • Move columns

  • Resize columns

  • Zoom in and out

Tutorial

We are going to look at EGFR aberrations in patients with lung adenocarcinomas using TCGA data. We will be looking at mutations and copy number aberrations and how they change gene expression.

Part A

Our goal is to build a Visual Spreadsheet and understand the relationship between the columns of data.

Steps

  1. Type 'GDC TCGA Lung Adenocarcinoma (LUAD)', select this study from the drop down menu, and click 'To first variable'.

  2. Type 'EGFR', select the checkboxes for Gene Expression, Copy Number, and Somatic Mutation, and click 'To second variable'.

Video of steps:

How to read a Visual Spreadsheet

Samples are on the y-axis and your columns of data are on the x-axis. We line up columns so that each row is the same sample, allowing you to easily see trends in the data. Data is always sorted left to right and sub-sorted on columns thereafter.

Biological interpretation

We can see that samples from TCGA patients that have high expression of EGFR (red, column B) tend to either have amplifications of EGFR (red, column C) or mutations in EGFR (blue tick marks, column D).

More information

Making your own Visual Spreadsheet: Which TCGA study to choose

Part B

We will now move the columns to change the sort order and resize columns. We will zoom in to the whole Visual Spreadsheet and also within a column.

Steps

  1. Move columns. Click column C, copy number variation, and drag it to the left so that it becomes the first column after the samples column (i.e. column B). Note that the samples are now sorted by the values in this column.

  2. Resize columns. Click the handle in the lower right corner of column D, mutation. Move it to the right to make the column bigger.

  3. Zoom in on a column. Click and drag within column D. Release to zoom.

  4. Zoom out on a column. Click the red zoom out text at the top of column D.

  5. Zoom in on samples. Click and drag vertically in any column in the Visual Spreadsheet to zoom in on these samples.

  6. Zoom out on samples. To zoom out click either 'Zoom out' or 'Clear zoom' at the top of the Visual Spreadsheet.

Video of step 1

Video of step 2

Video of steps 3-6

More information

Test your knowledge

Create a Visual Spreadsheet looking at TP53 gene expression and mutation in samples from patients in the GDC TCGA Lower Grade Glioma study.

Change the Visual Spreadsheet from Question 1 so that the patient's samples are sorted by mutations rather than gene expression.

Start at our home page and click on 'Launch Xena'. You are now in our Visual Spreadsheet Wizard.

In this example we selected the TCGA data from the GDC.

Link to Ending Screenshot
http://xena.ucsc.edu/
There are 4 versions of the TCGA data in Xena.
This page can help you decide which version of TCGA data to use for your own analysis.
Visual Spreadsheet
Ending Screenshot
Ending Screenshot
Visual Spreadsheet
Colors and values in columns
Sample sorting
https://connect.springerpub.com/content/book/978-0-8261-6868-9/chapter/ch01connect.springerpub.com
LogoWhat is functional genomics?Functional genomics I
LogoThe Cancer Genome Atlas - Cancers Selected for StudyNational Cancer Institute
LogoThe Cancer Genome Atlas - Data Types CollectedNational Cancer Institute