I have output from blastn. The output format is 6. -outfmt "6 qseqid sseqid stitle pident qcovs" and I have saved it as csv file.
So I have multiple csv blast output files in a directory. I want to work on cleaning up the csv files all at once using R studio. Each csv file has the same number of columns (1 column) and a different number of rows.
To read all the csv files at once, i used:
fnames <- list.files() csv <- lapply(fnames, read.csv)
This creates a list of data frames. Now I want to split the one column into multiple ones based on tab spaces. I tried to use:
strings <- str_split_fixed(csv$col1, " ", 5)
However, this is not working, as it creates no data at all:
Is there another way with which I could split the column on all the csv's all at once?
P.S. I am posting on behalf of someone, so they may respond here to any questions for clarification.