contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA853194" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3390792 | 3390792 | PRJNA853194_S_NODE_25823_length_405_cov_0.930723_g24732_i0 | PRJNA853194 | 25823 | 405 | 0.930723 | 3.76942815 | Saccharomycopsis malanga | 44092 | Fungi | Fungi | 56.5 | 0.003 | NTclustered | gi|1554514677|gb|CP025327.1| | 44092 | g24732 | i0 | 92.308 | 0.0962962962962963 | 39 | 3 | 10 | 0 | 204 | 242 | 106621 | 106583 | Saccharomycopsis malanga strain KCN26 mitochondrion | blastn | 39 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Ascoideales | Saccharomycopsidaceae | Saccharomycopsis | Saccharomycopsis malanga | |
| 4669063 | 4669063 | PRJNA853194_S_NODE_53504_length_298_cov_1.320000_g52413_i0 | PRJNA853194 | 53504 | 298 | 1.32 | 3.9336 | Trematosphaeria pertusa | 390896 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|1835107105|ref|XM_033829793.1| | 390896 | g52413 | i0 | 100 | 8.25167785234899 | 30 | 0 | 10 | 0 | 15 | 44 | 189 | 218 | Trematosphaeria pertusa uncharacterized protein (BU26DRAFT_522475), mRNA | blastn | 2459 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Trematosphaeriaceae | Trematosphaeria | Trematosphaeria pertusa | |
| 5062545 | 5062545 | PRJNA853194_S_NODE_33424_length_365_cov_1.537671_g32333_i0 | PRJNA853194 | 33424 | 365 | 1.537671 | 5.61249915 | Ophiostomataceae | 5152 | Fungi | Fungi | 54.7 | 0.01 | NTclustered | gi|257097865|gb|FJ717838.1| | 5174 | g32333 | i0 | 100 | 0.742465753424657 | 29 | 0 | 8 | 0 | 36 | 64 | 855 | 827 | Ophiostoma ulmi strain WIN(M)1223 large subunit ribosomal RNA (rnl) gene, partial sequence; and ribosomal protein 3/homing endonuclease-like fusion protein (rps3/HEG fusion) gene, complete cds; mitochondrial | blastn | 271 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Ophiostoma | Ophiostoma ulmi | |
| 5943792 | 5943792 | PRJNA853194_S_NODE_51825_length_302_cov_2.248908_g50734_i0 | PRJNA853194 | 51825 | 302 | 2.248908 | 6.79170216 | Pichia kudriavzevii | 4909 | Fungi | Fungi | 52.8 | 0.028 | NTclustered | gi|2210890464|gb|CP093510.1| | 4909 | g50734 | i0 | 100 | 0.0927152317880795 | 28 | 0 | 9 | 0 | 189 | 216 | 331905 | 331932 | Pichia kudriavzevii strain GS1-1 chromosome 5 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia kudriavzevii | |
| 9768286 | 9768286 | PRJNA853194_S_NODE_34288_length_361_cov_2.100694_g33197_i0 | PRJNA853194 | 34288 | 361 | 2.100694 | 7.58350534 | Wickerhamomyces canadensis | 1156965 | Fungi | Fungi | 54.7 | 0.01 | NTclustered | gi|11466048|ref|NC_001762.1| | 1156965 | g33197 | i0 | 94.286 | 0.0969529085872576 | 35 | 2 | 10 | 0 | 268 | 302 | 6454 | 6488 | Pichia canadensis mitochondrion, complete genome | blastn | 35 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Wickerhamomycetaceae | Wickerhamomyces | Wickerhamomyces canadensis | |
| 9768339 | 9768339 | PRJNA853194_S_NODE_37428_length_348_cov_2.527273_g36337_i0 | PRJNA853194 | 37428 | 348 | 2.527273 | 8.79491004 | Trichoderma atroviride | 63577 | Fungi | Fungi | 86.1 | 3.25e-12 | NTclustered | gi|2749703766|ref|XM_014090103.2| | 63577 | g36337 | i0 | 88 | 1.26724137931034 | 75 | 6 | 22 | 1 | 137 | 211 | 2269 | 2198 | Trichoderma atroviride uncharacterized protein (TrAtP1_012533), partial mRNA | blastn | 441 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma atroviride | |
| 12320242 | 12320242 | PRJNA853194_S_NODE_72850_length_257_cov_1.831522_g71759_i0 | PRJNA853194 | 72850 | 257 | 1.831522 | 4.70701154 | Colletotrichum scovillei | 1209932 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|1868487896|ref|XM_035471490.1| | 1209932 | g71759 | i0 | 100 | 0.54863813229572 | 29 | 0 | 11 | 0 | 96 | 124 | 3515 | 3543 | Colletotrichum scovillei RNA recognition domain-containing protein (HER10_EVM0001755), mRNA | blastn | 141 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum scovillei | |
| 12320519 | 12320519 | PRJNA853194_S_NODE_9510_length_609_cov_1.759328_g8478_i0 | PRJNA853194 | 9510 | 609 | 1.759328 | 10.71430752 | [Candida] subhashii | 561895 | Fungi | Fungi | 54.7 | 0.017 | NTclustered | gi|2272013728|ref|XM_049406769.1| | 561895 | g8478 | i0 | 100 | 0.0476190476190476 | 29 | 0 | 5 | 0 | 178 | 206 | 858 | 886 | [Candida] subhashii BUD2 (J8A68_002965), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Spathaspora | [Candida] subhashii | |
| 17812000 | 17812000 | PRJNA853194_S_NODE_52274_length_301_cov_1.692982_g51183_i0 | PRJNA853194 | 52274 | 301 | 1.692982 | 5.09587582 | Cordycipitaceae | 474943 | Fungi | Fungi | 551 | 2.2699999999999992e-152 | NTclustered | gi|1473262842|gb|MH875786.1| | 37999 | g51183 | i0 | 99.668 | 100 | 301 | 1 | 100 | 0 | 1 | 301 | 604 | 304 | Beauveria tenella culture CBS:126934 strain CBS 126934 large subunit ribosomal RNA gene, partial sequence | blastn | 30100 | 556 | 0.991007194244604 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Beauveria | Beauveria tenella | |
| 18691695 | 18691695 | PRJNA853194_S_NODE_41755_length_333_cov_1.023077_g40664_i0 | PRJNA853194 | 41755 | 333 | 1.023077 | 3.40684641 | Aspergillus chevalieri | 182096 | Fungi | Fungi | 52.8 | 0.031 | NTclustered | gi|2086738146|ref|XM_043280429.1| | 182096 | g40664 | i0 | 100 | 0.0840840840840841 | 28 | 0 | 8 | 0 | 56 | 83 | 609 | 636 | Aspergillus chevalieri uncharacterized protein (ACHE_50685A), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 18692168 | 18692168 | PRJNA853194_S_NODE_65215_length_272_cov_1.155779_g64124_i0 | PRJNA853194 | 65215 | 272 | 1.155779 | 3.14371888 | Endocarpon pusillum | 364733 | Fungi | Fungi | 52.8 | 0.025 | NTclustered | gi|629643547|ref|XM_007802487.1| | 1263415 | g64124 | i0 | 100 | 0.102941176470588 | 28 | 0 | 10 | 0 | 1 | 28 | 369 | 342 | Endocarpon pusillum Z07020 uncharacterized protein (EPUS_00928), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Verrucariales | Verrucariaceae | Endocarpon | Endocarpon pusillum | |
| 18692438 | 18692438 | PRJNA853194_S_NODE_80035_length_247_cov_1.109195_g78944_i0 | PRJNA853194 | 80035 | 247 | 1.109195 | 2.73971165 | Annulohypoxylon maeteangense | 1927788 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2234903655|ref|XM_047959521.1| | 1927788 | g78944 | i0 | 96.97 | 0.279352226720648 | 33 | 1 | 13 | 0 | 43 | 75 | 172 | 140 | Annulohypoxylon maeteangense Oxysterol-binding protein (GGS22DRAFT_151629), mRNA | blastn | 69 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Hypoxylaceae | Annulohypoxylon | Annulohypoxylon maeteangense | |
| 19966454 | 19966454 | PRJNA853194_S_NODE_21016_length_439_cov_1.166667_g19925_i0 | PRJNA853194 | 21016 | 439 | 1.166667 | 5.12166813 | Zymoseptoria tritici | 1047171 | Fungi | Fungi | 52.8 | 0.042 | NTclustered | gi|2021827471|gb|CP062575.1| | 1047171 | g19925 | i0 | 100 | 0.0637813211845103 | 28 | 0 | 6 | 0 | 46 | 73 | 550970 | 550943 | Zymoseptoria tritici isolate M4_8 chromosome 18 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zymoseptoria | Zymoseptoria tritici | |
| 21241867 | 21241867 | PRJNA853194_S_NODE_15057_length_502_cov_2.913753_g13972_i0 | PRJNA853194 | 15057 | 502 | 2.913753 | 14.62704006 | Candida pseudojiufengensis | 497109 | Fungi | Fungi | 52.8 | 0.049 | NTclustered | gi|2325086576|ref|XM_051758856.1| | 497109 | g13972 | i0 | 100 | 0.0557768924302789 | 28 | 0 | 6 | 0 | 193 | 220 | 988 | 1015 | Candida pseudojiufengensis MCM2 (KGF55_003999), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida pseudojiufengensis | |
| 23793289 | 23793289 | PRJNA853194_S_NODE_7659_length_669_cov_19.739933_g6682_i0 | PRJNA853194 | 7659 | 669 | 19.739933 | 132.06015177 | Candida margitis | 1775924 | Fungi | Fungi | 54.7 | 0.019 | NTclustered | gi|2325475487|ref|XM_051817735.1| | 1775924 | g6682 | i0 | 100 | 0.0433482810164425 | 29 | 0 | 4 | 0 | 127 | 155 | 1845 | 1873 | Candida margitis uncharacterized protein (CANMA_005361), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida margitis | |
| 25066876 | 25066876 | PRJNA853194_S_NODE_58600_length_286_cov_1.079812_g57509_i0 | PRJNA853194 | 58600 | 286 | 1.079812 | 3.08826232 | Wickerhamomyces ciferrii | 1041607 | Fungi | Fungi | 52.8 | 0.026 | NTclustered | gi|754405368|ref|XM_011274464.1| | 1041607 | g57509 | i0 | 100 | 0.0979020979020979 | 28 | 0 | 10 | 0 | 77 | 104 | 99 | 126 | Wickerhamomyces ciferrii 27S pre-rRNA (guanosine2922-2'-O)-methyltransferase (BN7_4996), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Wickerhamomycetaceae | Wickerhamomyces | Wickerhamomyces ciferrii | |
| 25461244 | 25461244 | PRJNA853194_S_NODE_87020_length_232_cov_2.893082_g85929_i0 | PRJNA853194 | 87020 | 232 | 2.893082 | 6.71195024 | root | 1 | Root_unresolved | Root_unresolved | 429 | 8.2e-116 | NTclustered | gi|1280049812|gb|MF072571.1| | 29917 | g85929 | i0 | 100 | 100 | 232 | 0 | 100 | 0 | 1 | 232 | 703 | 934 | Cladosporium cladosporioides strain 007 small subunit ribosomal RNA gene, partial sequence | blastn | 23200 | 429 | 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);;