consensus_index

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

9 rows where inchi_id = 159706

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
215819 215819 74952 74952 159706 1 0.0514430841834131
244863 244863 83323 83323 159706 1 0.310344827586207
285328 285328 96687 96687 159706 1 0.0535486396933145
426294 426294 153766 153766 159706 2 0.0450571252366353
456044 456044 163845 163845 159706 1 0.0535486396933145
850747 850747 294322 294322 159706 2 0.0450571252366353
850758 850758 294323 294323 159706 1 0.0512047015794368
951756 951756 341447 341447 159706 1 0.3
1629254 1629254 492255 492255 159706 1 0.239130434782609 
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)
);