home / zeropm-v0-0-4

consensus_index

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

18 rows where inchi_id = 100

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
32382 32382 9529 9529 100 8 0.9
123578 123578 42909 42909 100 8 0.9
169485 169485 60448 60448 100 10 0.916666666666667
251307 251307 85382 85382 100 8 0.9
443274 443274 158889 158889 100 8 0.9
596335 596335 232176 232176 100 8 0.9
668818 668818 239623 239623 100 8 0.9
737258 737258 259972 259972 100 8 0.9
737259 737259 259973 259973 100 6 0.875
967541 967541 351197 351197 100 8 0.9
967542 967542 351198 351198 100 8 0.9
1177416 1177416 395088 395088 100 8 0.9
1177417 1177417 395089 395089 100 8 0.9
1433123 1433123 446775 446775 100 8 0.9
1433124 1433124 446776 446776 100 8 0.9
1589240 1589240 479743 479743 100 8 0.9
1631986 1631986 493232 493232 100 8 0.9
1728773 1728773 529423 529423 100 8 0.9
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 967.648ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website