consensus_index

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

38 rows where inventory_id = 59

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
395 395 59 59 2837 1 0.0275809855091614
396 396 59 59 23336 1 0.0735492946910972
397 397 59 59 30887 1 0.016972914159484
398 398 59 59 43718 1 0.00612910789092477
399 399 59 59 74051 1 0.0245164315636991
400 400 59 59 74052 12 0.220647884073292
401 401 59 59 74372 1 0.00848645707974198
402 402 59 59 80068 1 0.00788028157404613
403 403 59 59 85198 1 0.00689524637729036
404 404 59 59 149064 1 0.0200588985521174
405 405 59 59 149315 1 0.0220647884073292
406 406 59 59 157213 1 0.00596345632630518
407 407 59 59 168342 1 0.00760854772666523
408 408 59 59 171785 1 0.0122582157818495
409 409 59 59 172818 1 0.00959338626405615
410 410 59 59 175250 1 0.0147098589382194
411 411 59 59 178251 1 0.0100294492760587
412 412 59 59 183392 1 0.0063042252592369
413 413 59 59 184889 1 0.00882591536293166
414 414 59 59 187793 1 0.0137904927545807
415 415 59 59 198102 1 0.00919366183638715
416 416 59 59 198544 1 0.00668629951737247
417 417 59 59 202947 2 0.0589706275227765
418 418 59 59 205572 2 0.0780108075413438
419 419 59 59 208113 1 0.0551619710183229
420 420 59 59 208114 1 0.0367746473455486
421 421 59 59 208115 1 0.0441295768146583
422 422 59 59 209265 1 0.00817214385456635
423 423 59 59 209700 1 0.0116130465301732
424 424 59 59 211139 1 0.0110323942036646
425 425 59 59 214338 1 0.0183873236727743
426 426 59 59 216506 1 0.0735492946910972
427 427 59 59 217112 1 0.0129792872984289
428 428 59 59 220562 1 0.0157605631480923
429 429 59 59 226372 1 0.0105070420987282
430 430 59 59 231353 1 0.0071176736797836
431 431 59 59 232432 1 0.00735492946910972
432 432 59 59 249476 1 0.00648964364921446 
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)
);