home / zeropm-v0-0-4

consensus_index

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

11 rows where inchi_id = 198636

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
54443 54443 16991 16991 198636 1 0.0791075050709939
92732 92732 33015 33015 198636 1 0.0791075050709939
139648 139648 49744 49744 198636 2 0.144420131291028
235990 235990 80461 80461 198636 1 0.157894736842105
325688 325688 109755 109755 198636 1 0.0625
472403 472403 171365 171365 198636 1 0.0787589498806683
558301 558301 219809 219809 198636 1 0.170984455958549
573140 573140 224590 224590 198636 1 0.0625
776156 776156 271470 271470 198636 1 0.0779220779220779
803668 803668 280187 280187 198636 1 0.157894736842105
1668035 1668035 505873 505873 198636 1 0.0789473684210526
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 869.093ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website