home / zeropm-v0-0-4

consensus_index

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

35 rows where inchi_id = 139366

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
25104 25104 7387 7387 139366 1 0.258620689655172
43457 43457 13243 13243 139366 2 0.0726957524314134
75490 75490 26462 26462 139366 1 0.243864228693887
116036 116036 40474 40474 139366 2 0.0726957524314134
116045 116045 40476 40476 139366 1 0.258620689655172
190050 190050 67769 67769 139366 1 0.258620689655172
191037 191037 67997 67997 139366 2 0.0726957524314134
225361 225361 77719 77719 139366 1 0.257142857142857
340666 340666 114931 114931 139366 2 0.0726957524314134
433056 433056 155724 155724 139366 1 0.257142857142857
510972 510972 205681 205681 139366 2 0.0726957524314134
566465 566465 222401 222401 139366 2 0.0726957524314134
696712 696712 248390 248390 139366 2 0.0726957524314134
754823 754823 265299 265299 139366 1 0.25531914893617
754826 754826 265300 265300 139366 1 0.25531914893617
754829 754829 265301 265301 139366 1 0.259842519685039
788529 788529 275344 275344 139366 1 0.0729809781065183
788535 788535 275345 275345 139366 2 0.0726957524314134
1048514 1048514 371072 371072 139366 2 0.0726957524314134
1048520 1048520 371073 371073 139366 2 0.0726957524314134
1048526 1048526 371074 371074 139366 2 0.0726957524314134
1048532 1048532 371075 371075 139366 2 0.0726957524314134
1048538 1048538 371076 371076 139366 2 0.0726957524314134
1048544 1048544 371077 371077 139366 2 0.0726957524314134
1269985 1269985 418032 418032 139366 2 0.0726957524314134
1269991 1269991 418033 418033 139366 2 0.0726957524314134
1269997 1269997 418034 418034 139366 2 0.0726957524314134
1270003 1270003 418035 418035 139366 2 0.0726957524314134
1490600 1490600 461277 461277 139366 2 0.0726957524314134
1490606 1490606 461278 461278 139366 2 0.0726957524314134
1597941 1597941 482627 482627 139366 2 0.0726957524314134
1619333 1619333 488998 488998 139366 1 0.259842519685039
1674645 1674645 508289 508289 139366 2 0.0726957524314134
1721944 1721944 527384 527384 139366 1 0.253012048192771
1752297 1752297 536816 536816 139366 2 0.0726957524314134
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 1621.597ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website