consensus_index

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

24 rows where inchi_id = 19135

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
33326 33326 9828 9828 19135 1 0.262293328370693
54192 54192 16905 16905 19135 10 0.645246644871712
122086 122086 42412 42412 19135 10 0.645246644871712
139578 139578 49724 49724 19135 1 0.0343286019064275
171157 171157 61046 61046 19135 11 0.440062265016279
324537 324537 109350 109350 19135 11 0.440062265016279
471977 471977 171116 171116 19135 11 0.440062265016279
502481 502481 200812 200812 19135 5 0.446766195981321
573620 573620 224780 224780 19135 11 0.440062265016279
680082 680082 243005 243005 19135 2 0.262583341711862
689861 689861 245995 245995 19135 1 0.0365736712628984
689870 689870 245996 245996 19135 10 0.645246644871712
775399 775399 271182 271182 19135 1 0.0351408305811212
775414 775414 271185 271185 19135 11 0.440062265016279
775417 775417 271186 271186 19135 10 0.645246644871712
930804 930804 331404 331404 19135 1 0.268328287620752
947212 947212 339504 339504 19135 6 0.606729399800907
1039269 1039269 368243 368243 19135 10 0.645246644871712
1259108 1259108 414809 414809 19135 10 0.645246644871712
1483958 1483958 459191 459191 19135 10 0.645246644871712
1596103 1596103 481829 481829 19135 10 0.645246644871712
1667538 1667538 505696 505696 19135 10 0.645246644871712
1729829 1729829 529755 529755 19135 1 0.268328287620752
1748608 1748608 535597 535597 19135 11 0.440062265016279 
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)
);