consensus_index

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

11 rows where inventory_id = 216367

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
547045 547045 216367 216367 14240 2 0.147929941404374
547046 547046 216367 216367 33027 1 0.0591719765617495
547047 547047 216367 216367 45992 1 0.0369824853510935
547048 547048 216367 216367 61368 9 0.295859882808748
547049 547049 216367 216367 94018 1 0.0591719765617495
547050 547050 216367 216367 97121 1 0.0493099804681246
547051 547051 216367 216367 148742 1 0.0739649707021869
547052 547052 216367 216367 168950 1 0.0422656975441068
547053 547053 216367 216367 171974 1 0.0739649707021869
547054 547054 216367 216367 176709 2 0.0986199609362492
547055 547055 216367 216367 318196 1 0.0493099804681246 
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)
);