Bacterial metagenomics on the JHU campus: analyzing the data, part II

What do you do after you've used DNA sequencing to identify the bacteria, viruses, or other organisms in the environment?

What's the next step?

This four part video series covers those next steps. In this part, we learn that a surprisingly large portion of bioinformatics, or any type of informatics is concerned with fixing data entry errors and spelling mistakes.

The parts of this series are:

I. Downloading the data from iFinch and preparing it for analysis. (this is the video below) (We split the data from one column into three).

II. Cleaning up the data

III. Counting all the bacteria

IV. Counting the bacteria by biome

Part II. Pivot tables from Sandra Porter on Vimeo.

For more information about this project, check here, here, here, and here.

More like this

This is third video in our series on analyzing the DNA sequences that came from bacteria on the JHU campus. In this video, we use a pivot table to count all the different types of bacteria that students found in 2004 and we make a pie graph to visualize the different numbers of each genus. The…
Do different kinds of biomes (forest vs. creek) support different kinds of bacteria? Or do we find the same amounts of each genus wherever we look? Those are the questions that we'll answer in this last video. We're going to use pivot tables and count all the genera that live in each biome. Then…
For the past few years, I've been collaborating with a friend, Dr. Rebecca Pearlman, who teaches introductory biology at the Johns Hopkins University. Her students isolate bacteria from different environments on campus, use PCR to amplify the 16S ribosomal RNA genes, send the samples to the JHU…
Do mosquitoes get the mumps? Part V. A general method for finding interesting things in GenBank This is the last in a five part series on an unexpected discovery of a paramyxovirus in mosquitoes and a general method for finding other interesting things. In this last part, I discuss a general…