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.dat5/28/2024N/ABaseline, Main, Ext1, Ext2Specimen Test1,250

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,2500136,17018,528.82614,926.585
TESTABBR - Test abbreviation
Col 2
Usage Notes:

e.g. CRP, GLUC.

NMissing
1,2500
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,25001352.773.794
TESTNAME - Test Name
Col 4
NMissing
1,2500
TESTDESC - Test Description
Col 5

Short description of the test.

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

Some test methods are not available.

NMissing
1,22426
TESTUNITS - Test Units
Col 7
NMissing
1,2500
TESTCMNTS - Test Comments
Col 8
NMissing
590660
SPECTYPE - Specimen Type
Col 9
NMissing
1,2500
LABNAME - Lab Name
Col 10
NMissing
1,2500
VERCOUNT - Number of rows in result file for this test/version
Col 11
NMissingMinMaxMeanStdDev
1,25001243,3722,740.65914,054.349
TESTVALMED - Median of TESTVAL
Col 12

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

NMissingMinMaxMeanStdDev
1,2500033,467,50086,877.841,371,080.099
TESTVALSTD - Standard deviation of TESTVAL
Col 13

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

NMissingMinMaxMeanStdDev
1,2500050,174,734.5596,841.6091,721,173.109
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,12612431,07591.194137.415
DUPCORR - Coefficient of correlation of blinded duplicates
Col 15

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

NMissingMinMaxMeanStdDev
1,104146-0.5810.8550.212
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,126124077.3914.82113.621
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,126124-552.8627.08-0.69421.29
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,12612401,495.1763.92863.958