Table 3 Metadata SQL query results
From: Investigation into the annotation of protocol sequencing steps in the sequence read archive
Table | Field | Total records (in table) | Annotation record counts | |||
|---|---|---|---|---|---|---|
Fragmentation | Adapter ligation | Enrichment | All steps | |||
Study | study_abstract | 29,598 | 376 (1.27%) | 138 (0.47%) | 941 (3.18%) | 12 (0.04%) |
Study | study_description | 292 (0.98%) | 136 (0.51%) | 488 (1.65%) | 53 (0.18%) | |
Sample | description | 480,222 | 1,632 (0.34%) | 896 (0.19%) | 2159 (0.45%) | 653 (0.14%) |
Experiment | design_description | 419,620 | 11,705 (2.79%) | 6,382 (1.53%) | 16,779 (4.00%) | 2,691 (0.64%) |
Experiment | library_selection | 1,493 (0.36%) | 0 (0%) | 0 (0%) | 0 (0%) | |
Experiment | library_construction_protocol | 29,799 (7.10%) | 24,486 (5.84%) | 31,782 (7.57%) | 17,021 (4.06%) | |
Experiment | experiment_attribute | 422 (0.10%) | 1,026 (0.24%) | 2,814 (0.67%) | 129 (0.03%) | |