home / zeropm-v0-0-4

consensus_index

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

16 rows where inchi_id = 93397

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
10711 10711 3267 3267 93397 1 0.454545454545455
111838 111838 39130 39130 93397 2 0.473684210526316
145959 145959 52063 52063 93397 3 0.481481481481481
321110 321110 108209 108209 93397 1 0.466666666666667
506255 506255 202457 202457 93397 1 0.466666666666667
575058 575058 225282 225282 93397 2 0.21505376344086
688431 688431 245492 245492 93397 2 0.473684210526316
773169 773169 270471 270471 93397 2 0.473684210526316
882668 882668 306928 306928 93397 1 0.454545454545455
1037843 1037843 367750 367750 93397 2 0.473684210526316
1257447 1257447 414228 414228 93397 2 0.473684210526316
1257449 1257449 414229 414229 93397 2 0.473684210526316
1482962 1482962 458832 458832 93397 2 0.473684210526316
1595757 1595757 481692 481692 93397 2 0.473684210526316
1665959 1665959 505122 505122 93397 2 0.473684210526316
1747956 1747956 535368 535368 93397 2 0.473684210526316
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 829.793ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website