consensus_index

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

27 rows where inchi_id = 31625

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
3290 3290 916 916 31625 6 0.473684210526316
14133 14133 4343 4343 31625 1 0.3125
21110 21110 6229 6229 31625 1 0.3125
80091 80091 28898 28898 31625 1 0.3125
155288 155288 55849 55849 31625 1 0.3125
199072 199072 70792 70792 31625 6 0.473684210526316
200778 200778 71335 71335 31625 1 0.243243243243243
219608 219608 76075 76075 31625 1 0.3125
230567 230567 78977 78977 31625 6 0.473684210526316
428836 428836 154531 154531 31625 1 0.3125
520779 520779 207923 207923 31625 6 0.473684210526316
520781 520781 207924 207924 31625 3 0.454545454545455
531057 531057 210692 210692 31625 1 0.241935483870968
565715 565715 222160 222160 31625 6 0.473684210526316
662092 662092 237271 237271 31625 6 0.473684210526316
736993 736993 259884 259884 31625 1 0.241935483870968
860233 860233 297509 297509 31625 1 0.307692307692308
860235 860235 297510 297510 31625 1 0.3125
860237 860237 297511 297511 31625 1 0.304347826086957
925857 925857 329210 329210 31625 1 0.3
1177283 1177283 395049 395049 31625 1 0.3125
1432937 1432937 446726 446726 31625 1 0.3125
1589131 1589131 479713 479713 31625 1 0.3125
1607594 1607594 485678 485678 31625 1 0.3125
1614444 1614444 487436 487436 31625 1 0.3125
1718917 1718917 526448 526448 31625 1 0.310344827586207
1723811 1723811 527902 527902 31625 6 0.470588235294118 
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)
);