consensus_index

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

10 rows where inventory_id = 422868

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1286455 1286455 422868 422868 33708 1 0.0327404153108245
1286456 1286456 422868 422868 49796 8 0.327404153108245
1286457 1286457 422868 422868 183577 2 0.163702076554122
1286458 1286458 422868 422868 202639 1 0.065480830621649
1286459 1286459 422868 422868 203897 1 0.0545673588513742
1286460 1286460 422868 422868 204190 1 0.0818510382770612
1286461 1286461 422868 422868 204498 1 0.109134717702748
1286462 1286462 422868 422868 243281 1 0.0409255191385306
1286463 1286463 422868 422868 245046 2 0.071445443545783
1286464 1286464 422868 422868 259649 1 0.0363782392342494 
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)
);