contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1046144" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1446768 | 1446768 | PRJNA1046144_P_NODE_2822_length_912_cov_2.970344_g2610_i0 | PRJNA1046144 | 2822 | 912 | 2.970344 | 27.08953728 | Penicillium pulvis | 1562058 | Fungi | Fungi | 63.9 | 4.26e-5 | NTclustered | gi|2517442546|ref|XM_057071252.1| | 1562058 | g2610 | i0 | 97.297 | 12.625 | 37 | 1 | 4 | 0 | 13 | 49 | 45 | 9 | Penicillium pulvis uncharacterized protein (N7503_011706), partial mRNA | blastn | 11514 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium pulvis | |
| 2284686 | 2284686 | PRJNA1046144_P_NODE_68162_length_227_cov_0.911392_g67867_i0 | PRJNA1046144 | 68162 | 227 | 0.911392 | 2.06885984 | Harzia | 911088 | Fungi | Fungi | 409 | 1.04e-109 | NTclustered | gi|2164562940|gb|OL826785.1| | 2420197 | g67867 | i0 | 99.119 | 100.31718061674 | 227 | 2 | 100 | 0 | 1 | 227 | 1323 | 1097 | Harzia sp. isolate CP-746 small subunit ribosomal RNA gene, partial sequence | blastn | 22772 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Coronophorales | Ceratostomataceae | Harzia | Harzia sp. | |
| 3999277 | 3999277 | PRJNA1046144_P_NODE_64324_length_229_cov_1.693750_g64029_i0 | PRJNA1046144 | 64324 | 229 | 1.69375 | 3.8786875 | Fusarium graminearum | 5518 | Fungi | Fungi | 424 | 3.76e-114 | NTclustered | gi|758203102|ref|XM_011325609.1| | 229533 | g64029 | i0 | 100 | 4 | 229 | 0 | 100 | 0 | 1 | 229 | 1194 | 966 | Fusarium graminearum PH-1 uncharacterized protein (FGSG_05384), partial mRNA | blastn | 916 | 424 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium graminearum | |
| 5275223 | 5275223 | PRJNA1046144_P_NODE_44645_length_260_cov_1.356021_g44350_i0 | PRJNA1046144 | 44645 | 260 | 1.356021 | 3.5256546 | Alternaria postmessia | 1187938 | Fungi | Fungi | 475 | 1.1899999999999999e-129 | NTclustered | gi|2324843542|ref|XM_051726599.1| | 1187938 | g44350 | i0 | 99.615 | 4 | 260 | 1 | 100 | 0 | 1 | 260 | 1088 | 1347 | Alternaria postmessia uncharacterized protein (J4E82_000277), partial mRNA | blastn | 1040 | 475 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria postmessia | |
| 6112452 | 6112452 | PRJNA1046144_P_NODE_54305_length_238_cov_1.704142_g54010_i0 | PRJNA1046144 | 54305 | 238 | 1.704142 | 4.05585796 | Aspergillus | 5052 | Fungi | Fungi | 124 | 4.469999999999999e-24 | NTclustered | gi|134075767|emb|AM270122.1| | 5061 | g54010 | i0 | 92.045 | 1.82352941176471 | 88 | 7 | 37 | 0 | 1 | 88 | 36620 | 36707 | Aspergillus niger contig An07c0040, genomic contig | blastn | 434 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 7824952 | 7824952 | PRJNA1046144_P_NODE_42267_length_266_cov_1.040609_g41972_i0 | PRJNA1046144 | 42267 | 266 | 1.040609 | 2.76801994 | Ilyonectria robusta | 1079257 | Fungi | Fungi | 52.8 | 0.024 | NTclustered | gi|2185593040|ref|XM_046254147.1| | 1079257 | g41972 | i0 | 100 | 0.105263157894737 | 28 | 0 | 11 | 0 | 129 | 156 | 196 | 223 | Ilyonectria robusta uncharacterized protein (BGZ61DRAFT_534430), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Ilyonectria | Ilyonectria robusta | |
| 7825361 | 7825361 | PRJNA1046144_P_NODE_60987_length_232_cov_0.883436_g60692_i0 | PRJNA1046144 | 60987 | 232 | 0.883436 | 2.04957152 | Aureobasidium pullulans | 5580 | Fungi | Fungi | 412 | 8.26e-111 | NTclustered | gi|1701886503|ref|XM_029899711.1| | 1043002 | g60692 | i0 | 98.707 | 1 | 232 | 3 | 100 | 0 | 1 | 232 | 1478 | 1709 | Aureobasidium pullulans EXF-150 uncharacterized protein (M438DRAFT_255542), partial mRNA | blastn | 232 | 412 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 11650758 | 11650758 | PRJNA1046144_P_NODE_35950_length_284_cov_2.004651_g35655_i0 | PRJNA1046144 | 35950 | 284 | 2.004651 | 5.69320884 | Chaetomium strumarium | 1170767 | Fungi | Fungi | 52.8 | 0.026 | NTclustered | gi|2669859221|ref|XM_062870948.1| | 1170767 | g35655 | i0 | 100 | 0.0985915492957746 | 28 | 0 | 10 | 0 | 126 | 153 | 4144 | 4171 | Chaetomium strumarium uncharacterized protein (B0T15DRAFT_574236), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Chaetomium | Chaetomium strumarium | |
| 11651065 | 11651065 | PRJNA1046144_P_NODE_51750_length_244_cov_1.325714_g51455_i0 | PRJNA1046144 | 51750 | 244 | 1.325714 | 3.23474216 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 302 | 1.98e-77 | NTclustered | gi|2837748938|ref|XM_069374158.1| | 1052096 | g51455 | i0 | 92.788 | 74.733606557377 | 208 | 15 | 85 | 0 | 1 | 208 | 430 | 223 | Cladosporium halotolerans Superoxide dismutase [Cu-Zn] (sod1), mRNA | blastn | 18235 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 12488314 | 12488314 | PRJNA1046144_P_NODE_64110_length_229_cov_2.512500_g63815_i0 | PRJNA1046144 | 64110 | 229 | 2.5125 | 5.753625 | Nectriaceae | 110618 | Fungi | Fungi | 418 | 1.7499999999999995e-112 | NTclustered | gi|2320065613|gb|OP693470.1| | 29916 | g63815 | i0 | 99.563 | 100 | 229 | 1 | 100 | 0 | 1 | 229 | 279 | 51 | Fusarium sp. strain GZUIFR 22.371 large subunit ribosomal RNA gene, partial sequence | blastn | 22900 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium sp. | |
| 12488405 | 12488405 | PRJNA1046144_P_NODE_9550_length_511_cov_3.506787_g9257_i0 | PRJNA1046144 | 9550 | 511 | 3.506787 | 17.91968157 | Pleosporaceae | 28556 | Fungi | Fungi | 774 | 0 | NTclustered | gi|417357276|gb|JX648198.1| | 29001 | g9257 | i0 | 94.466 | 98.7592954990215 | 506 | 23 | 98 | 5 | 9 | 511 | 1001 | 498 | Alternaria brassicicola strain NRRL 54912 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 50466 | 774 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria brassicicola | |
| 12926600 | 12926600 | PRJNA1046144_P_NODE_68491_length_227_cov_0.911392_g68196_i0 | PRJNA1046144 | 68491 | 227 | 0.911392 | 2.06885984 | Meyerozyma guilliermondii | 4929 | Fungi | Fungi | 420 | 4.81e-113 | NTclustered | gi|146421454|ref|XM_001486623.1| | 294746 | g68196 | i0 | 100 | 1 | 227 | 0 | 100 | 0 | 1 | 227 | 374 | 600 | Meyerozyma guilliermondii ATCC 6260 uncharacterized protein (PGUG_00050), partial mRNA | blastn | 227 | 420 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma guilliermondii | |
| 13762886 | 13762886 | PRJNA1046144_P_NODE_9551_length_511_cov_3.497738_g9258_i0 | PRJNA1046144 | 9551 | 511 | 3.497738 | 17.87344118 | Eukaryota | 2759 | Fungi | Fungi | 939 | 0 | NTclustered | gi|1050550568|gb|KX664389.1| | 29917 | g9258 | i0 | 99.804 | 100 | 511 | 1 | 100 | 0 | 1 | 511 | 1009 | 499 | Cladosporium cladosporioides isolate F37-03 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 51100 | 939 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 15036660 | 15036660 | PRJNA1046144_P_NODE_18512_length_377_cov_2.814935_g18217_i0 | PRJNA1046144 | 18512 | 377 | 2.814935 | 10.61230495 | Eukaryota | 2759 | Fungi | Fungi | 691 | 0 | NTclustered | gi|2532687033|gb|OR243761.1| | 29917 | g18217 | i0 | 99.735 | 99.9283819628647 | 377 | 1 | 100 | 0 | 1 | 377 | 4062 | 3686 | 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 | 37673 | 691 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 15475615 | 15475615 | PRJNA1046144_P_NODE_65213_length_229_cov_0.900000_g64918_i0 | PRJNA1046144 | 65213 | 229 | 0.9 | 2.061 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 267 | 6.7e-67 | NTclustered | gi|2837760178|ref|XM_069374973.1| | 1052096 | g64918 | i0 | 88.636 | 0.960698689956332 | 220 | 23 | 96 | 2 | 1 | 219 | 381 | 163 | Cladosporium halotolerans uncharacterized protein (WHR41_06368), partial mRNA | blastn | 220 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 19298420 | 19298420 | PRJNA1046144_P_NODE_57316_length_234_cov_1.442424_g57021_i0 | PRJNA1046144 | 57316 | 234 | 1.442424 | 3.37527216 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 246 | 8.96e-61 | NTclustered | gi|2837754316|ref|XM_069374287.1| | 1052096 | g57021 | i0 | 87.981 | 1.01709401709402 | 208 | 25 | 89 | 0 | 27 | 234 | 346 | 139 | Cladosporium halotolerans uncharacterized protein (WHR41_05682), mRNA | blastn | 238 | 246 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 20573730 | 20573730 | PRJNA1046144_P_NODE_55877_length_235_cov_1.506024_g55582_i0 | PRJNA1046144 | 55877 | 235 | 1.506024 | 3.5391564 | Alternaria alternata | 5599 | Fungi | Fungi | 429 | 8.33e-116 | NTclustered | gi|1070556747|ref|XM_018527691.1| | 5599 | g55582 | i0 | 99.574 | 16.263829787234 | 235 | 1 | 100 | 0 | 1 | 235 | 1321 | 1555 | Alternaria alternata homocitrate synthase mRNA | blastn | 3822 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 23961657 | 23961657 | PRJNA1046144_P_NODE_48719_length_250_cov_2.298343_g48424_i0 | PRJNA1046144 | 48719 | 250 | 2.298343 | 5.7458575 | Alternaria | 5598 | Fungi | Fungi | 462 | 8.83e-126 | NTclustered | gi|1070544371|ref|XM_018524363.1| | 5599 | g48424 | i0 | 100 | 7 | 250 | 0 | 100 | 0 | 1 | 250 | 1514 | 1763 | Alternaria alternata hypothetical protein mRNA | blastn | 1750 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 24398448 | 24398448 | PRJNA1046144_P_NODE_45700_length_257_cov_2.037234_g45405_i0 | PRJNA1046144 | 45700 | 257 | 2.037234 | 5.23569138 | Truncatella angustata | 152316 | Fungi | Fungi | 110 | 1.37e-19 | NTclustered | gi|2185363721|ref|XM_046100693.1| | 152316 | g45405 | i0 | 90.361 | 0.32295719844358 | 83 | 8 | 32 | 0 | 166 | 248 | 130 | 212 | Truncatella angustata ribonuclease T2-like protein (BKA67DRAFT_539788), partial mRNA | blastn | 83 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Sporocadaceae | Truncatella | Truncatella angustata |
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);;