consensus_index

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

8 rows where inventory_id = 215019

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
543541 543541 215019 215019 610 1 0.074805666874285
543542 543542 215019 215019 24229 7 0.27101305083633
543543 543543 215019 215019 68382 2 0.0997408891657134
543544 543544 215019 215019 84981 1 0.0498704445828567
543545 543545 215019 215019 118610 2 0.211582377271955
543546 543546 215019 215019 142755 1 0.14961133374857
543547 543547 215019 215019 159447 1 0.059844533499428
543548 543548 215019 215019 220144 2 0.0669082224932422 
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)
);