For new projects, a sample table can be automatically created from a tab-delimited text file. There are several advantages of creating a sample table in this manner:
- You can define multiple samples and attributes even before data has been imported, and therefore you can:
- customize the name of your samples (and not use the automatic sample names generated based on file names)
- import sample sheets as defined by the instrument that generated your data
- You can simultaneously create the sample table and import data, which allows you to:
- combine several files into one sample
- import data located in multiple subdirectories
Selection of the Text File
The text file must be created outside of Partek® Flow® (you can use software such as Partek® Genomics Suite®, Microsoft® Excel® or any text editor). A valid text file is a tab-delimited text file that contains one sample per row and columns containing sample information. At least one column must have unique entries and will be suggested as Sample IDs. Additional columns may contain numeric or categorical attributes and (optional) filenames. Examples of text files are shown in Figures 3, X, Y, Z.
To select the text file, create a new project and in the blank Data Tab (no samples have been imported yet), click the Assign sample attributes from a file button (Figure 1).
Figure 1. A New project with no samples in the Data Tab
Navigate to the file using the browser as shown in in Figure 2. The text file may be located in either the Partek Flow server, My computer, or from a URL. However, if you wish to create the sample table and start importing the data at the same time, (explained later in this section), the text file must be on the Partek Flow server.
Check the box next to the text file that you want to use and click Next.
Figure 2. Locating a text file that contains sample information
Creating a Sample Table without Data Import
Text files that contain only sample information and attributes such as the one shown in Figure 3 can be imported to create a sample table with no associated files. For this type of import, the text file may be located in either the Partek Flow server, My computer, or from a URL (Figure 2).
Figure 3. Text with Attributes
The text file will be summarized as in Figure 4. The first two columns show the headers and example terms parsed from the text file in Figure 3. The suggested attribute names can be renamed before import. Columns that contain unique entries are recognized as possible Sample IDs and can be selected using the radio button. You can choose which attributes to be included and, if applicable, whether they are numeric or categorical. The Show/hide file preview link allows you to preview the text of the tab delimited text file you are using.
In the example in Figure 4, the columns for "Sample name" and "Freezer Location" are both unique and the former is selected as the Sample ID. The "Freezer location" has been deselected and it will not be included in the resulting Sample table. Since "Age" has all number terms, the Attribute type column for it is a drop down menu to choose between Numeric and Categorical. There are no filenames in the text file so the Files column is empty.
Figure 4. Selecting the attributes and Sample ID
Click Import and the table will be created (Figure 5). Click Show data files to expand the table and associate files. For more details see the Adding samples section.
Figure 5. Sample Table created from a Text File with Attributes
Creating a Sample Table with Data Import
Currently, filenames should be separated by tabs (if in a table, each file should be in a different column... maximum one file per column)
A feature of creating the sample ability to combine this step with data import ... the additional feature of importing samples during table creation (described below) are currently only available if the text file is in the Partek Flow Server.
can only be at the same time as creating the sample table) can only be performed if
a sample table that also includes the locations of filenames can only be based on the sample table (as described later in this section)
The text file must be in the server or a folder that is readable by the partek flow server. the text file contains filenames
A valid text file:
TABLE TEXT FILE NO PATH
useful if there are many files for one sample, You can add as many columns as you want on the right
Flow recognizes sees that some columns in your text file are filenames of
FIGURE OF NAVIGATION... SHOW THAT THE DATA IS IN THE SAME DIRECTORY MYDATA
FIGURE WITH FILENAMES
FIGURE RESULTING TABLE
FIGURE IMPORT task
FIGURE EXPANDED TABLE
In the example above, the text file and Data files are in the same directory. If your samples are in different subdirectories, YOU CAN USE PATHS. RELATIVE OR ABSOLUTE
Relative path
FIGURE NAVIGATION... SHOW THAT THE DATA IS DIFFERENT DIRECTORY THAN MY DATA
TABLE RELATIVE PATH
Relative to the text file
Absolute path
FIGURE NAVIGATION SHOW THAT THE DATA IS IN DIFFERENT DIRECTORY AND the directory structure starts with /home/directory....
TABLE ABSOLUTE PATH
you must write the path this way
For a short video of using a text file, please see. the
Note that this can only be done on a blank project... once you have any import
Issue with Pairing KB-6392 reopened
Additional Assistance
If you need additional assistance, please visit our support page to submit a help ticket or find phone numbers for regional support.
| Your Rating: |
|
Results: |
|
0 | rates |
Overview
Content Tools