Sort Gene Expression Data Using Spreadsheets

Terms of Use

Except where otherwise indicated, the contents of this slide presentation are available for use under the Creative Commons Attribution 4.0 license.

You are free to adapt and share the work, but you must give appropriate credit, provide a link to the license, and indicate if changes were made.

Sample attribution: [Title of work] by C-MOOR. CC-BY 4.0

2

This Google Slides template is modified

from original work by Jimena Catalina,

provided as free to use from SlidesCarnival

under Creative Commons License

Attribution 4.0 International.

Learning Goals

1. Access test-driveR.tsv
2. Convert to Google Sheet
3. Sort column
4. Select gene to plot
5. Insert barplot

​

Image: Lukas Blazek on Unsplash

https://drive.google.com/file/d/1kMWQReRTg0FDZDA5abxmkgKxp-7o5IeM

What is the gene expression of the lab gene?

Look for the GeneID for the Drosophila gene “lab”

​

14

Analyzing gene expression data

-Observation

Gene expression changes when it’s sorted by region

-Some possible hypotheses

1)These regions have cells with different functions

If this is true, you would expect to see genes that work in the same pathway expressed together in the same regions.

How can you find out if they function in the same pathway? What data is available? Biological databases, genome browsers

​

Summary

What we learned..

1. Accessed test-driveR.tsv and convert to Google Sheet
2. Sort by column
3. Create a barplot

What’s next..

1. Explore biological databases to learn more about what a gene looks like and what its function might be.

Add Attributions here. Delete if not needed.

Contributions

This lesson was created by:

• Rosa Alcazar Ph.D., Clovis Community College
• Frederick Tan Ph.D., Carnegie Science

Revised February 3, 2022

Add Attributions here. Delete if not needed.

​