consensus_index

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

9 rows where inventory_id = 30787

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
85683 85683 30787 30787 60665 1 0.0890465656846483
85684 85684 30787 30787 84744 3 0.168287463790402
85685 85685 30787 30787 101638 2 0.267139697053945
85686 85686 30787 30787 138255 4 0.164234320931755
85687 85687 30787 30787 264281 1 0.0445232828423241
85688 85688 30787 30787 314165 1 0.053427939410789
85689 85689 30787 30787 317271 1 0.133569848526972
85690 85690 30787 30787 318226 1 0.0333924621317431
85691 85691 30787 30787 334441 1 0.0296821885615494 
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)
);