consensus_index

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

20 rows where inventory_id = 223346

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
569478 569478 223346 223346 26246 8 0.26753991658971
569479 569479 223346 223346 139287 1 0.0297266573988567
569480 569480 223346 223346 139420 3 0.133769958294855
569481 569481 223346 223346 168053 3 0.0668849791474275
569482 569482 223346 223346 201636 3 0.08917997219657
569483 569483 223346 223346 216842 2 0.0226112498815506
569484 569484 223346 223346 222483 2 0.0412823053783709
569485 569485 223346 223346 226319 2 0.0423017750717476
569486 569486 223346 223346 232091 1 0.0243218105990645
569487 569487 223346 223346 233407 3 0.0202563454933231
569488 569488 223346 223346 237606 3 0.0503529401349485
569489 569489 223346 223346 238947 3 0.0384835825385984
569490 569490 223346 223346 240708 2 0.019831378035169
569491 569491 223346 223346 241947 3 0.0283549460505447
569492 569492 223346 223346 243366 2 0.0230261698088371
569493 569493 223346 223346 260113 2 0.0201665799947965
569494 569494 223346 223346 289279 2 0.0167539994603371
569495 569495 223346 223346 309832 3 0.0187459265081243
569496 569496 223346 223346 320570 2 0.0214203364563386
569497 569497 223346 223346 320704 2 0.0199412480063072 
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)
);