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.
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):