consensus_index

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

15 rows where inchi_id = 120257

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
17412 17412 5099 5099 120257 1 0.461538461538462
119750 119750 41680 41680 120257 2 0.473684210526316
156701 156701 56367 56367 120257 3 0.48
214566 214566 74598 74598 120257 1 0.466666666666667
416310 416310 147982 147982 120257 1 0.255869106996094
425375 425375 153527 153527 120257 1 0.466666666666667
497559 497559 190640 190640 120257 1 0.255869106996094
537711 537711 213335 213335 120257 2 0.473684210526316
729587 729587 257420 257420 120257 2 0.473684210526316
845585 845585 292889 292889 120257 1 0.466666666666667
845587 845587 292890 292890 120257 1 0.454545454545455
845589 845589 292891 292891 120257 2 0.473684210526316
947711 947711 339741 339741 120257 1 0.454545454545455
1610891 1610891 486263 486263 120257 2 0.473684210526316
1716972 1716972 525835 525835 120257 1 0.461538461538462 
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)
);