consensus_index

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

28 rows where inchi_id = 5061

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
14465 14465 4470 4470 5061 8 0.519685039370079
24564 24564 7202 7202 5061 8 0.519685039370079
100520 100520 35527 35527 5061 8 0.519685039370079
159829 159829 57488 57488 5061 16 0.358208955223881
159840 159840 57491 57491 5061 3 0.0963863181842898
224373 224373 77403 77403 5061 8 0.445714285714286
239246 239246 81351 81351 5061 1 0.224994510828984
255661 255661 86762 86762 5061 3 0.280848948714781
432319 432319 155479 155479 5061 1 0.0855945035784977
432380 432380 155502 155502 5061 12 0.357142857142857
438273 438273 157083 157083 5061 1 0.224994510828984
444929 444929 159459 159459 5061 3 0.280848948714781
583915 583915 228197 228197 5061 3 0.280848948714781
590032 590032 230301 230301 5061 12 0.357142857142857
676222 676222 241680 241680 5061 1 0.085962399022033
676357 676357 241718 241718 5061 12 0.449339207048458
751035 751035 264027 264027 5061 1 0.0855945035784977
751286 751286 264121 264121 5061 8 0.445714285714286
751290 751290 264122 264122 5061 8 0.519685039370079
892239 892239 312986 312986 5061 4 0.506024096385542
998901 998901 357899 357899 5061 8 0.519685039370079
1209969 1209969 402319 402319 5061 8 0.519685039370079
1209972 1209972 402320 402320 5061 8 0.519685039370079
1209975 1209975 402321 402321 5061 8 0.519685039370079
1453632 1453632 451474 451474 5061 8 0.519685039370079
1591969 1591969 480542 480542 5061 8 0.519685039370079
1618641 1618641 488738 488738 5061 8 0.519685039370079
1721465 1721465 527222 527222 5061 4 0.506024096385542 
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)
);