consensus_index

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

9 rows where inventory_id = 104198

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
308353 308353 104198 104198 8697 1 0.261846438403814
308354 308354 104198 104198 44524 2 0.130923219201907
308355 308355 104198 104198 99479 5 0.261846438403814
308356 308356 104198 104198 102176 1 0.0374066340576877
308357 308357 104198 104198 143039 2 0.0755885558493933
308358 308358 104198 104198 168123 1 0.0523692876807628
308359 308359 104198 104198 201873 1 0.0327308048004767
308360 308360 104198 104198 219389 1 0.0436410730673023
308361 308361 104198 104198 219448 1 0.0872821461346046 
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)
);