consensus_index

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

15 rows where inventory_id = 5978

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
20355 20355 5978 5978 47902 3 0.148720943761626
20356 20356 5978 5978 91910 3 0.0936883238027521
20357 20357 5978 5978 136302 4 0.145197978955014
20358 20358 5978 5978 138100 4 0.191091286835917
20359 20359 5978 5978 167483 1 0.0540487778989362
20360 20360 5978 5978 191920 2 0.0427293107273021
20361 20361 5978 5978 198142 2 0.0348883361142406
20362 20362 5978 5978 198143 2 0.0307971494315086
20363 20363 5978 5978 206967 2 0.0275816514736272
20364 20364 5978 5978 206968 2 0.0249840564218948
20365 20365 5978 5978 207043 2 0.0228397773020813
20366 20366 5978 5978 218160 3 0.0421264219945282
20367 20367 5978 5978 231795 2 0.0312050764693211
20368 20368 5978 5978 253221 2 0.029486025707349
20369 20369 5978 5978 298020 2 0.0367755352981696 
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)
);