consensus_index

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

28 rows where inchi_id = 47998

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
8026 8026 2430 2430 47998 2 0.1768777236606
19166 19166 5631 5631 47998 1 0.187951807228916
83522 83522 30055 30055 47998 1 0.187951807228916
166942 166942 59715 59715 47998 2 0.177095631641086
202131 202131 71676 71676 47998 1 0.229007633587786
217148 217148 75355 75355 47998 2 0.213143872113677
237625 237625 80884 80884 47998 5 0.382978723404255
427126 427126 154022 154022 47998 2 0.213143872113677
514815 514815 206504 206504 47998 1 0.229007633587786
534121 534121 211950 211950 47998 1 0.229007633587786
734078 734078 258907 258907 47998 2 0.176619007569386
807711 807711 281227 281227 47998 6 0.384615384615385
807714 807714 281228 281228 47998 3 0.375
854612 854612 295606 295606 47998 1 0.229007633587786
854616 854616 295607 295607 47998 1 0.230769230769231
854620 854620 295608 295608 47998 1 0.187951807228916
854625 854625 295609 295609 47998 2 0.213143872113677
854631 854631 295610 295610 47998 1 0.172454622755029
854636 854636 295611 295611 47998 1 0.226415094339623
861078 861078 297740 297740 47998 1 0.212215885571685
881315 881315 306226 306226 47998 1 0.226415094339623
1172560 1172560 393732 393732 47998 1 0.187951807228916
1428008 1428008 445340 445340 47998 1 0.187951807228916
1585755 1585755 478776 478776 47998 1 0.187951807228916
1606715 1606715 485415 485415 47998 1 0.187951807228916
1612598 1612598 486839 486839 47998 1 0.187951807228916
1624839 1624839 490641 490641 47998 6 0.384615384615385
1717939 1717939 526138 526138 47998 2 0.213143872113677 
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)
);