consensus_index

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

10 rows where inventory_id = 125382

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
368607 368607 125382 125382 54783 2 0.0898483696117538
368608 368608 125382 125382 54784 6 0.254129565724106
368609 368609 125382 125382 128299 2 0.254129565724106
368610 368610 125382 125382 149569 2 0.0733608865899276
368611 368611 125382 125382 190163 2 0.10374796076319
368612 368612 125382 125382 195881 1 0.0508259131448211
368613 368613 125382 125382 204939 1 0.0423549276206843
368614 368614 125382 125382 204940 1 0.0363042236748722
368615 368615 125382 125382 205048 1 0.0317661957155132
368616 368616 125382 125382 288145 1 0.0508259131448211 
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)
);