consensus_index

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

11 rows where inventory_id = 215092

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
543754 543754 215092 215092 67879 2 0.0789940205690451
543755 543755 215092 215092 106068 1 0.0296227577133919
543756 543756 215092 215092 127890 1 0.236982061707135
543757 543757 215092 215092 229247 3 0.236982061707135
543758 543758 215092 215092 229267 3 0.0692939752069919
543759 543759 215092 215092 230460 3 0.103511449800143
543760 543760 215092 215092 238971 3 0.0480457589543412
543761 543761 215092 215092 243933 3 0.0666261373114509
543762 543762 215092 215092 251977 3 0.0375187729645831
543763 543763 215092 215092 289277 1 0.0592455154267838
543764 543764 215092 215092 294698 1 0.0236982061707135 
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)
);