consensus_index

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

26 rows where inchi_id = 84659

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1677 1677 398 398 84659 7 0.385964912280702
45032 45032 13771 13771 84659 1 0.0986842105263158
78322 78322 28315 28315 84659 1 0.0986842105263158
135847 135847 48134 48134 84659 7 0.476190476190476
135996 135996 48200 48200 84659 2 0.0891225622537891
205848 205848 72963 72963 84659 7 0.385964912280702
217602 217602 75476 75476 84659 7 0.620689655172414
295490 295490 100036 100036 84659 1 0.105827945523747
325457 325457 109667 109667 84659 1 0.236842105263158
503349 503349 201450 201450 84659 7 0.620689655172414
725846 725846 256442 256442 84659 1 0.0986842105263158
838048 838048 290756 290756 84659 1 0.0980392156862745
838054 838054 290757 290757 84659 1 0.0980392156862745
838060 838060 290758 290758 84659 1 0.0986842105263158
855729 855729 296000 296000 84659 7 0.476190476190476
855731 855731 296001 296001 84659 7 0.620689655172414
896066 896066 314735 314735 84659 4 0.6
896078 896078 314741 314741 84659 1 0.0980392156862745
1173392 1173392 393909 393909 84659 7 0.620689655172414
1428884 1428884 445533 445533 84659 7 0.620689655172414
1586296 1586296 478897 478897 84659 7 0.620689655172414
1606841 1606841 485456 485456 84659 7 0.620689655172414
1612859 1612859 486925 486925 84659 7 0.620689655172414
1651683 1651683 500275 500275 84659 1 0.0983899821109123
1718047 1718047 526173 526173 84659 4 0.6
1739144 1739144 532721 532721 84659 1 0.0986842105263158 
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)
);