consensus_index

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

12 rows where inventory_id = 2785

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
9174 9174 2785 2785 24115 1 0.112687813021703
9175 9175 2785 2785 28386 1 0.0375626043405676
9176 9176 2785 2785 40056 1 0.0751252086811352
9177 9177 2785 2785 60355 1 0.0751252086811352
9178 9178 2785 2785 63045 15 0.225375626043406
9179 9179 2785 2785 63046 1 0.112687813021703
9180 9180 2785 2785 73287 1 0.0563439065108514
9181 9181 2785 2785 149358 1 0.0450751252086811
9182 9182 2785 2785 204346 1 0.0563439065108514
9183 9183 2785 2785 225875 1 0.0375626043405676
9184 9184 2785 2785 225876 1 0.0450751252086811
9185 9185 2785 2785 262240 1 0.112687813021703 
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)
);