consensus_index

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

27 rows where inchi_id = 123736

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
3151 3151 892 892 123736 1 0.194388532736563
11536 11536 3495 3495 123736 6 0.328479786395503
47358 47358 14580 14580 123736 6 0.328479786395503
162108 162108 58148 58148 123736 2 0.148106847650427
162117 162117 58150 58150 123736 17 0.317122949759061
199815 199815 71060 71060 123736 1 0.198652198248155
462226 462226 166042 166042 123736 1 0.180070216802505
501107 501107 199240 199240 123736 1 0.203389830508475
526706 526706 209534 209534 123736 6 0.328479786395503
526713 526713 209535 209535 123736 6 0.328479786395503
526997 526997 209595 209595 123736 1 0.18675180672245
527001 527001 209596 209596 123736 1 0.180070216802505
527005 527005 209597 209597 123736 1 0.180070216802505
595316 595316 231869 231869 123736 1 0.198652198248155
597236 597236 235349 235349 123736 1 0.198652198248155
669022 669022 239679 239679 123736 6 0.328479786395503
737648 737648 260076 260076 123736 6 0.333726456702504
737656 737656 260077 260077 123736 6 0.328479786395503
739296 739296 260525 260525 123736 1 0.18675180672245
739300 739300 260526 260526 123736 1 0.198652198248155
739304 739304 260527 260527 123736 1 0.128026989255776
928413 928413 330215 330215 123736 3 0.341182832449025
967876 967876 351302 351302 123736 6 0.328479786395503
1177769 1177769 395201 395201 123736 6 0.328479786395503
1433434 1433434 446872 446872 123736 6 0.328479786395503
1589290 1589290 479760 479760 123736 6 0.328479786395503
1741908 1741908 533559 533559 123736 3 0.341182832449025 
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)
);