consensus_index

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

12 rows where inventory_id = 218968

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
555483 555483 218968 218968 49228 11 0.250288095700607
555484 555484 218968 218968 136649 3 0.167926754104336
555485 555485 218968 218968 138976 1 0.0888557020396093
555486 555486 218968 218968 150413 1 0.0888557020396093
555487 555487 218968 218968 181016 1 0.066641776529707
555488 555488 218968 218968 216724 1 0.066641776529707
555489 555489 218968 218968 232810 1 0.0533134212237656
555490 555490 218968 218968 237296 1 0.0533134212237656
555491 555491 218968 218968 257218 2 0.0444278510198046
555492 555492 218968 218968 317108 1 0.0380810151598326
555493 555493 218968 218968 317828 1 0.0333208882648535
555494 555494 218968 218968 320651 1 0.0380810151598326 
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)
);