consensus_index

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

11 rows where inventory_id = 242597

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
678423 678423 242597 242597 29326 4 0.178697348813674
678424 678424 242597 242597 144875 4 0.218858661490821
678425 678425 242597 242597 152452 1 0.0343903208136824
678426 678426 242597 242597 169311 1 0.0281375352111947
678427 678427 242597 242597 171962 4 0.126358107126207
678428 678428 242597 242597 199544 1 0.0773782218307854
678429 678429 242597 242597 201097 1 0.0619025774646284
678430 678430 242597 242597 203217 1 0.0386891109153927
678431 678431 242597 242597 203872 1 0.0309512887323142
678432 678432 242597 242597 204110 1 0.0515854812205236
678433 678433 242597 242597 204294 1 0.0442161267604488 
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)
);