consensus_index

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

16 rows where inventory_id = 249977

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
701829 701829 249977 249977 4327 5 0.0924156811222376
701830 701830 249977 249977 38655 4 0.0936185496985363
701831 701831 249977 249977 106246 7 0.245263055167046
701832 701832 249977 249977 186681 2 0.0494396959904255
701833 701833 249977 249977 195027 5 0.080452523258359
701834 701834 249977 249977 206181 3 0.0628453414147194
701835 701835 249977 249977 207106 1 0.0386846239002197
701836 701836 249977 249977 215557 5 0.112724526968421
701837 701837 249977 249977 231887 1 0.0338490459126922
701838 701838 249977 249977 238749 1 0.0225660306084615
701839 701839 249977 249977 243309 2 0.0319131865354126
701840 701840 249977 249977 255552 2 0.0285440217887254
701841 701841 249977 249977 263104 2 0.0200724657219307
701842 701842 249977 249977 271716 2 0.0365136353581585
701843 701843 249977 249977 309981 2 0.0226447953526816
701844 701844 249977 249977 320827 1 0.0225660306084615 
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)
);