home / zeropm-v0-0-4

consensus_index

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

31 rows where inchi_id = 42730

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15152 15152 4711 4711 42730 1 0.0476056862680901
15324 15324 4736 4736 42730 3 0.259636732241006
107615 107615 37832 37832 42730 1 0.0701372636066687
152490 152490 54864 54864 42730 1 0.3125
209180 209180 73807 73807 42730 1 0.0629332488002227
209652 209652 73885 73885 42730 5 0.201008252723628
223611 223611 77182 77182 42730 2 0.186450668908557
278404 278404 94409 94409 42730 10 0.366908127977454
422057 422057 153072 153072 42730 1 0.0629332488002227
453523 453523 162860 162860 42730 10 0.366908127977454
505188 505188 202078 202078 42730 1 0.173228346456693
553772 553772 218487 218487 42730 4 0.233109885129925
555521 555521 218973 218973 42730 1 0.0629332488002227
560039 560039 220290 220290 42730 10 0.342393397008121
560045 560045 220291 220291 42730 1 0.173228346456693
590571 590571 230466 230466 42730 2 0.186450668908557
667988 667988 239381 239381 42730 14 0.386182382195667
710086 710086 251930 251930 42730 1 0.0476056862680901
731274 731274 257908 257908 42730 1 0.3125
800627 800627 279293 279293 42730 9 0.436922227534772
800631 800631 279294 279294 42730 6 0.411876793003125
809132 809132 281714 281714 42730 1 0.0476056862680901
809153 809153 281715 281715 42730 1 0.0458797228048421
849496 849496 293883 293883 42730 1 0.3125
910984 910984 321771 321771 42730 1 0.189765154131936
911064 911064 321791 321791 42730 1 0.205179828463401
915091 915091 324120 324120 42730 1 0.0701372636066687
1608088 1608088 485760 485760 42730 1 0.0476056862680901
1608383 1608383 485808 485808 42730 3 0.259636732241006
1630646 1630646 492786 492786 42730 1 0.3125
1644771 1644771 497884 497884 42730 9 0.436922227534772
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 1986.79ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website