This document can be used to prepare or evaluate feasibility of ancillary study proposals and paper proposals, but is NOT intended for publication.

Specimen Assays

File NameData as ofPopulationData collectedOne row perRows
spec_tests_ctos_inv.dat6/23/2025N/ABaseline, Main, Ext1, Ext2Specimen Test1,292

This file contains details about the assays referred to in spec_results_ctos_inv.dat. This file has one row for each version of an assay. Assays are assigned version numbers based on variations of lab/specimen type or method. e.g. if the GLUCOSE assay has results from two labs there would be two rows in this file, both rows would have the same TESTABBR, TESTNAME and TESTDESC values but the other columns would vary by version.

TESTVERID - Test version ID
Col 1

Unique identifier of the test name and test version.

NMissingMinMaxMeanStdDev
1,2920137,63819,142.95415,059.687
TESTABBR - Test abbreviation
Col 2
Usage Notes:

e.g. CRP, GLUC.

NMissing
1,2920
TESTVER - Test version
Col 3

A new version number is assigned for every change in lab, specimen type, units or method. e.g. if we have results from two different labs for a glucose assay, each would get its own version number. GLUC V1 & GLUC V2.

NMissingMinMaxMeanStdDev
1,29201442.9024.249
TESTNAME - Test Name
Col 4
NMissing
1,2920
TESTDESC - Test Description
Col 5

Short description of the test.

NMissing
1,2920
TESTMTHD - Test Method
Col 6
Usage Notes:

Some test methods are not available.

NMissing
1,24151
TESTUNITS - Test Units
Col 7
NMissing
1,2920
TESTCMNTS - Test Comments
Col 8
NMissing
599693
SPECTYPE - Specimen Type
Col 9
NMissing
1,2920
LABNAME - Lab Name
Col 10
NMissing
1,2920
VERCOUNT - Number of rows in result file for this test/version
Col 11
NMissingMinMaxMeanStdDev
1,29201243,3722,798.53713,830.359
TESTVALMED - Median of TESTVAL
Col 12

The median of TESTVAL in specimen results file (spec_results) for this test/version.

NMissingMinMaxMeanStdDev
1,2920033,467,50084,054.81,348,681.08
TESTVALSTD - Standard deviation of TESTVAL
Col 13

The standard deviation of TESTVAL in specimen results file (spec_results) for this test/version.

NMissingMinMaxMeanStdDev
1,2920050,174,734.5593,693.9711,693,031.378
NUMDUPPAIRS - Number of blind duplicate pairs
Col 14

Number of blind duplicate pairs used to calculate DUPAVGCV and DUPCORR.

Usage Notes:

See the Specimen Results readme documentation for a discussion of "blinded duplicate" samples used for QC.

NMissingMinMaxMeanStdDev
1,13915331,07592.586137.284
DUPCORR - Coefficient of correlation of blinded duplicates
Col 15

The correlation of result values over ALL duplicate pairs for this test version.

NMissingMinMaxMeanStdDev
1,117175-0.5810.8560.211
DUPAVGCV - Average Coefficient of Variation (%) of duplicate pairs
Col 16
Usage Notes:

Coefficient of Variation (stddev/avg) is calculated for EACH duplicate pair.

NMissingMinMaxMeanStdDev
1,139153077.3914.71713.589
DUPMINCV - Minumum Coefficient of Variation (%) of duplicate pairs
Col 17
Usage Notes:

Coefficient of Variation (stddev/avg) is calculated for EACH duplicate pair.

NMissingMinMaxMeanStdDev
1,139153-552.8627.08-0.68621.168
DUPMAXCV - Maximum Coefficient of Variation (%) of duplicate pairs
Col 18
Usage Notes:

Coefficient of Variation (stddev/avg) is calculated for EACH duplicate pair.

NMissingMinMaxMeanStdDev
1,13915301,495.1763.82863.748