consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
271 rows where inchi_id = 9870
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 8231 | 8231 | 2493 2493 | 9870 | 5 | 0.359639277722253 |
| 8237 | 8237 | 2494 2494 | 9870 | 2 | 0.244864008775844 |
| 8678 | 8678 | 2631 2631 | 9870 | 1 | 0.0235140428372907 |
| 22941 | 22941 | 6733 6733 | 9870 | 1 | 0.0236977321314669 |
| 54714 | 54714 | 17092 17092 | 9870 | 4 | 0.341486685816426 |
| 73304 | 73304 | 25149 25149 | 9870 | 2 | 0.254029877862684 |
| 116755 | 116755 | 40725 40725 | 9870 | 1 | 0.0236977321314669 |
| 117427 | 117427 | 40993 40993 | 9870 | 2 | 0.254029877862684 |
| 117503 | 117503 | 41022 41022 | 9870 | 4 | 0.341486685816426 |
| 129074 | 129074 | 46045 46045 | 9870 | 1 | 0.0235853371154791 |
| 172036 | 172036 | 61404 61404 | 9870 | 4 | 0.341486685816426 |
| 197557 | 197557 | 70186 70186 | 9870 | 4 | 0.243626516239764 |
| 202032 | 202032 | 71648 71648 | 9870 | 1 | 0.0235140428372907 |
| 222168 | 222168 | 76815 76815 | 9870 | 1 | 0.0236977321314669 |
| 227560 | 227560 | 78257 78257 | 9870 | 8 | 0.9 |
| 334926 | 334926 | 112895 112895 | 9870 | 3 | 0.363202262536147 |
| 400873 | 400873 | 139476 139476 | 9870 | 2 | 0.254029877862684 |
| 430749 | 430749 | 155069 155069 | 9870 | 1 | 0.0236977321314669 |
| 434178 | 434178 | 156012 156012 | 9870 | 8 | 0.9 |
| 475756 | 475756 | 173257 173257 | 9870 | 3 | 0.363202262536147 |
| 495520 | 495520 | 188686 188686 | 9870 | 2 | 0.254029877862684 |
| 517793 | 517793 | 207212 207212 | 9870 | 1 | 0.0236977321314669 |
| 517812 | 517812 | 207213 207213 | 9870 | 1 | 0.0236977321314669 |
| 517831 | 517831 | 207214 207214 | 9870 | 1 | 0.0236977321314669 |
| 528767 | 528767 | 210022 210022 | 9870 | 3 | 0.363202262536147 |
| 528772 | 528772 | 210023 210023 | 9870 | 3 | 0.363202262536147 |
| 530259 | 530259 | 210411 210411 | 9870 | 1 | 0.323656898901806 |
| 535515 | 535515 | 212511 212511 | 9870 | 1 | 0.349566795544274 |
| 569186 | 569186 | 223234 223234 | 9870 | 3 | 0.363202262536147 |
| 581620 | 581620 | 227510 227510 | 9870 | 4 | 0.833333333333333 |
| 592543 | 592543 | 231031 231031 | 9870 | 1 | 0.0236977321314669 |
| 598118 | 598118 | 235579 235579 | 9870 | 2 | 0.0239753428780086 |
| 661701 | 661701 | 237124 237124 | 9870 | 3 | 0.363202262536147 |
| 666757 | 666757 | 238702 238702 | 9870 | 1 | 0.323656898901806 |
| 673355 | 673355 | 240817 240817 | 9870 | 1 | 0.0236301416043904 |
| 694269 | 694269 | 247634 247634 | 9870 | 4 | 0.341486685816426 |
| 732305 | 732305 | 258238 258238 | 9870 | 2 | 0.254029877862684 |
| 746226 | 746226 | 262498 262498 | 9870 | 1 | 0.0236977321314669 |
| 751927 | 751927 | 264348 264348 | 9870 | 1 | 0.0256764533133296 |
| 782559 | 782559 | 273613 273613 | 9870 | 3 | 0.363202262536147 |
| 782564 | 782564 | 273614 273614 | 9870 | 4 | 0.341486685816426 |
| 782951 | 782951 | 273729 273729 | 9870 | 1 | 0.0180605609602062 |
| 791062 | 791062 | 276183 276183 | 9870 | 1 | 0.0200302658399579 |
| 826885 | 826885 | 287006 287006 | 9870 | 1 | 0.0164286522456363 |
| 851102 | 851102 | 294444 294444 | 9870 | 2 | 0.254029877862684 |
| 935599 | 935599 | 333986 333986 | 9870 | 2 | 0.387096774193548 |
| 989038 | 989038 | 355404 355404 | 9870 | 1 | 0.0236977321314669 |
| 989057 | 989057 | 355405 355405 | 9870 | 1 | 0.0236977321314669 |
| 989076 | 989076 | 355406 355406 | 9870 | 1 | 0.0236977321314669 |
| 989095 | 989095 | 355407 355407 | 9870 | 1 | 0.0236977321314669 |
| 989114 | 989114 | 355408 355408 | 9870 | 1 | 0.0236977321314669 |
| 989133 | 989133 | 355409 355409 | 9870 | 1 | 0.0236977321314669 |
| 989152 | 989152 | 355410 355410 | 9870 | 1 | 0.0236977321314669 |
| 989171 | 989171 | 355411 355411 | 9870 | 1 | 0.0236977321314669 |
| 989190 | 989190 | 355412 355412 | 9870 | 1 | 0.0236977321314669 |
| 989209 | 989209 | 355413 355413 | 9870 | 1 | 0.0236977321314669 |
| 989228 | 989228 | 355414 355414 | 9870 | 1 | 0.0236977321314669 |
| 989247 | 989247 | 355415 355415 | 9870 | 1 | 0.0236977321314669 |
| 989266 | 989266 | 355416 355416 | 9870 | 1 | 0.0236977321314669 |
| 989285 | 989285 | 355417 355417 | 9870 | 1 | 0.0236977321314669 |
| 989304 | 989304 | 355418 355418 | 9870 | 1 | 0.0236977321314669 |
| 989323 | 989323 | 355419 355419 | 9870 | 1 | 0.0236977321314669 |
| 989342 | 989342 | 355420 355420 | 9870 | 1 | 0.0236977321314669 |
| 989361 | 989361 | 355421 355421 | 9870 | 1 | 0.0236977321314669 |
| 989380 | 989380 | 355422 355422 | 9870 | 1 | 0.0236977321314669 |
| 989399 | 989399 | 355423 355423 | 9870 | 1 | 0.0236977321314669 |
| 989418 | 989418 | 355424 355424 | 9870 | 1 | 0.0236977321314669 |
| 989437 | 989437 | 355425 355425 | 9870 | 1 | 0.0236977321314669 |
| 989456 | 989456 | 355426 355426 | 9870 | 1 | 0.0236977321314669 |
| 989475 | 989475 | 355427 355427 | 9870 | 1 | 0.0236977321314669 |
| 989494 | 989494 | 355428 355428 | 9870 | 1 | 0.0236977321314669 |
| 989513 | 989513 | 355429 355429 | 9870 | 1 | 0.0236977321314669 |
| 989532 | 989532 | 355430 355430 | 9870 | 1 | 0.0236977321314669 |
| 989551 | 989551 | 355431 355431 | 9870 | 1 | 0.0236977321314669 |
| 989570 | 989570 | 355432 355432 | 9870 | 1 | 0.0236977321314669 |
| 989589 | 989589 | 355433 355433 | 9870 | 1 | 0.0236977321314669 |
| 989608 | 989608 | 355434 355434 | 9870 | 1 | 0.0236977321314669 |
| 1043918 | 1043918 | 369739 369739 | 9870 | 4 | 0.341486685816426 |
| 1043923 | 1043923 | 369740 369740 | 9870 | 4 | 0.341486685816426 |
| 1043928 | 1043928 | 369741 369741 | 9870 | 4 | 0.341486685816426 |
| 1170283 | 1170283 | 393067 393067 | 9870 | 2 | 0.254029877862684 |
| 1170288 | 1170288 | 393068 393068 | 9870 | 2 | 0.254029877862684 |
| 1170293 | 1170293 | 393069 393069 | 9870 | 2 | 0.254029877862684 |
| 1170298 | 1170298 | 393070 393070 | 9870 | 2 | 0.254029877862684 |
| 1170303 | 1170303 | 393071 393071 | 9870 | 2 | 0.254029877862684 |
| 1170308 | 1170308 | 393072 393072 | 9870 | 2 | 0.254029877862684 |
| 1170313 | 1170313 | 393073 393073 | 9870 | 2 | 0.254029877862684 |
| 1170318 | 1170318 | 393074 393074 | 9870 | 2 | 0.254029877862684 |
| 1170323 | 1170323 | 393075 393075 | 9870 | 2 | 0.254029877862684 |
| 1170328 | 1170328 | 393076 393076 | 9870 | 2 | 0.254029877862684 |
| 1170333 | 1170333 | 393077 393077 | 9870 | 2 | 0.254029877862684 |
| 1170338 | 1170338 | 393078 393078 | 9870 | 2 | 0.254029877862684 |
| 1170343 | 1170343 | 393079 393079 | 9870 | 2 | 0.254029877862684 |
| 1170348 | 1170348 | 393080 393080 | 9870 | 2 | 0.254029877862684 |
| 1170353 | 1170353 | 393081 393081 | 9870 | 2 | 0.254029877862684 |
| 1170358 | 1170358 | 393082 393082 | 9870 | 2 | 0.254029877862684 |
| 1170363 | 1170363 | 393083 393083 | 9870 | 2 | 0.254029877862684 |
| 1170368 | 1170368 | 393084 393084 | 9870 | 2 | 0.254029877862684 |
| 1170373 | 1170373 | 393085 393085 | 9870 | 2 | 0.254029877862684 |
| 1170378 | 1170378 | 393086 393086 | 9870 | 2 | 0.254029877862684 |
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)
);