consensus_index

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

8 rows where inventory_id = 199913

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
501696 501696 199913 199913 101374 2 0.109905940911985
501697 501697 199913 199913 110257 1 0.13707679188789
501698 501698 199913 199913 117513 1 0.0685383959439448
501699 501699 199913 199913 126353 2 0.130042463014387
501700 501700 199913 199913 170772 1 0.0456922639626299
501701 501701 199913 199913 235090 1 0.102807593915917
501702 501702 199913 199913 262859 2 0.183907814879348
501703 501703 199913 199913 264289 1 0.0514037969579586 
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)
);