consensus_index

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

8 rows where inventory_id = 249660

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
700762 700762 249660 249660 35931 1 0.0692729898772949
700763 700763 249660 249660 36992 10 0.323169924889557
700764 700764 249660 249660 171861 5 0.194302968583184
700765 700765 249660 249660 201538 2 0.0865912373466186
700766 700766 249660 249660 261027 2 0.0632372986360357
700767 700767 249660 249660 261322 4 0.141402898463631
700768 700768 249660 249660 287946 2 0.0534452719997834
700769 700769 249660 249660 307704 3 0.0570319118910139 
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)
);