contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA816527" and tax_phylum = "Microsporidia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2094843 | 2094843 | PRJNA816527_P_NODE_12502_length_297_cov_1.660714_g12452_i0 | PRJNA816527 | 12502 | 297 | 1.660714 | 4.93232058 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 182 | 3.8799999999999995e-56 | NR | XP_008073899.1 | 948595 | g12452 | i0 | 88.8 | 0.98989898989899 | 98 | 11 | 99 | 0 | 296 | 3 | 37 | 134 | XP_008073899.1 small GTP-binding protein domain [Vavraia culicis subsp. floridensis] | diamond | 294 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 12298394 | 12298394 | PRJNA816527_P_NODE_10310_length_327_cov_3.944882_g10260_i0 | PRJNA816527 | 10310 | 327 | 3.9448820000000002 | 12.89976414 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 194 | 1.73e-61 | NR | XP_008073948.1 | 948595 | g10260 | i0 | 96.3 | 0.990825688073395 | 108 | 4 | 99.1 | 0 | 325 | 2 | 5 | 112 | XP_008073948.1 uncharacterized protein VCUG_00927 [Vavraia culicis subsp. floridensis] | diamond | 324 | 194 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 22496480 | 22496480 | PRJNA816527_P_NODE_7378_length_381_cov_1.000000_g7328_i0 | PRJNA816527 | 7378 | 381 | 1 | 3.81 | Trachipleistophora hominis | 72359 | Fungi | Fungi | 190 | 3.59e-60 | NR | ELQ74559.1 | 72359 | g7328 | i0 | 92 | 0.78740157480315 | 100 | 8 | 78.7 | 0 | 318 | 19 | 1 | 100 | ELQ74559.1 Histone H4 [Trachipleistophora hominis] | diamond | 300 | 190 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Trachipleistophora | Trachipleistophora hominis | |||
| 27086151 | 27086151 | PRJNA816527_P_NODE_7982_length_368_cov_0.908475_g7932_i0 | PRJNA816527 | 7982 | 368 | 0.908475 | 3.343188 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 114 | 1.82e-29 | NR | XP_008075168.1 | 948595 | g7932 | i0 | 58.1 | 0.758152173913043 | 93 | 37 | 75.8 | 1 | 89 | 367 | 11 | 101 | XP_008075168.1 uncharacterized protein VCUG_02155 [Vavraia culicis subsp. floridensis] | diamond | 279 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 27086152 | 27086152 | PRJNA816527_P_NODE_8802_length_352_cov_1.458781_g8752_i0 | PRJNA816527 | 8802 | 352 | 1.458781 | 5.13490912 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 171 | 2.74e-52 | NR | KRH94038.1 | 146866 | g8752 | i0 | 67.2 | 1.97727272727273 | 116 | 38 | 98.9 | 0 | 350 | 3 | 5 | 120 | KRH94038.1 40S ribosomal protein S15 [Pseudoloma neurophilia] | diamond | 696 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27781110 | 27781110 | PRJNA816527_P_NODE_14564_length_275_cov_1.143564_g14514_i0 | PRJNA816527 | 14564 | 275 | 1.143564 | 3.144801 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 72 | 2.01e-12 | NR | XP_008074600.1 | 948595 | g14514 | i0 | 41.7 | 0.916363636363636 | 84 | 49 | 91.6 | 0 | 260 | 9 | 10 | 93 | XP_008074600.1 uncharacterized protein VCUG_01583 [Vavraia culicis subsp. floridensis] | diamond | 252 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 28160089 | 28160089 | PRJNA816527_P_NODE_14325_length_277_cov_1.509804_g14275_i0 | PRJNA816527 | 14325 | 277 | 1.509804 | 4.18215708 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 51.6 | 3.67e-5 | NR | KRH92775.1 | 146866 | g14275 | i0 | 37.4 | 0.985559566787004 | 91 | 43 | 97.5 | 4 | 8 | 277 | 90 | 167 | KRH92775.1 hypothetical protein M153_2800000189 [Pseudoloma neurophilia] | diamond | 273 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28222862 | 28222862 | PRJNA816527_P_NODE_18166_length_247_cov_2.206897_g18116_i0 | PRJNA816527 | 18166 | 247 | 2.206897 | 5.45103559 | Trachipleistophora hominis | 72359 | Fungi | Fungi | 73.2 | 6.9e-13 | NR | ELQ75773.1 | 72359 | g18116 | i0 | 45 | 1.94331983805668 | 80 | 43 | 97.2 | 1 | 245 | 6 | 213 | 291 | ELQ75773.1 Protein disulfide isomerase (prolyl 4-hydroxylase beta subunit) [Trachipleistophora hominis] | diamond | 480 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Trachipleistophora | Trachipleistophora hominis | |||
| 28380881 | 28380881 | PRJNA816527_P_NODE_14626_length_274_cov_1.378109_g14576_i0 | PRJNA816527 | 14626 | 274 | 1.378109 | 3.77601866 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 53.9 | 2.91e-6 | NR | KRH92482.1 | 146866 | g14576 | i0 | 71 | 0.678832116788321 | 62 | 18 | 67.9 | 0 | 67 | 252 | 16 | 77 | KRH92482.1 hypothetical protein M153_5516000295 [Pseudoloma neurophilia] | diamond | 186 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28926255 | 28926255 | PRJNA816527_P_NODE_7748_length_372_cov_1.926421_g7698_i0 | PRJNA816527 | 7748 | 372 | 1.926421 | 7.16628612 | Pleistophoridae | 35232 | Fungi | Fungi | 197 | 1.09e-60 | NR | ELQ75750.1 | 72359 | g7698 | i0 | 78.9 | 1.98387096774194 | 123 | 26 | 99.2 | 0 | 3 | 371 | 11 | 133 | ELQ75750.1 40S ribosomal protein S4 [Trachipleistophora hominis] | diamond | 738 | 197 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Trachipleistophora | Trachipleistophora hominis | |||
| 29012713 | 29012713 | PRJNA816527_P_NODE_15888_length_260_cov_2.128342_g15838_i0 | PRJNA816527 | 15888 | 260 | 2.128342 | 5.5336892 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 120 | 3.5e-33 | NR | KRH94670.1 | 146866 | g15838 | i0 | 65.9 | 0.980769230769231 | 85 | 29 | 98.1 | 0 | 259 | 5 | 6 | 90 | KRH94670.1 40s ribosomal protein s10 [Pseudoloma neurophilia] | diamond | 255 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29075715 | 29075715 | PRJNA816527_P_NODE_8608_length_356_cov_1.088339_g8558_i0 | PRJNA816527 | 8608 | 356 | 1.088339 | 3.87448684 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 54.7 | 8.33e-6 | NR | KRH93774.1 | 146866 | g8558 | i0 | 40.6 | 0.851123595505618 | 101 | 56 | 81.7 | 2 | 308 | 18 | 271 | 371 | KRH93774.1 hypothetical protein M153_5780002796 [Pseudoloma neurophilia] | diamond | 303 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29485760 | 29485760 | PRJNA816527_P_NODE_18430_length_247_cov_0.885057_g18380_i0 | PRJNA816527 | 18430 | 247 | 0.885057 | 2.18609079 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 45.1 | 0.00599 | NR | KRH93581.1 | 146866 | g18380 | i0 | 57.1 | 0.425101214574899 | 35 | 14 | 41.3 | 1 | 140 | 241 | 87 | 121 | KRH93581.1 ATP-dependent RNA helicase [Pseudoloma neurophilia] | diamond | 105 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29770014 | 29770014 | PRJNA816527_P_NODE_9591_length_338_cov_1.452830_g9541_i0 | PRJNA816527 | 9591 | 338 | 1.45283 | 4.9105654 | Glugea plecoglossi | 40978 | Fungi | Fungi | 211 | 4.45e-65 | NR | AAN35162.1 | 40978 | g9541 | i0 | 90.2 | 0.994082840236686 | 112 | 11 | 99.4 | 0 | 2 | 337 | 10 | 121 | AAN35162.1 alpha-tubulin, partial [Glugea plecoglossi] | diamond | 336 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Glugea | Glugea plecoglossi | |||
| 29991312 | 29991312 | PRJNA816527_P_NODE_18891_length_246_cov_0.890173_g18841_i0 | PRJNA816527 | 18891 | 246 | 0.890173 | 2.18982558 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 95.1 | 1.87e-22 | NR | KRH92413.1 | 146866 | g18841 | i0 | 63 | 0.98780487804878 | 81 | 30 | 98.8 | 0 | 245 | 3 | 5 | 85 | KRH92413.1 hypothetical protein M153_6262000310 [Pseudoloma neurophilia] | diamond | 243 | 95.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 30126087 | 30126087 | PRJNA816527_P_NODE_15232_length_268_cov_1.184615_g15182_i0 | PRJNA816527 | 15232 | 268 | 1.184615 | 3.1747682 | Pleistophoridae | 35232 | Fungi | Fungi | 85.1 | 3.38e-18 | NR | ELQ76147.1 | 72359 | g15182 | i0 | 51.9 | 1.83582089552239 | 81 | 39 | 90.7 | 0 | 3 | 245 | 15 | 95 | ELQ76147.1 putative Emp24/Gp25L/p24 protein [Trachipleistophora hominis] | diamond | 492 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Trachipleistophora | Trachipleistophora hominis | |||
| 30528324 | 30528324 | PRJNA816527_P_NODE_17453_length_249_cov_1.352273_g17403_i0 | PRJNA816527 | 17453 | 249 | 1.352273 | 3.36715977 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 116 | 4.0199999999999998e-28 | NR | KRH95253.1 | 146866 | g17403 | i0 | 62.2 | 0.987951807228916 | 82 | 31 | 98.8 | 0 | 248 | 3 | 615 | 696 | KRH95253.1 Glycosyltransferase [Pseudoloma neurophilia] | diamond | 246 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 30970839 | 30970839 | PRJNA816527_P_NODE_7254_length_384_cov_0.990354_g7204_i0 | PRJNA816527 | 7254 | 384 | 0.990354 | 3.80295936 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 151 | 1.58e-44 | NR | KRH92416.1 | 146866 | g7204 | i0 | 76.7 | 0.8046875 | 103 | 24 | 80.5 | 0 | 71 | 379 | 27 | 129 | KRH92416.1 Histone H2B [Pseudoloma neurophilia] | diamond | 309 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31137057 | 31137057 | PRJNA816527_P_NODE_18575_length_246_cov_1.780347_g18525_i0 | PRJNA816527 | 18575 | 246 | 1.780347 | 4.37965362 | Glugeidae | 36735 | Fungi | Fungi | 150 | 2.62e-41 | NR | BAA06865.1 | 40978 | g18525 | i0 | 85.2 | 1.96341463414634 | 81 | 12 | 98.8 | 0 | 3 | 245 | 113 | 193 | BAA06865.1 elongation factor 1 alpha, partial [Glugea plecoglossi] | diamond | 483 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Glugea | Glugea plecoglossi | |||
| 31286626 | 31286626 | PRJNA816527_P_NODE_13135_length_289_cov_1.884259_g13085_i0 | PRJNA816527 | 13135 | 289 | 1.884259 | 5.44550851 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 61.6 | 1.29e-8 | NR | XP_008075552.1 | 948595 | g13085 | i0 | 59.6 | 1.07958477508651 | 52 | 21 | 54 | 0 | 159 | 4 | 44 | 95 | XP_008075552.1 uncharacterized protein VCUG_02545 [Vavraia culicis subsp. floridensis] | diamond | 312 | 61.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 31697948 | 31697948 | PRJNA816527_P_NODE_14717_length_273_cov_1.540000_g14667_i0 | PRJNA816527 | 14717 | 273 | 1.54 | 4.2042 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 160 | 7.01e-45 | NR | XP_008073260.1 | 948595 | g14667 | i0 | 80.2 | 2 | 91 | 18 | 100 | 0 | 1 | 273 | 257 | 347 | XP_008073260.1 preprotein translocase, SecY subunit [Vavraia culicis subsp. floridensis] | diamond | 546 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 32109244 | 32109244 | PRJNA816527_P_NODE_18818_length_246_cov_0.890173_g18768_i0 | PRJNA816527 | 18818 | 246 | 0.890173 | 2.18982558 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 110 | 9.45e-27 | NR | XP_008073802.1 | 948595 | g18768 | i0 | 72.8 | 0.98780487804878 | 81 | 22 | 98.8 | 0 | 3 | 245 | 292 | 372 | XP_008073802.1 uncharacterized protein VCUG_00779 [Vavraia culicis subsp. floridensis] | diamond | 243 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 32804053 | 32804053 | PRJNA816527_P_NODE_13520_length_285_cov_1.882075_g13470_i0 | PRJNA816527 | 13520 | 285 | 1.882075 | 5.36391375 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 181 | 9.14e-57 | NR | XP_008075364.1 | 948595 | g13470 | i0 | 92.6 | 0.989473684210526 | 94 | 7 | 98.9 | 0 | 2 | 283 | 5 | 98 | XP_008075364.1 uncharacterized protein VCUG_02355 [Vavraia culicis subsp. floridensis] | diamond | 282 | 181 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis |
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);;