consensus_index

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

8 rows where inventory_id = 81000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
238027 238027 81000 81000 48564 3 0.196035211405621
238028 238028 81000 81000 48571 2 0.0602121054186869
238029 238029 81000 81000 54478 1 0.0445274524456695
238030 238030 81000 81000 125054 8 0.29954380113555
238031 238031 81000 81000 157516 1 0.0712439239130712
238032 238032 81000 81000 213669 1 0.118739873188452
238033 238033 81000 81000 215513 1 0.089054904891339
238034 238034 81000 81000 332902 2 0.102831746623342 
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)
);