consensus_index

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

26 rows where inchi_id = 56278

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
31504 31504 9246 9246 56278 1 0.137931034482759
42698 42698 12968 12968 56278 7 0.262368307124765
86803 86803 31112 31112 56278 1 0.3125
134455 134455 47699 47699 56278 7 0.262368307124765
236161 236161 80513 80513 56278 1 0.3125
246991 246991 84044 84044 56278 1 0.173228346456693
288003 288003 97537 97537 56278 6 0.350835767701278
441667 441667 158321 158321 56278 1 0.172413793103448
539762 539762 213916 213916 56278 1 0.173228346456693
549958 549958 217446 217446 56278 6 0.350835767701278
558153 558153 219761 219761 56278 1 0.3125
716466 716466 253444 253444 56278 10 0.267524248471884
727539 727539 256882 256882 56278 1 0.173913043478261
804050 804050 280285 280285 56278 2 0.314285714285714
804052 804052 280286 280286 56278 1 0.3
804054 804054 280287 280287 56278 1 0.310344827586207
819353 819353 284420 284420 56278 7 0.262368307124765
819358 819358 284421 284421 56278 6 0.350835767701278
819363 819363 284422 284422 56278 6 0.261821107259449
935526 935526 333942 333942 56278 3 0.295259569225378
1624231 1624231 490471 490471 56278 2 0.314285714285714
1630213 1630213 492624 492624 56278 1 0.173913043478261
1644179 1644179 497640 497640 56278 2 0.260869565217391
1648630 1648630 499213 499213 56278 7 0.262368307124765
1725081 1725081 528230 528230 56278 1 0.3125
1737517 1737517 532238 532238 56278 7 0.262368307124765 
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)
);