consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
85 rows where inchi_id = 227110
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 25407 | 25407 | 7461 7461 | 227110 | 2 | 0.106717737631888 |
| 25424 | 25424 | 7466 7466 | 227110 | 1 | 0.0641478872914925 |
| 95053 | 95053 | 33708 33708 | 227110 | 1 | 0.0641478872914925 |
| 95061 | 95061 | 33709 33709 | 227110 | 2 | 0.106717737631888 |
| 145631 | 145631 | 51920 51920 | 227110 | 5 | 0.114686314118454 |
| 194015 | 194015 | 68917 68917 | 227110 | 1 | 0.0419213769934679 |
| 226001 | 226001 | 77864 77864 | 227110 | 2 | 0.10690715903235 |
| 226036 | 226036 | 77872 77872 | 227110 | 1 | 0.0555013688766606 |
| 433356 | 433356 | 155797 155797 | 227110 | 1 | 0.147299509001637 |
| 433386 | 433386 | 155804 155804 | 227110 | 1 | 0.0555013688766606 |
| 585584 | 585584 | 228689 228689 | 227110 | 1 | 0.0555013688766606 |
| 585830 | 585830 | 228763 228763 | 227110 | 1 | 0.147299509001637 |
| 599450 | 599450 | 236156 236156 | 227110 | 1 | 0.0555013688766606 |
| 678884 | 678884 | 242726 242726 | 227110 | 4 | 0.126874324696372 |
| 678926 | 678926 | 242737 242737 | 227110 | 1 | 0.0419213769934679 |
| 756165 | 756165 | 265676 265676 | 227110 | 1 | 0.137614678899083 |
| 756171 | 756171 | 265677 265677 | 227110 | 2 | 0.106717737631888 |
| 756210 | 756210 | 265696 265696 | 227110 | 1 | 0.102523665955771 |
| 756218 | 756218 | 265697 265697 | 227110 | 1 | 0.0641478872914925 |
| 756225 | 756225 | 265698 265698 | 227110 | 1 | 0.102523665955771 |
| 756237 | 756237 | 265699 265699 | 227110 | 1 | 0.0555013688766606 |
| 927016 | 927016 | 329699 329699 | 227110 | 1 | 0.101943023042386 |
| 929381 | 929381 | 330782 330782 | 227110 | 1 | 0.147299509001637 |
| 1009473 | 1009473 | 360439 360439 | 227110 | 2 | 0.106717737631888 |
| 1009479 | 1009479 | 360440 360440 | 227110 | 2 | 0.106717737631888 |
| 1009485 | 1009485 | 360441 360441 | 227110 | 2 | 0.106717737631888 |
| 1009587 | 1009587 | 360491 360491 | 227110 | 1 | 0.098943496867299 |
| 1009591 | 1009591 | 360492 360492 | 227110 | 1 | 0.098943496867299 |
| 1009595 | 1009595 | 360493 360493 | 227110 | 1 | 0.098943496867299 |
| 1009599 | 1009599 | 360494 360494 | 227110 | 1 | 0.098943496867299 |
| 1009603 | 1009603 | 360495 360495 | 227110 | 1 | 0.098943496867299 |
| 1009607 | 1009607 | 360496 360496 | 227110 | 1 | 0.098943496867299 |
| 1009611 | 1009611 | 360497 360497 | 227110 | 1 | 0.098943496867299 |
| 1009615 | 1009615 | 360498 360498 | 227110 | 1 | 0.098943496867299 |
| 1009619 | 1009619 | 360499 360499 | 227110 | 1 | 0.098943496867299 |
| 1009623 | 1009623 | 360500 360500 | 227110 | 1 | 0.098943496867299 |
| 1009627 | 1009627 | 360501 360501 | 227110 | 1 | 0.098943496867299 |
| 1009631 | 1009631 | 360502 360502 | 227110 | 1 | 0.098943496867299 |
| 1009635 | 1009635 | 360503 360503 | 227110 | 1 | 0.098943496867299 |
| 1220637 | 1220637 | 404805 404805 | 227110 | 2 | 0.106717737631888 |
| 1220643 | 1220643 | 404806 404806 | 227110 | 2 | 0.106717737631888 |
| 1220649 | 1220649 | 404807 404807 | 227110 | 2 | 0.106717737631888 |
| 1220655 | 1220655 | 404808 404808 | 227110 | 2 | 0.106717737631888 |
| 1220753 | 1220753 | 404856 404856 | 227110 | 1 | 0.098943496867299 |
| 1220757 | 1220757 | 404857 404857 | 227110 | 1 | 0.098943496867299 |
| 1220761 | 1220761 | 404858 404858 | 227110 | 1 | 0.098943496867299 |
| 1220765 | 1220765 | 404859 404859 | 227110 | 1 | 0.098943496867299 |
| 1220769 | 1220769 | 404860 404860 | 227110 | 1 | 0.098943496867299 |
| 1220773 | 1220773 | 404861 404861 | 227110 | 1 | 0.098943496867299 |
| 1220777 | 1220777 | 404862 404862 | 227110 | 1 | 0.098943496867299 |
| 1220781 | 1220781 | 404863 404863 | 227110 | 1 | 0.098943496867299 |
| 1220785 | 1220785 | 404864 404864 | 227110 | 1 | 0.098943496867299 |
| 1220789 | 1220789 | 404865 404865 | 227110 | 1 | 0.098943496867299 |
| 1220793 | 1220793 | 404866 404866 | 227110 | 1 | 0.098943496867299 |
| 1220797 | 1220797 | 404867 404867 | 227110 | 1 | 0.098943496867299 |
| 1220801 | 1220801 | 404868 404868 | 227110 | 1 | 0.098943496867299 |
| 1220805 | 1220805 | 404869 404869 | 227110 | 1 | 0.098943496867299 |
| 1220809 | 1220809 | 404870 404870 | 227110 | 1 | 0.098943496867299 |
| 1220813 | 1220813 | 404871 404871 | 227110 | 1 | 0.098943496867299 |
| 1220817 | 1220817 | 404872 404872 | 227110 | 1 | 0.098943496867299 |
| 1220821 | 1220821 | 404873 404873 | 227110 | 1 | 0.098943496867299 |
| 1220825 | 1220825 | 404874 404874 | 227110 | 1 | 0.098943496867299 |
| 1220829 | 1220829 | 404875 404875 | 227110 | 1 | 0.098943496867299 |
| 1461365 | 1461365 | 453302 453302 | 227110 | 2 | 0.106717737631888 |
| 1461371 | 1461371 | 453303 453303 | 227110 | 2 | 0.106717737631888 |
| 1461377 | 1461377 | 453304 453304 | 227110 | 2 | 0.106717737631888 |
| 1461451 | 1461451 | 453340 453340 | 227110 | 1 | 0.098943496867299 |
| 1461455 | 1461455 | 453341 453341 | 227110 | 1 | 0.098943496867299 |
| 1461459 | 1461459 | 453342 453342 | 227110 | 1 | 0.098943496867299 |
| 1461463 | 1461463 | 453343 453343 | 227110 | 1 | 0.098943496867299 |
| 1461467 | 1461467 | 453344 453344 | 227110 | 1 | 0.098943496867299 |
| 1461471 | 1461471 | 453345 453345 | 227110 | 1 | 0.098943496867299 |
| 1461475 | 1461475 | 453346 453346 | 227110 | 1 | 0.098943496867299 |
| 1461479 | 1461479 | 453347 453347 | 227110 | 1 | 0.098943496867299 |
| 1461483 | 1461483 | 453348 453348 | 227110 | 1 | 0.098943496867299 |
| 1461487 | 1461487 | 453349 453349 | 227110 | 1 | 0.098943496867299 |
| 1461491 | 1461491 | 453350 453350 | 227110 | 1 | 0.098943496867299 |
| 1461495 | 1461495 | 453351 453351 | 227110 | 1 | 0.098943496867299 |
| 1461499 | 1461499 | 453352 453352 | 227110 | 1 | 0.098943496867299 |
| 1593017 | 1593017 | 480857 480857 | 227110 | 2 | 0.106717737631888 |
| 1593025 | 1593025 | 480860 480860 | 227110 | 1 | 0.098943496867299 |
| 1619674 | 1619674 | 489089 489089 | 227110 | 2 | 0.106717737631888 |
| 1619689 | 1619689 | 489095 489095 | 227110 | 1 | 0.098943496867299 |
| 1722196 | 1722196 | 527462 527462 | 227110 | 2 | 0.106717737631888 |
| 1722206 | 1722206 | 527467 527467 | 227110 | 1 | 0.103981521237678 |
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)
);