consensus_index

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

10 rows where inventory_id = 159597

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
445385 445385 159597 159597 101374 3 0.110809711010263
445386 445386 159597 159597 110257 1 0.112161182143498
445387 445387 159597 159597 117513 1 0.0560805910717488
445388 445388 159597 159597 126353 3 0.15618182718062
445389 445389 159597 159597 170772 1 0.0373870607144992
445390 445390 159597 159597 227696 1 0.0560805910717488
445391 445391 159597 159597 235090 1 0.0841208866076232
445392 445392 159597 159597 235270 1 0.0672967092860985
445393 445393 159597 159597 262859 3 0.13643739317181
445394 445394 159597 159597 264289 2 0.0594824493596749 
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)
);