consensus_index

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

14 rows where inventory_id = 284145

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
818455 818455 284145 284145 23211 3 0.140843323148127
818456 818456 284145 284145 25577 1 0.0256078769360232
818457 818457 284145 284145 40200 1 0.0469477743827091
818458 818458 284145 284145 45721 2 0.0938955487654183
818459 818459 284145 284145 52187 1 0.0312985162551394
818460 818460 284145 284145 53643 1 0.0704216615740637
818461 818461 284145 284145 55053 8 0.281686646296255
818462 818462 284145 284145 126623 1 0.0234738871913546
818463 818463 284145 284145 145498 1 0.0352108307870319
818464 818464 284145 284145 169556 1 0.056337329259251
818465 818465 284145 284145 188277 2 0.0629870489472365
818466 818466 284145 284145 189704 1 0.0402409494708936
818467 818467 284145 284145 235244 1 0.0469477743827091
818468 818468 284145 284145 266916 2 0.0336679938520742 
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)
);