consensus_index

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

22 rows where inchi_id = 101839

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
39436 39436 11907 11907 101839 5 0.381062355658199
99099 99099 35097 35097 101839 5 0.381062355658199
142701 142701 50873 50873 101839 3 0.378151260504202
172537 172537 61597 61597 101839 3 0.152287357293579
278791 278791 94522 94522 101839 6 0.321516900247321
453629 453629 162908 162908 101839 6 0.321516900247321
500604 500604 198731 198731 101839 3 0.311688311688312
500617 500617 198739 198739 101839 1 0.599254417849115
559963 559963 220265 220265 101839 3 0.378151260504202
703860 703860 250629 250629 101839 8 0.35967131081967
800799 800799 279355 279355 101839 3 0.378151260504202
800804 800804 279356 279356 101839 3 0.378151260504202
800809 800809 279357 279357 101839 6 0.382165605095541
1055855 1055855 373256 373256 101839 6 0.382165605095541
1279088 1279088 420777 420777 101839 6 0.382165605095541
1496191 1496191 462959 462959 101839 6 0.382165605095541
1599650 1599650 483213 483213 101839 6 0.382165605095541
1642555 1642555 497084 497084 101839 1 0.115384615384615
1644914 1644914 497934 497934 101839 6 0.382165605095541
1730589 1730589 529990 529990 101839 1 0.165411854621585
1734688 1734688 531367 531367 101839 1 0.115384615384615
1735783 1735783 531740 531740 101839 5 0.381062355658199 
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)
);