User Guide CollectionsImport from a Database to a Collection

Import from a Database to a Collection

How can I import files from a database into a collection?

Create a CSV file

To import a file from a database into a collection, you must first obtain or create a CSV (comma-separated values) file with appropriate formatting.

The file formatting should have the data field names in the top row. For the SnapGene collection, the first data field will be used as the sequence label in Map view, and will also be used as the file name (after removing any forbidden characters).

This file can be created, for example, by exporting from Excel to CSV format. In Excel, click File Save As... , click the Format: menu button, select Comma Separated Values (.csv), then click Save.

Create a New Collection

In SnapGene, click File → New Collection... , name the collection, then click OK.

Import a Database into a Collection

To import a database, click the Import/Export menu button, then choose Import a Database...

The Database Type: can be either DNA or Protein. Click the DNA: menu button to specify "Synthetic DNA" or "Natural DNA". Browse to the database CSV file.

For each data field in the database, a corresponding field in the SnapGene collection can be selected.

If the data field does not need to be imported, the selection can be left at ( None ).

Multiple data fields can be combined in the Description and Comments fields of the SnapGene collection.

Specify the fields, then click Import.

View the Collection

The database entries are shown in the collection. In this example, there was no sequence present for YCplac33, so a placeholder file is shown. To add a DNA sequence to the file, click Add Sequence... .

Add a DNA Sequence to a File

Paste the DNA sequence into the text box, specify the topology, then click OK.

If you wish to add the automatically detected features, click Add [ ] Features.

In this example, the added sequence is shown as an annotated map.

Click the Description Panel check box to show the imported data.