consensus_index

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

10 rows where inventory_id = 235465

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
597660 597660 235465 235465 2654 9 0.233867533923977
597661 597661 235465 235465 46275 1 0.0389779223206629
597662 597662 235465 235465 46716 2 0.0826846595685097
597663 597663 235465 235465 63957 2 0.116933766961989
597664 597664 235465 235465 97081 3 0.233867533923977
597665 597665 235465 235465 171547 1 0.0334096477034254
597666 597666 235465 235465 188174 1 0.0779558446413258
597667 597667 235465 235465 204461 1 0.0779558446413258
597668 597668 235465 235465 247836 2 0.0426981745994224
597669 597669 235465 235465 266982 2 0.0522943703584252 
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)
);