consensus_index

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

26 rows where inchi_id = 10

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
21169 21169 6247 6247 10 8 0.42368278109723
96291 96291 34132 34132 10 8 0.42368278109723
135129 135129 47890 47890 10 11 0.351845463953087
219691 219691 76097 76097 10 7 0.42368278109723
311309 311309 105100 105100 10 1 0.258956550280926
428899 428899 154547 154547 10 8 0.31413612565445
478500 478500 174694 174694 10 1 0.272727272727273
541343 541343 214369 214369 10 1 0.0468362283098384
581150 581150 227355 227355 10 1 0.258956550280926
596526 596526 232221 232221 10 11 0.426287744227353
668823 668823 239626 239626 10 11 0.351845463953087
737271 737271 259976 259976 10 7 0.422535211267606
737276 737276 259977 259977 10 8 0.42368278109723
737281 737281 259978 259978 10 7 0.422535211267606
737286 737286 259979 259979 10 5 0.297029702970297
737292 737292 259980 259980 10 8 0.42368278109723
737297 737297 259981 259981 10 7 0.422535211267606
954628 954628 342753 342753 10 4 0.417633410672854
967544 967544 351200 351200 10 8 0.42368278109723
1177419 1177419 395091 395091 10 8 0.42368278109723
1433126 1433126 446778 446778 10 8 0.42368278109723
1589242 1589242 479745 479745 10 8 0.42368278109723
1614507 1614507 487457 487457 10 8 0.42368278109723
1661731 1661731 503682 503682 10 1 0.258956550280926
1674623 1674623 508279 508279 10 1 0.272727272727273
1718960 1718960 526460 526460 10 5 0.41958041958042 
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)
);