consensus_index

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

15 rows where inchi_id = 36840

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
59922 59922 19021 19021 36840 8 0.9
87644 87644 31362 31362 36840 8 0.9
163430 163430 58505 58505 36840 8 0.9
349025 349025 117918 117918 36840 6 0.875
507034 507034 202772 202772 36840 6 0.875
562872 562872 221247 221247 36840 4 0.833333333333333
596627 596627 233019 233019 36840 1 0.599254417849115
700681 700681 249631 249631 36840 8 0.9
795563 795563 277620 277620 36840 4 0.833333333333333
795564 795564 277621 277621 36840 8 0.9
795565 795565 277622 277622 36840 4 0.833333333333333
893759 893759 313640 313640 36840 4 0.833333333333333
1677922 1677922 509553 509553 36840 8 0.9
1753894 1753894 537382 537382 36840 8 0.9
1763612 1763612 542111 542111 36840 5 0.608695652173913 
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)
);