consensus_index

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

17 rows where inchi_id = 58687

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
2543 2543 687 687 58687 9 0.628571428571429
185899 185899 66304 66304 58687 12 0.483870967741935
198415 198415 70536 70536 58687 9 0.628571428571429
211716 211716 74118 74118 58687 8 0.478260869565217
381475 381475 130535 130535 58687 1 0.112
423564 423564 153232 153232 58687 8 0.478260869565217
512013 512013 205994 205994 58687 8 0.478260869565217
512016 512016 205995 205995 58687 4 0.6
548540 548540 216826 216826 58687 8 0.478260869565217
663916 663916 237951 237951 58687 8 0.625
718552 718552 254112 254112 58687 12 0.483870967741935
822597 822597 285643 285643 58687 8 0.625
822599 822599 285644 285644 58687 8 0.478260869565217
937553 937553 334913 334913 58687 4 0.6
1609266 1609266 485944 485944 58687 8 0.625
1696492 1696492 517130 517130 58687 1 0.113636363636364
1715739 1715739 525563 525563 58687 4 0.6 
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)
);