consensus_index

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

10 rows where inventory_id = 220430

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
560418 560418 220430 220430 15154 2 0.153107856865287
560419 560419 220430 220430 28065 5 0.0981489383723967
560420 560420 220430 220430 98542 4 0.265190587128661
560421 560421 220430 220430 105996 2 0.0382769642163218
560422 560422 220430 220430 150771 1 0.0530381174257322
560423 560423 220430 220430 177813 3 0.13259529356433
560424 560424 220430 220430 183043 2 0.0501163102555459
560425 560425 220430 220430 203368 3 0.0605524439232042
560426 560426 220430 220430 206301 2 0.068471915168018
560427 560427 220430 220430 294934 1 0.0294656207920734 
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)
);