weird number in log2FC

Question

[roghaiyeh.safari]

does somebody knows why do I have weird numbers in base mean and log2FC. 4 points in one number? thanks

ENSOARG00000003154 356.920.477.363.281 239.408.657.153.029 0.243919505 94.649.345.411.828 2.94E-07 4.65E-03 ENSOARG00000000480 752.987.116.204.303 267.648.179.998.367 0.282750622 93.371.568.976.297 9.90E-07 7.83E-03

[roghaiyeh.safari]

baseMean log2FoldChange lfcSE stat pvalue padj
ENSOARG00000003154 356.920.477.363.281 239.408.657.153.029 0.243919505 94.649.345.411.828 2.94E-07 4.65E-03

[Carlo Yague]

Did you use excel at some point in your analysis ? Its automatic formating can be a pain sometimes.

PS: I think your question lacks some context. Where does your data come from ? And what have you done with it to obtain those numbers ?

[ATpoint]

Looks like decimal delimiter and float delimiter are the same here. Both "."

Answer 1

[roghaiyeh.safari]

Thanks for answering.

I analyzed data with deseq2 and using write.table I extracted. When I open it in windows environment it looks like this. write.table(Shrunkorder , "Treated_vs_ControlshrunkOrder.txt",sep="\t",col.names=T,row.names=T, quote=F)

I noticed thattThe problem occures when I try to open it by excel.

Thanks

Answer 2

[Antonio R. Franco]

Try to include dec="," as well in the write.table command, specially if your excel recognize the "," as the decimal digit