Importing gene list and attribute values to string cytoscape

326 views
Skip to first unread message

slba...@uw.edu

unread,
Sep 28, 2018, 2:12:49 PM9/28/18
to cytoscape-helpdesk
Hello,

I need basic help importing data into Cytoscape. I want to use string to build a PPI and I want to gradient color the nodes based on a specific value. The file I am using looks like this:

Entry,gene_symbol,MIIavg
Q14994,NR1I3,1
Q5XUX1,FBXW9,1
O00165,HAX1,1
Q9Y535,POLR3H,1
....

The tutorial from https://jensenlab.org/training/stringapp/ shows how to import a list of gene names. And I found other information on how to import a table. I need to combine this two functions.

Thanks,
SLB

Alexander Pico

unread,
Sep 28, 2018, 7:55:02 PM9/28/18
to cytoscape-helpdesk
Right. You can do both.  First, grab all the UniProt IDs, e.g., copied from the first column when opened in Excel. Then paste that into the STRING protein query tool at the top of the Network panel. This will generate a PPI from you list. Then, use Import Table from File... to import your full table, matching your uniprot column with the "query term" column in your STRING network. This will add your gene_symbol and MIIavg columns to the PPI network. Now you can do gradient color mapping etc.

 - Alex

slba...@uw.edu

unread,
Sep 30, 2018, 2:03:17 AM9/30/18
to cytoscape-helpdesk
Thanks so much for your reply! I followed your instructions and it imported the table headers (gene_symbol and MIIavg) but not the values. Any suggestions on why this may be?

Thanks, 
SLB

Alex Pico

unread,
Sep 30, 2018, 4:23:10 PM9/30/18
to cytoscape...@googlegroups.com
You’ll want to double check the options you use during table import. I might have suggested the wrong ones, as I’m going by memory and not directly working with your files. The options need to specify the column in your STRING network and that matches the column in table your are importing, e.g., the columns that contain matching Uniprot IDs. That is the only way Cytoscape knows how to match up your data with the network.

If you can’t get it to work, then, you’ll need to provide the files. 

Hope this helps!
 - Alex



--
You received this message because you are subscribed to the Google Groups "cytoscape-helpdesk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpd...@googlegroups.com.
To post to this group, send email to cytoscape...@googlegroups.com.
Visit this group at https://groups.google.com/group/cytoscape-helpdesk.
To view this discussion on the web visit https://groups.google.com/d/msgid/cytoscape-helpdesk/a060ae51-2777-4681-9a2f-03ee92fdcf32%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Message has been deleted

slba...@uw.edu

unread,
Oct 4, 2018, 11:56:42 PM10/4/18
to cytoscape-helpdesk
Thanks so much this worked perfectly!

Not sure if I should start another thread or not but...

When I change the node size, it only does it for nodes without any edges. I currently have my nodes sized based on degree of connectivity but would like to make them all larger, keeping the proportions the same of course.

Thanks in advance,
SLB
To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpdesk+unsub...@googlegroups.com.

piet molenaar

unread,
Oct 5, 2018, 6:29:11 AM10/5/18
to cytoscape-helpdesk
Hi, 
You can set the default node size in order to increase the size of all nodes.
Click on the number in the Def. column of the Node size attribute
See image below
Hope this helps,
Piet

image.png

To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpd...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "cytoscape-helpdesk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpd...@googlegroups.com.

To post to this group, send email to cytoscape...@googlegroups.com.
Visit this group at https://groups.google.com/group/cytoscape-helpdesk.

For more options, visit https://groups.google.com/d/optout.


--
Piet Molenaar
piet...@gmail.com
Department of Oncogenomics, M1-131
Amsterdam University Medical Centers 
Meibergdreef 9
1105 AZ Amsterdam
the Netherlands

tel (+31) 20-5666592
fax (+31) 20-6918626

slba...@uw.edu

unread,
Oct 5, 2018, 11:42:55 AM10/5/18
to cytoscape-helpdesk
Thanks for your reply. I attached images of the problem. The first image has size 30 (default?) and the second image I changed the size to 60. Notice only the non-connected nodes change in size. See also my size parameters in the image. 
To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpdesk+unsub...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "cytoscape-helpdesk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpdesk+unsub...@googlegroups.com.
size30.PNG
size60.PNG

piet molenaar

unread,
Oct 8, 2018, 4:00:37 AM10/8/18
to cytoscape-helpdesk
Aha, in that case you should set the minimal value of the mapping size to 60 also. The mapping size overrides the default size.
Hope this helps

To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpd...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "cytoscape-helpdesk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpd...@googlegroups.com.


--
Piet Molenaar
piet...@gmail.com
Department of Oncogenomics, M1-131
Amsterdam University Medical Centers 
Meibergdreef 9
1105 AZ Amsterdam
the Netherlands

tel (+31) 20-5666592
fax (+31) 20-6918626

--
You received this message because you are subscribed to the Google Groups "cytoscape-helpdesk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cytoscape-helpd...@googlegroups.com.

To post to this group, send email to cytoscape...@googlegroups.com.
Visit this group at https://groups.google.com/group/cytoscape-helpdesk.

For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages