consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
47 rows where inchi_id = 117009
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 49290 | 49290 | 15142 15142 | 117009 | 1 | 0.109606118893908 |
| 78100 | 78100 | 28198 28198 | 117009 | 6 | 0.341968911917098 |
| 118851 | 118851 | 41438 41438 | 117009 | 6 | 0.341968911917098 |
| 118855 | 118855 | 41439 41439 | 117009 | 1 | 0.109606118893908 |
| 190619 | 190619 | 67903 67903 | 117009 | 4 | 0.199449140023654 |
| 190627 | 190627 | 67904 67904 | 117009 | 4 | 0.207091676714085 |
| 304865 | 304865 | 103067 103067 | 117009 | 6 | 0.341968911917098 |
| 304910 | 304910 | 103078 103078 | 117009 | 2 | 0.122543452634429 |
| 463549 | 463549 | 166542 166542 | 117009 | 6 | 0.281941075708952 |
| 464250 | 464250 | 166804 166804 | 117009 | 6 | 0.341968911917098 |
| 464290 | 464290 | 166820 166820 | 117009 | 2 | 0.122543452634429 |
| 502130 | 502130 | 200427 200427 | 117009 | 3 | 0.279108337439798 |
| 588415 | 588415 | 229795 229795 | 117009 | 1 | 0.116522265181425 |
| 588471 | 588471 | 229809 229809 | 117009 | 6 | 0.341968911917098 |
| 676867 | 676867 | 241877 241877 | 117009 | 1 | 0.109606118893908 |
| 752233 | 752233 | 264413 264413 | 117009 | 4 | 0.199449140023654 |
| 752239 | 752239 | 264414 264414 | 117009 | 1 | 0.109606118893908 |
| 946288 | 946288 | 339059 339059 | 117009 | 3 | 0.336 |
| 946330 | 946330 | 339074 339074 | 117009 | 1 | 0.116522265181425 |
| 999678 | 999678 | 358174 358174 | 117009 | 6 | 0.341968911917098 |
| 999682 | 999682 | 358175 358175 | 117009 | 6 | 0.341968911917098 |
| 999694 | 999694 | 358178 358178 | 117009 | 1 | 0.109606118893908 |
| 999699 | 999699 | 358179 358179 | 117009 | 1 | 0.109606118893908 |
| 999704 | 999704 | 358180 358180 | 117009 | 1 | 0.109606118893908 |
| 999709 | 999709 | 358181 358181 | 117009 | 1 | 0.109606118893908 |
| 1210839 | 1210839 | 402607 402607 | 117009 | 6 | 0.341968911917098 |
| 1210843 | 1210843 | 402608 402608 | 117009 | 6 | 0.341968911917098 |
| 1210855 | 1210855 | 402611 402611 | 117009 | 1 | 0.109606118893908 |
| 1210860 | 1210860 | 402612 402612 | 117009 | 1 | 0.109606118893908 |
| 1210865 | 1210865 | 402613 402613 | 117009 | 1 | 0.109606118893908 |
| 1210870 | 1210870 | 402614 402614 | 117009 | 1 | 0.109606118893908 |
| 1210875 | 1210875 | 402615 402615 | 117009 | 1 | 0.109606118893908 |
| 1210880 | 1210880 | 402616 402616 | 117009 | 1 | 0.109606118893908 |
| 1454236 | 1454236 | 451666 451666 | 117009 | 6 | 0.341968911917098 |
| 1454240 | 1454240 | 451667 451667 | 117009 | 6 | 0.341968911917098 |
| 1454252 | 1454252 | 451670 451670 | 117009 | 1 | 0.109606118893908 |
| 1454257 | 1454257 | 451671 451671 | 117009 | 1 | 0.109606118893908 |
| 1454262 | 1454262 | 451672 451672 | 117009 | 1 | 0.109606118893908 |
| 1454267 | 1454267 | 451673 451673 | 117009 | 1 | 0.109606118893908 |
| 1592209 | 1592209 | 480615 480615 | 117009 | 6 | 0.341968911917098 |
| 1592217 | 1592217 | 480617 480617 | 117009 | 1 | 0.109606118893908 |
| 1656447 | 1656447 | 501920 501920 | 117009 | 6 | 0.281941075708952 |
| 1657464 | 1657464 | 502236 502236 | 117009 | 6 | 0.341968911917098 |
| 1657515 | 1657515 | 502248 502248 | 117009 | 1 | 0.109606118893908 |
| 1743307 | 1743307 | 533920 533920 | 117009 | 6 | 0.281941075708952 |
| 1743737 | 1743737 | 534042 534042 | 117009 | 6 | 0.242122236335857 |
| 1743757 | 1743757 | 534046 534046 | 117009 | 4 | 0.199449140023654 |
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)
);