home / zeropm-v0-0-4

consensus_index

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

27 rows where inventory_id = 249964

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
701762 701762 249964 249964 37415 2 0.0537153574030172
701763 701763 249964 249964 38590 10 0.246154691280933
701764 701764 249964 249964 50698 1 0.027350521253437
701765 701765 249964 249964 136872 3 0.123077345640467
701766 701766 249964 249964 148732 1 0.0410257818801555
701767 701767 249964 249964 149562 2 0.0615386728202333
701768 701768 249964 249964 176247 1 0.0164103127520622
701769 701769 249964 249964 178062 1 0.0129555100674175
701770 701770 249964 249964 189083 2 0.0449414923500958
701771 701771 249964 249964 195175 1 0.0136752606267185
701772 701772 249964 249964 195631 2 0.0635568679947921
701773 701773 249964 249964 203783 2 0.0189349762523795
701774 701774 249964 249964 208866 1 0.0129555100674175
701775 701775 249964 249964 210824 2 0.0240222381177686
701776 701776 249964 249964 223248 2 0.0223776992073575
701777 701777 249964 249964 234136 1 0.0153846682050583
701778 701778 249964 249964 234170 2 0.0290096085709381
701779 701779 249964 249964 258750 1 0.0136752606267185
701780 701780 249964 249964 258895 2 0.0246154691280933
701781 701781 249964 249964 286568 1 0.0205128909400778
701782 701782 249964 249964 289280 2 0.0251230579762752
701783 701783 249964 249964 308429 2 0.0175824779486381
701784 701784 249964 249964 309436 1 0.0153846682050583
701785 701785 249964 249964 320670 1 0.0144796877224078
701786 701786 249964 249964 323953 2 0.0133496124684457
701787 701787 249964 249964 334345 1 0.0117216519657587
701788 701788 249964 249964 334575 2 0.0117349644651834
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 806.426ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website