Use a Template

1. Click on the assay’s name (SugarsPhotometer) in the file tree.

2. Select the “SugarExtraction” table added in the previous step.

3. In the New Table! widget, click Create basic table!.

4. On top of the annotation table open Add Template.

   

5. This will show you all DataPLANT curated templates.

6. To select a template from a different community click .

7. From the dropdown, select “Training” and deselect “DataPLANT”.

8. Click on the template Training - Sugar extraction.

9. Click Import Templates.

10. Configure Import Type to ..With Units and SugarExtraction to Append to active table.

11. You can expand Preview Selected Columns to view all building blocks of the template.

    

    This shows me that the template has an Input, Output as well as two Parameter columns: “Vortex Mixer” and “Temperature”

12. Click Submit to use the template.

    Input [Sample Name]	Parameter [Vortex Mixer]	Parameter [Temperature]	Output [Sample Name]

13. At the bottom of the table, type 5 in the text field and click + to add 6 rows to your table for a total of 6 since one was added automatically.

14. Transfer the sample names of your study’s Output [Sample Name] to the Input [Sample Name] column.

    Input [Sample Name]	Parameter [Vortex Mixer]	Parameter [Temperature]	Output [Sample Name]
    Cold1_leaf
    Cold2_leaf
    Cold3_leaf
    RT1_leaf
    RT2_leaf
    RT3_leaf

    Note

    Select multiple cells by clicking once on the first and the last cell while holding the Shift key. You can copy and paste multiple cells by right-clicking on the selected cells.

15. Add information of the sugar_extraction_protocol.md into the table, e.g.

    Input [Sample Name]	Parameter [Vortex Mixer]	Parameter [Temperature]	Output [Sample Name]
    Cold1_leaf	3 seconds	95 degree celsius
    Cold2_leaf	3 seconds	95 degree celsius
    Cold3_leaf	3 seconds	95 degree celsius
    RT1_leaf	3 seconds	95 degree celsius
    RT2_leaf	3 seconds	95 degree celsius
    RT3_leaf	3 seconds	95 degree celsius

16. Fill the Output [Sample Name] column:

    • Select the six cells from Input, and copy the sample names (right-click -> Copy)
    • Select the cells below Output [Sample Name] and paste the sample names (right-click -> Paste)
    • Right-click a cell in the column Output [Sample Name]. Then select Edit and Update Rows in the opened field to update all rows at once.
    • Type “leaf” in the Regex and “sugar-ext” in the Replacement fields
    • Click Submit

    Input [Sample Name]	Parameter [Vortex Mixer]	Parameter [Temperature]	Output [Sample Name]
    Cold1_leaf	3 seconds	95 degree celsius	Cold1_sugar-ext
    Cold2_leaf	3 seconds	95 degree celsius	Cold2_sugar-ext
    Cold3_leaf	3 seconds	95 degree celsius	Cold3_sugar-ext
    RT1_leaf	3 seconds	95 degree celsius	RT1_sugar-ext
    RT2_leaf	3 seconds	95 degree celsius	RT2_sugar-ext
    RT3_leaf	3 seconds	95 degree celsius	RT3_sugar-ext