consensus_index

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

8 rows where inchi_id = 42719

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
127516 127516 45568 45568 42719 1 0.3125
218851 218851 75850 75850 42719 1 0.310344827586207
278398 278398 94407 94407 42719 9 0.56252903221277
428242 428242 154358 154358 42719 1 0.239130434782609
531973 531973 210997 210997 42719 1 0.239130434782609
892182 892182 312959 312959 42719 1 0.3
1613877 1613877 487243 487243 42719 1 0.3125
1644760 1644760 497881 497881 42719 10 0.56868735140123 
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)
);