consensus_index

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

8 rows where inventory_id = 84109

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
247156 247156 84109 84109 21666 4 0.0893675734720557
247157 247157 84109 84109 75229 2 0.268102720416167
247158 247158 84109 84109 121345 5 0.268102720416167
247159 247159 84109 84109 140553 4 0.0633889745461287
247160 247160 84109 84109 155185 1 0.0446837867360279
247161 247161 84109 84109 160666 1 0.0670256801040418
247162 247162 84109 84109 197036 4 0.134051360208084
247163 247163 84109 84109 224210 1 0.0536205440832335 
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)
);