contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA1047321" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1009783 | 1009783 | PRJNA1047321_P_NODE_2601_length_411_cov_2.769231_g2432_i0 | PRJNA1047321 | 2601 | 411 | 2.769231 | 11.38153941 | Ascomycota | 4890 | Fungi | Fungi | 760 | 0 | NTclustered | gi|74135491|gb|DQ123637.1| | 5074 | g2432 | i0 | 100 | 100 | 411 | 0 | 100 | 0 | 1 | 411 | 518 | 928 | Penicillium brevicompactum strain NRRL 32579 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 41100 | 760 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium brevicompactum | |
| 1449110 | 1449110 | PRJNA1047321_P_NODE_3722_length_336_cov_2.536122_g3552_i0 | PRJNA1047321 | 3722 | 336 | 2.536122 | 8.52136992 | Spissiomyces sp. SDBR-CMU319 | 2282406 | Fungi | Fungi | 593 | 4.199999999999999e-165 | NTclustered | gi|1432004530|gb|MF990799.1| | 2282406 | g3552 | i0 | 98.512 | 100.10119047619 | 336 | 5 | 100 | 0 | 1 | 336 | 337 | 2 | Spissiomyces sp. SDBR-CMU319 large subunit ribosomal RNA gene, partial sequence | blastn | 33634 | 593 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Spissiomyces | Spissiomyces sp. SDBR-CMU319 | |||
| 4000920 | 4000920 | PRJNA1047321_P_NODE_6524_length_251_cov_0.865169_g6353_i0 | PRJNA1047321 | 6524 | 251 | 0.865169 | 2.17157419 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 387 | 5.489999999999998e-103 | NTclustered | gi|2837743620|ref|XM_069373050.1| | 1052096 | g6353 | i0 | 94.422 | 98.0677290836653 | 251 | 14 | 100 | 0 | 1 | 251 | 309 | 59 | Cladosporium halotolerans 40S ribosomal protein eS26 (rps-26), mRNA | blastn | 24615 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 6112935 | 6112935 | PRJNA1047321_P_NODE_5265_length_277_cov_4.931373_g5094_i0 | PRJNA1047321 | 5265 | 277 | 4.931373 | 13.65990321 | Eukaryota | 2759 | Fungi | Fungi | 512 | 9.73e-141 | NTclustered | gi|1280049812|gb|MF072571.1| | 29917 | g5094 | i0 | 100 | 100 | 277 | 0 | 100 | 0 | 1 | 277 | 310 | 34 | Cladosporium cladosporioides strain 007 small subunit ribosomal RNA gene, partial sequence | blastn | 27700 | 512 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 7827038 | 7827038 | PRJNA1047321_P_NODE_4587_length_298_cov_2.462222_g4417_i0 | PRJNA1047321 | 4587 | 298 | 2.462222 | 7.33742156 | Cryptocoryneum condensatum | 1763021 | Fungi | Fungi | 412 | 1.1e-110 | NTclustered | gi|1187430660|gb|KY995559.1| | 1763021 | g4417 | i0 | 91.639 | 108.5 | 299 | 23 | 100 | 2 | 1 | 298 | 3468 | 3765 | Cryptocoryneum condensatum voucher G.M. 2016-01-29.2 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 | 32333 | 412 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Cryptocoryneum | Cryptocoryneum condensatum | ||
| 9102028 | 9102028 | PRJNA1047321_P_NODE_6248_length_255_cov_1.478022_g6077_i0 | PRJNA1047321 | 6248 | 255 | 1.478022 | 3.7689561 | Aspergillus puulaauensis | 1220207 | Fungi | Fungi | 420 | 5.51e-113 | NTclustered | gi|2833777549|gb|PQ475852.1| | 1220207 | g6077 | i0 | 96.471 | 106.098039215686 | 255 | 8 | 99 | 1 | 1 | 254 | 6295 | 6549 | Aspergillus puulaauensis strain F77 internal transcribed spacer region, partial sequence | blastn | 27055 | 420 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus puulaauensis | |
| 10377665 | 10377665 | PRJNA1047321_P_NODE_1209_length_635_cov_13.967972_g1046_i0 | PRJNA1047321 | 1209 | 635 | 13.967972 | 88.6966222 | uncultured Ascomycota | 175243 | Fungi | Fungi | 972 | 0 | NTclustered | gi|313483124|gb|HQ433129.1| | 175243 | g1046 | i0 | 94.331 | 98.0771653543307 | 635 | 35 | 100 | 1 | 1 | 635 | 291 | 924 | Uncultured Ascomycota clone asc07192 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 62279 | 972 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | uncultured Ascomycota | |||||
| 10377672 | 10377672 | PRJNA1047321_P_NODE_2849_length_390_cov_2.823344_g2680_i0 | PRJNA1047321 | 2849 | 390 | 2.823344 | 11.0110416 | Penicillium brevicompactum | 5074 | Fungi | Fungi | 704 | 0 | NTclustered | gi|1358186644|gb|MH047201.1| | 5074 | g2680 | i0 | 99.231 | 106.738461538462 | 390 | 3 | 100 | 0 | 1 | 390 | 3705 | 4094 | Penicillium brevicompactum 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 41628 | 704 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium brevicompactum | |
| 11213221 | 11213221 | PRJNA1047321_P_NODE_8669_length_241_cov_0.916667_g8498_i0 | PRJNA1047321 | 8669 | 241 | 0.916667 | 2.20916747 | Alternaria | 5598 | Fungi | Fungi | 440 | 3.959999999999999e-119 | NTclustered | gi|1070548317|ref|XM_018527162.1| | 5599 | g8498 | i0 | 99.585 | 5.78838174273859 | 241 | 1 | 100 | 0 | 1 | 241 | 2194 | 2434 | Alternaria alternata hypothetical protein mRNA | blastn | 1395 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 11213223 | 11213223 | PRJNA1047321_P_NODE_9089_length_217_cov_4.784722_g8918_i0 | PRJNA1047321 | 9089 | 217 | 4.784722 | 10.38284674 | Erysiphaceae | 34371 | Fungi | Fungi | 401 | 1.6499999999999994e-107 | NTclustered | gi|1706880624|gb|MK357451.1| | 157594 | g8918 | i0 | 100 | 100.009216589862 | 217 | 0 | 100 | 0 | 1 | 217 | 241 | 25 | Erysiphe alphitoides isolate F3 small subunit ribosomal RNA gene, partial sequence | blastn | 21702 | 401 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Erysiphe | Erysiphe alphitoides | |
| 12488737 | 12488737 | PRJNA1047321_P_NODE_8370_length_242_cov_1.514793_g8199_i0 | PRJNA1047321 | 8370 | 242 | 1.514793 | 3.66579906 | Komagataella | 460517 | Fungi | Fungi | 442 | 1.1099999999999995e-119 | NTclustered | gi|238034221|emb|FN392325.1| | 4922 | g8199 | i0 | 99.587 | 80.1900826446281 | 242 | 1 | 100 | 0 | 1 | 242 | 5076 | 4835 | Pichia pastoris GS115 rDNA sequence, whole genome shotgun sequence | blastn | 19406 | 442 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Komagataella | Komagataella pastoris | |
| 16751350 | 16751350 | PRJNA1047321_P_NODE_4274_length_311_cov_1.184874_g4104_i0 | PRJNA1047321 | 4274 | 311 | 1.184874 | 3.68495814 | Penicillium ulaiense | 293377 | Fungi | Fungi | 503 | 6.68e-138 | NTclustered | gi|300432961|gb|HM117807.1| | 293377 | g4104 | i0 | 96.393 | 102.768488745981 | 305 | 11 | 98 | 0 | 2 | 306 | 356 | 52 | Penicillium ulaiense 28S ribosomal RNA gene, partial sequence; 28S-18S ribosomal RNA intergenic spacer, complete sequence; and 18S ribosomal RNA gene, partial sequence | blastn | 31961 | 503 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium ulaiense | |
| 16751386 | 16751386 | PRJNA1047321_P_NODE_8774_length_241_cov_0.916667_g8603_i0 | PRJNA1047321 | 8774 | 241 | 0.916667 | 2.20916747 | Akanthomyces muscarius | 2231603 | Fungi | Fungi | 446 | 8.519999999999999e-121 | NTclustered | gi|2507617086|ref|XM_056203424.1| | 2231603 | g8603 | i0 | 100 | 7.91286307053942 | 241 | 0 | 100 | 0 | 1 | 241 | 1845 | 1605 | Akanthomyces muscarius uncharacterized protein (LMH87_005663), partial mRNA | blastn | 1907 | 446 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Akanthomyces | Akanthomyces muscarius | |
| 17587618 | 17587618 | PRJNA1047321_P_NODE_2754_length_398_cov_3.483077_g2585_i0 | PRJNA1047321 | 2754 | 398 | 3.483077 | 13.86264646 | Ramularia | 112497 | Fungi | Fungi | 730 | 0 | NTclustered | gi|283827985|gb|AY490776.2| | 43215 | g2585 | i0 | 99.749 | 100 | 398 | 1 | 100 | 0 | 1 | 398 | 1446 | 1843 | Mycosphaerella punctiformis strain CBS 113265 28S ribosomal RNA gene, partial sequence | blastn | 39800 | 730 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia punctiformis | |
| 17587630 | 17587630 | PRJNA1047321_P_NODE_5634_length_268_cov_1.579487_g5463_i0 | PRJNA1047321 | 5634 | 268 | 1.579487 | 4.23302516 | Penicillium | 5073 | Fungi | Fungi | 82.4 | 3.13e-11 | NTclustered | gi|1026980433|ref|XM_016742753.1| | 27334 | g5463 | i0 | 85.714 | 0.626865671641791 | 84 | 4 | 28 | 3 | 16 | 91 | 84 | 1 | Penicillium expansum CheY-like superfamily (PEX2_054790), partial mRNA | blastn | 168 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium expansum | |
| 18026266 | 18026266 | PRJNA1047321_P_NODE_8455_length_242_cov_0.911243_g8284_i0 | PRJNA1047321 | 8455 | 242 | 0.911243 | 2.20520806 | Komagataella phaffii | 460519 | Fungi | Fungi | 440 | 3.9799999999999986e-119 | NTclustered | gi|254568945|ref|XM_002491538.1| | 644223 | g8284 | i0 | 99.585 | 62.8099173553719 | 241 | 1 | 99 | 0 | 2 | 242 | 413 | 173 | Komagataella phaffii GS115 60S ribosomal protein L15 (PAS_chr2-1_0658), partial mRNA | blastn | 15200 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Komagataella | Komagataella phaffii | |
| 18861408 | 18861408 | PRJNA1047321_P_NODE_2775_length_396_cov_3.588235_g2606_i0 | PRJNA1047321 | 2775 | 396 | 3.588235 | 14.2094106 | Eukaryota | 2759 | Fungi | Fungi | 732 | 0 | NTclustered | gi|2532687033|gb|OR243761.1| | 29917 | g2606 | i0 | 100 | 100.085858585859 | 396 | 0 | 100 | 0 | 1 | 396 | 3696 | 4091 | Cladosporium cladosporioides strain DSM 104381 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 | 39634 | 732 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 22686658 | 22686658 | PRJNA1047321_P_NODE_4178_length_314_cov_19.900415_g4008_i0 | PRJNA1047321 | 4178 | 314 | 19.900415 | 62.4873031 | Dothideomycetes | 147541 | Fungi | Fungi | 547 | 3.069999999999999e-151 | NTclustered | gi|283827932|gb|FJ493209.2| | 630509 | g4008 | i0 | 98.089 | 100 | 314 | 6 | 100 | 0 | 1 | 314 | 1840 | 2153 | Phaeophleospora eugeniicola strain CPC 2558 28S large subunit ribosomal RNA gene, partial sequence | blastn | 31400 | 547 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Phaeophleospora | Phaeophleospora eugeniicola | |
| 22686668 | 22686668 | PRJNA1047321_P_NODE_7658_length_246_cov_0.890173_g7487_i0 | PRJNA1047321 | 7658 | 246 | 0.890173 | 2.18982558 | Alternaria | 5598 | Fungi | Fungi | 291 | 4.33e-74 | NTclustered | gi|2323867928|ref|XM_051467348.1| | 181017 | g7487 | i0 | 100 | 8.69512195121951 | 157 | 0 | 78 | 0 | 90 | 246 | 281 | 125 | Alternaria conjuncta uncharacterized protein (J4E85_003075), partial mRNA | blastn | 2139 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria conjuncta | |
| 23962271 | 23962271 | PRJNA1047321_P_NODE_9019_length_227_cov_3.285714_g8848_i0 | PRJNA1047321 | 9019 | 227 | 3.285714 | 7.45857078 | Opisthokonta | 33154 | Fungi | Fungi | 420 | 4.81e-113 | NTclustered | gi|283827952|gb|EU019262.2| | 29917 | g8848 | i0 | 100 | 99.8766519823789 | 227 | 0 | 100 | 0 | 1 | 227 | 2368 | 2594 | Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence | blastn | 22672 | 420 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides |
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);;