consensus_index

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

28 rows where inchi_id = 83814

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
8219 8219 2487 2487 83814 12 0.417391304347826
18988 18988 5578 5578 83814 8 0.625
97388 97388 34553 34553 83814 8 0.625
156293 156293 56196 56196 83814 2 0.487728457387774
160243 160243 57616 57616 83814 16 0.41958041958042
204934 204934 72626 72626 83814 8 0.413793103448276
216792 216792 75250 75250 83814 8 0.413793103448276
255667 255667 86763 86763 83814 4 0.504859306985452
426879 426879 153951 153951 83814 8 0.413793103448276
444935 444935 159460 159460 83814 3 0.494374522547733
503057 503057 201337 201337 83814 2 0.487728457387774
514653 514653 206463 206463 83814 8 0.413793103448276
514657 514657 206464 206464 83814 8 0.413793103448276
514661 514661 206465 206465 83814 8 0.413793103448276
534434 534434 212088 212088 83814 8 0.413793103448276
583913 583913 228196 228196 83814 3 0.494374522547733
666875 666875 238799 238799 83814 10 0.631578947368421
680585 680585 243155 243155 83814 3 0.494374522547733
733569 733569 258701 258701 83814 8 0.625
853242 853242 295203 295203 83814 8 0.625
853244 853244 295204 295204 83814 8 0.625
853246 853246 295205 295205 83814 6 0.615384615384615
952301 952301 341661 341661 83814 2 0.487728457387774
957413 957413 344262 344262 83814 4 0.6
1612335 1612335 486748 486748 83814 8 0.625
1650674 1650674 499922 499922 83814 1 0.3125
1717802 1717802 526096 526096 83814 4 0.6
1730096 1730096 529837 529837 83814 2 0.487728457387774 
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)
);