home / zeropm-v0-0-4

consensus_index

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

8 rows where inchi_id = 47116

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
28716 28716 8307 8307 47116 5 0.256467844159969
124946 124946 43287 43287 47116 1 0.0857880472569301
184648 184648 65938 65938 47116 4 0.308741336223061
236989 236989 80741 80741 47116 8 0.238965739352905
256341 256341 86958 86958 47116 1 0.0595944616393379
556956 556956 219403 219403 47116 8 0.238965739352905
708298 708298 251469 251469 47116 6 0.309332690949632
1624644 1624644 490590 490590 47116 6 0.309332690949632
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 763.742ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website