consensus_index

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

10 rows where inventory_id = 278536

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
798458 798458 278536 278536 38348 1 0.0542323166801622
798459 798459 278536 278536 39929 8 0.325393900080974
798460 798460 278536 278536 172061 4 0.162696950040487
798461 798461 278536 278536 197608 2 0.0594085263829771
798462 798462 278536 278536 208916 2 0.0575220583259986
798463 798463 278536 278536 208917 2 0.0727602880044831
798464 798464 278536 278536 208918 3 0.0914826148060755
798465 798465 278536 278536 245421 1 0.0361548777867748
798466 798466 278536 278536 245457 1 0.0813484750202434
798467 798467 278536 278536 260868 1 0.0464848428687105 
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)
);