consensus_index

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

17 rows where inchi_id = 142052

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
20081 20081 5898 5898 142052 1 0.170984455958549
87278 87278 31244 31244 142052 1 0.170984455958549
153840 153840 55294 55294 142052 1 0.170984455958549
218966 218966 75893 75893 142052 1 0.169811320754717
308028 308028 104082 104082 142052 2 0.0831232694161428
428332 428332 154387 154387 142052 1 0.169811320754717
736332 736332 259698 259698 142052 1 0.170984455958549
858724 858724 297069 297069 142052 1 0.168
858728 858728 297070 297070 142052 1 0.170984455958549
858732 858732 297071 297071 142052 1 0.168
858737 858737 297072 297072 142052 1 0.146616541353383
911020 911020 321779 321779 142052 1 0.0589198036006547
927832 927832 330030 330030 142052 1 0.168
1613956 1613956 487272 487272 142052 1 0.170984455958549
1659990 1659990 503093 503093 142052 2 0.0911059369260208
1718614 1718614 526353 526353 142052 1 0.170984455958549
1744946 1744946 534469 534469 142052 1 0.0589198036006547 
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)
);