consensus_index

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

10 rows where inventory_id = 120358

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
355382 355382 120358 120358 15154 2 0.153107856865287
355383 355383 120358 120358 28065 5 0.0981489383723967
355384 355384 120358 120358 98542 4 0.265190587128661
355385 355385 120358 120358 105996 2 0.0382769642163218
355386 355386 120358 120358 150771 1 0.0530381174257322
355387 355387 120358 120358 177813 3 0.13259529356433
355388 355388 120358 120358 183043 2 0.0501163102555459
355389 355389 120358 120358 203368 3 0.0605524439232042
355390 355390 120358 120358 206301 2 0.068471915168018
355391 355391 120358 120358 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)
);