consensus_index

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

38 rows where inchi_id = 38

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
11182 11182 3412 3412 38 9 0.294478527607362
21219 21219 6262 6262 38 6 0.384615384615385
107216 107216 37742 37742 38 6 0.384615384615385
194639 194639 69077 69077 38 9 0.388888888888889
200755 200755 71328 71328 38 6 0.292682926829268
219787 219787 76121 76121 38 6 0.292682926829268
428965 428965 154565 154565 38 5 0.380952380952381
516111 516111 206822 206822 38 6 0.384615384615385
516114 516114 206823 206823 38 6 0.384615384615385
596493 596493 232210 232210 38 9 0.326086956521739
596895 596895 235261 235261 38 5 0.380952380952381
596898 596898 235262 235262 38 6 0.292682926829268
669290 669290 239753 239753 38 8 0.387096774193548
738096 738096 260207 260207 38 6 0.384615384615385
738099 738099 260208 260208 38 6 0.384615384615385
968415 968415 351478 351478 38 6 0.384615384615385
968418 968418 351479 351479 38 6 0.384615384615385
968421 968421 351480 351480 38 6 0.384615384615385
968424 968424 351481 351481 38 6 0.384615384615385
968427 968427 351482 351482 38 6 0.384615384615385
968430 968430 351483 351483 38 6 0.384615384615385
968433 968433 351484 351484 38 6 0.384615384615385
1178393 1178393 395400 395400 38 6 0.384615384615385
1178396 1178396 395401 395401 38 6 0.384615384615385
1178399 1178399 395402 395402 38 6 0.384615384615385
1178402 1178402 395403 395403 38 6 0.384615384615385
1178405 1178405 395404 395404 38 6 0.384615384615385
1178408 1178408 395405 395405 38 6 0.384615384615385
1178411 1178411 395406 395406 38 6 0.384615384615385
1433940 1433940 447036 447036 38 6 0.384615384615385
1433943 1433943 447037 447037 38 6 0.384615384615385
1433946 1433946 447038 447038 38 6 0.384615384615385
1433949 1433949 447039 447039 38 6 0.384615384615385
1433952 1433952 447040 447040 38 6 0.384615384615385
1433955 1433955 447041 447041 38 6 0.384615384615385
1589335 1589335 479775 479775 38 6 0.384615384615385
1614573 1614573 487478 487478 38 6 0.384615384615385
1718991 1718991 526470 526470 38 3 0.378378378378378 
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)
);