consensus_index

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

10 rows where inventory_id = 282324

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
811477 811477 282324 282324 50402 1 0.210386044729865
811478 811478 282324 282324 75177 1 0.0262982555912331
811479 811479 282324 282324 107063 1 0.210386044729865
811480 811480 282324 282324 137613 3 0.0677084976186166
811481 811481 282324 282324 138513 1 0.105193022364933
811482 811482 282324 282324 195482 1 0.0300551492471236
811483 811483 282324 282324 239006 1 0.0525965111824663
811484 811484 282324 282324 255643 2 0.210386044729865
811485 811485 282324 282324 294527 2 0.0495884662985013
811486 811486 282324 282324 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)
);