consensus_index

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

12 rows where inventory_id = 201769

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
504375 504375 201769 201769 38540 1 0.030540732847168
504376 504376 201769 201769 53067 1 0.03817591605896
504377 504377 201769 201769 90404 7 0.30540732847168
504378 504378 201769 201769 127672 2 0.0719851976621307
504379 504379 201769 201769 136376 2 0.15270366423584
504380 504380 201769 201769 141132 2 0.0471253738861532
504381 504381 201769 201769 153697 1 0.0763518321179199
504382 504382 201769 201769 210103 2 0.061081465694336
504383 504383 201769 201769 218895 1 0.0436296183530971
504384 504384 201769 201769 226122 2 0.0881635016528044
504385 504385 201769 201769 239038 1 0.0339341476079644
504386 504386 201769 201769 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)
);