consensus_index

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

11 rows where inchi_id = 87570

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
162625 162625 58246 58246 87570 1 0.0432172833740063
250358 250358 85133 85133 87570 6 0.315789473684211
251203 251203 85350 85350 87570 1 0.307692307692308
271579 271579 92116 92116 87570 5 0.470588235294118
442982 442982 158793 158793 87570 6 0.306390402939431
451183 451183 161901 161901 87570 6 0.384615384615385
875819 875819 302976 302976 87570 3 0.454545454545455
907016 907016 320142 320142 87570 3 0.311688311688312
918214 918214 325509 325509 87570 1 0.3
1631924 1631924 493210 493210 87570 1 0.310344827586207
1728600 1728600 529368 529368 87570 6 0.315789473684211 
CREATE TABLE [consensus_index] (
        [inventory_id] integer,
        [inchi_id] text,
        [consensus_score] text,
        [consensus_count] integer,
        FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);