home / zeropm-v0-0-4

consensus_index

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

8 rows where inchi_id = 40361

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
232898 232898 79646 79646 40361 1 0.259842519685039
232975 232975 79672 79672 40361 8 0.413793103448276
277901 277901 94231 94231 40361 1 0.171428571428571
361520 361520 122775 122775 40361 1 0.047566331922681
872328 872328 301143 301143 40361 1 0.253012048192771
874975 874975 302485 302485 40361 1 0.168674698795181
903048 903048 318226 318226 40361 1 0.136786552308934
1644562 1644562 497799 497799 40361 1 0.173228346456693
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 1125.019ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website