The SQLite Module allows the usage of a SQL database. With this database it is possible to safe all created repeat, primer and multiplex tables and use these tables again for later research.When the database is opened a window like the one in the picture below will be created. This window consists of three lists, a multiplex-, a primer- and a repeat-list. Every list contains tables of according type. Every table in a list has a unique ID. If a primer table is written to the database it automatically will appear in the right list by the next opening of the database. With a double click on a row of a list the corresponding table will open.
Through the buttons “Multiplex”, “Primer” or “Repeat” it is possible to delete a selected table in the related list. The button “Reload DB” allows to reload the SQLite database, this is necessary when a table is added through one of the other modules. There are three kinds of tables in the SQLite database; at first the repeat table will be explained:
1. A table of the repeats, a double click on a row opens a contig editor. 2. The buttons to select or deselect all repeats in the list. 3. The button “Delete Table” will delete this table from the database when clicked. The button “Delete selected Rows” deletes all rows from this table which are checked in the “Use”-column. 4. The button “New Table” creates an empty table; it appears in the appropriate list of the SQLite database. With the button “Enter selected Rows” all rows which are checked in the “Use”-column can be written to the table with the ID set in the text field. 5. Here the names of the export file, SQLite database and Gap4 database annotation are set. 6. With the button “Safe Change” the comment for the table can be changed. The actual comment will be used if the table is again exported to a SQLite database. 7. Here a table shows all primers in the database which refer to the selected repeat. The columns “Table” and “ID” show the location of the specific primer in the database. Here again a double click will open a contig editor. 8. The “Add to…”-button write all selected rows to either the Gap4 database or the experiment files, this depends on status of the checkboxes “DB” and “exp-File”. 9. Exports all selected rows to atext file (“Export to File”) or to a SQLite database (“Export to SQLite Database”). 10. The button “Create Primertable” opens the interface of the Primer3 Module and uses all selected rows in the repeat table as targets. After a run the Primer3 interface will not close. It always keeps the same target information. After changing the repeat selection it is necessary to open a new Primer3 interface by clicking the “Create Primertable”-button again. The primer table nearly equals the repeat table with two differences: 1. There is no “Create Primertable”-button but a “Create Multiplex”-button. This will open the Multiplex Module interface; otherwise the handling of this function is the same. 2. There is no second table list included like for Point 7 in the repeat table but a text field with some additional primer information.
The multiplex table is of the same kind as the primer table, with two differences; there is no “Create Multiplex”-button, but buttons for R-Tree creation.