consensus_index

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

18 rows where inventory_id = 201607

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
503896 503896 201607 201607 19218 2 0.0367648127720184
503897 503897 201607 201607 48434 8 0.275122666563567
503898 503898 201607 201607 63043 1 0.0211632820433513
503899 503899 201607 201607 138104 2 0.137561333281784
503900 503900 201607 201607 169011 1 0.0229268888802973
503901 503901 201607 201607 169213 2 0.0374394527641452
503902 503902 201607 201607 184480 1 0.0275122666563567
503903 503903 201607 201607 196417 1 0.0343903333204459
503904 503904 201607 201607 197064 2 0.0232521092218454
503905 503905 201607 201607 197065 2 0.021418270543464
503906 503906 201607 201607 199635 2 0.0687806666408918
503907 503907 201607 201607 200127 2 0.0917075555211891
503908 503908 201607 201607 207042 2 0.0502302968526127
503909 503909 201607 201607 227561 1 0.0305691851737297
503910 503910 201607 201607 233317 1 0.0229268888802973
503911 503911 201607 201607 238171 2 0.0465042184436908
503912 503912 201607 201607 254347 1 0.0250111515057788
503913 503913 201607 201607 255321 2 0.0190763246411024 
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)
);