Child pages
  • Importing Annotations from CSV

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

It is possible to import annotations for a sequence from an annotations table stored in the CSV format.

To import annotations from a CSV file, right-click on a Project View and select Import ‣ Import annotations from CSV. The following dialog box will appear:

HTML
<center>
     <br>
     <img src="/wiki/download/attachments/4227368/Importing Annotations from CSV.png"/>
     <br>
</center>

Basically you need to specify the file to read annotations table from (required):

HTML
<center>
     <br>
     <img src="/wiki/download/attachments/4227368/Importing Annotations from CSV_1.png"/>
     <br>
</center>

And the format of and the path to the file to write the annotations table into (required):

HTML
<center>
     <br>
     <img src="/wiki/download/attachments/4227368/Importing Annotations from CSV_2.png"/>
     <br>
</center>

Check Add result file to project to link the annotations to the currently opened sequence.

HTML
<center>
     <br>
     <img src="/wiki/download/attachments/4227368/Importing Annotations from CSV_3.png"/>
     <br>
</center>

To use a separator to split the table, check the Column separator item and specify the separator symbols. Also you can press Guess to try to detect the separator from the input file.

HTML
<center>
     <br>
     <img src="/wiki/download/attachments/4227368/Importing Annotations from CSV_4.png"/>
     <br>
</center>

Alternatively, you can press Edit and edit the script which will specify the separator for each parsed line. It is possible to use line number in the script.

HTML
<center>
     <br>
     <img src="/wiki/download/attachments/4227368/Importing Annotations from CSV_5.png"/>
     <br>
</center>

Using the arrows, you exclude the necessary number of lines at the beginning of the document from parsing. You can also skip all lines that start with the specified text.

HTML
<center>
     <br>
     <img src="/wiki/download/attachments/4227368/Importing Annotations from CSV_6.png"/>
     <br>
</center>

By pressing Preview one can bring up the view of the current annotations table (which is produced from the input file with the specified parameters values). The input file contents will also be shown at the bottom part of the dialog.

HTML
<center>
     <br>
     <img src="/wiki/download/attachments/4227368/Importing Annotations from CSV_7.png"/>
     <br>
</center>

The preview table headline indicates the types of the information contained in the corresponding columns. By default the values are [ignored]. To specify a column role, click on the corresponding headline element:

HTML
<center>
     <br>
     <img src="/wiki/download/attachments/4227368/Importing Annotations from CSV_8.png"/>
     <br>
</center>

The annotation start and end positions must be specified. It is possible to add an offset to every read start position by checking the Add offset checkbox, and to shorten annotations by one from the end by uncheking the Inclusive checkbox.

When all the roles are specified, press Run. With the Add to project checkbox specified and a Sequence View opened, on success you will see the Sequence View with annotations linked:

HTML
<center>
     <br>
     <img src="/wiki/download/attachments/4227368/Importing Annotations from CSV_9.png"/>
     <br>
</center>