contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA478247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6825345 | 6825345 | PRJNA478247_P_NODE_2946_length_181_cov_1.513158_g2840_i0 | PRJNA478247 | 2946 | 181 | 1.513158 | 2.73881598 | Apiospora kogelbergensis | 1337665 | Fungi | Fungi | 95.3 | 2.52e-15 | NTclustered | gi|2781464268|ref|XM_066874997.1| | 1337665 | g2840 | i0 | 90.278 | 3.39779005524862 | 72 | 7 | 40 | 0 | 63 | 134 | 43 | 114 | Apiospora kogelbergensis 60S ribosomal protein uL14 (PG998_008181), partial mRNA | blastn | 615 | 95.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Apiosporaceae | Apiospora | Apiospora kogelbergensis | |
| 7475141 | 7475141 | PRJNA478247_P_NODE_1306_length_337_cov_2.886364_g1200_i0 | PRJNA478247 | 1306 | 337 | 2.886364 | 9.72704668 | Ascomycota | 4890 | Fungi | Fungi | 580 | 3.2799999999999998e-161 | NTclustered | gi|2123957803|dbj|LC618842.1| | 45145 | g1200 | i0 | 96.746 | 100.243323442137 | 338 | 10 | 100 | 1 | 1 | 337 | 403 | 66 | Herpotrichia juniperi HFRN18-240 gene for 28S rRNA, partial sequence | blastn | 33782 | 580 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Melanommataceae | Herpotrichia | Herpotrichia juniperi | |
| 8750111 | 8750111 | PRJNA478247_P_NODE_1847_length_260_cov_3.108225_g1741_i0 | PRJNA478247 | 1847 | 260 | 3.108225 | 8.081385 | Fonsecaea | 40354 | Fungi | Fungi | 115 | 2.98e-21 | NTclustered | gi|1248956188|ref|XM_022653483.1| | 254056 | g1741 | i0 | 81.25 | 1.66153846153846 | 144 | 25 | 55 | 2 | 10 | 152 | 152 | 10 | Fonsecaea monophora 60S acidic ribosomal protein P1 (AYO21_03509), partial mRNA | blastn | 432 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Fonsecaea | Fonsecaea monophora | |
| 11300379 | 11300379 | PRJNA478247_P_NODE_2689_length_196_cov_5.353293_g2583_i0 | PRJNA478247 | 2689 | 196 | 5.353293 | 10.49245428 | Pleosporales | 92860 | Fungi | Fungi | 315 | 1.9599999999999999e-81 | NTclustered | gi|120872260|dbj|AB288835.1| | 418284 | g2583 | i0 | 95.876 | 99.9897959183673 | 194 | 8 | 99 | 0 | 3 | 196 | 403 | 210 | Bipolaris sp. IFM 55164 gene for large subunit rRNA, partial sequence | blastn | 19598 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Bipolaris | Bipolaris sp. IFM 55164 | |
| 13850778 | 13850778 | PRJNA478247_P_NODE_3251_length_165_cov_1.610294_g3145_i0 | PRJNA478247 | 3251 | 165 | 1.610294 | 2.6569851 | Fungi | 4751 | Fungi | Fungi | 182 | 1.6899999999999996e-41 | NTclustered | gi|134284919|gb|DQ999851.1| | 321850 | g3145 | i0 | 86.957 | 97.4545454545455 | 161 | 21 | 98 | 0 | 3 | 163 | 779 | 619 | Dactylellina robusta strain CBS 110125 elongation factor 1-alpha (EF1-a) gene, partial cds | blastn | 16080 | 183 | 0.994535519125683 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Dactylellina | Dactylellina robusta | |
| 15125103 | 15125103 | PRJNA478247_P_NODE_1292_length_340_cov_2.778135_g1186_i0 | PRJNA478247 | 1292 | 340 | 2.778135 | 9.445659 | Eukaryota | 2759 | Fungi | Fungi | 257 | 6.34e-64 | NTclustered | gi|2515049772|ref|XM_056623102.1| | 1131581 | g1186 | i0 | 80.636 | 98.2764705882353 | 346 | 56 | 99 | 7 | 2 | 340 | 884 | 543 | Penicillium argentinense ADP-ATP carrier protein (N7532_010611), partial mRNA | blastn | 33414 | 259 | 0.992277992277992 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium argentinense | |
| 17674759 | 17674759 | PRJNA478247_P_NODE_3314_length_162_cov_1.894737_g3208_i0 | PRJNA478247 | 3314 | 162 | 1.894737 | 3.06947394 | Sordariomycetes | 147550 | Fungi | Fungi | 182 | 1.6499999999999996e-41 | NTclustered | gi|38524258|emb|BX842597.1| | 5141 | g3208 | i0 | 86.957 | 90.4506172839506 | 161 | 21 | 99 | 0 | 1 | 161 | 66950 | 66790 | Neurospora crassa DNA linkage group II BAC clone B22K18 | blastn | 14653 | 183 | 0.994535519125683 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Sordariaceae | Neurospora | Neurospora crassa | |
| 19573563 | 19573563 | PRJNA478247_P_NODE_3136_length_171_cov_1.626761_g3030_i0 | PRJNA478247 | 3136 | 171 | 1.626761 | 2.78176131 | Akanthomyces muscarius | 2231603 | Fungi | Fungi | 121 | 3.87e-23 | NTclustered | gi|2507620754|ref|XM_056204106.1| | 2231603 | g3030 | i0 | 80.488 | 2.7953216374269 | 164 | 27 | 94 | 4 | 4 | 163 | 1194 | 1032 | Akanthomyces muscarius uncharacterized protein (LMH87_006250), partial mRNA | blastn | 478 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Akanthomyces | Akanthomyces muscarius | |
| 21498999 | 21498999 | PRJNA478247_P_NODE_2177_length_231_cov_1.653465_g2071_i0 | PRJNA478247 | 2177 | 231 | 1.653465 | 3.81950415 | Ascomycota | 4890 | Fungi | Fungi | 169 | 1.9599999999999997e-37 | NTclustered | gi|2554122785|ref|XM_058514270.1| | 5083 | g2071 | i0 | 94.495 | 47.1904761904762 | 109 | 6 | 47 | 0 | 123 | 231 | 359 | 467 | Penicillium canescens uncharacterized protein (N7446_005522), partial mRNA | blastn | 10901 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium canescens | |
| 22124226 | 22124226 | PRJNA478247_P_NODE_2598_length_203_cov_1.540230_g2492_i0 | PRJNA478247 | 2598 | 203 | 1.54023 | 3.1266669 | Candida jiufengensis | 497108 | Fungi | Fungi | 237 | 4.55e-58 | NTclustered | gi|2325097674|ref|XM_051764167.1| | 497108 | g2492 | i0 | 87.685 | 141.665024630542 | 203 | 25 | 100 | 0 | 1 | 203 | 1324 | 1526 | Candida jiufengensis ubi4 (KGF54_003565), partial mRNA | blastn | 28758 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida jiufengensis |
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);;