home / zeropm-v0-0-4

consensus_index

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

17 rows where inchi_id = 208438

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
14942 14942 4687 4687 208438 1 0.115384615384615
100233 100233 35432 35432 208438 1 0.115384615384615
195480 195480 69293 69293 208438 1 0.115384615384615
208394 208394 73695 73695 208438 1 0.0939759036144578
421739 421739 153026 153026 208438 2 0.0766948956626504
511224 511224 205861 205861 208438 2 0.0766948956626504
511240 511240 205862 205862 208438 1 0.114503816793893
558383 558383 219828 219828 208438 1 0.115384615384615
662791 662791 237644 237644 208438 1 0.112123870625725
707178 707178 251231 251231 208438 1 0.0919354838709677
804600 804600 280427 280427 208438 1 0.113207547169811
804606 804606 280428 280428 208438 2 0.0766948956626504
804622 804622 280429 280429 208438 1 0.115384615384615
804626 804626 280430 280430 208438 1 0.114982578397213
926689 926689 329569 329569 208438 1 0.113207547169811
1607766 1607766 485707 485707 208438 1 0.115384615384615
1714398 1714398 525343 525343 208438 1 0.113207547169811
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 1396.309ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website