consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
112 rows where inchi_id = 75042
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 9090 | 9090 | 2754 2754 | 75042 | 2 | 0.207446808510638 |
| 45841 | 45841 | 13988 13988 | 75042 | 3 | 0.247994774075027 |
| 46391 | 46391 | 14132 14132 | 75042 | 1 | 0.218888275050204 |
| 122225 | 122225 | 42462 42462 | 75042 | 1 | 0.218888275050204 |
| 122443 | 122443 | 42522 42522 | 75042 | 3 | 0.247994774075027 |
| 162142 | 162142 | 58157 58157 | 75042 | 2 | 0.144663453183928 |
| 162390 | 162390 | 58198 58198 | 75042 | 5 | 0.245962724023731 |
| 199459 | 199459 | 70956 70956 | 75042 | 2 | 0.20625 |
| 297197 | 297197 | 100521 100521 | 75042 | 2 | 0.20625 |
| 298280 | 298280 | 100796 100796 | 75042 | 2 | 0.150485553406853 |
| 460246 | 460246 | 165469 165469 | 75042 | 2 | 0.20625 |
| 460862 | 460862 | 165621 165621 | 75042 | 1 | 0.190473596321527 |
| 525365 | 525365 | 209230 209230 | 75042 | 3 | 0.211694947616899 |
| 538685 | 538685 | 213638 213638 | 75042 | 2 | 0.150485553406853 |
| 539699 | 539699 | 213893 213893 | 75042 | 3 | 0.198535811042656 |
| 666092 | 666092 | 238475 238475 | 75042 | 2 | 0.150485553406853 |
| 727570 | 727570 | 256892 256892 | 75042 | 3 | 0.249000140016226 |
| 728694 | 728694 | 257181 257181 | 75042 | 1 | 0.218888275050204 |
| 796624 | 796624 | 277979 277979 | 75042 | 1 | 0.1865918254585 |
| 841235 | 841235 | 291674 291674 | 75042 | 4 | 0.2200141907037 |
| 841239 | 841239 | 291675 291675 | 75042 | 3 | 0.211694947616899 |
| 841245 | 841245 | 291676 291676 | 75042 | 3 | 0.247994774075027 |
| 843613 | 843613 | 292286 292286 | 75042 | 2 | 0.150485553406853 |
| 843618 | 843618 | 292287 292287 | 75042 | 1 | 0.218888275050204 |
| 843621 | 843621 | 292288 292288 | 75042 | 1 | 0.218888275050204 |
| 948937 | 948937 | 340297 340297 | 75042 | 2 | 0.203389830508475 |
| 1160041 | 1160041 | 389841 389841 | 75042 | 1 | 0.218888275050204 |
| 1160044 | 1160044 | 389842 389842 | 75042 | 1 | 0.218888275050204 |
| 1160047 | 1160047 | 389843 389843 | 75042 | 1 | 0.218888275050204 |
| 1160050 | 1160050 | 389844 389844 | 75042 | 1 | 0.218888275050204 |
| 1160053 | 1160053 | 389845 389845 | 75042 | 1 | 0.218888275050204 |
| 1160056 | 1160056 | 389846 389846 | 75042 | 1 | 0.218888275050204 |
| 1160059 | 1160059 | 389847 389847 | 75042 | 1 | 0.218888275050204 |
| 1160062 | 1160062 | 389848 389848 | 75042 | 1 | 0.218888275050204 |
| 1160065 | 1160065 | 389849 389849 | 75042 | 1 | 0.218888275050204 |
| 1160068 | 1160068 | 389850 389850 | 75042 | 1 | 0.218888275050204 |
| 1160071 | 1160071 | 389851 389851 | 75042 | 1 | 0.218888275050204 |
| 1160074 | 1160074 | 389852 389852 | 75042 | 1 | 0.218888275050204 |
| 1160077 | 1160077 | 389853 389853 | 75042 | 1 | 0.218888275050204 |
| 1160080 | 1160080 | 389854 389854 | 75042 | 1 | 0.218888275050204 |
| 1160083 | 1160083 | 389855 389855 | 75042 | 1 | 0.218888275050204 |
| 1160086 | 1160086 | 389856 389856 | 75042 | 1 | 0.218888275050204 |
| 1160089 | 1160089 | 389857 389857 | 75042 | 1 | 0.218888275050204 |
| 1160092 | 1160092 | 389858 389858 | 75042 | 1 | 0.218888275050204 |
| 1160095 | 1160095 | 389859 389859 | 75042 | 1 | 0.218888275050204 |
| 1160098 | 1160098 | 389860 389860 | 75042 | 1 | 0.218888275050204 |
| 1160101 | 1160101 | 389861 389861 | 75042 | 1 | 0.218888275050204 |
| 1160104 | 1160104 | 389862 389862 | 75042 | 1 | 0.218888275050204 |
| 1160107 | 1160107 | 389863 389863 | 75042 | 1 | 0.218888275050204 |
| 1160110 | 1160110 | 389864 389864 | 75042 | 1 | 0.218888275050204 |
| 1160113 | 1160113 | 389865 389865 | 75042 | 1 | 0.218888275050204 |
| 1160116 | 1160116 | 389866 389866 | 75042 | 1 | 0.218888275050204 |
| 1414431 | 1414431 | 440978 440978 | 75042 | 1 | 0.218888275050204 |
| 1414434 | 1414434 | 440979 440979 | 75042 | 1 | 0.218888275050204 |
| 1414437 | 1414437 | 440980 440980 | 75042 | 1 | 0.218888275050204 |
| 1414440 | 1414440 | 440981 440981 | 75042 | 1 | 0.218888275050204 |
| 1414443 | 1414443 | 440982 440982 | 75042 | 1 | 0.218888275050204 |
| 1414446 | 1414446 | 440983 440983 | 75042 | 1 | 0.218888275050204 |
| 1414449 | 1414449 | 440984 440984 | 75042 | 1 | 0.218888275050204 |
| 1414452 | 1414452 | 440985 440985 | 75042 | 1 | 0.218888275050204 |
| 1414455 | 1414455 | 440986 440986 | 75042 | 1 | 0.218888275050204 |
| 1414458 | 1414458 | 440987 440987 | 75042 | 1 | 0.218888275050204 |
| 1414461 | 1414461 | 440988 440988 | 75042 | 1 | 0.218888275050204 |
| 1414464 | 1414464 | 440989 440989 | 75042 | 1 | 0.218888275050204 |
| 1414467 | 1414467 | 440990 440990 | 75042 | 1 | 0.218888275050204 |
| 1414470 | 1414470 | 440991 440991 | 75042 | 1 | 0.218888275050204 |
| 1414473 | 1414473 | 440992 440992 | 75042 | 1 | 0.218888275050204 |
| 1414476 | 1414476 | 440993 440993 | 75042 | 1 | 0.218888275050204 |
| 1414479 | 1414479 | 440994 440994 | 75042 | 1 | 0.218888275050204 |
| 1414482 | 1414482 | 440995 440995 | 75042 | 1 | 0.218888275050204 |
| 1414485 | 1414485 | 440996 440996 | 75042 | 1 | 0.218888275050204 |
| 1414488 | 1414488 | 440997 440997 | 75042 | 1 | 0.218888275050204 |
| 1414491 | 1414491 | 440998 440998 | 75042 | 1 | 0.218888275050204 |
| 1414494 | 1414494 | 440999 440999 | 75042 | 1 | 0.218888275050204 |
| 1414497 | 1414497 | 441000 441000 | 75042 | 1 | 0.218888275050204 |
| 1414500 | 1414500 | 441001 441001 | 75042 | 1 | 0.218888275050204 |
| 1414503 | 1414503 | 441002 441002 | 75042 | 1 | 0.218888275050204 |
| 1414506 | 1414506 | 441003 441003 | 75042 | 1 | 0.218888275050204 |
| 1414509 | 1414509 | 441004 441004 | 75042 | 1 | 0.218888275050204 |
| 1414512 | 1414512 | 441005 441005 | 75042 | 1 | 0.218888275050204 |
| 1414515 | 1414515 | 441006 441006 | 75042 | 1 | 0.218888275050204 |
| 1414518 | 1414518 | 441007 441007 | 75042 | 1 | 0.218888275050204 |
| 1576775 | 1576775 | 475734 475734 | 75042 | 1 | 0.218888275050204 |
| 1576778 | 1576778 | 475735 475735 | 75042 | 1 | 0.218888275050204 |
| 1576781 | 1576781 | 475736 475736 | 75042 | 1 | 0.218888275050204 |
| 1576784 | 1576784 | 475737 475737 | 75042 | 1 | 0.218888275050204 |
| 1576787 | 1576787 | 475738 475738 | 75042 | 1 | 0.218888275050204 |
| 1576790 | 1576790 | 475739 475739 | 75042 | 1 | 0.218888275050204 |
| 1576793 | 1576793 | 475740 475740 | 75042 | 1 | 0.218888275050204 |
| 1576796 | 1576796 | 475741 475741 | 75042 | 1 | 0.218888275050204 |
| 1576799 | 1576799 | 475742 475742 | 75042 | 1 | 0.218888275050204 |
| 1576802 | 1576802 | 475743 475743 | 75042 | 1 | 0.218888275050204 |
| 1576805 | 1576805 | 475744 475744 | 75042 | 1 | 0.218888275050204 |
| 1576808 | 1576808 | 475745 475745 | 75042 | 1 | 0.218888275050204 |
| 1576811 | 1576811 | 475746 475746 | 75042 | 1 | 0.218888275050204 |
| 1576814 | 1576814 | 475747 475747 | 75042 | 1 | 0.218888275050204 |
| 1576817 | 1576817 | 475748 475748 | 75042 | 1 | 0.218888275050204 |
| 1576820 | 1576820 | 475749 475749 | 75042 | 1 | 0.218888275050204 |
| 1576823 | 1576823 | 475750 475750 | 75042 | 1 | 0.218888275050204 |
| 1576826 | 1576826 | 475751 475751 | 75042 | 1 | 0.218888275050204 |
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)
);