home / zeropm-v0-0-4

consensus_index

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

14 rows where inventory_id = 77167

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
223499 223499 77167 77167 4325 8 0.303304483664433
223500 223500 77167 77167 22313 1 0.101101494554811
223501 223501 77167 77167 45752 1 0.0303304483664433
223502 223502 77167 77167 92885 1 0.0233311141280333
223503 223503 77167 77167 138223 1 0.0505507472774054
223504 223504 77167 77167 138845 1 0.0606608967328865
223505 223505 77167 77167 139437 1 0.151652241832216
223506 223506 77167 77167 170023 1 0.0758261209161081
223507 223507 77167 77167 206042 1 0.0433292119520618
223508 223508 77167 77167 211353 1 0.0379130604580541
223509 223509 77167 77167 221102 1 0.0275731348785848
223510 223510 77167 77167 243977 1 0.0216646059760309
223511 223511 77167 77167 273616 1 0.033700498184937
223512 223512 77167 77167 280031 1 0.0252753736387027
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 654.572ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website