contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA330616" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 389544 | 389544 | PRJNA330616_P_NODE_12561_length_233_cov_2.086957_g12152_i0 | PRJNA330616 | 12561 | 233 | 2.086957 | 4.86260981 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 141 | 4.33e-29 | NTclustered | gi|1026989847|ref|XM_016753271.1| | 645134 | g12152 | i0 | 84.507 | 5.00429184549356 | 142 | 22 | 61 | 0 | 82 | 223 | 235 | 94 | Spizellomyces punctatus DAOM BR117 60S ribosomal protein L37a (SPPG_05030), mRNA | blastn | 1166 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 1664292 | 1664292 | PRJNA330616_P_NODE_16462_length_206_cov_1.949045_g16053_i0 | PRJNA330616 | 16462 | 206 | 1.949045 | 4.0150327 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 128 | 2.91e-25 | NTclustered | gi|1759152372|ref|XM_031169414.1| | 1806994 | g16053 | i0 | 88.571 | 0.509708737864078 | 105 | 12 | 51 | 0 | 102 | 206 | 647 | 543 | Synchytrium microbalum uncharacterized protein (SmJEL517_g03486), partial mRNA | blastn | 105 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 2940166 | 2940166 | PRJNA330616_P_NODE_12803_length_231_cov_2.736264_g12394_i0 | PRJNA330616 | 12803 | 231 | 2.736264 | 6.32076984 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 122 | 1.55e-23 | NTclustered | gi|1027027577|ref|XM_016756738.1| | 645134 | g12394 | i0 | 79.444 | 46.9134199134199 | 180 | 31 | 77 | 6 | 37 | 213 | 298 | 122 | Spizellomyces punctatus DAOM BR117 uncharacterized protein (SPPG_08592), mRNA | blastn | 10837 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 5493151 | 5493151 | PRJNA330616_P_NODE_17845_length_199_cov_1.320000_g17436_i0 | PRJNA330616 | 17845 | 199 | 1.32 | 2.6268 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 135 | 1.67e-27 | NTclustered | gi|1027028346|ref|XM_016756817.1| | 645134 | g17436 | i0 | 81.988 | 4.7286432160804 | 161 | 27 | 80 | 2 | 40 | 199 | 1733 | 1574 | Spizellomyces punctatus DAOM BR117 ADP,ATP carrier protein 1, mitochondrial, variant (SPPG_08669), partial mRNA | blastn | 941 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 5493298 | 5493298 | PRJNA330616_P_NODE_27305_length_165_cov_8.413793_g26896_i0 | PRJNA330616 | 27305 | 165 | 8.413793 | 13.88275845 | Lobulomycetales sp. | 2058121 | Fungi | Fungi | 106 | 1.04e-18 | NTclustered | gi|2468791005|gb|OQ702918.1| | 2058121 | g26896 | i0 | 95.455 | 38.2424242424242 | 66 | 3 | 40 | 0 | 99 | 164 | 3925 | 3990 | Lobulomycetales sp. isolate PSC233 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 6310 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetales sp. | |||
| 6172313 | 6172313 | PRJNA330616_P_NODE_29425_length_163_cov_8.570175_g29016_i0 | PRJNA330616 | 29425 | 163 | 8.570175 | 13.96938525 | Fimicolochytrium | 1396492 | Fungi | Fungi | 283 | 4.43e-72 | NTclustered | gi|386165070|gb|HQ901690.1| | 1396494 | g29016 | i0 | 98.75 | 98.3251533742331 | 160 | 1 | 98 | 1 | 4 | 163 | 810 | 652 | Fimicolochytrium alabamae voucher MP01 28S large subunit ribosomal RNA gene, partial sequence | blastn | 16027 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium alabamae | |
| 11868261 | 11868261 | PRJNA330616_P_NODE_19070_length_193_cov_1.250000_g18661_i0 | PRJNA330616 | 19070 | 193 | 1.25 | 2.4125 | Piromyces sp. E2 | 73868 | Fungi | Fungi | 200 | 5.62e-47 | NTclustered | gi|7838274|emb|AJ238886.1| | 73868 | g18661 | i0 | 86.022 | 85 | 186 | 26 | 96 | 0 | 6 | 191 | 476 | 661 | Piromyces sp. E2 hsp70.1 gene for putative heat shock protein 70, partial | blastn | 16405 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Piromyces | Piromyces sp. E2 | |
| 14418398 | 14418398 | PRJNA330616_P_NODE_1592_length_727_cov_179.800885_g1231_i0 | PRJNA330616 | 1592 | 727 | 179.800885 | 1307.15243395 | Geranomyces variabilis | 109894 | Fungi | Fungi | 257 | 1.44e-63 | NTclustered | gi|1866582431|gb|MT730606.1| | 109894 | g1231 | i0 | 95.625 | 28.5887207702889 | 160 | 7 | 29 | 0 | 372 | 531 | 4464 | 4623 | Geranomyces variabilis isolate AF30 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 20784 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 16372080 | 16372080 | PRJNA330616_P_NODE_8093_length_291_cov_5.483471_g7684_i0 | PRJNA330616 | 8093 | 291 | 5.483471 | 15.95690061 | Powellomycetaceae | 1134080 | Fungi | Fungi | 416 | 8.3e-112 | NTclustered | gi|1866582454|gb|MT730629.1| | 109894 | g7684 | i0 | 92.256 | 101.694158075601 | 297 | 17 | 100 | 6 | 1 | 291 | 373 | 77 | Geranomyces variabilis isolate Barr350 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 29593 | 420 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 16967028 | 16967028 | PRJNA330616_P_NODE_21934_length_180_cov_3.893130_g21525_i0 | PRJNA330616 | 21934 | 180 | 3.89313 | 7.007634 | Rhizophydiales sp. | 2011922 | Fungi | Fungi | 58.4 | 3.28e-4 | NTclustered | gi|2468790812|gb|OQ702855.1| | 2011922 | g21525 | i0 | 94.737 | 17.5666666666667 | 38 | 1 | 21 | 1 | 144 | 180 | 4734 | 4771 | Rhizophydiales sp. isolate PSC037 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 3162 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Rhizophydiales sp. | |||
| 20790983 | 20790983 | PRJNA330616_P_NODE_10097_length_261_cov_1.259434_g9688_i0 | PRJNA330616 | 10097 | 261 | 1.259434 | 3.28712274 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 219 | 2.22e-52 | NTclustered | gi|2432150000|ref|XM_053114178.1| | 110093 | g9688 | i0 | 83.843 | 6.04597701149425 | 229 | 37 | 88 | 0 | 21 | 249 | 507 | 279 | Polychytrium aggregatum ribosomal protein S2, flavodoxin-like domain-containing protein (BJ171DRAFT_582387), partial mRNA | blastn | 1578 | 219 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 21470975 | 21470975 | PRJNA330616_P_NODE_1457_length_767_cov_24.855153_g1106_i0 | PRJNA330616 | 1457 | 767 | 24.855153 | 190.63902351 | Fimicolochytrium | 1396492 | Fungi | Fungi | 505 | 4.92e-138 | NTclustered | gi|1866582580|gb|MT730755.1| | 1396494 | g1106 | i0 | 96.405 | 64.7040417209909 | 306 | 11 | 65 | 0 | 462 | 767 | 4393 | 4698 | Fimicolochytrium alabamae isolate JEL0588 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 49628 | 505 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium alabamae | |
| 22066313 | 22066313 | PRJNA330616_P_NODE_6718_length_322_cov_4.813187_g6309_i0 | PRJNA330616 | 6718 | 322 | 4.813187 | 15.498462140000001 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 318 | 2.7e-82 | NTclustered | gi|1027029543|ref|XR_001677161.1| | 645134 | g6309 | i0 | 95.074 | 47.9347826086956 | 203 | 8 | 62 | 2 | 1 | 201 | 3883 | 4085 | Spizellomyces punctatus DAOM BR117 28S ribosomal RNA (SPPG_11002), rRNA | blastn | 15435 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 25295461 | 25295461 | PRJNA330616_P_NODE_12120_length_237_cov_1.898936_g11711_i0 | PRJNA330616 | 12120 | 237 | 1.898936 | 4.50047832 | Powellomycetaceae | 1134080 | Fungi | Fungi | 422 | 1.41e-113 | NTclustered | gi|38260238|gb|AY349076.1| | 252690 | g11711 | i0 | 98.734 | 101.080168776371 | 237 | 3 | 100 | 0 | 1 | 237 | 646 | 410 | Powellomyces sp. EA 28S large subunit ribosomal RNA gene, partial sequence | blastn | 23956 | 422 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces sp. EA | |
| 25295661 | 25295661 | PRJNA330616_P_NODE_4540_length_398_cov_11.126074_g4131_i0 | PRJNA330616 | 4540 | 398 | 11.126074 | 44.28177452 | Powellomycetaceae | 1134080 | Fungi | Fungi | 730 | 0 | NTclustered | gi|38260204|gb|AY349042.1| | 252690 | g4131 | i0 | 99.749 | 99.9321608040201 | 398 | 1 | 100 | 0 | 1 | 398 | 902 | 505 | Powellomyces sp. EA 18S small subunit ribosomal RNA gene, partial sequence | blastn | 39773 | 730 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces sp. EA |
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);;