consensus_index

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

22 rows where inchi_id = 56953

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
119720 119720 41670 41670 56953 1 0.0789473684210526
168926 168926 60255 60255 56953 1 0.0789473684210526
168976 168976 60265 60265 56953 6 0.384615384615385
242882 242882 82598 82598 56953 1 0.0595918858855812
243003 243003 82644 82644 56953 6 0.385964912280702
373204 373204 127199 127199 56953 2 0.17559708548124
549645 549645 217336 217336 56953 6 0.385964912280702
549761 549761 217376 217376 56953 1 0.0789473684210526
716891 716891 253558 253558 56953 1 0.0789473684210526
717039 717039 253606 253606 56953 6 0.384615384615385
718996 718996 254221 254221 56953 3 0.187548370370736
820038 820038 284594 284594 56953 1 0.0789473684210526
820044 820044 284595 284595 56953 1 0.0595918858855812
866851 866851 299178 299178 56953 1 0.253012048192771
894979 894979 314181 314181 56953 1 0.0779220779220779
941718 941718 336996 336996 56953 3 0.375
1627485 1627485 491580 491580 56953 1 0.0789473684210526
1627561 1627561 491607 491607 56953 6 0.384615384615385
1689310 1689310 514087 514087 56953 2 0.260869565217391
1726934 1726934 528807 528807 56953 1 0.0789473684210526
1726978 1726978 528823 528823 56953 6 0.384615384615385
1757758 1757758 539004 539004 56953 1 0.258620689655172 
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)
);