consensus_index

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

29 rows where inchi_id = 4927

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
24462 24462 7174 7174 4927 6 0.473684210526316
64638 64638 21110 21110 4927 4 0.5
66995 66995 22139 22139 4927 1 0.0723348420905983
92937 92937 33059 33059 4927 6 0.473684210526316
123838 123838 42984 42984 4927 1 0.0723348420905983
123845 123845 42985 42985 4927 4 0.5
127957 127957 45751 45751 4927 3 0.454545454545455
194177 194177 68958 68958 4927 4 0.5
224163 224163 77349 77349 4927 6 0.470588235294118
371500 371500 126539 126539 4927 4 0.5
372753 372753 127024 127024 4927 1 0.310344827586207
380797 380797 130234 130234 4927 1 0.0723348420905983
490005 490005 183765 183765 4927 1 0.307692307692308
548941 548941 216977 216977 4927 5 0.428571428571429
717829 717829 253890 253890 4927 4 0.5
750902 750902 263994 263994 4927 3 0.174698531109194
750926 750926 263995 263995 4927 3 0.454545454545455
821548 821548 285248 285248 4927 2 0.487728457387774
821550 821550 285249 285249 4927 4 0.5
821552 821552 285250 285250 4927 4 0.5
829429 829429 287728 287728 4927 1 0.0723348420905983
927661 927661 329953 329953 4927 1 0.599254417849115
928041 928041 330107 330107 4927 2 0.487728457387774
928368 928368 330204 330204 4927 3 0.454545454545455
1618508 1618508 488696 488696 4927 6 0.473684210526316
1688827 1688827 513879 513879 4927 1 0.3125
1721419 1721419 527202 527202 4927 6 0.473684210526316
1757562 1757562 538918 538918 4927 4 0.5
1758929 1758929 539547 539547 4927 1 0.0723348420905983 
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)
);