consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
49 rows where inchi_id = 34912
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 14480 | 14480 | 4474 4474 | 34912 | 1 | 0.0537409693538231 |
| 14487 | 14487 | 4475 4475 | 34912 | 2 | 0.220896475407167 |
| 14495 | 14495 | 4476 4476 | 34912 | 1 | 0.130386988496846 |
| 15119 | 15119 | 4706 4706 | 34912 | 1 | 0.0537409693538231 |
| 15126 | 15126 | 4707 4707 | 34912 | 2 | 0.220896475407167 |
| 44642 | 44642 | 13642 13642 | 34912 | 1 | 0.130386988496846 |
| 87411 | 87411 | 31290 31290 | 34912 | 1 | 0.298019677998211 |
| 87415 | 87415 | 31291 31291 | 34912 | 1 | 0.0799332216166823 |
| 107478 | 107478 | 37807 37807 | 34912 | 6 | 0.192068533216843 |
| 128318 | 128318 | 45851 45851 | 34912 | 2 | 0.220896475407167 |
| 128332 | 128332 | 45853 45853 | 34912 | 1 | 0.0537409693538231 |
| 180330 | 180330 | 64429 64429 | 34912 | 1 | 0.130386988496846 |
| 208931 | 208931 | 73775 73775 | 34912 | 1 | 0.064892986954955 |
| 208936 | 208936 | 73776 73776 | 34912 | 2 | 0.220896475407167 |
| 249522 | 249522 | 84854 84854 | 34912 | 2 | 0.211164617362921 |
| 272645 | 272645 | 92496 92496 | 34912 | 7 | 0.314842364161523 |
| 301757 | 301757 | 102151 102151 | 34912 | 1 | 0.0953082493078182 |
| 421943 | 421943 | 153062 153062 | 34912 | 2 | 0.220896475407167 |
| 504288 | 504288 | 201748 201748 | 34912 | 2 | 0.211164617362921 |
| 511321 | 511321 | 205879 205879 | 34912 | 2 | 0.220896475407167 |
| 533457 | 533457 | 211606 211606 | 34912 | 2 | 0.211164617362921 |
| 543375 | 543375 | 214956 214956 | 34912 | 1 | 0.136575902777621 |
| 556984 | 556984 | 219404 219404 | 34912 | 2 | 0.217572980889904 |
| 556992 | 556992 | 219405 219405 | 34912 | 1 | 0.0739726658761204 |
| 662884 | 662884 | 237679 237679 | 34912 | 1 | 0.064892986954955 |
| 668523 | 668523 | 239516 239516 | 34912 | 1 | 0.113860088527479 |
| 708939 | 708939 | 251639 251639 | 34912 | 1 | 0.0537409693538231 |
| 708950 | 708950 | 251642 251642 | 34912 | 4 | 0.137029140298472 |
| 734604 | 734604 | 259159 259159 | 34912 | 2 | 0.211164617362921 |
| 793908 | 793908 | 277095 277095 | 34912 | 6 | 0.192068533216843 |
| 793923 | 793923 | 277096 277096 | 34912 | 7 | 0.317084218438923 |
| 807623 | 807623 | 281208 281208 | 34912 | 1 | 0.0641758628258988 |
| 807629 | 807629 | 281209 281209 | 34912 | 1 | 0.064892986954955 |
| 807635 | 807635 | 281210 281210 | 34912 | 1 | 0.0428375474751988 |
| 807642 | 807642 | 281211 281211 | 34912 | 1 | 0.0762969237903839 |
| 807647 | 807647 | 281212 281212 | 34912 | 1 | 0.0537409693538231 |
| 807654 | 807654 | 281213 281213 | 34912 | 1 | 0.295195233161436 |
| 807657 | 807657 | 281214 281214 | 34912 | 2 | 0.220896475407167 |
| 834191 | 834191 | 289519 289519 | 34912 | 1 | 0.136575902777621 |
| 834199 | 834199 | 289520 289520 | 34912 | 1 | 0.136575902777621 |
| 834207 | 834207 | 289521 289521 | 34912 | 1 | 0.141314230509866 |
| 834215 | 834215 | 289522 289522 | 34912 | 1 | 0.130386988496846 |
| 914999 | 914999 | 324019 324019 | 34912 | 1 | 0.298019677998211 |
| 915002 | 915002 | 324024 324024 | 34912 | 4 | 0.28838067200524 |
| 1608044 | 1608044 | 485751 485751 | 34912 | 1 | 0.0756275778306869 |
| 1608048 | 1608048 | 485752 485752 | 34912 | 2 | 0.220896475407167 |
| 1714586 | 1714586 | 525380 525380 | 34912 | 1 | 0.0537409693538231 |
| 1714593 | 1714593 | 525381 525381 | 34912 | 2 | 0.220896475407167 |
| 1738762 | 1738762 | 532610 532610 | 34912 | 1 | 0.130386988496846 |
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)
);