consensus_index

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

12 rows where inventory_id = 85231

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
250684 250684 85231 85231 38540 1 0.030540732847168
250685 250685 85231 85231 53067 1 0.03817591605896
250686 250686 85231 85231 90404 7 0.30540732847168
250687 250687 85231 85231 127672 2 0.0719851976621307
250688 250688 85231 85231 136376 2 0.15270366423584
250689 250689 85231 85231 141132 2 0.0471253738861532
250690 250690 85231 85231 153697 1 0.0763518321179199
250691 250691 85231 85231 210103 2 0.061081465694336
250692 250692 85231 85231 218895 1 0.0436296183530971
250693 250693 85231 85231 226122 2 0.0881635016528044
250694 250694 85231 85231 239038 1 0.0339341476079644
250695 250695 85231 85231 255314 1 0.03817591605896 
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)
);