consensus_index

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

16 rows where inventory_id = 42305

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
121699 121699 42305 42305 4082 1 0.0181600739178219
121700 121700 42305 42305 119555 6 0.254241034849507
121701 121701 42305 42305 167912 1 0.0508482069699013
121702 121702 42305 42305 188050 1 0.0211867529041255
121703 121703 42305 42305 192603 3 0.0769977699946653
121704 121704 42305 42305 193513 1 0.0254241034849507
121705 121705 42305 42305 199455 2 0.0293572259818823
121706 121706 42305 42305 201331 1 0.0847470116165022
121707 121707 42305 42305 212213 2 0.0480470393771072
121708 121708 42305 42305 212214 1 0.0317801293561883
121709 121709 42305 42305 218318 1 0.0158900646780942
121710 121710 42305 42305 230866 2 0.0312949080477542
121711 121711 42305 42305 247521 1 0.127120517424753
121712 121712 42305 42305 256712 1 0.0282490038721674
121713 121713 42305 42305 258451 2 0.0898877798989857
121714 121714 42305 42305 267222 1 0.0195570026807313 
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)
);