consensus_index

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

10 rows where inventory_id = 400125

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1202091 1202091 400125 400125 2662 1 0.0362252120391503
1202092 1202092 400125 400125 3331 1 0.0414002423304575
1202093 1202093 400125 400125 3489 8 0.289801696313203
1202094 1202094 400125 400125 3515 1 0.144900848156601
1202095 1202095 400125 400125 3671 1 0.0579603392626406
1202096 1202096 400125 400125 64734 2 0.0683069148874767
1202097 1202097 400125 400125 73277 1 0.0322001884792448
1202098 1202098 400125 400125 123644 1 0.0724504240783007
1202099 1202099 400125 400125 149056 1 0.0966005654377343
1202100 1202100 400125 400125 179137 1 0.144900848156601 
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)
);