home / zeropm-v0-0-4

consensus_index

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

13 rows where inchi_id = 17900

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
135816 135816 48116 48116 17900 1 0.232558139534884
247443 247443 84217 84217 17900 1 0.187951807228916
247463 247463 84223 84223 17900 1 0.229965156794425
248185 248185 84452 84452 17900 1 0.215038067148844
322683 322683 108703 108703 17900 6 0.615384615384615
438424 438424 157128 157128 17900 1 0.3125
441790 441790 158378 158378 17900 1 0.229965156794425
537495 537495 213266 213266 17900 1 0.232558139534884
729633 729633 257434 257434 17900 1 0.230769230769231
845727 845727 292930 292930 17900 1 0.229965156794425
845731 845731 292931 292931 17900 1 0.230769230769231
1630430 1630430 492715 492715 17900 1 0.230769230769231
1666611 1666611 505355 505355 17900 8 0.625
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 1185.592ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website