consensus_index

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

25 rows where inchi_id = 7316

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
23074 23074 6770 6770 7316 1 0.3125
25338 25338 7438 7438 7316 7 0.517241379310345
97889 97889 34720 34720 7316 7 0.517241379310345
122943 122943 42737 42737 7316 1 0.3125
179739 179739 64168 64168 7316 7 0.517241379310345
185937 185937 66323 66323 7316 1 0.219439210994089
222340 222340 76861 76861 7316 1 0.310344827586207
225846 225846 77820 77820 7316 8 0.413793103448276
282298 282298 95742 95742 7316 1 0.133676092544987
433272 433272 155773 155773 7316 8 0.413793103448276
519710 519710 207679 207679 7316 2 0.0373458117954722
585913 585913 228788 228788 7316 6 0.514285714285714
592413 592413 230987 230987 7316 1 0.307692307692308
673501 673501 240859 240859 7316 1 0.241935483870968
746541 746541 262598 262598 7316 1 0.3125
746543 746543 262599 262599 7316 1 0.307692307692308
922617 922617 327460 327460 7316 1 0.3
961607 961607 346140 346140 7316 4 0.506024096385542
1008829 1008829 360263 360263 7316 7 0.517241379310345
1219859 1219859 404588 404588 7316 7 0.517241379310345
1460891 1460891 453173 453173 7316 7 0.517241379310345
1592945 1592945 480833 480833 7316 7 0.517241379310345
1617586 1617586 488426 488426 7316 1 0.3125
1619598 1619598 489061 489061 7316 7 0.517241379310345
1720418 1720418 526907 526907 7316 1 0.3 
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)
);