consensus_index

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

9 rows where inventory_id = 245827

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
689355 689355 245827 245827 18316 3 0.153411872452381
689356 689356 245827 245827 102293 2 0.0657062177017495
689357 689357 245827 245827 117440 1 0.055753574523632
689358 689358 245827 245827 181557 3 0.27876787261816
689359 689359 245827 245827 223522 1 0.0398239818025943
689360 689360 245827 245827 227943 1 0.06969196815454
689361 689361 245827 245827 253305 1 0.0929226242060533
689362 689362 245827 245827 287389 1 0.13938393630908
689363 689363 245827 245827 329577 1 0.03484598407727 
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)
);