consensus_index

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

20 rows where inventory_id = 500117

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1651225 1651225 500117 500117 3977 1 0.0118694675244533
1651226 1651226 500117 500117 4325 1 0.0146622834125599
1651227 1651227 500117 500117 14680 1 0.0623147045033796
1651228 1651228 500117 500117 33486 1 0.0498517636027037
1651229 1651229 500117 500117 70946 6 0.184909258139096
1651230 1651230 500117 500117 73273 5 0.188902859905945
1651231 1651231 500117 500117 128290 2 0.176252600487902
1651232 1651232 500117 500117 169388 1 0.0249258818013518
1651233 1651233 500117 500117 169389 1 0.0356084025733598
1651234 1651234 500117 500117 169396 1 0.0226598925466835
1651235 1651235 500117 500117 169448 1 0.0178042012866799
1651236 1651236 500117 500117 169658 1 0.0191737552318091
1651237 1651237 500117 500117 169698 1 0.0131188851586062
1651238 1651238 500117 500117 169733 1 0.0124629409006759
1651239 1651239 500117 500117 176863 2 0.0587508668293008
1651240 1651240 500117 500117 177941 1 0.0155786761258449
1651241 1651241 500117 500117 184359 2 0.0254398715842655
1651242 1651242 500117 500117 197096 1 0.0166172545342346
1651243 1651243 500117 500117 198595 1 0.0276954242237243
1651244 1651244 500117 500117 241510 1 0.0138477121118621 
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)
);