consensus_index

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

10 rows where inventory_id = 422893

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1286705 1286705 422893 422893 33708 1 0.0327404153108245
1286706 1286706 422893 422893 49796 8 0.327404153108245
1286707 1286707 422893 422893 183577 2 0.163702076554122
1286708 1286708 422893 422893 202639 1 0.065480830621649
1286709 1286709 422893 422893 203897 1 0.0545673588513742
1286710 1286710 422893 422893 204190 1 0.0818510382770612
1286711 1286711 422893 422893 204498 1 0.109134717702748
1286712 1286712 422893 422893 243281 1 0.0409255191385306
1286713 1286713 422893 422893 245046 2 0.071445443545783
1286714 1286714 422893 422893 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)
);