Separating multiple delimiters in dplyr

[sr320]

I feel like I have asked before, but could not find..

In R I want to separate SPIDs in Blast output

How do I get V2 into three columns using dplyr / tidyverse?

[aspencoyle]

Ooh, I got this - ran into this exact problem recently! Something along these lines should work!

blast_sep <- separate(data = blast, col = V2, into = c("sp", "Accession_ID", "Gene"), sep = "\\|")

[sr320]

Awesome! --
and with pipes

blast <- read.csv("../data/cbai_transcriptome_v3.1.blastx.outfmt6.txt", header = FALSE, sep="\t") %>% 
    separate(col = V2, into = c("sp", "Accession_ID", "Gene"), sep = "\\|")