consensus_index

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

25 rows where inventory_id = 525341

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1714350 1714350 525341 525341 27781 2 0.0619778826042583
1714351 1714351 525341 525341 37157 1 0.011430443198071
1714352 1714352 525341 525341 45328 8 0.240039307159491
1714353 1714353 525341 525341 60779 1 0.0240039307159491
1714354 1714354 525341 525341 60780 1 0.0160026204772994
1714355 1714355 525341 525341 67516 1 0.0400065511932485
1714356 1714356 525341 525341 132347 1 0.0133355170644162
1714357 1714357 525341 525341 133252 1 0.0200032755966242
1714358 1714358 525341 525341 136336 2 0.120019653579745
1714359 1714359 525341 525341 136341 1 0.0600098267898727
1714360 1714360 525341 525341 138168 1 0.034291329594213
1714361 1714361 525341 525341 141957 2 0.0424333554609491
1714362 1714362 525341 525341 147391 2 0.0208140476315657
1714363 1714363 525341 525341 148630 1 0.0218217551963173
1714364 1714364 525341 525341 152494 1 0.0150024566974682
1714365 1714365 525341 525341 199857 1 0.0171456647971065
1714366 1714366 525341 525341 200280 1 0.0120019653579745
1714367 1714367 525341 525341 200653 1 0.0184645620891916
1714368 1714368 525341 525341 203745 1 0.0141199592446759
1714369 1714369 525341 525341 205666 1 0.0266710341288323
1714370 1714370 525341 525341 215571 1 0.0300049133949363
1714371 1714371 525341 525341 232146 1 0.0480078614318982
1714372 1714372 525341 525341 259539 2 0.0295467962119077
1714373 1714373 525341 525341 276661 1 0.0400065511932485
1714374 1714374 525341 525341 309924 2 0.0166838851610091 
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)
);