consensus_index

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

9 rows where inventory_id = 5031

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
17188 17188 5031 5031 21402 3 0.0697305469328902
17189 17189 5031 5031 51836 3 0.159643100430226
17190 17190 5031 5031 73275 1 0.0328921704282908
17191 17191 5031 5031 74761 4 0.230245192998036
17192 17192 5031 5031 137682 3 0.115122596499018
17193 17193 5031 5031 158446 1 0.057561298249509
17194 17194 5031 5031 169273 1 0.230245192998036
17195 17195 5031 5031 181166 2 0.0469986032144852
17196 17196 5031 5031 266298 1 0.0460490385996072 
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)
);