consensus_index

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

14 rows where inventory_id = 404547

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1219588 1219588 404547 404547 1639 6 0.237706780119915
1219589 1219589 404547 404547 7040 2 0.237706780119915
1219590 1219590 404547 404547 16464 3 0.0256061866573063
1219591 1219591 404547 404547 43799 3 0.0597394728701535
1219592 1219592 404547 404547 137983 2 0.0233090675066299
1219593 1219593 404547 404547 140143 3 0.0695058841564097
1219594 1219594 404547 404547 140401 3 0.103827999724062
1219595 1219595 404547 404547 159132 3 0.0409219398034297
1219596 1219596 404547 404547 169009 3 0.0512123733146126
1219597 1219597 404547 404547 170702 2 0.034310018372608
1219598 1219598 404547 404547 195795 2 0.0238904302964021
1219599 1219599 404547 404547 208656 1 0.0198088983433263
1219600 1219600 404547 404547 218754 2 0.0396177966866525
1219601 1219601 404547 404547 290984 1 0.0264118644577683 
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)
);