consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
38 rows where inchi_id = 10097
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 25975 | 25975 | 7604 7604 | 10097 | 6 | 0.384615384615385 |
| 34843 | 34843 | 10315 10315 | 10097 | 2 | 0.260869565217391 |
| 81874 | 81874 | 29475 29475 | 10097 | 6 | 0.384615384615385 |
| 81877 | 81877 | 29476 29476 | 10097 | 2 | 0.260869565217391 |
| 154275 | 154275 | 55483 55483 | 10097 | 6 | 0.384615384615385 |
| 227629 | 227629 | 78280 78280 | 10097 | 5 | 0.382978723404255 |
| 258565 | 258565 | 87546 87546 | 10097 | 2 | 0.171428571428571 |
| 347800 | 347800 | 117456 117456 | 10097 | 4 | 0.461538461538462 |
| 434232 | 434232 | 156029 156029 | 10097 | 5 | 0.382978723404255 |
| 446204 | 446204 | 159821 159821 | 10097 | 2 | 0.171428571428571 |
| 480997 | 480997 | 176358 176358 | 10097 | 5 | 0.470588235294118 |
| 520006 | 520006 | 207750 207750 | 10097 | 5 | 0.382978723404255 |
| 520009 | 520009 | 207751 207751 | 10097 | 5 | 0.382978723404255 |
| 576614 | 576614 | 225999 225999 | 10097 | 2 | 0.171428571428571 |
| 581385 | 581385 | 227431 227431 | 10097 | 5 | 0.382978723404255 |
| 682576 | 682576 | 243795 243795 | 10097 | 9 | 0.294478527607362 |
| 686941 | 686941 | 244987 244987 | 10097 | 1 | 0.259842519685039 |
| 763564 | 763564 | 267715 267715 | 10097 | 6 | 0.384615384615385 |
| 763567 | 763567 | 267716 267716 | 10097 | 6 | 0.292682926829268 |
| 763572 | 763572 | 267717 267717 | 10097 | 5 | 0.382978723404255 |
| 770941 | 770941 | 269755 269755 | 10097 | 1 | 0.259842519685039 |
| 770944 | 770944 | 269756 269756 | 10097 | 1 | 0.253012048192771 |
| 889960 | 889960 | 311167 311167 | 10097 | 3 | 0.375 |
| 922658 | 922658 | 327485 327485 | 10097 | 1 | 0.253012048192771 |
| 1028612 | 1028612 | 365314 365314 | 10097 | 6 | 0.384615384615385 |
| 1028615 | 1028615 | 365315 365315 | 10097 | 6 | 0.384615384615385 |
| 1246924 | 1246924 | 411494 411494 | 10097 | 6 | 0.384615384615385 |
| 1246927 | 1246927 | 411495 411495 | 10097 | 6 | 0.384615384615385 |
| 1246930 | 1246930 | 411496 411496 | 10097 | 6 | 0.384615384615385 |
| 1246933 | 1246933 | 411497 411497 | 10097 | 6 | 0.384615384615385 |
| 1475992 | 1475992 | 456978 456978 | 10097 | 6 | 0.384615384615385 |
| 1475995 | 1475995 | 456979 456979 | 10097 | 6 | 0.384615384615385 |
| 1594286 | 1594286 | 481212 481212 | 10097 | 6 | 0.384615384615385 |
| 1620569 | 1620569 | 489370 489370 | 10097 | 6 | 0.384615384615385 |
| 1635591 | 1635591 | 494461 494461 | 10097 | 1 | 0.259842519685039 |
| 1722796 | 1722796 | 527615 527615 | 10097 | 3 | 0.375 |
| 1731267 | 1731267 | 530136 530136 | 10097 | 2 | 0.260869565217391 |
| 1753689 | 1753689 | 537296 537296 | 10097 | 4 | 0.461538461538462 |
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)
);