consensus_index

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

8 rows where inventory_id = 497843

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1644658 1644658 497843 497843 42423 2 0.247259905464389
1644659 1644659 497843 497843 62872 1 0.0353228436377698
1644660 1644660 497843 497843 111771 3 0.144598469905342
1644661 1644661 497843 497843 191105 4 0.247259905464389
1644662 1644662 497843 497843 231154 1 0.123629952732194
1644663 1644663 497843 497843 248132 1 0.0618149763660971
1644664 1644664 497843 497843 295316 1 0.0824199684881295
1644665 1644665 497843 497843 307739 1 0.0412099842440647 
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)
);