User's Guide  Rules for Loading OmicSoft Data

Rules for Loading OmicSoft Data

The following rules determine whether OmicSoft data is loaded into tranSMART databases:

Rules for loading data into table BIO_ASSAY_ANALYSIS_DATA

Load the data if one of the following two criteria is satisfied:

■    fold_change_ratio is >= 1.0 OR <=-1.0

AND

preferred_pvalue is null OR <= 0.1

■    fold_change_ratio is null

AND

At least one of the following values is not null:

□    r_value

Pearson product-moment correlation coefficient.

□    rho_value

Spearman rank correlation coefficient

□    cut_value

□    results_value

Rules for loading data into table BIO_ASSAY_ANALYSIS_DATA_TEA

Load the data if:

TEA_NORMALIZED_PVALUE <= 0.05

For information about the TEA algorithm, see Appendix A:  How TEA Scores Are Calculated.