It may be useful to export a hierarchy or OTU table for further analysis in a dedicated statistical software package such as SAS or R. To do so, display your data on the Explicet workspace exactly as you wish it to appear in the exported spreadsheet (i.e., check library groupings, choose OTU counts or percentages, OTU Start, OTU Width, OTU Last functions, etc.), then export to a .txt (tab-separated-value) formatted file. The text file can be imported into a variety of programs, including Microsoft Excel, SPSS, R, SAS, JMP, GraphPad, SigmaPlot, etc.
A. Hierarchy Table
File → Export → Hierarchy
- Enter desired hierarchy output file name and location
B. OTU Table
File → Export → OTU
- A new pop-up window will appear
- Choose the export format
Select Entire OTU Name to export the full OTU name, regardless of the current display format.
Select Edited OTU Name to export the abbreviated OTU name exactly as it is displayed in the current workspace.
Choose the OTU Name delimiter (character placed between columns)
To format the export so that it is compatible for use with the program, R, select Export to R.
- Another pop-up window will appear
- Enter desired OTU export file name and location