consensus_index

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

8 rows where inventory_id = 78731

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
229628 229628 78731 78731 13697 9 0.182549422198206
229629 229629 78731 78731 38827 1 0.0388428076430825
229630 229630 78731 78731 47099 2 0.15537123057233
229631 229631 78731 78731 102067 2 0.31074246114466
229632 229632 78731 78731 149876 2 0.0587248052840659
229633 229633 78731 78731 197892 1 0.062148492228932
229634 229634 78731 78731 228711 1 0.103580820381553
229635 229635 78731 78731 263646 2 0.0732427004926622 
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)
);