consensus_index

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

12 rows where inchi_id = 138879

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
41166 41166 12471 12471 138879 2 0.183257565625156
99610 99610 35246 35246 138879 2 0.183257565625156
182879 182879 65282 65282 138879 2 0.229168905188733
290415 290415 98362 98362 138879 3 0.348299929946621
457704 457704 164500 164500 138879 3 0.348299929946621
547630 547630 216578 216578 138879 2 0.229168905188733
719341 719341 254322 254322 138879 2 0.183257565625156
824249 824249 286050 286050 138879 1 0.120297944775532
824255 824255 286051 286051 138879 2 0.229168905188733
902049 902049 317693 317693 138879 1 0.236609695454706
1649644 1649644 499564 499564 138879 1 0.219396145094266
1738069 1738069 532395 532395 138879 2 0.183257565625156 
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)
);