consensus_index

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

8 rows where inventory_id = 157590

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
439641 439641 157590 157590 16669 2 0.110450297366185
439642 439642 157590 157590 24443 1 0.22090059473237
439643 439643 157590 157590 56075 1 0.22090059473237
439644 439644 157590 157590 119133 1 0.0552251486830926
439645 439645 157590 157590 144537 1 0.0736335315774568
439646 439646 157590 157590 161242 4 0.22090059473237
439647 439647 157590 157590 196243 1 0.0368167657887284
439648 439648 157590 157590 257079 1 0.0441801189464741 
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)
);