consensus_index

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

10 rows where inventory_id = 294242

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
850454 850454 294242 294242 11653 1 0.0387945964669207
850455 850455 294242 294242 73583 4 0.193972982334603
850456 850456 294242 294242 79094 1 0.193972982334603
850457 850457 294242 294242 96928 2 0.0969864911673017
850458 850458 294242 294242 97260 1 0.0484932455836509
850459 850459 294242 294242 108808 1 0.0277104260478005
850460 850460 294242 294242 126851 1 0.0323288303891006
850461 850461 294242 294242 149235 1 0.0646576607782011
850462 850462 294242 294242 275648 1 0.0969864911673017
850463 850463 294242 294242 315970 2 0.193972982334603 
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)
);