consensus_index

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

10 rows where inventory_id = 214153

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
540483 540483 214153 214153 1136 1 0.063736130105328
540484 540484 214153 214153 27941 1 0.042490753403552
540485 540485 214153 214153 40965 1 0.0509889040842624
540486 540486 214153 214153 41722 3 0.254944520421312
540487 540487 214153 214153 57857 1 0.0849815068071039
540488 540488 214153 214153 74059 11 0.211031162967401
540489 540489 214153 214153 77228 1 0.0849815068071039
540490 540490 214153 214153 84592 1 0.0364206457744731
540491 540491 214153 214153 180106 1 0.031868065052664
540492 540492 214153 214153 192464 1 0.127472260210656 
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)
);