consensus_index

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

9 rows where inventory_id = 101360

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
299742 299742 101360 101360 168968 4 0.310191855702645
299743 299743 101360 101360 169062 1 0.044313122243235
299744 299744 101360 101360 169168 1 0.0387739819628307
299745 299745 101360 101360 170091 3 0.103397285234215
299746 299746 101360 101360 205290 1 0.0620383711405291
299747 299747 101360 101360 205650 1 0.0516986426171075
299748 299748 101360 101360 240095 4 0.155095927851323
299749 299749 101360 101360 259964 2 0.0462406716945281
299750 299750 101360 101360 329361 2 0.0775479639256613 
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)
);