consensus_index

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

14 rows where inventory_id = 404550

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1219630 1219630 404550 404550 1639 6 0.237706780119915
1219631 1219631 404550 404550 7040 2 0.237706780119915
1219632 1219632 404550 404550 16464 3 0.0256061866573063
1219633 1219633 404550 404550 43799 3 0.0597394728701535
1219634 1219634 404550 404550 137983 2 0.0233090675066299
1219635 1219635 404550 404550 140143 3 0.0695058841564097
1219636 1219636 404550 404550 140401 3 0.103827999724062
1219637 1219637 404550 404550 159132 3 0.0409219398034297
1219638 1219638 404550 404550 169009 3 0.0512123733146126
1219639 1219639 404550 404550 170702 2 0.034310018372608
1219640 1219640 404550 404550 195795 2 0.0238904302964021
1219641 1219641 404550 404550 208656 1 0.0198088983433263
1219642 1219642 404550 404550 218754 2 0.0396177966866525
1219643 1219643 404550 404550 290984 1 0.0264118644577683 
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)
);