trying to export DNA sequences into excel so that there are three nucleotides per column

Question

[ashrafm2]

I have a sequence of DNA randomised in 15 amino acid positions. we have amplified the DNA and sequenced and aligned it using galaxy and have bamfiles . what we would like to do now is to break up the aligned DNA into three so that it is sorted in codons and export into excel as three nucleotides into a column. Is this possible for each sequence?

[Pierre Lindenbaum]

[ATpoint]

That one actually inspired me in the past to change my profile picture :)

Answer 1

[zx8754]

Please provide example input and expected output.

Here is an example using R:

x <- "12345678"
n <- 3
substring(x, seq(1, nchar(x), n), seq(n, nchar(x) + n - 1, n)) 
# [1] "123" "456" "78"

More solutions are at:

• Chopping a string into a vector of fixed width character elements