consensus_index

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

15 rows where inchi_id = 20165

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
36599 36599 10936 10936 20165 1 0.170454545454545
41878 41878 12723 12723 20165 1 0.259842519685039
109280 109280 38231 38231 20165 1 0.259842519685039
165653 165653 59347 59347 20165 1 0.253012048192771
335080 335080 112946 112946 20165 1 0.258620689655172
449068 449068 161016 161016 20165 1 0.170454545454545
470925 470925 170526 170526 20165 1 0.131704529927968
472501 472501 171426 171426 20165 7 0.517241379310345
690489 690489 246297 246297 20165 6 0.514285714285714
782820 782820 273685 273685 20165 1 0.253012048192771
782823 782823 273686 273686 20165 1 0.253012048192771
866691 866691 299141 299141 20165 1 0.139211136890951
867866 867866 299437 299437 20165 4 0.506024096385542
949367 949367 340489 340489 20165 1 0.253012048192771
1671496 1671496 507148 507148 20165 1 0.257142857142857 
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)
);