consensus_index

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

26 rows where inventory_id = 156657

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
436749 436749 156657 156657 24948 1 0.024409390672908
436750 436750 156657 156657 25712 1 0.02034115889409
436751 436751 156657 156657 44609 8 0.24409390672908
436752 436752 156657 156657 136814 2 0.12204695336454
436753 436753 156657 156657 137765 1 0.0128470477225832
436754 436754 156657 156657 138145 2 0.0545810568339717
436755 436755 156657 156657 155131 1 0.024409390672908
436756 436756 156657 156657 169304 2 0.0813646355763601
436757 436757 156657 156657 176162 2 0.0163092101639174
436758 436758 156657 156657 176240 1 0.01356077259606
436759 436759 156657 156657 176441 2 0.0209308798229724
436760 436760 156657 156657 181279 1 0.0221903551571891
436761 436761 156657 156657 189174 1 0.016272927115272
436762 436762 156657 156657 192049 1 0.0152558691705675
436763 436763 156657 156657 192418 2 0.0498254600673964
436764 436764 156657 156657 196013 1 0.02034115889409
436765 436765 156657 156657 196130 2 0.0385946354116298
436766 436766 156657 156657 206702 1 0.0221903551571891
436767 436767 156657 156657 207804 1 0.0187764543637754
436768 436768 156657 156657 208364 2 0.0376645075136315
436769 436769 156657 156657 217159 2 0.0128648784705433
436770 436770 156657 156657 233025 1 0.02712154519212
436771 436771 156657 156657 239276 2 0.0307529416072068
436772 436772 156657 156657 265398 2 0.0180934441564069
436773 436773 156657 156657 278022 1 0.016272927115272
436774 436774 156657 156657 309731 2 0.0135817482815991 
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)
);