Question: How I can visualize my GO term data in excel?
0
gravatar for uk0gam
10 days 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 • 151 views
ADD COMMENTlink modified 10 days ago • written 10 days ago by uk0gam0
5

enter image description here

ADD REPLYlink written 10 days ago by Pierre Lindenbaum101k

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

ADD REPLYlink written 9 days 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 9 days ago • written 9 days ago by genomax37k

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

ADD REPLYlink written 9 days 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 9 days ago by cpad01123.1k

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 9 days 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 9 days ago • written 9 days ago by LLTommy1.1k

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 REPLYlink written 9 days ago by cpad01123.1k
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: 616 users visited in the last hour