consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
1,127 rows where inchi_id = 123102
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 33547 | 33547 | 9886 9886 | 123102 | 1 | 0.272727272727273 |
| 33549 | 33549 | 9887 9887 | 123102 | 2 | 0.275295868368177 |
| 45293 | 45293 | 13819 13819 | 123102 | 1 | 0.0466864246186812 |
| 50493 | 50493 | 15675 15675 | 123102 | 1 | 0.196338121907467 |
| 121001 | 121001 | 42062 42062 | 123102 | 2 | 0.275295868368177 |
| 123135 | 123135 | 42782 42782 | 123102 | 1 | 0.0466864246186812 |
| 123162 | 123162 | 42789 42789 | 123102 | 5 | 0.234254091466578 |
| 123176 | 123176 | 42792 42792 | 123102 | 1 | 0.196338121907467 |
| 144937 | 144937 | 51667 51667 | 123102 | 5 | 0.0848085467689575 |
| 158565 | 158565 | 57123 57123 | 123102 | 5 | 0.203963364792434 |
| 172518 | 172518 | 61576 61576 | 123102 | 1 | 0.272727272727273 |
| 183666 | 183666 | 65646 65646 | 123102 | 1 | 0.0466864246186812 |
| 185465 | 185465 | 66149 66149 | 123102 | 1 | 0.0798136634625567 |
| 190734 | 190734 | 67918 67918 | 123102 | 3 | 0.186054462670331 |
| 190742 | 190742 | 67919 67919 | 123102 | 5 | 0.234254091466578 |
| 255574 | 255574 | 86738 86738 | 123102 | 1 | 0.272727272727273 |
| 255576 | 255576 | 86739 86739 | 123102 | 2 | 0.275295868368177 |
| 295946 | 295946 | 100141 100141 | 123102 | 1 | 0.0466864246186812 |
| 304812 | 304812 | 103056 103056 | 123102 | 4 | 0.3 |
| 305837 | 305837 | 103353 103353 | 123102 | 3 | 0.186054462670331 |
| 309388 | 309388 | 104520 104520 | 123102 | 2 | 0.170697012802276 |
| 358701 | 358701 | 121745 121745 | 123102 | 5 | 0.234254091466578 |
| 444867 | 444867 | 159437 159437 | 123102 | 1 | 0.269752143389818 |
| 444869 | 444869 | 159438 159438 | 123102 | 1 | 0.262020410288673 |
| 464214 | 464214 | 166791 166791 | 123102 | 2 | 0.343849596088132 |
| 464464 | 464464 | 166924 166924 | 123102 | 1 | 0.0801852293166789 |
| 466449 | 466449 | 168472 168472 | 123102 | 2 | 0.170697012802276 |
| 485256 | 485256 | 179494 179494 | 123102 | 2 | 0.343849596088132 |
| 527698 | 527698 | 209752 209752 | 123102 | 2 | 0.170697012802276 |
| 527704 | 527704 | 209753 209753 | 123102 | 1 | 0.204545454545455 |
| 527708 | 527708 | 209754 209754 | 123102 | 1 | 0.203389830508475 |
| 527712 | 527712 | 209755 209755 | 123102 | 1 | 0.203389830508475 |
| 540978 | 540978 | 214290 214290 | 123102 | 1 | 0.0466864246186812 |
| 557232 | 557232 | 219466 219466 | 123102 | 5 | 0.234254091466578 |
| 582570 | 582570 | 227773 227773 | 123102 | 2 | 0.170697012802276 |
| 584133 | 584133 | 228256 228256 | 123102 | 1 | 0.262020410288673 |
| 584135 | 584135 | 228257 228257 | 123102 | 1 | 0.272727272727273 |
| 588514 | 588514 | 229820 229820 | 123102 | 3 | 0.352941176470588 |
| 660097 | 660097 | 236333 236333 | 123102 | 2 | 0.275295868368177 |
| 660100 | 660100 | 236334 236334 | 123102 | 2 | 0.191552062868369 |
| 660419 | 660419 | 236408 236408 | 123102 | 2 | 0.170697012802276 |
| 680458 | 680458 | 243108 243108 | 123102 | 1 | 0.272727272727273 |
| 680460 | 680460 | 243109 243109 | 123102 | 2 | 0.275295868368177 |
| 681757 | 681757 | 243488 243488 | 123102 | 2 | 0.167167285648249 |
| 726124 | 726124 | 256505 256505 | 123102 | 1 | 0.0466864246186812 |
| 759119 | 759119 | 266452 266452 | 123102 | 1 | 0.272727272727273 |
| 759121 | 759121 | 266453 266453 | 123102 | 1 | 0.269752143389818 |
| 759131 | 759131 | 266456 266456 | 123102 | 2 | 0.275295868368177 |
| 759133 | 759133 | 266457 266457 | 123102 | 1 | 0.262020410288673 |
| 762015 | 762015 | 267281 267281 | 123102 | 1 | 0.194219637525835 |
| 762019 | 762019 | 267282 267282 | 123102 | 1 | 0.195755783681398 |
| 762023 | 762023 | 267283 267283 | 123102 | 1 | 0.203389830508475 |
| 762027 | 762027 | 267284 267284 | 123102 | 1 | 0.194219637525835 |
| 762031 | 762031 | 267285 267285 | 123102 | 1 | 0.195755783681398 |
| 762035 | 762035 | 267286 267286 | 123102 | 1 | 0.195755783681398 |
| 762039 | 762039 | 267287 267287 | 123102 | 1 | 0.195755783681398 |
| 762043 | 762043 | 267288 267288 | 123102 | 1 | 0.204545454545455 |
| 762047 | 762047 | 267289 267289 | 123102 | 2 | 0.170697012802276 |
| 762054 | 762054 | 267290 267290 | 123102 | 4 | 0.195442064737778 |
| 762061 | 762061 | 267291 267291 | 123102 | 1 | 0.196338121907467 |
| 838504 | 838504 | 290868 290868 | 123102 | 1 | 0.0466864246186812 |
| 929943 | 929943 | 331056 331056 | 123102 | 1 | 0.203389830508475 |
| 934886 | 934886 | 333511 333511 | 123102 | 1 | 0.08302071094264 |
| 945832 | 945832 | 338812 338812 | 123102 | 2 | 0.343849596088132 |
| 1018408 | 1018408 | 362922 362922 | 123102 | 1 | 0.272727272727273 |
| 1018410 | 1018410 | 362923 362923 | 123102 | 1 | 0.272727272727273 |
| 1018412 | 1018412 | 362924 362924 | 123102 | 1 | 0.272727272727273 |
| 1018414 | 1018414 | 362925 362925 | 123102 | 1 | 0.272727272727273 |
| 1018416 | 1018416 | 362926 362926 | 123102 | 1 | 0.272727272727273 |
| 1018418 | 1018418 | 362927 362927 | 123102 | 1 | 0.272727272727273 |
| 1018420 | 1018420 | 362928 362928 | 123102 | 1 | 0.272727272727273 |
| 1018422 | 1018422 | 362929 362929 | 123102 | 1 | 0.272727272727273 |
| 1018424 | 1018424 | 362930 362930 | 123102 | 1 | 0.272727272727273 |
| 1018426 | 1018426 | 362931 362931 | 123102 | 1 | 0.272727272727273 |
| 1018431 | 1018431 | 362933 362933 | 123102 | 2 | 0.275295868368177 |
| 1018433 | 1018433 | 362934 362934 | 123102 | 2 | 0.275295868368177 |
| 1018435 | 1018435 | 362935 362935 | 123102 | 2 | 0.275295868368177 |
| 1018437 | 1018437 | 362936 362936 | 123102 | 2 | 0.275295868368177 |
| 1018439 | 1018439 | 362937 362937 | 123102 | 2 | 0.275295868368177 |
| 1018441 | 1018441 | 362938 362938 | 123102 | 2 | 0.275295868368177 |
| 1018443 | 1018443 | 362939 362939 | 123102 | 2 | 0.275295868368177 |
| 1018445 | 1018445 | 362940 362940 | 123102 | 2 | 0.275295868368177 |
| 1018447 | 1018447 | 362941 362941 | 123102 | 2 | 0.275295868368177 |
| 1018449 | 1018449 | 362942 362942 | 123102 | 2 | 0.275295868368177 |
| 1018451 | 1018451 | 362943 362943 | 123102 | 2 | 0.275295868368177 |
| 1018453 | 1018453 | 362944 362944 | 123102 | 2 | 0.275295868368177 |
| 1018455 | 1018455 | 362945 362945 | 123102 | 2 | 0.275295868368177 |
| 1018457 | 1018457 | 362946 362946 | 123102 | 2 | 0.275295868368177 |
| 1018459 | 1018459 | 362947 362947 | 123102 | 2 | 0.275295868368177 |
| 1018461 | 1018461 | 362948 362948 | 123102 | 2 | 0.275295868368177 |
| 1018463 | 1018463 | 362949 362949 | 123102 | 2 | 0.275295868368177 |
| 1018465 | 1018465 | 362950 362950 | 123102 | 2 | 0.275295868368177 |
| 1025976 | 1025976 | 364678 364678 | 123102 | 1 | 0.196338121907467 |
| 1025980 | 1025980 | 364679 364679 | 123102 | 1 | 0.196338121907467 |
| 1025984 | 1025984 | 364680 364680 | 123102 | 1 | 0.196338121907467 |
| 1025988 | 1025988 | 364681 364681 | 123102 | 1 | 0.196338121907467 |
| 1025992 | 1025992 | 364682 364682 | 123102 | 1 | 0.196338121907467 |
| 1025996 | 1025996 | 364683 364683 | 123102 | 1 | 0.196338121907467 |
| 1026000 | 1026000 | 364684 364684 | 123102 | 1 | 0.196338121907467 |
| 1026004 | 1026004 | 364685 364685 | 123102 | 1 | 0.196338121907467 |
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)
);