consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
43 rows where inchi_id = 31485
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 5807 | 5807 | 1770 1770 | 31485 | 1 | 0.177606177606178 |
| 8541 | 8541 | 2577 2577 | 31485 | 6 | 0.875 |
| 20180 | 20180 | 5931 5931 | 31485 | 1 | 0.173228346456693 |
| 87488 | 87488 | 31316 31316 | 31485 | 1 | 0.173228346456693 |
| 147303 | 147303 | 53003 53003 | 31485 | 1 | 0.175824175824176 |
| 198993 | 198993 | 70753 70753 | 31485 | 6 | 0.875 |
| 201333 | 201333 | 71455 71455 | 31485 | 1 | 0.173913043478261 |
| 219108 | 219108 | 75934 75934 | 31485 | 1 | 0.173913043478261 |
| 230422 | 230422 | 78947 78947 | 31485 | 8 | 0.625 |
| 290803 | 290803 | 98492 98492 | 31485 | 1 | 0.239130434782609 |
| 428427 | 428427 | 154415 154415 | 31485 | 1 | 0.173913043478261 |
| 457820 | 457820 | 164548 164548 | 31485 | 1 | 0.239130434782609 |
| 515716 | 515716 | 206721 206721 | 31485 | 1 | 0.173228346456693 |
| 515719 | 515719 | 206722 206722 | 31485 | 1 | 0.173913043478261 |
| 515722 | 515722 | 206723 206723 | 31485 | 1 | 0.173913043478261 |
| 520732 | 520732 | 207908 207908 | 31485 | 5 | 0.857142857142857 |
| 520733 | 520733 | 207909 207909 | 31485 | 7 | 0.888888888888889 |
| 531515 | 531515 | 210813 210813 | 31485 | 1 | 0.173228346456693 |
| 565877 | 565877 | 222202 222202 | 31485 | 8 | 0.625 |
| 662081 | 662081 | 237265 237265 | 31485 | 8 | 0.9 |
| 667403 | 667403 | 239146 239146 | 31485 | 1 | 0.175824175824176 |
| 736483 | 736483 | 259745 259745 | 31485 | 1 | 0.175824175824176 |
| 789719 | 789719 | 275808 275808 | 31485 | 8 | 0.9 |
| 789720 | 789720 | 275809 275809 | 31485 | 5 | 0.857142857142857 |
| 789721 | 789721 | 275810 275810 | 31485 | 8 | 0.9 |
| 859104 | 859104 | 297189 297189 | 31485 | 1 | 0.173228346456693 |
| 859107 | 859107 | 297190 297190 | 31485 | 1 | 0.170212765957447 |
| 859110 | 859110 | 297191 297191 | 31485 | 1 | 0.173913043478261 |
| 938125 | 938125 | 335177 335177 | 31485 | 4 | 0.833333333333333 |
| 961327 | 961327 | 346012 346012 | 31485 | 1 | 0.168674698795181 |
| 1176373 | 1176373 | 394743 394743 | 31485 | 1 | 0.173228346456693 |
| 1176376 | 1176376 | 394744 394744 | 31485 | 1 | 0.173228346456693 |
| 1431821 | 1431821 | 446381 446381 | 31485 | 1 | 0.173228346456693 |
| 1431824 | 1431824 | 446382 446382 | 31485 | 1 | 0.173228346456693 |
| 1431827 | 1431827 | 446383 446383 | 31485 | 1 | 0.173228346456693 |
| 1431830 | 1431830 | 446384 446384 | 31485 | 1 | 0.173228346456693 |
| 1431833 | 1431833 | 446385 446385 | 31485 | 1 | 0.173228346456693 |
| 1588432 | 1588432 | 479489 479489 | 31485 | 1 | 0.173228346456693 |
| 1588435 | 1588435 | 479490 479490 | 31485 | 1 | 0.173228346456693 |
| 1607417 | 1607417 | 485625 485625 | 31485 | 1 | 0.173228346456693 |
| 1614059 | 1614059 | 487308 487308 | 31485 | 1 | 0.173228346456693 |
| 1718691 | 1718691 | 526378 526378 | 31485 | 1 | 0.173228346456693 |
| 1723743 | 1723743 | 527883 527883 | 31485 | 4 | 0.833333333333333 |
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)
);