home / zeropm-v0-0-4

consensus_index

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

29 rows where inventory_id = 427891

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1317450 1317450 427891 427891 50 1 0.0434081346911564
1317451 1317451 427891 427891 5026 1 0.0144693782303855
1317452 1317452 427891 427891 13102 1 0.0325561010183673
1317453 1317453 427891 427891 19292 1 0.0236771643769944
1317454 1317454 427891 427891 31986 1 0.0118385821884972
1317455 1317455 427891 427891 43529 1 0.0162780505091837
1317456 1317456 427891 427891 50396 1 0.0124023241974733
1317457 1317457 427891 427891 56841 1 0.00898099338437719
1317458 1317458 427891 427891 57219 1 0.0137078320077336
1317459 1317459 427891 427891 61367 10 0.167831653177846
1317460 1317460 427891 427891 75145 2 0.130224404073469
1317461 1317461 427891 427891 91291 2 0.0492201982585695
1317462 1317462 427891 427891 91427 1 0.0173632538764626
1317463 1317463 427891 427891 91431 1 0.0113238612237799
1317464 1317464 427891 427891 97057 1 0.0217040673455782
1317465 1317465 427891 427891 97370 1 0.0153205181262905
1317466 1317466 427891 427891 138664 1 0.0868162693823128
1317467 1317467 427891 427891 153141 1 0.0200345237036107
1317468 1317468 427891 427891 175261 1 0.0289387564607709
1317469 1317469 427891 427891 178281 1 0.00930174314810494
1317470 1317470 427891 427891 180035 1 0.0520897616293877
1317471 1317471 427891 427891 203079 1 0.0104179523258775
1317472 1317472 427891 427891 203382 1 0.0651122020367346
1317473 1317473 427891 427891 207203 1 0.0130224404073469
1317474 1317474 427891 427891 210591 1 0.0108520336727891
1317475 1317475 427891 427891 219653 1 0.0260448808146938
1317476 1317476 427891 427891 232687 1 0.0100172618518053
1317477 1317477 427891 427891 234514 1 0.0186034862962099
1317478 1317478 427891 427891 259706 1 0.0520897616293877
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 1601.629ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website