PGS Documentation

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The preferred method for importing a generic data spreadsheet into Partek ® Genomics Suite ® is as a text file. Here, we illustrate importing a list of genes with p-value and fold-change from an experiment comparing two conditions. 

...

The File Type section of the Import dialog includes a preview of the text file and import options (Figure 1). 

 


Numbered figure captions
SubtitleTextImport .txt, .tsv, or .csv file dialog
AnchorNameImport .txt, .tsv, or .csv file dialog

...

The next step is to identify where the data starts and where the optional header is found using Identify Column Labels, Start of Data (Figure 3). The line that contains the header (if present) must precede the data. If there are lines to be skipped in the file (like comments), they may only appear at the top of the file, before the header line or data begin.

 


Numbered figure captions
SubtitleTextIdentifying column labels and start of data
AnchorNameIdentifying Column Labels and Start of Data

...

  • If the text does not appear properly, use the Specify the text encoding: drop-down menu to choose the correct encoding 

 


Numbered figure captions
SubtitleTextPreviewing text encoding
AnchorNamePreviewing text encoding

...

The final section of the Import .txt, .tsv, or .csv File dialog is Verify Type & Attribute of Data Columns (Figure 5). While data column type and attribute can be modified after import, it is easier and faster to select the proper options during import as multiple columns may be selected during this dialog.  

 


Numbered figure captions
SubtitleTextVerifying type and attribute of data columns. While individual column types and attributes can be modified after import, this dialog allows multiple columns to be selected and modified simultaneously.
AnchorNameVerifying Type and Attribute of Data Columns

...

If Genomic data was selected in the Data Type section, the Configure Genomic Properties dialog will open (Figure 6). These options will be discussed in the next section when we add an annotation file.  


Numbered figure captions
SubtitleTextMany types of genomic data can be imported into Partek Genomics Suite using the text data file importer. This dialog allows these files to be associated with an annotation file and reference genome.
AnchorNameConfigure Genomic Properties of Spreadsheet

...

Image Added


  • Select OK 

The imported spreadsheet will open (Figure 7). 

 


Numbered figure captions
SubtitleTextAn imported .txt data file spreadsheet
AnchorNameImported .txt file

 


Page Turner
button-linkstrue
 


Additional assistance


 

Rate Macro
allowUsersfalse

...