home / zeropm-v0-0-4

consensus_index

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

8 rows where inventory_id = 79712

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
233111 233111 79712 79712 41722 8 0.316921335597057
233112 233112 79712 79712 46393 1 0.0792303338992643
233113 233113 79712 79712 119280 1 0.0633842671194114
233114 233114 79712 79712 140661 1 0.0528202225995095
233115 233115 79712 79712 178525 1 0.0452744765138653
233116 233116 79712 79712 215809 1 0.105640445199019
233117 233117 79712 79712 225111 1 0.158460667798529
233118 233118 79712 79712 265626 1 0.158460667798529
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)
);
Powered by Datasette · Queries took 826.982ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website