consensus_index

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

17 rows where inchi_id = 14899

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
2143 2143 573 573 14899 1 0.113636363636364
58337 58337 18400 18400 14899 1 0.116522265181425
120090 120090 41802 41802 14899 1 0.121931073218957
131432 131432 46665 46665 14899 1 0.121360075362878
134839 134839 47785 47785 14899 9 0.388888888888889
201461 201461 71488 71488 14899 1 0.113636363636364
341740 341740 115328 115328 14899 1 0.109606118893908
469403 469403 169791 169791 14899 5 0.382978723404255
478847 478847 174926 174926 14899 1 0.116522265181425
524442 524442 209018 209018 14899 1 0.113636363636364
566068 566068 222270 222270 14899 1 0.0908343260411018
687164 687164 245068 245068 14899 6 0.384615384615385
697133 697133 248519 248519 14899 1 0.123027060665595
771386 771386 269886 269886 14899 6 0.384615384615385
927515 927515 329896 329896 14899 1 0.116522265181425
1747295 1747295 535171 535171 14899 6 0.384615384615385
1752569 1752569 536910 536910 14899 1 0.116522265181425 
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)
);