consensus_index

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

11 rows where inventory_id = 452743

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1457827 1457827 452743 452743 6853 8 0.269183846720376
1457828 1457828 452743 452743 14046 1 0.089727948906792
1457829 1457829 452743 452743 20780 1 0.0538367693440752
1457830 1457830 452743 452743 33838 1 0.067295961680094
1457831 1457831 452743 452743 56726 1 0.134591923360188
1457832 1457832 452743 452743 73217 1 0.044863974453396
1457833 1457833 452743 452743 73274 1 0.134591923360188
1457834 1457834 452743 452743 136515 1 0.089727948906792
1457835 1457835 452743 452743 138569 1 0.038454835245768
1457836 1457836 452743 452743 139053 1 0.033647980840047
1457837 1457837 452743 452743 167433 1 0.029909316302264 
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)
);