consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inchi_id = 31891
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 40330 | 40330 | 12215 12215 | 31891 | 1 | 0.0569085085737813 |
| 124314 | 124314 | 43136 43136 | 31891 | 1 | 0.0569085085737813 |
| 145603 | 145603 | 51913 51913 | 31891 | 1 | 0.0569085085737813 |
| 282142 | 282142 | 95690 95690 | 31891 | 1 | 0.0593839857192763 |
| 342847 | 342847 | 115729 115729 | 31891 | 8 | 0.625 |
| 454908 | 454908 | 163440 163440 | 31891 | 1 | 0.0597389412590038 |
| 557361 | 557361 | 219500 219500 | 31891 | 1 | 0.0560195713400694 |
| 707849 | 707849 | 251375 251375 | 31891 | 1 | 0.0298038382784449 |
| 805723 | 805723 | 280710 280710 | 31891 | 1 | 0.0597389412590038 |
| 805732 | 805732 | 280711 280711 | 31891 | 1 | 0.0542173494180524 |
| 1059474 | 1059474 | 374323 374323 | 31891 | 1 | 0.0542173494180524 |
| 1059483 | 1059483 | 374324 374324 | 31891 | 1 | 0.0542173494180524 |
| 1283448 | 1283448 | 422037 422037 | 31891 | 1 | 0.0542173494180524 |
| 1283457 | 1283457 | 422038 422038 | 31891 | 1 | 0.0542173494180524 |
| 1283466 | 1283466 | 422039 422039 | 31891 | 1 | 0.0542173494180524 |
| 1499012 | 1499012 | 463769 463769 | 31891 | 1 | 0.0542173494180524 |
| 1499021 | 1499021 | 463770 463770 | 31891 | 1 | 0.0542173494180524 |
| 1600182 | 1600182 | 483394 483394 | 31891 | 1 | 0.0542173494180524 |
| 1646321 | 1646321 | 498466 498466 | 31891 | 1 | 0.0542173494180524 |
| 1736337 | 1736337 | 531919 531919 | 31891 | 1 | 0.0569085085737813 |
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)
);