Question: How I can visualize my GO term data in excel?
0
gravatar for uk0gam
10 months ago by
uk0gam0
uk0gam0 wrote:

Hello

I got the GO term data thought de novo from the RNA-seq company.

but company give me the data only excel form.

So I want to change my data to visualization.

Please help me how to change my excel data.

Dataenter link description here

rna-seq gene • 525 views
ADD COMMENTlink modified 8 months ago by Biostar ♦♦ 20 • written 10 months ago by uk0gam0
7

enter image description here

ADD REPLYlink written 10 months ago by Pierre Lindenbaum112k

If I use the R program, how to match up GO_Number to GO_Name?

ADD REPLYlink written 10 months ago by uk0gam0

Just because you are able to open the file in excel does not mean that the data is in excel format (unless you actually got a .xlsx file). In any case you can export the data into a simple delimited (tab, comma etc) format and use it with other programs.

ADD REPLYlink modified 10 months ago • written 10 months ago by genomax55k

Can you tell me other programs for visualization and changing GO_Number to GO_Name?

ADD REPLYlink written 10 months ago by uk0gam0

Image is not clear. Since it is a bar chart, I guess on Y-axis you have number of genes and x-axis you have GO terms (most probably BP). They are organized by some kind of grouping. It would help forum members if you could provide more details such as high resolution image and the data columns you have etc.

ADD REPLYlink written 10 months ago by cpad01128.8k

Yes, that image looks like you guessed it. So I want to change GO_Number to GO term Name and visualize to graph image. Do I have to change the data one by one? Can you tell me a good program for visualization?

ADD REPLYlink written 10 months ago by uk0gam0
1

Do you have any programming experience? How big is the file, how many rows/terms are we talking about (or in other words, could you translate the GO_IRIs to Go_Labels manually if you are not able to program)?

ADD REPLYlink modified 10 months ago • written 10 months ago by LLTommy1.2k
1
gravatar for cpad0112
10 months ago by
cpad01128.8k
India
cpad01128.8k wrote:

There are several online and offline tools to convert GO IDs to GO term description. Make a list of GO IDs (one per line) and upload the IDs onto a server. Server will generate GO terms for you.

ADD COMMENTlink written 10 months ago by cpad01128.8k

I have moved this to an answer and accepted it, but it would be a nice improvement if you could add one or a few example(s) of online/offline tools to this post for completeness sake.

ADD REPLYlink written 8 months ago by WouterDeCoster32k
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 1578 users visited in the last hour