consensus_index

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

9 rows where inventory_id = 154471

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
428622 428622 154471 154471 61367 2 0.154715127701375
428623 428623 154471 154471 91291 8 0.30943025540275
428624 428624 154471 154471 98073 1 0.0773575638506876
428625 428625 154471 154471 114770 1 0.103143418467583
428626 428626 154471 154471 147582 1 0.103143418467583
428627 428627 154471 154471 186251 1 0.0442043222003929
428628 428628 154471 154471 186252 1 0.0773575638506876
428629 428629 154471 154471 209651 1 0.0618860510805501
428630 428630 154471 154471 222496 1 0.0515717092337917 
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)
);