contig_metadata
26 rows where bioproject = "PRJNA737474", tax_clade = "Sar" and tax_phylum = "Foraminifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25844033 | 25844033 | PRJNA737474c_S_NODE_4451_length_510_cov_6.311213_g3627_i0 | PRJNA737474 | 4451 | 510 | 6.311213 | 32.1871863 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 5.8e-51 | NR | ETO03070.1 | 46433 | g3627 | i0 | 78 | 1.28235294117647 | 109 | 24 | 64.1 | 0 | 3 | 329 | 78 | 186 | ETO03070.1 hypothetical protein RFI_34341 [Reticulomyxa filosa] | diamond | 654 | 171 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 25981291 | 25981291 | PRJNA737474d_S_NODE_21324_length_330_cov_4.408560_g20730_i0 | PRJNA737474 | 21324 | 330 | 4.40856 | 14.548248 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 6.229999999999999e-31 | NR | ETO16550.1 | 46433 | g20730 | i0 | 75.7 | 0.672727272727273 | 74 | 18 | 67.3 | 0 | 329 | 108 | 325 | 398 | ETO16550.1 methionine aminopeptidase [Reticulomyxa filosa] | diamond | 222 | 124 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26118747 | 26118747 | PRJNA737474d_S_NODE_9013_length_516_cov_3.358916_g8440_i0 | PRJNA737474 | 9013 | 516 | 3.358916 | 17.33200656 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 3.26e-44 | NR | ETO17530.1 | 46433 | g8440 | i0 | 84.4 | 3.65697674418605 | 90 | 14 | 52.3 | 0 | 2 | 271 | 102 | 191 | ETO17530.1 hypothetical protein RFI_19788 [Reticulomyxa filosa] | diamond | 1887 | 154 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26253604 | 26253604 | PRJNA737474d_S_NODE_22790_length_319_cov_3.455285_g22196_i0 | PRJNA737474 | 22790 | 319 | 3.455285 | 11.02235915 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 1.52e-17 | NR | ETO14766.1 | 46433 | g22196 | i0 | 60.7 | 0.573667711598746 | 61 | 24 | 57.4 | 0 | 2 | 184 | 100 | 160 | ETO14766.1 hypothetical protein RFI_22603 [Reticulomyxa filosa] | diamond | 183 | 83.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32921038 | 32921038 | PRJNA737474g_S_NODE_97017_length_330_cov_2.782101_g95723_i0 | PRJNA737474 | 97017 | 330 | 2.782101 | 9.1809333 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.0106 | NR | ETO32611.1 | 46433 | g95723 | i0 | 60 | 0.318181818181818 | 35 | 14 | 31.8 | 0 | 2 | 106 | 211 | 245 | ETO32611.1 rab family small GTPase [Reticulomyxa filosa] | diamond | 105 | 45.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32935620 | 32935620 | PRJNA737474b_S_NODE_38561_length_262_cov_1.174603_g37522_i0 | PRJNA737474 | 38561 | 262 | 1.174603 | 3.07745986 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 82.8 | 2.03e-16 | NR | ETO17022.1 | 46433 | g37522 | i0 | 57.7 | 0.812977099236641 | 71 | 30 | 81.3 | 0 | 253 | 41 | 277 | 347 | ETO17022.1 hypothetical protein RFI_20315, partial [Reticulomyxa filosa] | diamond | 213 | 82.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32937442 | 32937442 | PRJNA737474g_S_NODE_186497_length_282_cov_1.373206_g185203_i0 | PRJNA737474 | 186497 | 282 | 1.373206 | 3.87244092 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.6499999999999996e-23 | NR | ETN98481.1 | 46433 | g185203 | i0 | 55.4 | 0.787234042553192 | 74 | 32 | 78.7 | 1 | 278 | 57 | 129 | 201 | ETN98481.1 hypothetical protein RFI_39015, partial [Reticulomyxa filosa] | diamond | 222 | 99 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32954597 | 32954597 | PRJNA737474g_S_NODE_141898_length_300_cov_2.541850_g140604_i0 | PRJNA737474 | 141898 | 300 | 2.54185 | 7.62555 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 8.639999999999998e-35 | NR | ETO11298.1 | 46433 | g140604 | i0 | 62.2 | 0.98 | 98 | 37 | 98 | 0 | 2 | 295 | 35 | 132 | ETO11298.1 hypothetical protein RFI_26081 [Reticulomyxa filosa] | diamond | 294 | 125 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32970233 | 32970233 | PRJNA737474c_S_NODE_28306_length_243_cov_1.100000_g27475_i0 | PRJNA737474 | 28306 | 243 | 1.1 | 2.673 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 2.08e-16 | NR | ETO12402.1 | 46433 | g27475 | i0 | 57.5 | 1.7037037037037 | 73 | 27 | 90.1 | 1 | 23 | 241 | 448 | 516 | ETO12402.1 hypothetical protein RFI_24974, partial [Reticulomyxa filosa] | diamond | 414 | 83.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32970554 | 32970554 | PRJNA737474d_S_NODE_37082_length_251_cov_1.522472_g36488_i0 | PRJNA737474 | 37082 | 251 | 1.522472 | 3.82140472 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 7.07e-7 | NR | ETO16550.1 | 46433 | g36488 | i0 | 85.2 | 0.645418326693227 | 27 | 4 | 32.3 | 0 | 1 | 81 | 372 | 398 | ETO16550.1 methionine aminopeptidase [Reticulomyxa filosa] | diamond | 162 | 56.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32986815 | 32986815 | PRJNA737474b_S_NODE_11003_length_486_cov_5.326877_g9968_i0 | PRJNA737474 | 11003 | 486 | 5.326877 | 25.88862222 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 1.97e-9 | NR | ETO19205.1 | 46433 | g9968 | i0 | 36.7 | 0.487654320987654 | 79 | 44 | 48.8 | 1 | 29 | 265 | 166 | 238 | ETO19205.1 hypothetical protein RFI_18026 [Reticulomyxa filosa] | diamond | 237 | 65.5 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32987210 | 32987210 | PRJNA737474c_S_NODE_24107_length_255_cov_4.252747_g23276_i0 | PRJNA737474 | 24107 | 255 | 4.252747 | 10.84450485 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 7.24e-16 | NR | ETO36017.1 | 46433 | g23276 | i0 | 70.2 | 0.552941176470588 | 47 | 14 | 55.3 | 0 | 2 | 142 | 297 | 343 | ETO36017.1 hypothetical protein RFI_01047 [Reticulomyxa filosa] | diamond | 141 | 81.3 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32987420 | 32987420 | PRJNA737474d_S_NODE_23267_length_316_cov_0.913580_g22673_i0 | PRJNA737474 | 23267 | 316 | 0.91358 | 2.8869128 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 164 | 3.99e-49 | NR | ETO17530.1 | 46433 | g22673 | i0 | 79.6 | 0.930379746835443 | 98 | 20 | 93 | 0 | 314 | 21 | 91 | 188 | ETO17530.1 hypothetical protein RFI_19788 [Reticulomyxa filosa] | diamond | 294 | 164 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 32988224 | 32988224 | PRJNA737474f_S_NODE_32531_length_385_cov_2.368590_g31853_i0 | PRJNA737474 | 32531 | 385 | 2.36859 | 9.1190715 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 6.649999999999998e-30 | NR | ETO11298.1 | 46433 | g31853 | i0 | 58.7 | 0.716883116883117 | 92 | 38 | 71.7 | 0 | 1 | 276 | 41 | 132 | ETO11298.1 hypothetical protein RFI_26081 [Reticulomyxa filosa] | diamond | 276 | 114 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 33010043 | 33010043 | PRJNA737474f_S_NODE_31227_length_390_cov_3.955836_g30549_i0 | PRJNA737474 | 31227 | 390 | 3.955836 | 15.4277604 | Suessiales | 89954 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 8.13e-12 | NR | ETO10631.1 | 46433 | g30549 | i0 | 45.5 | 1.2 | 77 | 41 | 58.5 | 1 | 2 | 229 | 101 | 177 | ETO10631.1 acid ceramidase-like protein [Reticulomyxa filosa] | diamond | 468 | 70.1 | 0.994293865905849 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 33022159 | 33022159 | PRJNA737474f_S_NODE_204772_length_250_cov_2.220339_g204094_i0 | PRJNA737474 | 204772 | 250 | 2.220339 | 5.5508475 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 5.72e-5 | NR | ETO09431.1 | 46433 | g204094 | i0 | 42 | 0.6 | 50 | 29 | 60 | 0 | 198 | 49 | 200 | 249 | ETO09431.1 hypothetical protein RFI_27944 [Reticulomyxa filosa] | diamond | 150 | 50.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 33022448 | 33022448 | PRJNA737474f_S_NODE_49588_length_341_cov_2.522388_g48910_i0 | PRJNA737474 | 49588 | 341 | 2.522388 | 8.60134308 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 84 | 2.44e-17 | NR | ETO14801.1 | 46433 | g48910 | i0 | 48.8 | 1.63636363636364 | 80 | 41 | 70.4 | 0 | 327 | 88 | 35 | 114 | ETO14801.1 hypothetical protein RFI_22567 [Reticulomyxa filosa] | diamond | 558 | 84 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 33038427 | 33038427 | PRJNA737474d_S_NODE_14940_length_397_cov_8.027778_g14346_i0 | PRJNA737474 | 14940 | 397 | 8.027778 | 31.87027866 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 7.66e-4 | NR | ETO22841.1 | 46433 | g14346 | i0 | 30.9 | 0.732997481108312 | 97 | 65 | 73.3 | 1 | 3 | 293 | 1353 | 1447 | ETO22841.1 hypothetical protein RFI_14352 [Reticulomyxa filosa] | diamond | 291 | 49.7 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 33055269 | 33055269 | PRJNA737474c_S_NODE_13917_length_312_cov_3.263598_g13086_i0 | PRJNA737474 | 13917 | 312 | 3.263598 | 10.18242576 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 3.57e-7 | NR | ETO15348.1 | 46433 | g13086 | i0 | 55.8 | 0.5 | 52 | 22 | 50 | 1 | 311 | 156 | 247 | 297 | ETO15348.1 hypothetical protein RFI_22013 [Reticulomyxa filosa] | diamond | 156 | 57.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 33055494 | 33055494 | PRJNA737474d_S_NODE_18693_length_354_cov_4.704626_g18099_i0 | PRJNA737474 | 18693 | 354 | 4.704626 | 16.65437604 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 2.58e-5 | NR | ETO10289.1 | 46433 | g18099 | i0 | 56.8 | 0.372881355932203 | 44 | 19 | 37.3 | 0 | 126 | 257 | 193 | 236 | ETO10289.1 hypothetical protein RFI_27086, partial [Reticulomyxa filosa] | diamond | 132 | 52.8 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 33071919 | 33071919 | PRJNA737474b_S_NODE_10029_length_514_cov_3.403628_g8996_i0 | PRJNA737474 | 10029 | 514 | 3.403628 | 17.49464792 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 3.7799999999999996e-24 | NR | ETO21339.1 | 46433 | g8996 | i0 | 61.3 | 1.07976653696498 | 93 | 33 | 52.5 | 1 | 514 | 245 | 340 | 432 | ETO21339.1 hypothetical protein RFI_15866 [Reticulomyxa filosa] | diamond | 555 | 108 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 33106471 | 33106471 | PRJNA737474b_S_NODE_9302_length_537_cov_5.303879_g8273_i0 | PRJNA737474 | 9302 | 537 | 5.303879 | 28.48183023 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 9.75e-10 | NR | ETO21800.1 | 46433 | g8273 | i0 | 37 | 0.407821229050279 | 73 | 46 | 40.8 | 0 | 10 | 228 | 417 | 489 | ETO21800.1 hypothetical protein RFI_15406 [Reticulomyxa filosa] | diamond | 219 | 68.2 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 33112382 | 33112382 | PRJNA737474g_S_NODE_165302_length_290_cov_1.746544_g164008_i0 | PRJNA737474 | 165302 | 290 | 1.746544 | 5.0649776 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 2.25e-9 | NR | ETO21406.1 | 46433 | g164008 | i0 | 43.3 | 2.42068965517241 | 60 | 34 | 62.1 | 0 | 1 | 180 | 460 | 519 | ETO21406.1 hypothetical protein RFI_15799 [Reticulomyxa filosa] | diamond | 702 | 63.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 33140629 | 33140629 | PRJNA737474c_S_NODE_29039_length_241_cov_1.178571_g28208_i0 | PRJNA737474 | 29039 | 241 | 1.178571 | 2.84035611 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 1.39e-18 | NR | ETO07418.1 | 46433 | g28208 | i0 | 51.3 | 0.995850622406639 | 80 | 38 | 98.3 | 1 | 3 | 239 | 227 | 306 | ETO07418.1 hypothetical protein RFI_29975, partial [Reticulomyxa filosa] | diamond | 240 | 89.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 33141356 | 33141356 | PRJNA737474f_S_NODE_148999_length_267_cov_1.309278_g148321_i0 | PRJNA737474 | 148999 | 267 | 1.309278 | 3.49577226 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 77.4 | 2.81e-14 | NR | ETO25294.1 | 46433 | g148321 | i0 | 68.6 | 2.35955056179775 | 51 | 16 | 57.3 | 0 | 260 | 108 | 103 | 153 | ETO25294.1 hypothetical protein RFI_11843 [Reticulomyxa filosa] | diamond | 630 | 77.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 33157753 | 33157753 | PRJNA737474d_S_NODE_19112_length_350_cov_4.133574_g18518_i0 | PRJNA737474 | 19112 | 350 | 4.133574 | 14.467509 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 3.04e-15 | NR | ETO26409.1 | 46433 | g18518 | i0 | 60.7 | 1.56857142857143 | 61 | 23 | 52.3 | 1 | 6 | 188 | 1204 | 1263 | ETO26409.1 ubiquitin protein ligase, partial [Reticulomyxa filosa] | diamond | 549 | 81.6 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa |
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);;