consensus_index

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

10 rows where inventory_id = 282323

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
811467 811467 282323 282323 50402 1 0.210386044729865
811468 811468 282323 282323 75177 1 0.0262982555912331
811469 811469 282323 282323 107063 1 0.210386044729865
811470 811470 282323 282323 137613 3 0.0677084976186166
811471 811471 282323 282323 138513 1 0.105193022364933
811472 811472 282323 282323 195482 1 0.0300551492471236
811473 811473 282323 282323 239006 1 0.0525965111824663
811474 811474 282323 282323 255643 2 0.210386044729865
811475 811475 282323 282323 294527 2 0.0495884662985013
811476 811476 282323 282323 329529 1 0.0233762271922072 
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)
);