consensus_index

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

15 rows where inventory_id = 525507

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1715471 1715471 525507 525507 1340 3 0.143747802399169
1715472 1715472 525507 525507 28601 1 0.228185412746558
1715473 1715473 525507 525507 54007 6 0.203290091714233
1715474 1715474 525507 525507 132595 2 0.0760618042488527
1715475 1715475 525507 525507 136277 2 0.0510238094375151
1715476 1715476 525507 525507 139024 2 0.0510238094375151
1715477 1715477 525507 525507 140653 1 0.0190154510622132
1715478 1715478 525507 525507 157551 1 0.0325979161066512
1715479 1715479 525507 525507 169012 2 0.0198609908871021
1715480 1715480 525507 525507 197707 1 0.0253539347496176
1715481 1715481 525507 525507 231807 1 0.0285231765933198
1715482 1715482 525507 525507 254902 2 0.0240528544368247
1715483 1715483 525507 525507 255356 2 0.0329357273685928
1715484 1715484 525507 525507 265325 2 0.0352097735992766
1715485 1715485 525507 525507 270213 2 0.0217566254465408 
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)
);