consensus_index

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

15 rows where inchi_id = 142017

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
32989 32989 9737 9737 142017 1 0.192307692307692
92815 92815 33039 33039 142017 1 0.192307692307692
181384 181384 64803 64803 142017 1 0.1875
254384 254384 86434 86434 142017 1 0.191489361702128
588876 588876 229923 229923 142017 2 0.380952380952381
677207 677207 241961 241961 142017 1 0.192307692307692
752856 752856 264569 264569 142017 1 0.192307692307692
752859 752859 264570 264570 142017 1 0.189189189189189
903448 903448 318438 318438 142017 1 0.1875
999483 999483 358129 358129 142017 4 0.382978723404255
1210580 1210580 402544 402544 142017 4 0.382978723404255
1454054 1454054 451623 451623 142017 4 0.382978723404255
1592149 1592149 480599 480599 142017 4 0.382978723404255
1633355 1633355 493748 493748 142017 1 0.192307692307692
1657115 1657115 502138 502138 142017 4 0.382978723404255 
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)
);