consensus_index

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

9 rows where inventory_id = 47198

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
132899 132899 47198 47198 75291 3 0.217804689413165
132900 132900 47198 47198 91483 2 0.0628747980317269
132901 132901 47198 47198 108010 4 0.165495775518385
132902 132902 47198 47198 110197 1 0.0435609378826331
132903 132903 47198 47198 229181 2 0.036815711991472
132904 132904 47198 47198 229661 4 0.217804689413165
132905 132905 47198 47198 230545 4 0.129507443165547
132906 132906 47198 47198 248132 1 0.0726015631377218
132907 132907 47198 47198 296632 2 0.0444591960539687 
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)
);