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 = 100088

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
8871 8871 2689 2689 100088 1 0.276923076923077
52733 52733 16402 16402 100088 1 0.276923076923077
160861 160861 57782 57782 100088 1 0.276923076923077
319052 319052 107511 107511 100088 1 0.277777777777778
469653 469653 169906 169906 100088 1 0.277777777777778
576007 576007 225716 225716 100088 1 0.277777777777778
771636 771636 269989 269989 100088 1 0.277777777777778
771640 771640 269990 269990 100088 1 0.272727272727273
771644 771644 269991 269991 100088 1 0.276923076923077
1747441 1747441 535223 535223 100088 1 0.276923076923077
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 949.88ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website