Now I want to find all the partial sequences in all the full sequences (the partial sequences might even overlap) and create an output which looks like this:
Hi @Sere,
how would you like to output that formatted string? To check whether a string exists within another string, you can use the String Manipulation node with the indexOf() function. It outputs the position in the queried string at which the searched string was found. However, this only works if it occurs only once. I might be able to give you more helpful advice if you tell me which output format you would prefer.
Kind regards,
Alexander
I will have a long list of partial sequences and a long list o full sequences, so a few partial sequences will definitely be matched more than just once. As output I don´t really care, word-file, excel-file, RTF would do it.
Hi @Sere,
to answer your question: Yes, it is possible, but only by really bending KNIME to your will using a bunch of veeery dirty tricks. Please have a look at the attached workflow. But disclaimer: If you are dealing with a lot of sequences, it might be easier to use one of the scripting nodes, e.g. Python or R.
The workflow goes through all the subsequences in a recursive loop and does the replacement one by one, always passing the table with the treated full sequences back to the loop start. Within the loop a String Manipulation node uses regular expressions to add parentheses around the detected subsequences. After the loop, a Column Expression node goes through the sequences again, inserting opening and closing HTML bold tags (<b> and </b>). Then we add some HTML tags at the beginning and end and write it using the CSV Writer. This is as ugly as it can get, but if it is stupid and it works, it ain’t stupid Subsequences.knwf (37.6 KB)
I was working on a different approach like this wf identify occurence multiple substring.knwf (316.6 KB) . For every partial sequence it gives you if it occurs and on what position.
Thank you very much! …and I agree, if it works it works The workflow works nicely, but when I change the substrings and sequences in the first two tables, I run into some problems. It seems that only the last substring sequence is being highlighted in the html output and all other sequences are being ignored, although they are definitively present. Do I need to adjust some settings? Find attached the workflow with my updated sequences.
Hi @Sere,
I tried your downloaded and had the same result. However, when I paste your sequences into a text editor and search for the partial sequences, I also don’t get any hits except for the last sequence. Are you sure the partial sequences are contained? Or maybe it would be better to use tools made for sequence data, such as SeqAn?
Kind regards
Alexander
That´s weird. If I paste them into a text editor and then search for the partial sequences, I do find them. The partial sequences are definitely there. I´ll have a look at SeqAn. Thanks for the recommendation!
Hi @Sere,
you have some trailing spaces in your partial sequences, that is why it does not work. You can either change that in the table creator or simply use a String Manipulation node with the strip() function to remove any leading and trailing whitespace.
Kind regards
Alexander
The workflow works nicely, but when I change the substrings and sequences in the first two tables, I run into some problems. It seems that only the last substring sequence is being highlighted in the html output and all other sequences are being ignored, although they are definitively present. Do I need to adjust some settings? Find attached the workflow with my updated sequences.