consensus_index

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

12 rows where inchi_id = 34364

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
20200 20200 5938 5938 34364 1 0.0751494473436015
98703 98703 34970 34970 34364 1 0.0751494473436015
129154 129154 46055 46055 34364 1 0.0751494473436015
272236 272236 92354 92354 34364 6 0.615384615384615
451458 451458 162013 162013 34364 6 0.615384615384615
515757 515757 206734 206734 34364 1 0.0751494473436015
531482 531482 210806 210806 34364 1 0.0751494473436015
736524 736524 259761 259761 34364 1 0.0748214417892569
859209 859209 297227 297227 34364 1 0.0751494473436015
892514 892514 313099 313099 34364 4 0.833333333333333
1614086 1614086 487318 487318 34364 1 0.0751494473436015
1718711 1718711 526385 526385 34364 1 0.0751494473436015 
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)
);