How to open a .tabular file in R or excel?
2
1
Entering edit mode
5.6 years ago

Hi

I am trying to use featureCounts to get gene expression data for a paired-end single cell RNA-seq data. The function returns a .tabular file and I am unable to open it in excel or R.

Can someone please help me on this?

featureCounts tabular RNA-Seq • 9.2k views
ADD COMMENT
0
Entering edit mode

.tabular file is a tab separated values (.txt). Take a back up of .tabular file, change the extension of existing file to .tsv or .txt and then try opening with excel. One has option to change the output while using featurecounts using -o output.txt. I guess you are in windows, try using software like notepad++ (text viewer) for viewing texts instead of notepad or wordpad

ADD REPLY
0
Entering edit mode
5.6 years ago
h.mon 35k

What is the relation of your title ("How long is the waiting time for a job to run?") to your question (how to open a text file containing tab-separated values in Excel)?

Save it as .tsv (or .csv) and open it in Excel.

ADD COMMENT
1
Entering edit mode

sorry I posted something else by mistake. Just modified it. Thanks.

ADD REPLY
0
Entering edit mode
5.6 years ago
ahmad mousavi ▴ 800

Hi Just drag and drop it in a excel window, If you see all data were in one column, then go to Data tab and Use Text to Column and then use Tab for delimiting your data.

See this link.

ADD COMMENT

Login before adding your answer.

Traffic: 1925 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6