Category Archives: snippet

MySQL: add a new record

We can add a new record with a statement like this one:

INSERT INTO reagents (name, supplier, amount) VALUES ('Trizma Base', 12, 100);

Note that we list the fields we want to populate and then the values in the same order. See more examples.

Tagged , ,

Load a multifasta file

Today’s task is quite complex, instead of parsing a file that keeps all information we need in a single line, as we did for BLAST. Instead a multifasta has a variable number of lines per item (sequence). This example is hard, that’s why I publish it now so that you can study it!

Let’s consider the following file (called minimultifasta.fna):
Continue reading