consensus_index

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

12 rows where inchi_id = 200145

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
16887 16887 4935 4935 200145 2 0.0716512454525095
102294 102294 36042 36042 200145 1 0.04396482813749
170979 170979 61001 61001 200145 2 0.0716512454525095
213617 213617 74347 74347 200145 1 0.0416509294400746
424720 424720 153355 153355 200145 1 0.0416509294400746
541354 541354 214369 214369 200145 1 0.0312241522065589
664972 664972 238222 238222 200145 1 0.0416509294400746
726650 726650 256646 256646 200145 2 0.0718341146227959
839436 839436 291117 291117 200145 1 0.04396482813749
839443 839443 291118 291118 200145 2 0.0716512454525095
1610302 1610302 486077 486077 200145 2 0.0716512454525095
1716569 1716569 525685 525685 200145 1 0.041498310448653 
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)
);