consensus_index

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

11 rows where inventory_id = 57644

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
160336 160336 57644 57644 1445 1 0.113388487098885
160337 160337 57644 57644 11826 1 0.037796162366295
160338 160338 57644 57644 23335 1 0.0425206826620819
160339 160339 57644 57644 33878 1 0.0485950658995222
160340 160340 57644 57644 75172 14 0.299300872765269
160341 160341 57644 57644 136854 1 0.0850413653241638
160342 160342 57644 57644 140507 1 0.0566942435494425
160343 160343 57644 57644 170306 1 0.068033092259331
160344 160344 57644 57644 186044 1 0.170082730648328
160345 160345 57644 57644 237767 1 0.0309241328451505
160346 160346 57644 57644 322730 1 0.0340165461296655 
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)
);