contig_metadata
21 rows where bioproject = "PRJEB12237", tax_clade = "Opisthokonta" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2570580 | 2570580 | PRJEB12237_P_NODE_3723_length_339_cov_2.273026_g3527_i0 | PRJEB12237 | 3723 | 339 | 2.273026 | 7.70555814 | Fungi | 4751 | Fungi | Fungi | 156 | 5.23e-47 | NR | RKP08967.1 | 78915 | g3527 | i0 | 79.6 | 25.0353982300885 | 93 | 19 | 82.3 | 0 | 2 | 280 | 15 | 107 | RKP08967.1 60S ribosomal protein L30-like protein [Thamnocephalis sphaerospora] | diamond | 8487 | 157 | 0.993630573248408 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Sigmoideomycetaceae | Thamnocephalis | Thamnocephalis sphaerospora | |
| 4813487 | 4813487 | PRJEB12237_P_NODE_9984_length_169_cov_1.171642_g9788_i0 | PRJEB12237 | 9984 | 169 | 1.171642 | 1.98007498 | Entomophthorales | 4857 | Fungi | Fungi | 313 | 5.859999999999999e-81 | NTclustered | gi|22535854|gb|AF296757.1| | 164418 | g9788 | i0 | 100 | 77.0887573964497 | 169 | 0 | 100 | 0 | 1 | 169 | 429 | 261 | Conidiobolus obscurus isolate 560 small subunit ribosomal RNA gene, partial sequence | blastn | 13028 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus obscurus | |
| 15013440 | 15013440 | PRJEB12237_P_NODE_5312_length_262_cov_1.458150_g5116_i0 | PRJEB12237 | 5312 | 262 | 1.45815 | 3.820353 | Coemansia | 4863 | Fungi | Fungi | 106 | 2.0299999999999998e-24 | NR | KAI9472825.1 | 4864 | g5116 | i0 | 61.4 | 6.65267175572519 | 83 | 32 | 95 | 0 | 12 | 260 | 197 | 279 | KAI9472825.1 P-loop containing nucleoside triphosphate hydrolase protein [Coemansia mojavensis] | diamond | 1743 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia mojavensis | |
| 20112166 | 20112166 | PRJEB12237_P_NODE_3236_length_373_cov_1.952663_g3040_i0 | PRJEB12237 | 3236 | 373 | 1.952663 | 7.28343299 | Eukaryota | 2759 | Fungi | Fungi | 52.8 | 0.035 | NTclustered | gi|2572089157|gb|OR502659.1| | 34485 | g3040 | i0 | 100 | 0.46112600536193 | 28 | 0 | 8 | 0 | 121 | 148 | 666 | 693 | Entomophthora muscae strain KVL 14-117 large subunit ribosomal RNA gene, partial sequence | blastn | 172 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 22972639 | 22972639 | PRJEB12237_P_NODE_1139_length_682_cov_4.012365_g980_i0 | PRJEB12237 | 1139 | 682 | 4.012365 | 27.3643293 | Piptocephalis cylindrospora | 1907219 | Fungi | Fungi | 249 | 1.78e-80 | NR | RKP14947.1 | 1907219 | g980 | i0 | 63.3 | 2.63049853372434 | 199 | 73 | 87.5 | 0 | 654 | 58 | 4 | 202 | RKP14947.1 60S ribosomal protein L16 [Piptocephalis cylindrospora] | diamond | 1794 | 249 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis cylindrospora | |
| 22972683 | 22972683 | PRJEB12237_P_NODE_7299_length_208_cov_1.387283_g7103_i0 | PRJEB12237 | 7299 | 208 | 1.387283 | 2.88554864 | Eukaryota | 2759 | Fungi | Fungi | 89 | 8.54e-19 | NR | KAI8320682.1 | 61414 | g7103 | i0 | 68.9 | 13.3413461538462 | 61 | 19 | 88 | 0 | 23 | 205 | 242 | 302 | KAI8320682.1 ribosomal protein L22 [Martensiomyces pterosporus] | diamond | 2775 | 89 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Martensiomyces | Martensiomyces pterosporus | |
| 24246459 | 24246459 | PRJEB12237_P_NODE_11400_length_156_cov_0.991736_g11204_i0 | PRJEB12237 | 11400 | 156 | 0.991736 | 1.54710816 | Conidiobolus pseudapiculatus | 423463 | Fungi | Fungi | 289 | 9e-74 | NTclustered | gi|145307831|gb|EF392398.1| | 423463 | g11204 | i0 | 100 | 76.9807692307692 | 156 | 0 | 100 | 0 | 1 | 156 | 175 | 20 | Conidiobolus pseudapiculatus strain ARSEF 1662 28S ribosomal RNA gene, partial sequence | blastn | 12009 | 289 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus pseudapiculatus | |
| 27222422 | 27222422 | PRJEB12237_P_NODE_11463_length_155_cov_1.666667_g11267_i0 | PRJEB12237 | 11463 | 155 | 1.666667 | 2.58333385 | Syncephalis plumigaleata | 1851185 | Fungi | Fungi | 49.3 | 1.82e-5 | NR | KAI8055824.1 | 1851185 | g11267 | i0 | 76.9 | 1.08387096774194 | 26 | 6 | 50.3 | 0 | 1 | 78 | 115 | 140 | KAI8055824.1 50S ribosomal protein L30e-like protein [Syncephalis plumigaleata] | diamond | 168 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis plumigaleata | |
| 27879564 | 27879564 | PRJEB12237_P_NODE_6445_length_227_cov_1.843750_g6249_i0 | PRJEB12237 | 6445 | 227 | 1.84375 | 4.1853125 | Eukaryota | 2759 | Fungi | Fungi | 57.8 | 1.3e-7 | NR | RKP34012.1 | 215637 | g6249 | i0 | 62.2 | 2.45814977973568 | 45 | 17 | 59.5 | 0 | 4 | 138 | 262 | 306 | RKP34012.1 heme peroxidase [Dimargaris cristalligena] | diamond | 558 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dimargaris | Dimargaris cristalligena | |
| 27980626 | 27980626 | PRJEB12237_P_NODE_6005_length_239_cov_1.764706_g5809_i0 | PRJEB12237 | 6005 | 239 | 1.764706 | 4.21764734 | Smittium simulii | 133385 | Fungi | Fungi | 82 | 1.82e-17 | NR | PVU94845.1 | 133385 | g5809 | i0 | 50 | 2.10878661087866 | 84 | 35 | 97.9 | 3 | 4 | 237 | 21 | 103 | PVU94845.1 hypothetical protein BB561_002225 [Smittium simulii] | diamond | 504 | 82 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium simulii | |
| 28549143 | 28549143 | PRJEB12237_P_NODE_2347_length_462_cov_2.154567_g2151_i0 | PRJEB12237 | 2347 | 462 | 2.154567 | 9.95409954 | Furculomyces boomerangus | 61424 | Fungi | Fungi | 128 | 1.61e-34 | NR | PVU86898.1 | 61424 | g2151 | i0 | 42 | 1.94805194805195 | 150 | 86 | 96.8 | 1 | 8 | 454 | 4 | 153 | PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus] | diamond | 900 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 29237358 | 29237358 | PRJEB12237_P_NODE_589_length_929_cov_3.041387_g482_i0 | PRJEB12237 | 589 | 929 | 3.041387 | 28.25448523 | Fungi | 4751 | Fungi | Fungi | 100 | 4.97e-22 | NR | KAJ1991364.1 | 215637 | g482 | i0 | 41.3 | 1.47578040904198 | 109 | 63 | 34.9 | 1 | 146 | 469 | 21 | 129 | KAJ1991364.1 translation initiation factor eIF5A [Dimargaris cristalligena] | diamond | 1371 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dimargaris | Dimargaris cristalligena | |
| 29868780 | 29868780 | PRJEB12237_P_NODE_7551_length_203_cov_0.952381_g7355_i0 | PRJEB12237 | 7551 | 203 | 0.952381 | 1.93333343 | Coemansia | 4863 | Fungi | Fungi | 85.1 | 4.01e-19 | NR | KAJ2721634.1 | 2663910 | g7355 | i0 | 55.6 | 3.8128078817734 | 63 | 28 | 93.1 | 0 | 10 | 198 | 39 | 101 | KAJ2721634.1 hypothetical protein GGI07_003818 [Coemansia sp. Benny D115] | diamond | 774 | 85.9 | 0.990686845168801 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. Benny D115 | |
| 30854431 | 30854431 | PRJEB12237_P_NODE_3354_length_365_cov_1.327273_g3158_i0 | PRJEB12237 | 3354 | 365 | 1.327273 | 4.84454645 | Coemansia sp. RSA 1365 | 2761419 | Fungi | Fungi | 58.2 | 5.82e-7 | NR | KAJ2610031.1 | 2761419 | g3158 | i0 | 50 | 0.821917808219178 | 50 | 25 | 41.1 | 0 | 365 | 216 | 584 | 633 | KAJ2610031.1 putative proteasome subunit alpha type-7 [Coemansia sp. RSA 1365] | diamond | 300 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 1365 | |
| 31353903 | 31353903 | PRJEB12237_P_NODE_8096_length_194_cov_0.993711_g7900_i0 | PRJEB12237 | 8096 | 194 | 0.993711 | 1.92779934 | Coemansia | 4863 | Fungi | Fungi | 51.2 | 1.79e-5 | NR | KAI9503642.1 | 417178 | g7900 | i0 | 55.6 | 10.3917525773196 | 36 | 16 | 55.7 | 0 | 2 | 109 | 207 | 242 | KAI9503642.1 phosphatidic acid phosphatase type 2/haloperoxidase, partial [Coemansia spiralis] | diamond | 2016 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia spiralis | |
| 31739557 | 31739557 | PRJEB12237_P_NODE_2897_length_406_cov_4.242588_g2701_i0 | PRJEB12237 | 2897 | 406 | 4.242588 | 17.22490728 | Ramicandelaber brevisporus | 304332 | Fungi | Fungi | 102 | 3.19e-25 | NR | KAI8872700.1 | 304332 | g2701 | i0 | 43.6 | 3.2807881773399 | 117 | 58 | 86.5 | 1 | 379 | 29 | 13 | 121 | KAI8872700.1 ribosomal protein S1 [Ramicandelaber brevisporus] | diamond | 1332 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Ramicandelaberales | Ramicandelaberaceae | Ramicandelaber | Ramicandelaber brevisporus | ||
| 32024528 | 32024528 | PRJEB12237_P_NODE_8478_length_188_cov_1.045752_g8282_i0 | PRJEB12237 | 8478 | 188 | 1.045752 | 1.96601376 | Syncephalis fuscata | 1851187 | Fungi | Fungi | 61.6 | 3.08e-9 | NR | KAI9596781.1 | 1851187 | g8282 | i0 | 62.5 | 0.765957446808511 | 48 | 18 | 76.6 | 0 | 6 | 149 | 207 | 254 | KAI9596781.1 60S ribosomal protein L5 [Syncephalis fuscata] | diamond | 144 | 61.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis fuscata | |
| 32271413 | 32271413 | PRJEB12237_P_NODE_9558_length_173_cov_2.724638_g9362_i0 | PRJEB12237 | 9558 | 173 | 2.724638 | 4.71362374 | Zoopagomycota | 1913638 | Fungi | Fungi | 80.1 | 3.56e-17 | NR | KAI8055230.1 | 1851185 | g9362 | i0 | 72 | 9.53757225433526 | 50 | 14 | 86.7 | 0 | 152 | 3 | 1 | 50 | KAI8055230.1 60S ribosomal protein L21-A [Syncephalis plumigaleata] | diamond | 1650 | 80.9 | 0.990111248454882 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis plumigaleata | |
| 32593980 | 32593980 | PRJEB12237_P_NODE_10560_length_163_cov_1.250000_g10364_i0 | PRJEB12237 | 10560 | 163 | 1.25 | 2.0375 | Entomophthora muscae | 34485 | Fungi | Fungi | 68.6 | 8.79e-12 | NR | KAJ9069024.1 | 34485 | g10364 | i0 | 51.9 | 3.97546012269939 | 54 | 26 | 99.4 | 0 | 1 | 162 | 256 | 309 | KAJ9069024.1 hypothetical protein DSO57_1022773 [Entomophthora muscae] | diamond | 648 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 32751305 | 32751305 | PRJEB12237_P_NODE_10400_length_164_cov_1.860465_g10204_i0 | PRJEB12237 | 10400 | 164 | 1.860465 | 3.0511626 | Coemansia brasiliensis | 2650707 | Fungi | Fungi | 73.6 | 4.33e-14 | NR | KAJ2851334.1 | 2650707 | g10204 | i0 | 65.5 | 5.01219512195122 | 55 | 18 | 98.8 | 1 | 2 | 163 | 97 | 151 | KAJ2851334.1 60S ribosomal protein L6 [Coemansia brasiliensis] | diamond | 822 | 73.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia brasiliensis | |
| 32751309 | 32751309 | PRJEB12237_P_NODE_7420_length_205_cov_1.882353_g7224_i0 | PRJEB12237 | 7420 | 205 | 1.882353 | 3.85882365 | Coemansia sp. RSA 376 | 2663904 | Fungi | Fungi | 67.4 | 4.45e-11 | NR | KAJ2260593.1 | 2663904 | g7224 | i0 | 58.5 | 0.775609756097561 | 53 | 22 | 77.6 | 0 | 42 | 200 | 584 | 636 | KAJ2260593.1 transcription factor, contains a PHD finger motif [Coemansia sp. RSA 376] | diamond | 159 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 376 |
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);;