I have a file 'ids.txt' containing IDs like this:
gi|78062356|ref|YP_372264.1| gi|206563435|ref|YP_002234198.1| gi|402568881|ref|YP_006618225.1| gi|54024439|ref|YP_118681.1| gi|146275970|ref|YP_001166130.1|
How can I have them into two columns one having the gi's and the other having all the ref's like as shown below?
78062356 YP_372264.1 206563435 YP_002234198.1 402568881 YP_006618225.1 54024439 YP_118681.1 146275970 YP_001166130.1
Preferably in R or Python.