home / zeropm-v0-0-4

consensus_index

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

30 rows where inchi_id = 115585

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19269 19269 5661 5661 115585 1 0.230769230769231
32424 32424 9546 9546 115585 5 0.338067833577476
99304 99304 35156 35156 115585 5 0.338067833577476
157153 157153 56511 56511 115585 5 0.338067833577476
217436 217436 75425 75425 115585 1 0.207915688882607
251528 251528 85458 85458 115585 5 0.347597941686258
300939 300939 101869 101869 115585 1 0.152757997001702
427267 427267 154057 154057 115585 2 0.159284692360696
443339 443339 158918 158918 115585 6 0.330690824186493
533760 533760 211745 211745 115585 1 0.230769230769231
595762 595762 231995 231995 115585 6 0.330284273653506
669627 669627 239833 239833 115585 5 0.338067833577476
891033 891033 312343 312343 115585 1 0.226415094339623
891059 891059 312357 312357 115585 1 0.136786552308934
971282 971282 352095 352095 115585 6 0.349349381000177
971289 971289 352096 352096 115585 6 0.349349381000177
971296 971296 352097 352097 115585 6 0.349349381000177
971303 971303 352098 352098 115585 6 0.349349381000177
1181285 1181285 396110 396110 115585 6 0.349349381000177
1181292 1181292 396111 396111 115585 6 0.349349381000177
1181299 1181299 396112 396112 115585 6 0.349349381000177
1181306 1181306 396113 396113 115585 6 0.349349381000177
1435799 1435799 447492 447492 115585 6 0.349349381000177
1435806 1435806 447493 447493 115585 6 0.349349381000177
1435813 1435813 447494 447494 115585 6 0.349349381000177
1435820 1435820 447495 447495 115585 6 0.349349381000177
1589492 1589492 479811 479811 115585 6 0.349349381000177
1612756 1612756 486888 486888 115585 1 0.230769230769231
1632081 1632081 493272 493272 115585 6 0.349349381000177
1728825 1728825 529441 529441 115585 5 0.338067833577476
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 1760.344ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website