Table 1 Summary of entry numbers in a data extraction session.
From: A new workflow for the effective curation of membrane permeability data from open ADME information
Step | Table 1 | Table 2 | Joining columns (Join mode) | Retained entries |
|---|---|---|---|---|
1 | Activities | Assays | assay_id (Full outer join) | 22,689 |
2 | Combined activities and assays | Docs | doc_id (Inner join) | 22,614 |
3 | Combined activities, assays, and docs | Molecule_dictionary | molregno (Inner join) | 16,847 |
4 | Combined activities, assays, docs, and molecule_dictionary | Compound_property | molregno (Inner join) | 16,847 |
5 | Combined activities, assays, docs, molecule_dictionary, and compound_properties | Compound_records | molregno (Inner join) | 16,847 |
6 | Combined activities, assays, docs, molecule_dictionary, compound_properties, and compound_records | Compound_structures | molregno (Inner join) | 16,845 |