consensus_index

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

14 rows where inventory_id = 485687

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1607621 1607621 485687 485687 38590 1 0.029819785205624
1607622 1607622 485687 485687 45276 6 0.212531267319285
1607623 1607623 485687 485687 136872 1 0.119279140822496
1607624 1607624 485687 485687 170036 1 0.0596395704112479
1607625 1607625 485687 485687 189096 1 0.0795194272149972
1607626 1607626 485687 485687 192423 2 0.238558281644992
1607627 1607627 485687 485687 195566 1 0.0238558281644992
1607628 1607628 485687 485687 199646 1 0.0216871165131811
1607629 1607629 485687 485687 208866 2 0.0520576849188938
1607630 1607630 485687 485687 255455 1 0.0265064757383324
1607631 1607631 485687 485687 259588 1 0.0477116563289984
1607632 1607632 485687 485687 310078 1 0.0198798568037493
1607633 1607633 485687 485687 323953 1 0.0397597136074986
1607634 1607634 485687 485687 334581 1 0.0183506370496148 
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)
);