contig_metadata
18 rows where bioproject = "PRJNA1249535", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20758470 | 20758470 | PRJNA1249535_S_NODE_242937_length_283_cov_6.357143_g239554_i0 | PRJNA1249535 | 242937 | 283 | 6.357143 | 17.99071469 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 492 | 1.2999999999999999e-134 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g239554 | i0 | 99.627 | 93.3745583038869 | 268 | 1 | 95 | 0 | 1 | 268 | 546 | 813 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 26425 | 492 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 26757063 | 26757063 | PRJNA1249535_S_NODE_245641_length_282_cov_3.043062_g242258_i0 | PRJNA1249535 | 245641 | 282 | 3.043062 | 8.58143484 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 129 | 2.19e-35 | NR | KRH93999.1 | 146866 | g242258 | i0 | 100 | 0.691489361702128 | 65 | 0 | 69.1 | 0 | 282 | 88 | 66 | 130 | KRH93999.1 hypothetical protein M153_4420006276 [Pseudoloma neurophilia] | diamond | 195 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27073678 | 27073678 | PRJNA1249535_S_NODE_194362_length_309_cov_3.648305_g190979_i0 | PRJNA1249535 | 194362 | 309 | 3.648305 | 11.27326245 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 207 | 2.45e-63 | NR | KRH92464.1 | 146866 | g190979 | i0 | 100 | 0.990291262135922 | 102 | 0 | 99 | 0 | 2 | 307 | 65 | 166 | KRH92464.1 Global transcriptional regulator, cell division control protein, partial [Pseudoloma neurophilia] | diamond | 306 | 207 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27231743 | 27231743 | PRJNA1249535_S_NODE_240623_length_285_cov_1.849057_g237240_i0 | PRJNA1249535 | 240623 | 285 | 1.849057 | 5.26981245 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 101 | 6.409999999999999e-23 | NR | KRH93141.1 | 146866 | g237240 | i0 | 96.3 | 0.863157894736842 | 82 | 3 | 86.3 | 0 | 1 | 246 | 355 | 436 | KRH93141.1 hypothetical protein M153_14260002472 [Pseudoloma neurophilia] | diamond | 246 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27516106 | 27516106 | PRJNA1249535_S_NODE_251543_length_279_cov_2.650485_g248160_i0 | PRJNA1249535 | 251543 | 279 | 2.650485 | 7.39485315 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 93.2 | 2.2e-21 | NR | KRH93526.1 | 146866 | g248160 | i0 | 95.7 | 0.505376344086022 | 47 | 2 | 50.5 | 0 | 144 | 4 | 1 | 47 | KRH93526.1 putative spore wall protein 2, partial [Pseudoloma neurophilia] | diamond | 141 | 93.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27768943 | 27768943 | PRJNA1249535_S_NODE_252204_length_279_cov_1.160194_g248821_i0 | PRJNA1249535 | 252204 | 279 | 1.160194 | 3.23694126 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 182 | 1.5999999999999998e-57 | NR | KRH92512.1 | 146866 | g248821 | i0 | 100 | 0.989247311827957 | 92 | 0 | 98.9 | 0 | 278 | 3 | 22 | 113 | KRH92512.1 Histone 2A, partial [Pseudoloma neurophilia] | diamond | 276 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28937042 | 28937042 | PRJNA1249535_S_NODE_293728_length_256_cov_2.530055_g290345_i0 | PRJNA1249535 | 293728 | 256 | 2.530055 | 6.4769408 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 166 | 3.82e-46 | NR | KRH94022.1 | 146866 | g290345 | i0 | 98.8 | 0.9375 | 80 | 1 | 93.8 | 0 | 254 | 15 | 538 | 617 | KRH94022.1 Neutral trehalase [Pseudoloma neurophilia] | diamond | 240 | 166 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29599748 | 29599748 | PRJNA1249535_S_NODE_266030_length_271_cov_3.434343_g262647_i0 | PRJNA1249535 | 266030 | 271 | 3.434343 | 9.30706953 | Amphiamblys sp. WSBS2 | 1866961 | Fungi | Fungi | 52 | 2.96e-5 | NR | OIR56586.1 | 1866961 | g262647 | i0 | 56.1 | 1.4280442804428 | 41 | 18 | 45.4 | 0 | 2 | 124 | 630 | 670 | OIR56586.1 MAG: uncharacterized protein A8A55_2666 [Amphiamblys sp. WSBS2006] | diamond | 387 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Amphiacanthidae | Amphiamblys | Amphiamblys sp. WSBS2006 | |||
| 29631246 | 29631246 | PRJNA1249535_S_NODE_231250_length_290_cov_1.797235_g227867_i0 | PRJNA1249535 | 231250 | 290 | 1.797235 | 5.2119815 | Cucumispora dikerogammari | 658444 | Fungi | Fungi | 43.1 | 0.0449 | NR | KAF7685156.1 | 658444 | g227867 | i0 | 40 | 0.46551724137931 | 45 | 27 | 46.6 | 0 | 5 | 139 | 319 | 363 | KAF7685156.1 RNA-directed DNA polymerase from mobile element jockey, partial [Cucumispora dikerogammari] | diamond | 135 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Cucumispora | Cucumispora dikerogammari | ||||
| 30105279 | 30105279 | PRJNA1249535_S_NODE_77092_length_406_cov_4.060060_g73711_i0 | PRJNA1249535 | 77092 | 406 | 4.06006 | 16.4838436 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 229 | 1.5700000000000003e-73 | NR | KRH92911.1 | 146866 | g73711 | i0 | 100 | 0.923645320197044 | 125 | 0 | 92.4 | 0 | 1 | 375 | 120 | 244 | KRH92911.1 hypothetical protein M153_2108000826 [Pseudoloma neurophilia] | diamond | 375 | 229 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31021578 | 31021578 | PRJNA1249535_S_NODE_127055_length_351_cov_2.820144_g123672_i0 | PRJNA1249535 | 127055 | 351 | 2.820144 | 9.89870544 | Pancytospora philotis | 1923975 | Fungi | Fungi | 54.3 | 1.15e-5 | NR | KAI4293155.1 | 1923975 | g123672 | i0 | 47.3 | 0.47008547008547 | 55 | 28 | 46.2 | 1 | 305 | 144 | 619 | 673 | KAI4293155.1 hypothetical protein PAPHI01_2429 [Pancytospora philotis] | diamond | 165 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pancytospora | Pancytospora philotis | ||||
| 31306000 | 31306000 | PRJNA1249535_S_NODE_283175_length_262_cov_2.052910_g279792_i0 | PRJNA1249535 | 283175 | 262 | 2.05291 | 5.3786242 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 178 | 2.3399999999999998e-54 | NR | KRH95070.1 | 146866 | g279792 | i0 | 98.9 | 0.99618320610687 | 87 | 1 | 99.6 | 0 | 2 | 262 | 139 | 225 | KRH95070.1 60s ribosomal protein L15, partial [Pseudoloma neurophilia] | diamond | 261 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31622270 | 31622270 | PRJNA1249535_S_NODE_277116_length_265_cov_3.234375_g273733_i0 | PRJNA1249535 | 277116 | 265 | 3.234375 | 8.57109375 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 63.2 | 4e-10 | NR | KRH95167.1 | 146866 | g273733 | i0 | 100 | 0.633962264150943 | 56 | 0 | 63.4 | 0 | 186 | 19 | 97 | 152 | KRH95167.1 hypothetical protein M153_2200027139 [Pseudoloma neurophilia] | diamond | 168 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32160330 | 32160330 | PRJNA1249535_S_NODE_255078_length_277_cov_3.058824_g251695_i0 | PRJNA1249535 | 255078 | 277 | 3.058824 | 8.47294248 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 178 | 1.27e-53 | NR | KRH92775.1 | 146866 | g251695 | i0 | 100 | 0.855595667870036 | 79 | 0 | 85.6 | 0 | 276 | 40 | 205 | 283 | KRH92775.1 hypothetical protein M153_2800000189 [Pseudoloma neurophilia] | diamond | 237 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32508487 | 32508487 | PRJNA1249535_S_NODE_314459_length_245_cov_2.540698_g311076_i0 | PRJNA1249535 | 314459 | 245 | 2.540698 | 6.2247101 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 167 | 3.35e-47 | NR | KRH92949.1 | 146866 | g311076 | i0 | 100 | 0.942857142857143 | 77 | 0 | 94.3 | 0 | 2 | 232 | 46 | 122 | KRH92949.1 hypothetical protein M153_1976000584 [Pseudoloma neurophilia] | diamond | 231 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32697300 | 32697300 | PRJNA1249535_S_NODE_299780_length_253_cov_1.300000_g296397_i0 | PRJNA1249535 | 299780 | 253 | 1.3 | 3.289 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 174 | 2.8099999999999993e-52 | NR | KRH92371.1 | 146866 | g296397 | i0 | 100 | 0.99604743083004 | 84 | 0 | 99.6 | 0 | 252 | 1 | 187 | 270 | KRH92371.1 hypothetical protein M153_6864000155 [Pseudoloma neurophilia] | diamond | 252 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32760400 | 32760400 | PRJNA1249535_S_NODE_332140_length_232_cov_2.943396_g328757_i0 | PRJNA1249535 | 332140 | 232 | 2.943396 | 6.82867872 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 143 | 5.27e-41 | NR | KRH92093.1 | 146866 | g328757 | i0 | 98.7 | 0.995689655172414 | 77 | 1 | 99.6 | 0 | 231 | 1 | 147 | 223 | KRH92093.1 Tetraspanin family integral membrane protein [Pseudoloma neurophilia] | diamond | 231 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32854696 | 32854696 | PRJNA1249535_S_NODE_101000_length_374_cov_1.677741_g97617_i0 | PRJNA1249535 | 101000 | 374 | 1.677741 | 6.27475134 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 144 | 6.82e-41 | NR | KRH92021.1 | 146866 | g97617 | i0 | 100 | 0.842245989304813 | 105 | 0 | 84.2 | 0 | 3 | 317 | 99 | 203 | KRH92021.1 hypothetical protein M153_14069000139 [Pseudoloma neurophilia] | diamond | 315 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia |
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);;