consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
46 rows where inventory_id = 153677
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 425963 | 425963 | 153677 153677 | 77512 | 8 | 0.202951377618409 |
| 425964 | 425964 | 153677 153677 | 136304 | 2 | 0.101475688809204 |
| 425965 | 425965 | 153677 153677 | 137695 | 2 | 0.0676504592061363 |
| 425966 | 425966 | 153677 153677 | 158886 | 2 | 0.01746727345791 |
| 425967 | 425967 | 153677 153677 | 160457 | 1 | 0.0156116444321853 |
| 425968 | 425968 | 153677 153677 | 169679 | 1 | 0.0184501252380372 |
| 425969 | 425969 | 153677 153677 | 173370 | 1 | 0.028993053945487 |
| 425970 | 425970 | 153677 153677 | 184959 | 1 | 0.0126844611011506 |
| 425971 | 425971 | 153677 153677 | 185892 | 1 | 0.00483217565758116 |
| 425972 | 425972 | 153677 153677 | 185893 | 1 | 0.00615004174601239 |
| 425973 | 425973 | 153677 153677 | 186066 | 1 | 0.0253689222023011 |
| 425974 | 425974 | 153677 153677 | 188273 | 2 | 0.0338252296030681 |
| 425975 | 425975 | 153677 153677 | 195614 | 1 | 0.0405902755236818 |
| 425976 | 425976 | 153677 153677 | 207899 | 1 | 0.00634223055057528 |
| 425977 | 425977 | 153677 153677 | 216247 | 2 | 0.00823076522442608 |
| 425978 | 425978 | 153677 153677 | 232943 | 1 | 0.0169126148015341 |
| 425979 | 425979 | 153677 153677 | 234501 | 1 | 0.028993053945487 |
| 425980 | 425980 | 153677 153677 | 234502 | 1 | 0.00922506261901858 |
| 425981 | 425981 | 153677 153677 | 234503 | 1 | 0.0225501530687121 |
| 425982 | 425982 | 153677 153677 | 234538 | 1 | 0.0253689222023011 |
| 425983 | 425983 | 153677 153677 | 234539 | 1 | 0.0101475688809204 |
| 425984 | 425984 | 153677 153677 | 234540 | 1 | 0.0202951377618409 |
| 425985 | 425985 | 153677 153677 | 234541 | 1 | 0.00882397293993082 |
| 425986 | 425986 | 153677 153677 | 234542 | 1 | 0.00845630740076703 |
| 425987 | 425987 | 153677 153677 | 234567 | 1 | 0.0156116444321853 |
| 425988 | 425988 | 153677 153677 | 234568 | 1 | 0.0144965269727435 |
| 425989 | 425989 | 153677 153677 | 234569 | 1 | 0.0135300918412273 |
| 425990 | 425990 | 153677 153677 | 235151 | 2 | 0.0507378444046022 |
| 425991 | 425991 | 153677 153677 | 237408 | 1 | 0.0119383163304946 |
| 425992 | 425992 | 153677 153677 | 237409 | 1 | 0.011275076534356 |
| 425993 | 425993 | 153677 153677 | 237995 | 1 | 0.0106816514536005 |
| 425994 | 425994 | 153677 153677 | 240699 | 2 | 0.0135300918412273 |
| 425995 | 425995 | 153677 153677 | 249630 | 1 | 0.00966435131516232 |
| 425996 | 425996 | 153677 153677 | 255024 | 2 | 0.0125865101287068 |
| 425997 | 425997 | 153677 153677 | 275429 | 2 | 0.0115642279933358 |
| 425998 | 425998 | 153677 153677 | 284912 | 2 | 0.0108793357953647 |
| 425999 | 425999 | 153677 153677 | 287634 | 1 | 0.00676504592061363 |
| 426000 | 426000 | 153677 153677 | 287635 | 1 | 0.0065468186328519 |
| 426001 | 426001 | 153677 153677 | 320888 | 1 | 0.0144965269727435 |
| 426002 | 426002 | 153677 153677 | 323206 | 1 | 0.00596915816524732 |
| 426003 | 426003 | 153677 153677 | 323232 | 1 | 0.00563753826717802 |
| 426004 | 426004 | 153677 153677 | 324632 | 2 | 0.00885752428887548 |
| 426005 | 426005 | 153677 153677 | 331496 | 1 | 0.0054851723680651 |
| 426006 | 426006 | 153677 153677 | 335134 | 1 | 0.0052038814773951 |
| 426007 | 426007 | 153677 153677 | 335135 | 1 | 0.00507378444046022 |
| 426008 | 426008 | 153677 153677 | 335136 | 1 | 0.004950033600449 |
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)
);