consensus_index

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

10 rows where inventory_id = 153001

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
421595 421595 153001 153001 45291 7 0.334695344422135
421596 421596 153001 153001 137375 1 0.167347672211067
421597 421597 153001 153001 165307 1 0.0557825574036891
421598 421598 153001 153001 189150 1 0.0478136206317336
421599 421599 153001 153001 204863 1 0.111565114807378
421600 421600 153001 153001 227359 1 0.066939068884427
421601 421601 153001 153001 243351 1 0.0836738361055337
421602 421602 153001 153001 261964 1 0.0418369180527669
421603 421603 153001 153001 266825 1 0.0371883716024594
421604 421604 153001 153001 308500 1 0.0334695344422135 
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)
);