consensus_index

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

20 rows where inchi_id = 3711

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
23634 23634 6918 6918 3711 7 0.44997514137919
89316 89316 31918 31918 3711 7 0.44997514137919
187346 187346 66722 66722 3711 7 0.44997514137919
223028 223028 77052 77052 3711 7 0.525
297157 297157 100508 100508 3711 2 0.211841390548615
308775 308775 104332 104332 3711 1 0.258620689655172
431474 431474 155258 155258 3711 7 0.525
460214 460214 165457 165457 3711 2 0.211841390548615
466175 466175 168376 168376 3711 1 0.257142857142857
539727 539727 213902 213902 3711 2 0.211841390548615
583097 583097 227936 227936 3711 1 0.258620689655172
591601 591601 230771 230771 3711 7 0.525
748547 748547 263180 263180 3711 7 0.44997514137919
748550 748550 263181 263181 3711 7 0.525
891308 891308 312479 312479 3711 4 0.514285714285714
935680 935680 334039 334039 3711 1 0.253012048192771
1618223 1618223 488607 488607 3711 7 0.44997514137919
1720827 1720827 527038 527038 3711 4 0.514285714285714
1739893 1739893 532897 532897 3711 1 0.205788682372584
1745098 1745098 534514 534514 3711 1 0.2510567450641 
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)
);