consensus_index

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

12 rows where inchi_id = 43571

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
39684 39684 11999 11999 43571 8 0.519685039370079
145567 145567 51903 51903 43571 1 0.095569271061135
164649 164649 58937 58937 43571 8 0.519685039370079
279760 279760 94880 94880 43571 6 0.514285714285714
301156 301156 101946 101946 43571 1 0.310344827586207
559616 559616 220137 220137 43571 6 0.514285714285714
1056031 1056031 373348 373348 43571 8 0.519685039370079
1279324 1279324 420894 420894 43571 8 0.519685039370079
1496342 1496342 463038 463038 43571 8 0.519685039370079
1599735 1599735 483253 483253 43571 8 0.519685039370079
1645323 1645323 498101 498101 43571 8 0.519685039370079
1735964 1735964 531798 531798 43571 8 0.519685039370079 
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)
);