home / zeropm-v0-0-4

consensus_index

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

12 rows where inchi_id = 3892

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
25039 25039 7366 7366 3892 1 0.140060834503875
102794 102794 36197 36197 3892 1 0.140060834503875
133814 133814 47459 47459 3892 1 0.123156429991878
195083 195083 69220 69220 3892 9 0.388059701492537
252680 252680 85850 85850 3892 6 0.382978723404255
443717 443717 159067 159067 3892 6 0.382978723404255
591235 591235 230666 230666 3892 3 0.375
678029 678029 242264 242264 3892 1 0.123156429991878
754639 754639 265228 265228 3892 1 0.140060834503875
927336 927336 329813 329813 3892 3 0.375
1632568 1632568 493455 493455 3892 6 0.384615384615385
1721869 1721869 527361 527361 3892 1 0.140060834503875
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 1947.189ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website