consensus_index

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

12 rows where inventory_id = 509721

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1678392 1678392 509721 509721 37783 5 0.155485129220176
1678393 1678393 509721 509721 129218 2 0.235671386205031
1678394 1678394 509721 509721 192689 3 0.0785571287350104
1678395 1678395 509721 509721 193636 3 0.235671386205031
1678396 1678396 509721 509721 196765 2 0.0445377056451693
1678397 1678397 509721 509721 197573 3 0.0546944837305659
1678398 1678398 509721 509721 228315 2 0.0251226541817162
1678399 1678399 509721 509721 233993 3 0.0392785643675052
1678400 1678400 509721 509721 234314 1 0.0235671386205031
1678401 1678401 509721 509721 249637 3 0.0421334970499572
1678402 1678402 509721 509721 287900 1 0.0261857095783368
1678403 1678403 509721 509721 320196 2 0.0314929136801896 
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)
);