consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
81 rows where inchi_id = 4029
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 3669 | 3669 | 1039 1039 | 4029 | 17 | 0.368983957219251 |
| 23745 | 23745 | 6961 6961 | 4029 | 7 | 0.517241379310345 |
| 79302 | 79302 | 28629 28629 | 4029 | 7 | 0.517241379310345 |
| 175458 | 175458 | 62620 62620 | 4029 | 10 | 0.415841584158416 |
| 205431 | 205431 | 72814 72814 | 4029 | 10 | 0.365853658536585 |
| 223190 | 223190 | 77102 77102 | 4029 | 8 | 0.413793103448276 |
| 431599 | 431599 | 155300 155300 | 4029 | 4 | 0.506024096385542 |
| 518723 | 518723 | 207405 207405 | 4029 | 10 | 0.365853658536585 |
| 518728 | 518728 | 207406 207406 | 4029 | 8 | 0.364485981308411 |
| 591015 | 591015 | 230596 230596 | 4029 | 8 | 0.364485981308411 |
| 598586 | 598586 | 235693 235693 | 4029 | 10 | 0.365853658536585 |
| 674924 | 674924 | 241230 241230 | 4029 | 11 | 0.366412213740458 |
| 742515 | 742515 | 261454 261454 | 4029 | 4 | 0.506024096385542 |
| 749179 | 749179 | 263407 263407 | 4029 | 5 | 0.51063829787234 |
| 749182 | 749182 | 263408 263408 | 4029 | 7 | 0.517241379310345 |
| 749185 | 749185 | 263409 263409 | 4029 | 8 | 0.519685039370079 |
| 749188 | 749188 | 263410 263410 | 4029 | 8 | 0.519685039370079 |
| 749191 | 749191 | 263411 263411 | 4029 | 6 | 0.514285714285714 |
| 749194 | 749194 | 263412 263412 | 4029 | 7 | 0.517241379310345 |
| 749197 | 749197 | 263413 263413 | 4029 | 7 | 0.4125 |
| 749201 | 749201 | 263414 263414 | 4029 | 8 | 0.413793103448276 |
| 749205 | 749205 | 263415 263415 | 4029 | 8 | 0.364485981308411 |
| 829271 | 829271 | 287666 287666 | 4029 | 4 | 0.506024096385542 |
| 829813 | 829813 | 287926 287926 | 4029 | 4 | 0.506024096385542 |
| 830745 | 830745 | 288310 288310 | 4029 | 4 | 0.506024096385542 |
| 830748 | 830748 | 288311 288311 | 4029 | 4 | 0.506024096385542 |
| 831363 | 831363 | 288500 288500 | 4029 | 4 | 0.340909090909091 |
| 832107 | 832107 | 288782 288782 | 4029 | 4 | 0.338028169014085 |
| 832138 | 832138 | 288805 288805 | 4029 | 4 | 0.506024096385542 |
| 832165 | 832165 | 288813 288813 | 4029 | 4 | 0.506024096385542 |
| 854961 | 854961 | 295737 295737 | 4029 | 4 | 0.338028169014085 |
| 921692 | 921692 | 327108 327108 | 4029 | 2 | 0.630993034743972 |
| 934045 | 934045 | 332883 332883 | 4029 | 4 | 0.506024096385542 |
| 996062 | 996062 | 356932 356932 | 4029 | 8 | 0.519685039370079 |
| 996065 | 996065 | 356933 356933 | 4029 | 8 | 0.519685039370079 |
| 996068 | 996068 | 356934 356934 | 4029 | 8 | 0.519685039370079 |
| 996071 | 996071 | 356935 356935 | 4029 | 8 | 0.519685039370079 |
| 996074 | 996074 | 356936 356936 | 4029 | 8 | 0.519685039370079 |
| 996077 | 996077 | 356937 356937 | 4029 | 8 | 0.519685039370079 |
| 996080 | 996080 | 356938 356938 | 4029 | 8 | 0.519685039370079 |
| 996083 | 996083 | 356939 356939 | 4029 | 8 | 0.519685039370079 |
| 996086 | 996086 | 356940 356940 | 4029 | 8 | 0.519685039370079 |
| 996089 | 996089 | 356941 356941 | 4029 | 8 | 0.519685039370079 |
| 996092 | 996092 | 356942 356942 | 4029 | 8 | 0.519685039370079 |
| 996095 | 996095 | 356943 356943 | 4029 | 8 | 0.519685039370079 |
| 996098 | 996098 | 356944 356944 | 4029 | 8 | 0.519685039370079 |
| 1206932 | 1206932 | 401224 401224 | 4029 | 8 | 0.519685039370079 |
| 1206935 | 1206935 | 401225 401225 | 4029 | 8 | 0.519685039370079 |
| 1206938 | 1206938 | 401226 401226 | 4029 | 8 | 0.519685039370079 |
| 1206941 | 1206941 | 401227 401227 | 4029 | 8 | 0.519685039370079 |
| 1206944 | 1206944 | 401228 401228 | 4029 | 8 | 0.519685039370079 |
| 1206947 | 1206947 | 401229 401229 | 4029 | 8 | 0.519685039370079 |
| 1206950 | 1206950 | 401230 401230 | 4029 | 8 | 0.519685039370079 |
| 1206953 | 1206953 | 401231 401231 | 4029 | 8 | 0.519685039370079 |
| 1206956 | 1206956 | 401232 401232 | 4029 | 8 | 0.519685039370079 |
| 1206959 | 1206959 | 401233 401233 | 4029 | 8 | 0.519685039370079 |
| 1206962 | 1206962 | 401234 401234 | 4029 | 8 | 0.519685039370079 |
| 1206965 | 1206965 | 401235 401235 | 4029 | 8 | 0.519685039370079 |
| 1206968 | 1206968 | 401236 401236 | 4029 | 8 | 0.519685039370079 |
| 1206971 | 1206971 | 401237 401237 | 4029 | 8 | 0.519685039370079 |
| 1206974 | 1206974 | 401238 401238 | 4029 | 8 | 0.519685039370079 |
| 1206977 | 1206977 | 401239 401239 | 4029 | 8 | 0.519685039370079 |
| 1206980 | 1206980 | 401240 401240 | 4029 | 8 | 0.519685039370079 |
| 1206983 | 1206983 | 401241 401241 | 4029 | 8 | 0.519685039370079 |
| 1206986 | 1206986 | 401242 401242 | 4029 | 8 | 0.519685039370079 |
| 1206989 | 1206989 | 401243 401243 | 4029 | 8 | 0.519685039370079 |
| 1206992 | 1206992 | 401244 401244 | 4029 | 8 | 0.519685039370079 |
| 1451851 | 1451851 | 450803 450803 | 4029 | 8 | 0.519685039370079 |
| 1451854 | 1451854 | 450804 450804 | 4029 | 8 | 0.519685039370079 |
| 1451857 | 1451857 | 450805 450805 | 4029 | 8 | 0.519685039370079 |
| 1451860 | 1451860 | 450806 450806 | 4029 | 8 | 0.519685039370079 |
| 1451863 | 1451863 | 450807 450807 | 4029 | 8 | 0.519685039370079 |
| 1451866 | 1451866 | 450808 450808 | 4029 | 8 | 0.519685039370079 |
| 1451869 | 1451869 | 450809 450809 | 4029 | 8 | 0.519685039370079 |
| 1451872 | 1451872 | 450810 450810 | 4029 | 8 | 0.519685039370079 |
| 1451875 | 1451875 | 450811 450811 | 4029 | 8 | 0.519685039370079 |
| 1451878 | 1451878 | 450812 450812 | 4029 | 8 | 0.519685039370079 |
| 1451881 | 1451881 | 450813 450813 | 4029 | 8 | 0.519685039370079 |
| 1591646 | 1591646 | 480419 480419 | 4029 | 8 | 0.519685039370079 |
| 1615087 | 1615087 | 487645 487645 | 4029 | 8 | 0.519685039370079 |
| 1720926 | 1720926 | 527074 527074 | 4029 | 4 | 0.506024096385542 |
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)
);