consensus_index

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

24 rows where inventory_id = 59597

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
166481 166481 59597 59597 17087 5 0.0564494521065963
166482 166482 59597 59597 23743 10 0.11108798426115
166483 166483 59597 59597 102490 16 0.155963411576869
166484 166484 59597 59597 137239 5 0.0333538588144633
166485 166485 59597 59597 139256 2 0.0333538588144633
166486 166486 59597 59597 217831 9 0.0517463072708638
166487 166487 59597 59597 224214 1 0.0153940886835984
166488 166488 59597 59597 229528 10 0.043425913381857
166489 166489 59597 59597 229958 1 0.0500307882216949
166490 166490 59597 59597 230264 12 0.111218311279416
166491 166491 59597 59597 230296 11 0.049896667542921
166492 166492 59597 59597 243187 1 0.020012315288678
166493 166493 59597 59597 255525 2 0.0213331997774024
166494 166494 59597 59597 261919 10 0.0381261741636454
166495 166495 59597 59597 265329 2 0.0118542725026095
166496 166496 59597 59597 277803 4 0.0232511164241927
166497 166497 59597 59597 290054 2 0.0333538588144633
166498 166498 59597 59597 308195 1 0.0153940886835984
166499 166499 59597 59597 308340 4 0.0223154081053906
166500 166500 59597 59597 309079 4 0.021294805895516
166501 166501 59597 59597 309877 4 0.0277932939302385
166502 166502 59597 59597 317905 1 0.0181930138987981
166503 166503 59597 59597 320779 2 0.0161789979898789
166504 166504 59597 59597 326371 4 0.0173649161774471 
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)
);