consensus_index

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

8 rows where inventory_id = 83587

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
245650 245650 83587 83587 13330 2 0.200413432654611
245651 245651 83587 83587 58699 2 0.115708749292357
245652 245652 83587 83587 61475 1 0.0801653730618444
245653 245653 83587 83587 63226 10 0.312635792802348
245654 245654 83587 83587 143544 1 0.066804477551537
245655 245655 83587 83587 185989 1 0.066804477551537
245656 245656 83587 83587 197326 1 0.0801653730618444
245657 245657 83587 83587 202204 1 0.0572609807584603 
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)
);