consensus_index

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

23 rows where inventory_id = 501908

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1656377 1656377 501908 501908 4755 1 0.0849019953344625
1656378 1656378 501908 501908 45302 1 0.0636764965008469
1656379 1656379 501908 501908 64739 6 0.202160275062187
1656380 1656380 501908 501908 76730 1 0.127352993001694
1656381 1656381 501908 501908 76731 1 0.0509411972006775
1656382 1656382 501908 501908 136467 1 0.0115775448183358
1656383 1656383 501908 501908 136468 2 0.103983283356796
1656384 1656384 501908 501908 185607 1 0.0159191241252117
1656385 1656385 501908 501908 186927 1 0.0318382482504234
1656386 1656386 501908 501908 193959 1 0.0195927681541067
1656387 1656387 501908 501908 195516 1 0.0134055782107046
1656388 1656388 501908 501908 197765 1 0.0212254988336156
1656389 1656389 501908 501908 200179 1 0.0127352993001694
1656390 1656390 501908 501908 200411 1 0.0181932847145277
1656391 1656391 501908 501908 202223 1 0.0283006651114875
1656392 1656392 501908 501908 202224 1 0.0254705986003388
1656393 1656393 501908 501908 202387 1 0.0231550896366716
1656394 1656394 501908 501908 202582 1 0.0149827050590228
1656395 1656395 501908 501908 202870 1 0.0169803990668925
1656396 1656396 501908 501908 204613 1 0.0141503325557437
1656397 1656397 501908 501908 231613 1 0.0121288564763518
1656398 1656398 501908 501908 315679 1 0.0424509976672312
1656399 1656399 501908 501908 315681 1 0.0363865694290554 
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)
);