consensus_index

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

10 rows where inventory_id = 52398

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
146557 146557 52398 52398 46097 9 0.274594154434817
146558 146558 52398 52398 57065 2 0.127954428549291
146559 146559 52398 52398 106356 1 0.0402121973822458
146560 146560 52398 52398 136413 1 0.180954888220106
146561 146561 52398 52398 140820 2 0.120636592146737
146562 146562 52398 52398 149684 1 0.0723819552880424
146563 146563 52398 52398 169069 1 0.051701396634316
146564 146564 52398 52398 172093 1 0.032900888767292
146565 146565 52398 52398 237459 1 0.0452387220550265
146566 146566 52398 52398 247645 1 0.0361909776440212 
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)
);