Associating data elements with metadata

Once a Metadata Table has been saved, data elements - such as, but not restricted to, sequencing reads - may be associated with its rows if it was not already done during import. Association means that you can keep track of the sample to which a particular analysis result pertains without having to resort to data element naming conventions or an elaborate folder structure.

Each association between a particular data element and a row in your Metadata Table will be qualified by a "role" label that indicates what the role of the data element is with respect to your row. For example, a suitable role for a freshly imported data element would be "Sample data". Each analysis tool will subsequently provide its own role labels when transferring the results to the table. As an example, a read mapping tool will assign the role "Unmapped reads" to the Sequence List it produces, allowing you to keep track of which Sequence List contained the original imported NGS reads, and which contained the unmapped ones.

To associate read- and metadata automatically: Click Associate Data (Image add_array_annotations_16_h_p) and select Associate Data Automatically. When using the Associate Data Automatically option, you will be able to select the read files you would like to associate with the metadata (figure 9.4).

Image associate_meta
Figure 9.4: When using the Associate Data Automatically option, the wizard will search among the selected elements (47 in this example) and select the ones with names identical with the Key identifier (here 14).

The role assignment for this association is set by the wizard to "Sample data" (figure 9.5) but can be edited to fit your needs.

Image associate_rolemeta
Figure 9.5: Specify the role label for freshly imported data elements.

Sometimes, more data elements correspond to a specific metadata key, or the names of the elements do not match the metadata key value. In these cases, you must associate a given metadata role to one or more data elements manually: Click Associate Data and select Associate Data with row (Image add_array_annotations_16_h_p), or right click on the row you would like to process. The wizard is the same than the one described above, the difference being that you can only create one association at a time.

When you are done with associating sequencing data and metadata, you can open the sequencing file and check the icon Show Element Info (Image element_info_16_n_p) to get a process log that indicates the association between Metadata Table rows and data was successful (figure 9.6).

Image showelementinfo
Figure 9.6: The Show Element Info button displays association between the element and the metadata.

Tips when using Metadata Tables: