Question

how to export data as excel file from plotSmear when using edgeR

0

Entering edit mode

linya • 0

@linya-11536

Last seen 8.0 years ago

Hi,

I am using edgeR to analyze differential expression of my RNA-Seq data. I am getting a plot of log-fold change vs log-counts per million with plotSmear function. I am wondering how can I export all the data as excel file containing gene name, logFC, logCPM, PValue, and FDR. Thanks!

edger • 1.2k views

ADD COMMENT • link updated 8.0 years ago by Gordon Smyth 51k • written 8.0 years ago by linya • 0

score 3 · Accepted Answer · 2016-09-22

3

Entering edit mode

Gordon Smyth 51k

@gordon-smyth

Last seen 1 day ago

WEHI, Melbourne, Australia

Have you done a DE analysis? What you are asking for is the toptags table produced by the topTags() function:

tab <- topTags(lrt)
write.csv(tab, file="myfile.csv")

ADD COMMENT • link 8.0 years ago Gordon Smyth 51k

0

Entering edit mode

Thanks so much! Gordon. I just tried your code. It only shows the top 10 genes.

I would like to have all the up or downregulated gene list with logFC, logCPM, Pvalue, and FDR. Would you have some suggestions? Thanks!

ADD REPLY • link 8.0 years ago linya • 0

1

Entering edit mode

If you read ?topTags, you can see that the n parameter is the relevant argument. Try setting n=Inf.

ADD REPLY • link 8.0 years ago Aaron Lun ★ 28k

0

Entering edit mode

Thanks! It works!

> tab<-topTags(lrt,n=Inf)
> write.csv(tab,file="my file.csv")

ADD REPLY • link 8.0 years ago linya • 0