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 = 107342

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
318585 318585 107342 107342 14980 4 0.193621211823696
318586 318586 107342 107342 92907 1 0.0482552071865233
318587 318587 107342 107342 117431 1 0.072382810779785
318588 318588 107342 107342 120707 1 0.14476562155957
318589 318589 107342 107342 124127 2 0.28953124311914
318590 318590 107342 107342 133059 1 0.0413616061598771
318591 318591 107342 107342 190940 1 0.0965104143730466
318592 318592 107342 107342 230767 1 0.0361914053898925
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 965.027ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website