consensus_index

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

16 rows where inventory_id = 116542

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
345023 345023 116542 116542 33810 6 0.247631953675839
345024 345024 116542 116542 84307 1 0.0412719922793064
345025 345025 116542 116542 120043 4 0.142970375114698
345026 345026 116542 116542 137050 2 0.0353759933822626
345027 345027 116542 116542 137648 1 0.0619079884189596
345028 345028 116542 116542 157221 4 0.123815976837919
345029 345029 116542 116542 204371 1 0.0619079884189596
345030 345030 116542 116542 227568 1 0.0206359961396532
345031 345031 116542 116542 227621 1 0.0247631953675839
345032 345032 116542 116542 240519 2 0.0369147921213503
345033 345033 116542 116542 243352 1 0.0495263907351677
345034 345034 116542 116542 259329 2 0.0357425937786746
345035 345035 116542 116542 274450 2 0.0505476608761938
345036 345036 116542 116542 289540 1 0.0225119957887126
345037 345037 116542 116542 320632 1 0.0190486118212184
345038 345038 116542 116542 329511 1 0.0176879966911313 
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)
);