Hi,
I've run FastOrtho and I have a table in ".txt" and excel format with the Ortholog groups in the rows and Protein ID/Strains ID in the columnn:
ORTHOMCL0 (317 genes,19 taxa): PROKKA_01189(Firmino_Lb.brevis_3C0_TAAGGCGA-) ORTHOMCL1 (268 genes,19 taxa): PROKKA_02245(Firmino_Lb.brevis_3C0_TAAGGCGA-) ORTHOMCL2 (258 genes,19 taxa): PROKKA_02126(Firmino_Lb.brevis_3C0_TAAGGCGA-) ORTHOMCL3 (227 genes,19 taxa): PROKKA_02191(Firmino_Lb.brevis_3C0_TAAGGCGA-) ORTHOMCL4 (222 genes,19 taxa): PROKKA_02050(Firmino_Lb.brevis_3C0_TAAGGCGA-)
I would like to have a matrix with the counts and "0" for absence, like this:
ortholog brevis367 casei12A casei334 caseiUW1 ORTHOMCL0 (71 genes,21 taxa): 3 4 3 3 ORTHOMCL1 (49 genes,1 taxa): 0 0 0 0 ORTHOMCL2 (48 genes,3 taxa): 0 0 0 0 ORTHOMCL3 (42 genes,21 taxa): 2 2 2 2 ORTHOMCL4 (42 genes,21 taxa): 2 2 2 2
Can someone help me?
Thanks