This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Arrange Table for orthogroup categorization

Hi all,

I would like to make Venn-diagram by pairwisely comparing orthogroups generated from 4 different strains. I have run Inparanoid and got a list of all paired orthogroups (e.g., SQLtable). However, I am in trouble making Venn-diagram by determining "Core", "Accessary", and "Singleton" from the output from Inparanoid. If you have a similar experience, could you please share your idea with me?

Or, if you help me how to transform the output table from Inparanoid below, I may go further by myself.
[Original]

1 tfs232

1 tfs235

2 tfs148

2 tfs146

3 tfs139

3 tfs178

3 tfs179

*The total table length is ~1000 and the No. ranges from 2~5. So, I cannot just extract odd and even rows.

[This is what I want to make]

1 tfs232 tfs235

2 tfs148 tfs146

3 tfs139 tfs178 tfs179

Thanks.

alignment
• 974 views • link
written by ysas • ysas

Here's how you can do it : awk '{tass[$1]=tass[$1]"\t"$2}END{for(i in tass){print i"\t"tass[i]}}' your file then to know which are "Core", "Accessary", and "Singleton" it depends on your data.

• 0 views • link
written by lagartija lagartija

0 answers

No answers yet.

Log in to answer this question.

More posts like this