consensus_index

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

12 rows where inchi_id = 27938

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
138877 138877 49468 49468 27938 3 0.454545454545455
336767 336767 113513 113513 27938 5 0.470588235294118
336843 336843 113535 113535 27938 1 0.21059349074665
357938 357938 121478 121478 27938 3 0.15877502283683
510513 510513 204888 204888 27938 2 0.343849596088132
695040 695040 247873 247873 27938 9 0.274311642776116
707510 707510 251297 251297 27938 2 0.177184821165779
949582 949582 340608 340608 27938 3 0.454545454545455
1751151 1751151 536419 536419 27938 6 0.473684210526316
1751175 1751175 536424 536424 27938 1 0.211841390548615
1755410 1755410 538009 538009 27938 1 0.206896551724138
1766226 1766226 543603 543603 27938 2 0.343849596088132 
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)
);