consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
56 rows where inchi_id = 218709
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 37865 | 37865 | 11392 11392 | 218709 | 1 | 0.259842519685039 |
| 90180 | 90180 | 32200 32200 | 218709 | 1 | 0.259842519685039 |
| 154198 | 154198 | 55435 55435 | 218709 | 1 | 0.253012048192771 |
| 272147 | 272147 | 92323 92323 | 218709 | 1 | 0.258620689655172 |
| 451411 | 451411 | 161994 161994 | 218709 | 1 | 0.259842519685039 |
| 564223 | 564223 | 221669 221669 | 218709 | 2 | 0.263157894736842 |
| 699291 | 699291 | 249210 249210 | 218709 | 1 | 0.259842519685039 |
| 793343 | 793343 | 276907 276907 | 218709 | 1 | 0.253012048192771 |
| 793346 | 793346 | 276908 276908 | 218709 | 1 | 0.253012048192771 |
| 793349 | 793349 | 276909 276909 | 218709 | 1 | 0.253012048192771 |
| 793352 | 793352 | 276910 276910 | 218709 | 2 | 0.260869565217391 |
| 933741 | 933741 | 332713 332713 | 218709 | 1 | 0.253012048192771 |
| 1051763 | 1051763 | 371967 371967 | 218709 | 1 | 0.25531914893617 |
| 1051766 | 1051766 | 371968 371968 | 218709 | 1 | 0.25531914893617 |
| 1051769 | 1051769 | 371969 371969 | 218709 | 1 | 0.25531914893617 |
| 1051772 | 1051772 | 371970 371970 | 218709 | 1 | 0.25531914893617 |
| 1051775 | 1051775 | 371971 371971 | 218709 | 1 | 0.25531914893617 |
| 1051778 | 1051778 | 371972 371972 | 218709 | 1 | 0.25531914893617 |
| 1051781 | 1051781 | 371973 371973 | 218709 | 1 | 0.25531914893617 |
| 1051784 | 1051784 | 371974 371974 | 218709 | 1 | 0.25531914893617 |
| 1051787 | 1051787 | 371975 371975 | 218709 | 1 | 0.25531914893617 |
| 1051790 | 1051790 | 371976 371976 | 218709 | 1 | 0.25531914893617 |
| 1051793 | 1051793 | 371977 371977 | 218709 | 1 | 0.25531914893617 |
| 1051796 | 1051796 | 371978 371978 | 218709 | 1 | 0.25531914893617 |
| 1051799 | 1051799 | 371979 371979 | 218709 | 1 | 0.25531914893617 |
| 1051802 | 1051802 | 371980 371980 | 218709 | 1 | 0.25531914893617 |
| 1051805 | 1051805 | 371981 371981 | 218709 | 1 | 0.25531914893617 |
| 1273965 | 1273965 | 419151 419151 | 218709 | 1 | 0.25531914893617 |
| 1273968 | 1273968 | 419152 419152 | 218709 | 1 | 0.25531914893617 |
| 1273971 | 1273971 | 419153 419153 | 218709 | 1 | 0.25531914893617 |
| 1273974 | 1273974 | 419154 419154 | 218709 | 1 | 0.25531914893617 |
| 1273977 | 1273977 | 419155 419155 | 218709 | 1 | 0.25531914893617 |
| 1273980 | 1273980 | 419156 419156 | 218709 | 1 | 0.25531914893617 |
| 1273983 | 1273983 | 419157 419157 | 218709 | 1 | 0.25531914893617 |
| 1273986 | 1273986 | 419158 419158 | 218709 | 1 | 0.25531914893617 |
| 1273989 | 1273989 | 419159 419159 | 218709 | 1 | 0.25531914893617 |
| 1273992 | 1273992 | 419160 419160 | 218709 | 1 | 0.25531914893617 |
| 1273995 | 1273995 | 419161 419161 | 218709 | 1 | 0.25531914893617 |
| 1273998 | 1273998 | 419162 419162 | 218709 | 1 | 0.25531914893617 |
| 1274001 | 1274001 | 419163 419163 | 218709 | 1 | 0.25531914893617 |
| 1274004 | 1274004 | 419164 419164 | 218709 | 1 | 0.25531914893617 |
| 1274007 | 1274007 | 419165 419165 | 218709 | 1 | 0.25531914893617 |
| 1274010 | 1274010 | 419166 419166 | 218709 | 1 | 0.25531914893617 |
| 1274013 | 1274013 | 419167 419167 | 218709 | 1 | 0.25531914893617 |
| 1492997 | 1492997 | 461949 461949 | 218709 | 1 | 0.25531914893617 |
| 1493000 | 1493000 | 461950 461950 | 218709 | 1 | 0.25531914893617 |
| 1493003 | 1493003 | 461951 461951 | 218709 | 1 | 0.25531914893617 |
| 1493006 | 1493006 | 461952 461952 | 218709 | 1 | 0.25531914893617 |
| 1493009 | 1493009 | 461953 461953 | 218709 | 1 | 0.25531914893617 |
| 1493012 | 1493012 | 461954 461954 | 218709 | 1 | 0.25531914893617 |
| 1493015 | 1493015 | 461955 461955 | 218709 | 1 | 0.25531914893617 |
| 1493018 | 1493018 | 461956 461956 | 218709 | 1 | 0.25531914893617 |
| 1493021 | 1493021 | 461957 461957 | 218709 | 1 | 0.25531914893617 |
| 1598612 | 1598612 | 482846 482846 | 218709 | 1 | 0.25531914893617 |
| 1642101 | 1642101 | 496923 496923 | 218709 | 1 | 0.25531914893617 |
| 1734427 | 1734427 | 531295 531295 | 218709 | 1 | 0.259842519685039 |
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)
);