consensus_index

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

10 rows where inventory_id = 87455

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
258321 258321 87455 87455 14002 3 0.2096845850566
258322 258322 87455 87455 56057 1 0.0554755884833936
258323 258323 87455 87455 92485 2 0.078454329613844
258324 258324 87455 87455 102567 8 0.249604935378043
258325 258325 87455 87455 136700 1 0.0475505044143374
258326 258326 87455 87455 209568 3 0.132093011275641
258327 258327 87455 87455 210018 2 0.0444794240216831
258328 258328 87455 87455 226436 2 0.0640576918886804
258329 258329 87455 87455 238707 1 0.0665707061800724
258330 258330 87455 87455 264506 2 0.039227164806922 
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)
);