consensus_index

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

9 rows where inventory_id = 1643

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
5471 5471 1643 1643 2836 12 0.287178618065055
5472 5472 1643 1643 14166 2 0.0829013262226822
5473 5473 1643 1643 47700 1 0.0478631030108425
5474 5474 1643 1643 111422 1 0.0717946545162638
5475 5475 1643 1643 161311 1 0.143589309032528
5476 5476 1643 1643 185018 2 0.143589309032528
5477 5477 1643 1643 194218 1 0.0574357236130111
5478 5478 1643 1643 200449 1 0.0574357236130111
5479 5479 1643 1643 212154 1 0.0957262060216851 
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)
);