consensus_index

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

12 rows where inventory_id = 69354

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
195630 195630 69354 69354 26599 5 0.0985215430179526
195631 195631 69354 69354 32134 1 0.0430013648800919
195632 195632 69354 69354 45934 6 0.251473507353505
195633 195633 69354 69354 136234 2 0.0370096822321743
195634 195634 69354 69354 169043 2 0.0574629909089133
195635 195635 69354 69354 210285 2 0.215006824400459
195636 195636 69354 69354 219581 1 0.0330779729846861
195637 195637 69354 69354 275077 2 0.0716689414668198
195638 195638 69354 69354 277583 1 0.0358344707334099
195639 195639 69354 69354 287282 1 0.0477792943112132
195640 195640 69354 69354 288641 2 0.036342786487543
195641 195641 69354 69354 289245 2 0.0574629909089133 
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)
);