Using the DEE2 bulk data dumps

The DEE2 project makes freely available bulk data dumps of expression for each of the nine species. 

The data is organised as tab separated values (tsv) in "long" format. This is different to a standard gene expression matrix - see below.


The long format is prefered for really huge datasets because it can be readily indexed and converted to a database, as compared to wide matrix format. 

You'll notice that there are 4 files for each species, with each having a different suffix. They are all compressed with bz2. You can use pbzip2 to de-compress these quickly.

*accessions.tsv.bz2 This is a list of runs included in DEE2, along with other SRA/GEO accession numbers. 

*se.tsv.bz2 These are the STAR based gene expression counts in 'long format' tables with the columns: 'dataset', 'gene', 'count'.

*ke.tsv.bz2 These are the Kallisto estimated transcript expression counts also in long format

 *qc.tsv.bz2 These are the QC metrics are also available in long format with the columns 'dataset','QC metric type', 'QC metric result'.

 Once downloaded and decompressed, we can start working with it in R.
# Load data
x<-read.table("ecoli_se.tsv")

 # Randomly select a few run names
runs<-sample(unique(x$V1),9)

 # subset based on the run names
y<-x[which (x$V1 %in% runs),]

#Use acast to transform the data from long format to wide
library(reshape2)
z<-as.matrix(acast(y, V2~V1, value.var="V3"))

 head(z)
      ERR862937 SRR1793913 SRR2086965 SRR2099922 SRR4434025 SRR5115646
b0001       200         91         40       6292          8        838
b0002       921        167        822       1474        641       3745
b0003       446         64        216        294        287       2437
b0004       832         65        333        957        462       2962
b0005       105          6         84         23          1        324
b0006      2415         38        212        387          3       1443
      SRR5130628 SRR6001772 SRR6020052
b0001         21       5613       2352
b0002          4       5709       1618
b0003          0       1985        839
b0004          0       4250       1440
b0005          1        727         25
b0006          0       1435       1797
Location: Laverton VIC 3028, Australia

Popular posts from this blog

Mass download from google drive using R

Google drive is great for sharing documents and other small files but it's definitely not suited to moving  many large files around. For example I just received 170 fastq files that are about 200 MB in size. If you use the browser to download the whole folder, the web app will zip the contents for you which will take a LOOONG time. Alternatively you can download each and every one of those files one by one, which is annoying and prone to human error. You can insist to your collaborators to transfer in a different way, but there are not that many user-friendly and economic approaches. Your biologist collaborators probably won't be able to use rsync  to get the data to you safely. And fast convenient tools for moving around large files like Hightail cost a lot of money. A good solution to this problem is to use the R package googledrive  which enables command line automation of tasks that might take a long time manually. The package vignette has a good overview of the main comma
Read more

Data analysis step 8: Pathway analysis with GSEA

Image
In our RNA-seq series so far we've performed differential analysis and generated some pretty graphs, showing thousands of differentially expressed genes after azacitidine treatment. In order to understand the biology underlying the differential gene expression profile, we need to perform pathway analysis. We use Gene Set Enrichment Analysis ( GSEA ) because it can detect pathway changes more sensitively and robustly than some methods. A 2013 paper compared a bunch of gene set analyses software with microarrays and is worth a look. Generate a rank file The rank file is a list of detected genes and a rank metric score. At the top of the list are genes with the "strongest" up-regulation, at the bottom of the list are the genes with the "strongest" down-regulation and the genes not changing are in the middle. The metric score I like to use is the sign of the fold change multiplied by the inverse of the p-value, although there may be better methods out there
Read more

Extract properly paired reads from a BAM file using SamTools

For a few different types of sequence analysis I need to extract read pairs that are properly mapped and satisfy some map quality filter, but I always forget the command line. So here it is: To read pairs from a bam file (-b) that map with mapQ≥30 including the bam file header (-h). The -f 0x2 option corresponds to the bitwise flags that specify that reads need to be properly paired. Proper pairing means reads are in Read1 forward, Read2 reverse orientation or Read1 reverse, Read2 forward orientation. $ samtools view -q 30 -f 0x2 -b -h in.bam > out.bam To extract single end reads from a bam file (-b) that map with mapQ≥30 including the bam file header (-h). $ samtools view -q 30 -b -h in.bam > out.bam
Read more