consensus_index

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

10 rows where inventory_id = 4742

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15371 15371 4742 4742 24229 1 0.0558971287418964
15372 15372 4742 4742 39957 1 0.0670765544902757
15373 15373 4742 4742 51342 9 0.270172392258864
15374 15374 4742 4742 56959 1 0.0558971287418964
15375 15375 4742 4742 56960 1 0.0670765544902757
15376 15376 4742 4742 68374 1 0.0419228465564223
15377 15377 4742 4742 68382 2 0.167691386225689
15378 15378 4742 4742 84981 1 0.0838456931128447
15379 15379 4742 4742 173564 2 0.111794257483793
15380 15380 4742 4742 178059 2 0.0633813864229794 
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)
);