Versions Compared

Key

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

Table of Contents

Insert excerpt
EUG:HeaderEUG:
Header
nopaneltrue

titleColumn

View tables

The Table tab has two sections where the Stats and Trait table section allows us to review assess the trait phenotypic data , manage the data like suppressing possible outliers and view the descriptive statistics. It is divided into two sections: The Stats and Trait Table sections.before running the desired analysis.

  1. The Stats section contains the descriptive statistics of all numeric traits of the active occurrence. You The table is shown by default, but you may click the dropdown button ( image-20240605-011621.pngImage Added ) beside the section title to show or hide the table. By default, the table is shown.

Image Removed
Stats and Trait table.gifImage Added

  1. The Trait Table section contains the table with the plot list information and all the trait data collected. You may allows the user to suppress or unsuppress raw data in this section collected per plot, per trait, or per data point.

Image Removed2024-07-15_11-00-32.gifImage Added

  1. Before reviewing your plot trait data, you must first be familiar with the color-coded keys in the Phenotypic Data Manager. These keys group your data depending on their types and whether the collected trait is quality controlled -checked or not. Any changes to the data will be reflected in the trait table. Click on the dropdown menu for the list of keys.

Expand

Column Keys

Cell Keys

  • Quality Controlled - trait data for all plots are checked for quality control

  • Not Quality Controlled - trait data for all plots are for review

Expandtitle
Cell Keys
  • Possible Outliers- trait data

that are
  • identified as outliers based on 1.

5IQR
  • 5 IQR in the trait table. The cell is colored

red
  • orange.

  • Suppressed Data - trait data

that are
  • identified by users as suppressed. The cell is colored gray.

  • Bad Data - trait data

that are
  • identified as invalid. It may be data that do not conform with the set data type or are not within the set range of values.

Data
  • The cell is

written in
  • colored red

font
  • .

  • Missing Data - missing data during collection. The cell is empty and colored blue

Image Removed
image-20240715-030546.pngImage Added

Pin columns

Pinning the first few columns of your Trait Table lets you view the trait data values without scrolling past the main columns such as the plot and entry numbers, germplasm data, and planting arrangement information.

  1. Click the Pin button above the table to freeze the first column. Repeat this step until you pin the needed columns.

2024-07-15_11-10-59.gifImage Added

  1. To undo, click Unpin. Repeat this step until the columns are returned to normal.

2024-07-15_11-14-27.gifImage Added

Sort and filter data

Sort using headers

You may sort your data in either ascending or descending order by clicking the column headers.

Image Removedascending or descending order.gifImage Added

Filter using the search bar

You can filter your data by typing the specific data in the search bar under each header.

Image RemovedFiltering by germ name.gifImage Added

Filter using settings

  1. You may also filter your data by showing only the outliers and/or suppressed data. From the toolbar above the trait table, click the filter icon ((blue star)).

Image Removed

You have the option of clicking image-20240418-092813.pngImage Added

  1. Click Show possible outliers only, Show suppressed data only, or both by clicking the checkbox ((blue star)) above.

Image RemovedImage RemovedImage Removedimage-20240418-092055.pngImage Addedimage-20240418-092321.pngImage Addedimage-20240418-092446.pngImage Added

Filter trait columns

You may also select the trait columns that you want to hide or show in your table.

  1. At Click the Trait(s) dropdown menu from the upper left part of the table, click the Trait(s) dropdown menu.

Image Removedimage-20240418-093351.pngImage Added

  1. Click the trait(s) that you want to view in the table. You may either select between one or more traits, or click the All traits option. Click again on the trait(s) to deselect.

Image Removedimage-20240418-093708.pngImage Added

  1. Once done, click Apply.

Image Removedimage-20240418-093809.pngImage Added

Assign trait data classification

You may now assign a classification

Assign QC code of each trait data

You can change the QC code of your plot trait data individually in the Phenotypic Data Manager. Locate a cell in the trait table and right-click to view the options for trait data classificationall the QC codes. The cell will then change color depending on the classification of data. Click the dropdown menu for the options.

Info

Initially, all trait data have the default QC code of Questionable except those with bad and missing data.

Expand
Trait data classification
titleQC codes

Questionable

Good

Bad

Suppress/Unsuppress

QC code assign.gifImage Added

Info

When you right-click on trait data with the QC code of bad, suppressed, or questionable, the option to change them to Good

Bad

Questionable

Image Removed

Suppress multiple data

or Questionable is disabled if the trait data value follows the data format for that trait. A brief explanation is also provided for your reference.

QC value code to Good or Questionable.gifImage Added

Change QC code by trait

This allows all data under the selected trait column to change into a specific QC code.

  1. From the toolbar, click Edit and select Change QC code by trait.

image-20240419-075349.pngImage Added

  1. Select the trait and the QC code from the modal window to be updated.

image-20240419-075658.pngImage Added

  1. Once done, click Update.

