consensus_index

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

10 rows where inventory_id = 422883

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1286605 1286605 422883 422883 33708 1 0.0327404153108245
1286606 1286606 422883 422883 49796 8 0.327404153108245
1286607 1286607 422883 422883 183577 2 0.163702076554122
1286608 1286608 422883 422883 202639 1 0.065480830621649
1286609 1286609 422883 422883 203897 1 0.0545673588513742
1286610 1286610 422883 422883 204190 1 0.0818510382770612
1286611 1286611 422883 422883 204498 1 0.109134717702748
1286612 1286612 422883 422883 243281 1 0.0409255191385306
1286613 1286613 422883 422883 245046 2 0.071445443545783
1286614 1286614 422883 422883 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)
);