consensus_index

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

10 rows where inventory_id = 334874

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
937459 937459 334874 334874 32364 4 0.334695344422135
937460 937460 334874 334874 144849 2 0.167347672211067
937461 937461 334874 334874 165946 1 0.0557825574036891
937462 937462 334874 334874 198250 1 0.0478136206317336
937463 937463 334874 334874 198251 1 0.0418369180527669
937464 937464 334874 334874 198252 1 0.0371883716024594
937465 937465 334874 334874 198253 1 0.0334695344422135
937466 937466 334874 334874 218159 2 0.111565114807378
937467 937467 334874 334874 231793 2 0.0836738361055337
937468 937468 334874 334874 259420 1 0.066939068884427 
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)
);