consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inchi_id = 142028
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 33414 | 33414 | 9849 9849 | 142028 | 1 | 0.115727002967359 |
| 118761 | 118761 | 41407 41407 | 142028 | 1 | 0.115727002967359 |
| 144838 | 144838 | 51647 51647 | 142028 | 2 | 0.07458779460907 |
| 255386 | 255386 | 86686 86686 | 142028 | 2 | 0.100671140939597 |
| 305793 | 305793 | 103339 103339 | 142028 | 4 | 0.428162418861584 |
| 444725 | 444725 | 159403 159403 | 142028 | 2 | 0.100671140939597 |
| 584359 | 584359 | 228326 228326 | 142028 | 2 | 0.100671140939597 |
| 587512 | 587512 | 229516 229516 | 142028 | 4 | 0.428162418861584 |
| 680221 | 680221 | 243041 243041 | 142028 | 1 | 0.094488188976378 |
| 758602 | 758602 | 266301 266301 | 142028 | 1 | 0.0843740030742741 |
| 758606 | 758606 | 266302 266302 | 142028 | 1 | 0.115727002967359 |
| 946180 | 946180 | 338993 338993 | 142028 | 1 | 0.113207547169811 |
| 1016442 | 1016442 | 362449 362449 | 142028 | 1 | 0.115727002967359 |
| 1231121 | 1231121 | 407901 407901 | 142028 | 1 | 0.115727002967359 |
| 1466794 | 1466794 | 454839 454839 | 142028 | 1 | 0.115727002967359 |
| 1593438 | 1593438 | 480980 480980 | 142028 | 1 | 0.115727002967359 |
| 1633983 | 1633983 | 493918 493918 | 142028 | 1 | 0.115727002967359 |
| 1658795 | 1658795 | 502670 502670 | 142028 | 4 | 0.435769154529544 |
| 1729914 | 1729914 | 529775 529775 | 142028 | 1 | 0.113207547169811 |
| 1755852 | 1755852 | 538175 538175 | 142028 | 1 | 0.0645126764646784 |
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)
);