consensus_index

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

11 rows where inchi_id = 42664

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27878 27878 8089 8089 42664 1 0.192307692307692
87289 87289 31248 31248 42664 1 0.192307692307692
173708 173708 62055 62055 42664 1 0.192307692307692
233372 233372 79797 79797 42664 8 0.461538461538462
234394 234394 80054 80054 42664 1 0.191489361702128
559317 559317 220053 220053 42664 1 0.191489361702128
802033 802033 279737 279737 42664 1 0.192307692307692
802036 802036 279738 279738 42664 1 0.1875
896592 896592 314985 314985 42664 1 0.1875
1623540 1623540 490266 490266 42664 1 0.192307692307692
1724677 1724677 528126 528126 42664 1 0.192307692307692 
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)
);