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 = 138043

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
4059 4059 1179 1179 138043 1 0.173228346456693
28047 28047 8130 8130 138043 2 0.188559657740453
43015 43015 13057 13057 138043 2 0.314285714285714
87392 87392 31284 31284 138043 2 0.314285714285714
87395 87395 31285 31285 138043 2 0.188559657740453
145114 145114 51729 51729 138043 1 0.175438596491228
156244 156244 56178 56178 138043 2 0.188559657740453
203503 203503 72108 72108 138043 1 0.173228346456693
216672 216672 75204 75204 138043 1 0.173228346456693
235181 235181 80235 80235 138043 2 0.188298587760592
288827 288827 97814 97814 138043 2 0.3125
426780 426780 153913 153913 138043 1 0.173228346456693
436794 436794 156661 156661 138043 2 0.188298587760592
457198 457198 164312 164312 138043 2 0.3125
491689 491689 184986 184986 138043 2 0.448457694392291
558899 558899 219937 219937 138043 2 0.134024281045196
705987 705987 250951 250951 138043 3 0.2783834914032
802713 802713 279921 279921 138043 3 0.2783834914032
802720 802720 279922 279922 138043 2 0.255056430799862
802727 802727 279923 279923 138043 1 0.186832740213523
821622 821622 285281 285281 138043 2 0.172830416813475
853011 853011 295104 295104 138043 1 0.173228346456693
853014 853014 295105 295105 138043 1 0.173228346456693
870377 870377 300240 300240 138043 1 0.18630534720542
928736 928736 330392 330392 138043 1 0.168674698795181
1612238 1612238 486707 486707 138043 1 0.173228346456693
1623788 1623788 490329 490329 138043 1 0.183131930331141
1648863 1648863 499298 499298 138043 2 0.314285714285714
1717758 1717758 526078 526078 138043 1 0.168674698795181
1724844 1724844 528160 528160 138043 2 0.188559657740453
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 785.169ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website