consensus_index

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

21 rows where inventory_id = 283028

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
814322 814322 283028 283028 31939 1 0.199227548925198
814323 814323 283028 283028 51218 1 0.0199227548925198
814324 814324 283028 283028 52206 7 0.180445105634847
814325 814325 283028 283028 75159 2 0.0575120395009761
814326 814326 283028 283028 83488 1 0.0249034436156497
814327 814327 283028 283028 136474 2 0.0514403319395342
814328 814328 283028 283028 137028 2 0.0336756021266529
814329 814329 283028 283028 168930 2 0.0249034436156497
814330 814330 283028 283028 169002 1 0.0332045914875329
814331 814331 283028 283028 169031 2 0.0704375754220909
814332 814332 283028 283028 169090 2 0.0171467773131781
814333 814333 283028 283028 177695 2 0.115024079001952
814334 814334 283028 283028 188233 1 0.0181115953568361
814335 814335 283028 283028 192471 1 0.0249034436156497
814336 814336 283028 283028 206321 1 0.0181115953568361
814337 814337 283028 283028 207704 1 0.022136394325022
814338 814338 283028 283028 214832 1 0.0142305392089427
814339 814339 283028 283028 214833 1 0.0199227548925198
814340 814340 283028 283028 234534 1 0.0117192675838352
814341 814341 283028 283028 238191 2 0.0208847218595559
814342 814342 283028 283028 250674 1 0.0166022957437665 
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)
);