consensus_index

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

9 rows where inventory_id = 6186

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
20971 20971 6186 6186 61367 2 0.154715127701375
20972 20972 6186 6186 91291 8 0.30943025540275
20973 20973 6186 6186 98073 1 0.0773575638506876
20974 20974 6186 6186 114770 1 0.103143418467583
20975 20975 6186 6186 147582 1 0.103143418467583
20976 20976 6186 6186 186251 1 0.0442043222003929
20977 20977 6186 6186 186252 1 0.0773575638506876
20978 20978 6186 6186 209651 1 0.0618860510805501
20979 20979 6186 6186 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)
);