contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA835051" and tax_clade = "Sar"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27180844 | 27180844 | PRJNA835051_S_NODE_7202_length_352_cov_12.174757_g6906_i0 | PRJNA835051 | 7202 | 352 | 12.174757 | 42.85514464 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 4.41e-8 | NR | SBT57149.1 | 864142 | g6906 | i0 | 56.3 | 0.409090909090909 | 48 | 21 | 40.9 | 0 | 144 | 1 | 972 | 1019 | SBT57149.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 144 | 61.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 27686829 | 27686829 | PRJNA835051_S_NODE_324_length_1078_cov_28.434783_g145_i1 | PRJNA835051 | 324 | 1078 | 28.434783 | 306.52696074 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 3.45e-14 | NR | SBT56012.1 | 864142 | g145 | i1 | 70.7 | 0.317254174397032 | 58 | 17 | 16.1 | 0 | 803 | 630 | 82 | 139 | SBT56012.1 hypothetical protein POVWA2_071070 [Plasmodium ovale wallikeri] | diamond | 342 | 80.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 27781292 | 27781292 | PRJNA835051_S_NODE_101244_length_168_cov_3.056000_g100948_i0 | PRJNA835051 | 101244 | 168 | 3.056 | 5.13408 | Durusdinium trenchii | 1381693 | SAR_Eukaryotes | SAR_Eukaryotes | 41.2 | 0.0463 | NR | CAK9070685.1 | 1381693 | g100948 | i0 | 38.3 | 2.51785714285714 | 47 | 28 | 82.1 | 1 | 152 | 15 | 204 | 250 | CAK9070685.1 unnamed protein product [Durusdinium trenchii] | diamond | 423 | 41.2 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Durusdinium | Durusdinium trenchii | |||
| 27844150 | 27844150 | PRJNA835051_S_NODE_50844_length_215_cov_45.087209_g50548_i0 | PRJNA835051 | 50844 | 215 | 45.087209 | 96.93749935 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 1.46e-8 | NR | SBT57149.1 | 864142 | g50548 | i0 | 59.2 | 0.683720930232558 | 49 | 20 | 68.4 | 0 | 68 | 214 | 972 | 1020 | SBT57149.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 147 | 60.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 27875834 | 27875834 | PRJNA835051_S_NODE_3245_length_443_cov_34.075000_g2952_i0 | PRJNA835051 | 3245 | 443 | 34.075 | 150.95225 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 4.56e-8 | NR | SBT57149.1 | 864142 | g2952 | i0 | 59.2 | 0.331828442437923 | 49 | 20 | 33.2 | 0 | 52 | 198 | 972 | 1020 | SBT57149.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 147 | 62.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 27907221 | 27907221 | PRJNA835051_S_NODE_63885_length_200_cov_1.777070_g63589_i0 | PRJNA835051 | 63885 | 200 | 1.77707 | 3.55414 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 9.4e-7 | NR | SBT55483.1 | 864142 | g63589 | i0 | 50 | 1.605 | 54 | 27 | 81 | 0 | 166 | 5 | 28 | 81 | SBT55483.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 321 | 55.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 28096897 | 28096897 | PRJNA835051_S_NODE_1825_length_538_cov_33.256566_g1547_i0 | PRJNA835051 | 1825 | 538 | 33.256566 | 178.92032508 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 2.94e-6 | NR | SBT55483.1 | 864142 | g1547 | i0 | 58.2 | 0.306691449814126 | 55 | 23 | 30.7 | 0 | 117 | 281 | 46 | 100 | SBT55483.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 165 | 58.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 28096909 | 28096909 | PRJNA835051_S_NODE_7625_length_347_cov_15.125000_g7329_i0 | PRJNA835051 | 7625 | 347 | 15.125 | 52.48375 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 5.94e-6 | NR | SBT57149.1 | 864142 | g7329 | i0 | 54.2 | 0.414985590778098 | 48 | 22 | 41.5 | 0 | 204 | 347 | 972 | 1019 | SBT57149.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 144 | 55.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 28191403 | 28191403 | PRJNA835051_S_NODE_2426_length_487_cov_39.342342_g2138_i0 | PRJNA835051 | 2426 | 487 | 39.342342 | 191.59720554 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 3.26e-7 | NR | SBT57149.1 | 864142 | g2138 | i0 | 59.2 | 0.301848049281314 | 49 | 20 | 30.2 | 0 | 340 | 486 | 972 | 1020 | SBT57149.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 147 | 60.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 28381059 | 28381059 | PRJNA835051_S_NODE_2166_length_506_cov_14.615551_g1882_i0 | PRJNA835051 | 2166 | 506 | 14.615551 | 73.95468806 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 1.7e-10 | NR | SBT55483.1 | 864142 | g1882 | i0 | 72.7 | 0.326086956521739 | 55 | 15 | 32.6 | 0 | 276 | 440 | 55 | 109 | SBT55483.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 165 | 70.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 28665382 | 28665382 | PRJNA835051_S_NODE_8767_length_335_cov_11.493151_g8471_i0 | PRJNA835051 | 8767 | 335 | 11.493151 | 38.50205585 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 5.2e-6 | NR | SBT57149.1 | 864142 | g8471 | i0 | 54.2 | 0.429850746268657 | 48 | 22 | 43 | 0 | 144 | 1 | 972 | 1019 | SBT57149.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 144 | 55.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 28949647 | 28949647 | PRJNA835051_S_NODE_2828_length_464_cov_7.634204_g2537_i0 | PRJNA835051 | 2828 | 464 | 7.634204 | 35.42270656 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 5.37e-4 | NR | SBT55483.1 | 864142 | g2537 | i0 | 54.3 | 1.18318965517241 | 46 | 21 | 29.7 | 0 | 144 | 281 | 28 | 73 | SBT55483.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 549 | 50.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 29202146 | 29202146 | PRJNA835051_S_NODE_1469_length_582_cov_5.298701_g1212_i0 | PRJNA835051 | 1469 | 582 | 5.298701 | 30.83843982 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 1.87e-6 | NR | SBT55340.1 | 864142 | g1212 | i0 | 53.1 | 0.494845360824742 | 49 | 23 | 25.3 | 0 | 581 | 435 | 309 | 357 | SBT55340.1 PIR Superfamily Protein [Plasmodium ovale wallikeri] | diamond | 288 | 58.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 29485951 | 29485951 | PRJNA835051_S_NODE_71250_length_192_cov_9.557047_g70954_i0 | PRJNA835051 | 71250 | 192 | 9.557047 | 18.34953024 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 7.59e-14 | NR | SBT55483.1 | 864142 | g70954 | i0 | 68.8 | 0.75 | 48 | 15 | 75 | 0 | 1 | 144 | 62 | 109 | SBT55483.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 144 | 75.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 29643660 | 29643660 | PRJNA835051_S_NODE_16950_length_287_cov_33.770492_g16654_i0 | PRJNA835051 | 16950 | 287 | 33.770492 | 96.92131204 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 1.28e-12 | NR | SBT57149.1 | 864142 | g16654 | i0 | 73.9 | 0.480836236933798 | 46 | 12 | 48.1 | 0 | 141 | 4 | 972 | 1017 | SBT57149.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 138 | 73.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 29643674 | 29643674 | PRJNA835051_S_NODE_5550_length_378_cov_11.722388_g5254_i0 | PRJNA835051 | 5550 | 378 | 11.722388 | 44.31062664 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 7.77e-15 | NR | SBT55483.1 | 864142 | g5254 | i0 | 60.3 | 0.46031746031746 | 58 | 23 | 46 | 0 | 157 | 330 | 52 | 109 | SBT55483.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 174 | 80.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 30212461 | 30212461 | PRJNA835051_S_NODE_44152_length_225_cov_1.565934_g43856_i0 | PRJNA835051 | 44152 | 225 | 1.565934 | 3.5233515 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 41.2 | 0.0479 | NR | AIZ73304.1 | 5833 | g43856 | i0 | 43.1 | 0.773333333333333 | 58 | 30 | 73.3 | 1 | 38 | 202 | 31 | 88 | AIZ73304.1 erythrocyte membrane protein 1, partial [Plasmodium falciparum] | diamond | 174 | 41.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 30497073 | 30497073 | PRJNA835051_S_NODE_130213_length_151_cov_1.759259_g129917_i0 | PRJNA835051 | 130213 | 151 | 1.759259 | 2.65648109 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 3.11e-6 | NR | SBT57149.1 | 864142 | g129917 | i0 | 62.9 | 0.695364238410596 | 35 | 13 | 69.5 | 0 | 28 | 132 | 973 | 1007 | SBT57149.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 105 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 30497081 | 30497081 | PRJNA835051_S_NODE_38713_length_233_cov_9.873684_g38417_i0 | PRJNA835051 | 38713 | 233 | 9.873684 | 23.00568372 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 2.73e-8 | NR | SBT55701.1 | 864142 | g38417 | i0 | 71.8 | 0.502145922746781 | 39 | 11 | 50.2 | 0 | 117 | 1 | 78 | 116 | SBT55701.1 hypothetical protein POVWA1_071660 [Plasmodium ovale wallikeri] | diamond | 117 | 57.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 30497087 | 30497087 | PRJNA835051_S_NODE_90293_length_176_cov_2.135338_g89997_i0 | PRJNA835051 | 90293 | 176 | 2.135338 | 3.75819488 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.00823 | NR | SBT59076.1 | 864142 | g89997 | i0 | 60 | 2.48863636363636 | 35 | 14 | 59.7 | 0 | 147 | 43 | 14 | 48 | SBT59076.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 438 | 43.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 30623170 | 30623170 | PRJNA835051_S_NODE_3833_length_420_cov_24.045093_g3540_i0 | PRJNA835051 | 3833 | 420 | 24.045093 | 100.9893906 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 8.84e-10 | NR | SBT54812.1 | 864142 | g3540 | i0 | 74.4 | 0.307142857142857 | 43 | 11 | 30.7 | 0 | 249 | 377 | 1 | 43 | SBT54812.1 PIR Superfamily Protein [Plasmodium ovale wallikeri] | diamond | 129 | 67 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 31034377 | 31034377 | PRJNA835051_S_NODE_16235_length_290_cov_8.336032_g15939_i0 | PRJNA835051 | 16235 | 290 | 8.336032 | 24.1744928 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 4.98e-5 | NR | SBT55483.1 | 864142 | g15939 | i0 | 50 | 0.558620689655172 | 54 | 27 | 55.9 | 0 | 127 | 288 | 29 | 82 | SBT55483.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 162 | 51.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 31065909 | 31065909 | PRJNA835051_S_NODE_11815_length_312_cov_80.312268_g11519_i0 | PRJNA835051 | 11815 | 312 | 80.312268 | 250.57427616 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 1.21e-4 | NR | SBT59076.1 | 864142 | g11519 | i0 | 51.1 | 0.432692307692308 | 45 | 22 | 43.3 | 0 | 242 | 108 | 14 | 58 | SBT59076.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 135 | 50.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 31445102 | 31445102 | PRJNA835051_S_NODE_236_length_1207_cov_28.426117_g145_i0 | PRJNA835051 | 236 | 1207 | 28.426117 | 343.10323219000003 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 4.85e-14 | NR | SBT56012.1 | 864142 | g145 | i0 | 70.7 | 0.283347141673571 | 58 | 17 | 14.4 | 0 | 276 | 449 | 82 | 139 | SBT56012.1 hypothetical protein POVWA2_071070 [Plasmodium ovale wallikeri] | diamond | 342 | 80.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 31571785 | 31571785 | PRJNA835051_S_NODE_67416_length_196_cov_3.901961_g67120_i0 | PRJNA835051 | 67416 | 196 | 3.901961 | 7.64784356 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.0247 | NR | SBT58489.1 | 864142 | g67120 | i0 | 66.7 | 0.459183673469388 | 30 | 10 | 45.9 | 0 | 80 | 169 | 128 | 157 | SBT58489.1 hypothetical protein POVWA2_085340 [Plasmodium ovale wallikeri] | diamond | 90 | 42 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 32172892 | 32172892 | PRJNA835051_S_NODE_116738_length_158_cov_2.556522_g116442_i0 | PRJNA835051 | 116738 | 158 | 2.556522 | 4.03930476 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 2.88e-4 | NR | SBT55701.1 | 864142 | g116442 | i0 | 54.5 | 0.626582278481013 | 33 | 15 | 62.7 | 0 | 54 | 152 | 5 | 37 | SBT55701.1 hypothetical protein POVWA1_071660 [Plasmodium ovale wallikeri] | diamond | 99 | 46.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 32867226 | 32867226 | PRJNA835051_S_NODE_38680_length_233_cov_44.305263_g38384_i0 | PRJNA835051 | 38680 | 233 | 44.305263 | 103.23126279 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 1.53e-9 | NR | SBT57149.1 | 864142 | g38384 | i0 | 59.2 | 0.630901287553648 | 49 | 20 | 63.1 | 0 | 52 | 198 | 972 | 1020 | SBT57149.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 147 | 63.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;