home / zeropm-v0-0-4

consensus_index

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

16 rows where inchi_id = 199706

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
41771 41771 12682 12682 199706 2 0.230769230769231
113606 113606 39669 39669 199706 2 0.230769230769231
190353 190353 67849 67849 199706 4 0.202486678507993
190877 190877 67947 67947 199706 1 0.0824862824262822
329985 329985 111230 111230 199706 1 0.230769230769231
474006 474006 172275 172275 199706 2 0.124418405225718
528564 528564 209975 209975 199706 1 0.230769230769231
528568 528568 209976 209976 199706 2 0.200956937799043
571342 571342 223952 223952 199706 1 0.227848101265823
692159 692159 246854 246854 199706 2 0.232558139534884
778956 778956 272395 272395 199706 2 0.231454005934718
778960 778960 272396 272396 199706 1 0.229965156794425
778964 778964 272397 272397 199706 2 0.230769230769231
945018 945018 338476 338476 199706 1 0.226415094339623
1669558 1669558 506430 506430 199706 2 0.230769230769231
1749648 1749648 535940 535940 199706 2 0.124418405225718
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 550.533ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website