home / zeropm-v0-0-4

consensus_index

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

30 rows where inchi_id = 139003

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
41469 41469 12588 12588 139003 1 0.105263157894737
123391 123391 42857 42857 139003 1 0.104712041884817
142754 142754 50886 50886 139003 1 0.0818828838257891
168349 168349 60056 60056 139003 2 0.036094438679143
185136 185136 66022 66022 139003 1 0.0453313054525808
298463 298463 100849 100849 139003 1 0.104712041884817
463613 463613 166560 166560 139003 1 0.0434539356235671
503103 503103 201364 201364 139003 1 0.0596017060832674
527740 527740 209760 209760 139003 1 0.0442066332792585
538537 538537 213596 213596 139003 1 0.104712041884817
579001 579001 226744 226744 139003 1 0.159842212057866
591380 591380 230712 230712 139003 1 0.0386740331491713
668673 668673 239563 239563 139003 1 0.081239870133253
748066 748066 263033 263033 139003 1 0.0386923467934586
755296 755296 265457 265457 139003 1 0.3
762173 762173 267320 267320 139003 1 0.0442066332792585
770411 770411 269575 269575 139003 1 0.3
770413 770413 269578 269578 139003 1 0.3
789023 789023 275573 275573 139003 1 0.164972564852564
870445 870445 300260 300260 139003 2 0.454545454545455
959755 959755 345364 345364 139003 1 0.103896103896104
1161543 1161543 390130 390130 139003 1 0.105011933174224
1161548 1161548 390131 390131 139003 1 0.105011933174224
1416212 1416212 441327 441327 139003 1 0.105011933174224
1416217 1416217 441328 441328 139003 1 0.105011933174224
1416222 1416222 441329 441329 139003 1 0.105011933174224
1577785 1577785 475935 475935 139003 1 0.105011933174224
1577790 1577790 475936 475936 139003 1 0.105011933174224
1605436 1605436 484973 484973 139003 1 0.105011933174224
1653386 1653386 500763 500763 139003 1 0.105011933174224
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)
);
Powered by Datasette · Queries took 1083.782ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website