consensus_index

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

13 rows where inventory_id = 73722

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
208601 208601 73722 73722 10441 2 0.132595775053876
208602 208602 73722 73722 13103 2 0.0441985916846252
208603 208603 73722 73722 45249 1 0.0530383100215503
208604 208604 73722 73722 46101 1 0.0883971833692504
208605 208605 73722 73722 46102 8 0.265191550107751
208606 208606 73722 73722 46104 1 0.0530383100215503
208607 208607 73722 73722 102568 1 0.0441985916846252
208608 208608 73722 73722 128066 1 0.0441985916846252
208609 208609 73722 73722 175323 1 0.0883971833692504
208610 208610 73722 73722 202710 1 0.0662978875269378
208611 208611 73722 73722 219158 1 0.0378845071582502
208612 208612 73722 73722 220503 1 0.0378845071582502
208613 208613 73722 73722 231997 1 0.0331489437634689 
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)
);