home / zeropm-v0-0-4

consensus_index

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

28 rows where inchi_id = 243219

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
59258 59258 18762 18762 243219 1 0.150741041020006
115088 115088 40147 40147 243219 1 0.0585274945914446
186624 186624 66523 66523 243219 1 0.0549264653748867
300655 300655 101785 101785 243219 1 0.0561358506302627
462113 462113 166012 166012 243219 1 0.0561358506302627
503149 503149 201387 201387 243219 1 0.155844155844156
595468 595468 231914 231914 243219 2 0.090073929775192
669745 669745 239867 239867 243219 2 0.0936745833469742
699295 699295 249211 249211 243219 1 0.152423685089105
793356 793356 276911 276911 243219 1 0.152423685089105
793359 793359 276912 276912 243219 1 0.153846153846154
928916 928916 330464 330464 243219 1 0.150741041020006
951470 951470 341350 341350 243219 1 0.0599110046083375
971605 971605 352197 352197 243219 1 0.0597074398272627
971612 971612 352198 352198 243219 1 0.0597074398272627
971619 971619 352199 352199 243219 1 0.0597074398272627
971626 971626 352200 352200 243219 1 0.0597074398272627
1181684 1181684 396231 396231 243219 1 0.0597074398272627
1181691 1181691 396232 396232 243219 1 0.0597074398272627
1181698 1181698 396233 396233 243219 1 0.0597074398272627
1181705 1181705 396234 396234 243219 1 0.0597074398272627
1436071 1436071 447570 447570 243219 1 0.0597074398272627
1436078 1436078 447571 447571 243219 1 0.0597074398272627
1436085 1436085 447572 447572 243219 1 0.0597074398272627
1436092 1436092 447573 447573 243219 1 0.0597074398272627
1589559 1589559 479830 479830 243219 1 0.0597074398272627
1654893 1654893 501421 501421 243219 1 0.0597074398272627
1742280 1742280 533650 533650 243219 1 0.0585274945914446
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)
);
Powered by Datasette · Queries took 1199.666ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website