home / zeropm-v0-0-4

consensus_index

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

10 rows where inchi_id = 47789

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
117123 117123 40881 40881 47789 8 0.9
237512 237512 80847 80847 47789 8 0.625
246155 246155 83772 83772 47789 1 0.206896551724138
437632 437632 156883 156883 47789 8 0.625
441369 441369 158221 158221 47789 1 0.206896551724138
493068 493068 185904 185904 47789 1 0.247187261273867
543694 543694 215069 215069 47789 1 0.206896551724138
723529 723529 255726 255726 47789 1 0.208695652173913
1624786 1624786 490622 490622 47789 8 0.9
1703105 1703105 520155 520155 47789 1 0.247187261273867
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 2100.488ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website