consensus_index

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

11 rows where inchi_id = 197818

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
17648 17648 5170 5170 197818 1 0.0789473684210526
119732 119732 41673 41673 197818 1 0.0789473684210526
171635 171635 61238 61238 197818 1 0.0789473684210526
214910 214910 74687 74687 197818 1 0.0626003210272873
730047 730047 257555 257555 197818 1 0.06288532675709
846371 846371 293130 293130 197818 1 0.0626003210272873
846376 846376 293131 293131 197818 1 0.0789473684210526
846382 846382 293132 293132 197818 1 0.0668789808917197
892596 892596 313135 313135 197818 1 0.0779220779220779
1611143 1611143 486341 486341 197818 1 0.0789473684210526
1717124 1717124 525897 525897 197818 1 0.0789473684210526 
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)
);