consensus_index

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

10 rows where inventory_id = 327814

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
923409 923409 327814 327814 39316 3 0.231228348048774
923410 923410 327814 327814 136429 2 0.0840995719542377
923411 923411 327814 327814 150734 1 0.0416184947198669
923412 923412 327814 327814 169020 2 0.291329463039068
923413 923413 327814 327814 183982 1 0.0291329463039069
923414 923414 327814 327814 219272 2 0.118934755247455
923415 923415 327814 327814 240685 1 0.0323699403376743
923416 923416 327814 327814 241017 1 0.0364161828798836
923417 923417 327814 327814 258881 1 0.0582658926078137
923418 923418 327814 327814 277414 2 0.0594673776237274 
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)
);