consensus_index

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

18 rows where inchi_id = 41857

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
39167 39167 11814 11814 41857 9 0.483250936615753
93156 93156 33125 33125 41857 9 0.483250936615753
142676 142676 50858 50858 41857 5 0.441593045863771
277776 277776 94186 94186 41857 7 0.470219995516654
278774 278774 94517 94517 41857 1 0.310344827586207
453282 453282 162759 162759 41857 7 0.470219995516654
453621 453621 162906 162906 41857 1 0.3
502598 502598 201004 201004 41857 4 0.506024096385542
560442 560442 220437 220437 41857 5 0.441593045863771
667965 667965 239371 239371 41857 9 0.483250936615753
668002 668002 239387 239387 41857 1 0.307692307692308
799914 799914 279046 279046 41857 5 0.441593045863771
799917 799917 279047 279047 41857 8 0.476391089719463
800793 800793 279352 279352 41857 1 0.307692307692308
1644505 1644505 497775 497775 41857 9 0.483250936615753
1644907 1644907 497932 497932 41857 1 0.307692307692308
1735581 1735581 531663 531663 41857 9 0.483250936615753
1735770 1735770 531735 531735 41857 1 0.307692307692308 
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)
);