consensus_index

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

13 rows where inventory_id = 78471

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
228313 228313 78471 78471 11224 9 0.284713257702043
228314 228314 78471 78471 14168 1 0.0321677854387385
228315 228315 78471 78471 14462 2 0.160838927193693
228316 228316 78471 78471 24835 1 0.0804194635968464
228317 228317 78471 78471 57453 1 0.0268064878656155
228318 228318 78471 78471 77644 1 0.107225951462462
228319 228319 78471 78471 98444 1 0.0357419838208206
228320 228320 78471 78471 129530 1 0.0402097317984232
228321 228321 78471 78471 201553 1 0.0292434413079441
228322 228322 78471 78471 203436 1 0.0643355708774771
228323 228323 78471 78471 204617 1 0.0536129757312309
228324 228324 78471 78471 205137 1 0.0459539791981979
228325 228325 78471 78471 322717 1 0.0247444503374912 
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)
);