home / zeropm-v0-0-4

consensus_index

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

27 rows where inchi_id = 37922

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
8694 8694 2632 2632 37922 2 0.168025755550837
17240 17240 5047 5047 37922 1 0.3125
27554 27554 7993 7993 37922 8 0.9
78505 78505 28374 28374 37922 1 0.3125
109571 109571 38352 38352 37922 8 0.9
144708 144708 51613 51613 37922 7 0.888888888888889
147215 147215 52979 52979 37922 1 0.3125
179456 179456 64047 64047 37922 5 0.857142857142857
202242 202242 71716 71716 37922 2 0.168025755550837
214249 214249 74509 74509 37922 2 0.168025755550837
232434 232434 79500 79500 37922 6 0.875
425175 425175 153469 153469 37922 1 0.307692307692308
513697 513697 206229 206229 37922 2 0.168025755550837
513702 513702 206230 206230 37922 1 0.307692307692308
539283 539283 213799 213799 37922 1 0.304347826086957
665795 665795 238418 238418 37922 2 0.168025755550837
701361 701361 249828 249828 37922 8 0.9
728152 728152 257018 257018 37922 2 0.169130681905699
842260 842260 291920 291920 37922 1 0.304347826086957
842262 842262 291921 291921 37922 1 0.3125
842264 842264 291922 291922 37922 1 0.304347826086957
842266 842266 291923 291923 37922 1 0.304347826086957
842268 842268 291924 291924 37922 2 0.168025755550837
919591 919591 326205 326205 37922 4 0.833333333333333
1610703 1610703 486204 486204 37922 1 0.3125
1622854 1622854 490034 490034 37922 7 0.888888888888889
1716825 1716825 525786 525786 37922 2 0.168025755550837
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 742.334ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website