consensus_index

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

10 rows where inventory_id = 422871

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1286485 1286485 422871 422871 33708 1 0.0327404153108245
1286486 1286486 422871 422871 49796 8 0.327404153108245
1286487 1286487 422871 422871 183577 2 0.163702076554122
1286488 1286488 422871 422871 202639 1 0.065480830621649
1286489 1286489 422871 422871 203897 1 0.0545673588513742
1286490 1286490 422871 422871 204190 1 0.0818510382770612
1286491 1286491 422871 422871 204498 1 0.109134717702748
1286492 1286492 422871 422871 243281 1 0.0409255191385306
1286493 1286493 422871 422871 245046 2 0.071445443545783
1286494 1286494 422871 422871 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)
);