consensus_index

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

10 rows where inventory_id = 283820

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
817378 817378 283820 283820 25712 4 0.321350940158597
817379 817379 283820 283820 155131 1 0.0459072771655138
817380 817380 283820 283820 174493 1 0.0803377350396492
817381 817381 283820 283820 176679 1 0.0357056600176219
817382 817382 283820 283820 181279 1 0.160675470079298
817383 817383 283820 283820 232351 1 0.0535584900264328
817384 817384 283820 283820 238516 2 0.101620089913764
817385 817385 283820 283820 272753 1 0.107116980052866
817386 817386 283820 283820 310007 1 0.0401688675198246
817387 817387 283820 283820 327208 1 0.0321350940158597 
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)
);