consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
37 rows where inchi_id = 7023
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 25234 | 25234 | 7420 7420 | 7023 | 8 | 0.521739130434783 |
| 115340 | 115340 | 40224 40224 | 7023 | 8 | 0.521739130434783 |
| 176732 | 176732 | 63032 63032 | 7023 | 1 | 0.0263971191530433 |
| 176969 | 176969 | 63070 63070 | 7023 | 8 | 0.521739130434783 |
| 223371 | 223371 | 77154 77154 | 7023 | 1 | 0.0263959092474976 |
| 225511 | 225511 | 77764 77764 | 7023 | 8 | 0.625 |
| 431777 | 431777 | 155348 155348 | 7023 | 1 | 0.0263959092474976 |
| 433166 | 433166 | 155756 155756 | 7023 | 8 | 0.521739130434783 |
| 586221 | 586221 | 228906 228906 | 7023 | 8 | 0.345323741007194 |
| 598677 | 598677 | 235713 235713 | 7023 | 1 | 0.0263959092474976 |
| 675173 | 675173 | 241429 241429 | 7023 | 1 | 0.0263971191530433 |
| 678390 | 678390 | 242587 242587 | 7023 | 8 | 0.521739130434783 |
| 749701 | 749701 | 263590 263590 | 7023 | 1 | 0.0263959092474976 |
| 755172 | 755172 | 265414 265414 | 7023 | 8 | 0.521739130434783 |
| 755175 | 755175 | 265415 265415 | 7023 | 8 | 0.625 |
| 755177 | 755177 | 265416 265416 | 7023 | 8 | 0.625 |
| 931441 | 931441 | 331688 331688 | 7023 | 2 | 0.630993034743972 |
| 952223 | 952223 | 341624 341624 | 7023 | 4 | 0.6 |
| 1006769 | 1006769 | 359999 359999 | 7023 | 8 | 0.521739130434783 |
| 1006772 | 1006772 | 360000 360000 | 7023 | 8 | 0.521739130434783 |
| 1006775 | 1006775 | 360001 360001 | 7023 | 8 | 0.521739130434783 |
| 1006778 | 1006778 | 360002 360002 | 7023 | 8 | 0.521739130434783 |
| 1218043 | 1218043 | 404340 404340 | 7023 | 8 | 0.521739130434783 |
| 1218046 | 1218046 | 404341 404341 | 7023 | 8 | 0.521739130434783 |
| 1218049 | 1218049 | 404342 404342 | 7023 | 8 | 0.521739130434783 |
| 1218052 | 1218052 | 404343 404343 | 7023 | 8 | 0.521739130434783 |
| 1218055 | 1218055 | 404344 404344 | 7023 | 8 | 0.521739130434783 |
| 1218058 | 1218058 | 404345 404345 | 7023 | 8 | 0.521739130434783 |
| 1218061 | 1218061 | 404346 404346 | 7023 | 8 | 0.521739130434783 |
| 1218064 | 1218064 | 404347 404347 | 7023 | 8 | 0.521739130434783 |
| 1218067 | 1218067 | 404348 404348 | 7023 | 8 | 0.521739130434783 |
| 1459353 | 1459353 | 452981 452981 | 7023 | 8 | 0.521739130434783 |
| 1459356 | 1459356 | 452982 452982 | 7023 | 8 | 0.521739130434783 |
| 1459359 | 1459359 | 452983 452983 | 7023 | 8 | 0.521739130434783 |
| 1592853 | 1592853 | 480810 480810 | 7023 | 8 | 0.521739130434783 |
| 1619481 | 1619481 | 489038 489038 | 7023 | 8 | 0.521739130434783 |
| 1722028 | 1722028 | 527417 527417 | 7023 | 8 | 0.521739130434783 |
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)
);