consensus_index

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

11 rows where inventory_id = 242627

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
678568 678568 242627 242627 7155 6 0.257367617379255
678569 678569 242627 242627 137682 5 0.0829230761440738
678570 678570 242627 242627 140144 3 0.0540438131162354
678571 678571 242627 242627 153721 1 0.0321709521724068
678572 678572 242627 242627 161528 5 0.112025762141846
678573 678573 242627 242627 169273 5 0.0514735234758509
678574 678574 242627 242627 169302 2 0.0397126855333809
678575 678575 242627 242627 173345 6 0.112415661399122
678576 678576 242627 242627 196518 5 0.179855470518251
678577 678577 242627 242627 207923 2 0.0397126855333809
678578 678578 242627 242627 266298 1 0.0321709521724068 
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)
);