Lab Data Mining Script Prototype

Gameplay and Strategies Tools
31

Re Further grouping and analysis is a bit more fuzzy in my mind as yet.
Yes, grouping seems like a very open-ended question. From experience using my tool, here’s a new variation I thing I will at least try out.

Allow the standard notation of sets of bases (S,W, R, … in addition to C, G, U, …) to be used in grouping as well as filtering. That is, in addition to specifying a position to group on (which multiplies by four the potential number of different groups), one could specify a position and a letter. For example 17S in the group by option would split designs into just two groups, S and W (i.e.not S).

33

OK, I have a very rough example of a secondary structure server running from a Google spreadsheet. The spreadsheet URL is https://docs.google.com/spreadsheet/ccc?key=0AkRBfaX8rvhLdE9TVWdRdWlQLWJxTFY1TmxjbDB1b3c&usp=sharing. I’'ve manually entered five labs, with their target structure. In the spreadsheet, if you click on Tools/Script Editor, you should be able to see the Javascript code for the server. (But I haven’t verified that it is visible to anyone who has access to the spreadsheet itself.)

To use the server, the URL for searching for tetraloops is https://script.google.com/macros/s/AKfycbzEjhHe_q4Ze_Uj4-sSaOED8jpHa6bTUOX9SWp434S5tkB4mUDb/exec?TargetMotif=%28....%29. Note that you have to escape each dot and parens, because right now, I’m passing the parameter value straight to the regular expression match.

Let me know if you can see the source and use the URL.

35

Thanks for the example. I can see the spreadsheet and run the code, but I cannot see the script. Have sent a request for additional access for my gmail account. Thanks.