consensus_index

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

8 rows where inventory_id = 50782

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
142498 142498 50782 50782 6834 16 0.363067447964596
142499 142499 50782 50782 12515 2 0.12836372724193
142500 142500 50782 50782 176383 1 0.0518667782806565
142501 142501 50782 50782 210363 2 0.0485169285204962
142502 142502 50782 50782 210364 2 0.0811843494066204
142503 142503 50782 50782 210620 3 0.133755191443255
142504 142504 50782 50782 245536 2 0.121022482654865
142505 142505 50782 50782 266906 2 0.0605112413274326 
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)
);