image-20240419-080447.pngImage Added

  1. All data from the selected trait will be updated with the selected QC code and the cells will change color depending on the QC code.

image-20240419-080323.pngImage Added

Suppress multiple trait data

While you can suppress the trait data values individually by changing the QC code, you can also suppress them in bulk. There are three ways of suppressing data in the Phenotypic Data Manager: (1) by suppressing all possible outliers, (2) by suppressing outliers from a trait column, and (3) by suppressing trait data of selected plots.

Suppress all possible outliers

This allows you to suppress all the outliers that were automatically identified in the trait table.

  1. From the toolbar above the trait table, click Edit, then Suppress all possible outliers.

Image RemovedImage Added

  1. A modal window will notify you that you will suppress all the possible outliers. Click Suppress to confirm. When it’s done, the cells with the outliers will change their color to gray.

Image RemovedImage Added

Suppress possible outliers by trait

This allows you to suppress all the outliers from a specific trait column in the table.

  1. From the toolbar above the trait table, click Edit, then Suppress possible outliers by trait.

Image RemovedImage Added

  1. A modal window will notify you that you will suppress all the possible outliers from a of that trait. From there, select the trait where the outliers will be suppressed.

Image RemovedImage Added

  1. Click Suppress to confirm. When it’s done, the cells with the outliers from the selected trait column will change their color to gray.

Image Removedimage-20240419-133525.pngImage Added

Suppress from selected plot

This allows you to suppress all the trait data from a specific plot row in the table.

  1. Tick the checkbox ((blue star)) of the plot(s) where you want to suppress data. From the toolbar above the trait table, click Edit, then Suppress possible outliers by trait.

Image Removedimage-20240419-133324.pngImage Added

  1. All of the data selected will be suppressed and the cells will change their color to gray.

Review trait data

If you need to update your trait data in PDM, either by changing the QC code of a trait data or by updating the data from the Core Breeding domain, you may view these changes in the Phenotypic Data Manager.

Show edit history

Any changes in the QC code of a selected trait data can be viewed by checking its edit history. You must first save all the changes to your trait data before viewing the edit history.

  1. Right-click on the cell with the trait data and select Show edit history.

Image Added

  1. The pop-up message will display the person who changed the trait QC code, the date and time it was updated, and the replaced QC code of the selected trait data.

  2. You may also check previous and recent changes by clicking the arrows in the pop-up window.

Image Added

Review updated data from Core Breeding

Any changes to your trait data from the Core Breeding domain can be checked and updated in the Phenotypic Data Manager.

  1. From the Trait Table toolbar, click the Check for Updates button. If no changes were made to your trait data, the button will change to

    Status
    colourGreen
    titleyou're up to date
    .

Image Added

  1. On the other hand, if the system detects changes in your trait data, the Check for Updates button will change to Update Transaction.

Image Added

  1. After clicking the Update Transaction button, a modal window will appear to notify you that the current transaction will be closed and a new transaction with the updated changes will be reflected in the table. Click Yes to confirm.

Image Added

  1. Once done, the browser will refresh with the new transaction and updated trait data.

Save changes

Once you are done reviewing your trait data, you may finally save it. By saving the changes, the trait data will be marked as good data. There are two ways to do so.

  1. From the toolbar above the trait table, click the save icon ((blue star)).

Image Removed

A modal window will notify you that you will save all the changes done to the plot trait data. Select first image-20240419-133904.pngImage Added

  1. One option is that you can Save your QC changes without selecting traits. This will save the changes without marking the traits as QCed.

image-20241212-002710.pngImage Added

Marking traits as QCed

Another option is to mark trait data columns with at least one (1) good data and no questionable data as quality-checked (QCed).

  1. Select the trait(s) that are done for quality checking. Optionally, write comments on the textbox provided.

Image Removedimage-20241212-002802.pngImage Added

  1. Once done, click Saveto confirm.

Image Removed
Info

By clicking the (blue star) beside Close Transaction, the system will close the transaction without applying the changes previously done. A new transaction will then be made with the most recent trait data from Core Breeding.

Image Removed
  1. The selected traits will be marked as quality checked (QCed) and will save your QC changes, and the questionable data will be set to GOOD.

image-20241212-002836.pngImage Added

  1. After saving, a modal window will

appear notifying
  1. notify you of your successful transaction.

You will then be automatically sent to the Analysis Request Manager.Image Removed
image-20240419-143333.pngImage Added

  1. The column headers of the QCed traits will change to green.

image-20240516-060546.pngImage Added
Note

Traits whose data are all or have a mix of questionable, suppressed, bad, and missing cannot be marked as QCed.

  1. In the Experiment Manager tool, your occurrence will now have the additional status of

    Status
    titletrait data quality checked
    .

Image Removedimage-20240419-143729.pngImage Added

Great job!Your phenotypic data has undergone quality checking and is ready for analysis. If you want to review your data thoroughly, you may proceed with generating data visualizations.