consensus_index

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

24 rows where inchi_id = 57688

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
30671 30671 8956 8956 57688 8 0.519685039370079
135406 135406 47989 47989 57688 1 0.0843989769820972
173052 173052 61817 61817 57688 1 0.125301204819277
233845 233845 79915 79915 57688 1 0.153846153846154
243578 243578 82862 82862 57688 8 0.334661354581673
432964 432964 155691 155691 57688 1 0.0836653386454183
440235 440235 157824 157824 57688 8 0.334661354581673
503767 503767 201570 201570 57688 1 0.152671755725191
549184 549184 217073 217073 57688 8 0.334661354581673
559660 559660 220153 220153 57688 2 0.114845748137344
704166 704166 250731 250731 57688 1 0.125786163522013
717549 717549 253800 253800 57688 8 0.519685039370079
801378 801378 279558 279558 57688 1 0.125301204819277
801383 801383 279559 279559 57688 1 0.151898734177215
821042 821042 285071 285071 57688 8 0.519685039370079
821045 821045 285072 285072 57688 7 0.517241379310345
904542 904542 319025 319025 57688 1 0.150943396226415
907819 907819 320502 320502 57688 4 0.506024096385542
1056018 1056018 373340 373340 57688 1 0.125301204819277
1279311 1279311 420886 420886 57688 1 0.125301204819277
1496329 1496329 463030 463030 57688 1 0.125301204819277
1599729 1599729 483250 483250 57688 1 0.125301204819277
1623298 1623298 490191 490191 57688 1 0.125301204819277
1727068 1727068 528868 528868 57688 5 0.51063829787234 
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)
);