consensus_index

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

50 rows where inventory_id = 86

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
517 517 86 86 31908 6 0.0405079863106518
518 518 86 86 111360 6 0.0238589266482464
519 519 86 86 136618 4 0.0623218690638047
520 520 86 86 138843 2 0.0325129987577024
521 521 86 86 138847 1 0.0108376662525675
522 522 86 86 161135 4 0.195077992546214
523 523 86 86 170120 2 0.0151868011226377
524 524 86 86 173315 3 0.0274225251991614
525 525 86 86 185639 1 0.0092894282164864
526 526 86 86 192008 4 0.0881364324624729
527 527 86 86 195587 4 0.0263589413727891
528 528 86 86 195739 2 0.0216753325051349
529 529 86 86 196012 4 0.00974811683070042
530 530 86 86 207306 1 0.0121923745341384
531 531 86 86 207526 1 0.0081282496894256
532 532 86 86 207528 1 0.00780311970184858
533 533 86 86 215977 2 0.00971752697249631
534 534 86 86 227576 4 0.00870679146032147
535 535 86 86 230915 4 0.0107313069738484
536 536 86 86 231919 4 0.0563141657547644
537 537 86 86 232304 1 0.00975389962731073
538 538 86 86 232305 4 0.0269533189839177
539 539 86 86 233000 2 0.007260051125773
540 540 86 86 235111 2 0.0212847539824538
541 541 86 86 238760 1 0.0114751760321303
542 542 86 86 238761 2 0.0138635892520225
543 543 86 86 239226 3 0.0219706175626368
544 544 86 86 241859 3 0.0161573719180152
545 545 86 86 249106 1 0.00722511083504498
546 546 86 86 258459 2 0.00905626844919243
547 547 86 86 260055 2 0.00987815813516028
548 548 86 86 262099 2 0.00697597477131708
549 549 86 86 270715 2 0.00876810371628421
550 550 86 86 275022 2 0.00788556047550487
551 551 86 86 277979 2 0.0243847490682768
552 552 86 86 284742 2 0.00745899347033096
553 553 86 86 288244 2 0.00921656883105349
554 554 86 86 288701 2 0.00698491260300489
555 555 86 86 288770 2 0.00673083020208936
556 556 86 86 290638 4 0.0133568924384634
557 557 86 86 292512 2 0.00649538666030038
558 558 86 86 294888 4 0.00840782536415579
559 559 86 86 297896 2 0.00607251266397435
560 560 86 86 309405 4 0.00783460223962098
561 561 86 86 318628 1 0.0102672627655902
562 562 86 86 318629 1 0.00848165184983541
563 563 86 86 318630 1 0.00750299971331594
564 564 86 86 323447 2 0.00600311023994217
565 565 86 86 334271 4 0.00728366756977976
566 566 86 86 339854 4 0.00696929457773075 
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)
);