contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA733995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1992678 | 1992678 | PRJNA733995_P_NODE_6522_length_336_cov_1.171103_g6475_i0 | PRJNA733995 | 6522 | 336 | 1.171103 | 3.93490608 | Sporothrix brasiliensis | 545650 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2028021442|ref|XM_040764308.1| | 1398154 | g6475 | i0 | 100 | 0.175595238095238 | 30 | 0 | 9 | 0 | 18 | 47 | 464 | 435 | Sporothrix brasiliensis 5110 uncharacterized protein (SPBR_06046), partial mRNA | blastn | 59 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Sporothrix | Sporothrix brasiliensis | |
| 8369982 | 8369982 | PRJNA733995_P_NODE_967_length_925_cov_3.962441_g931_i0 | PRJNA733995 | 967 | 925 | 3.962441 | 36.65257925 | Trichoderma atroviride | 63577 | Fungi | Fungi | 86.1 | 9.22e-12 | NTclustered | gi|2749703766|ref|XM_014090103.2| | 63577 | g931 | i0 | 88 | 0.549189189189189 | 75 | 6 | 8 | 1 | 498 | 572 | 2198 | 2269 | Trichoderma atroviride uncharacterized protein (TrAtP1_012533), partial mRNA | blastn | 508 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma atroviride | |
| 8849753 | 8849753 | PRJNA733995_P_NODE_12907_length_246_cov_0.890173_g12860_i0 | PRJNA733995 | 12907 | 246 | 0.890173 | 2.18982558 | Ascomycota | 4890 | Fungi | Fungi | 82.4 | 2.83e-11 | NTclustered | gi|2287669193|ref|XM_050115318.1| | 69781 | g12860 | i0 | 92.857 | 8.19105691056911 | 56 | 4 | 23 | 0 | 3 | 58 | 180 | 235 | Penicillium oxalicum calmodulin (POX_e06497), partial mRNA | blastn | 2015 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium oxalicum | |
| 10920562 | 10920562 | PRJNA733995_P_NODE_13949_length_238_cov_3.230303_g13902_i0 | PRJNA733995 | 13949 | 238 | 3.230303 | 7.68812114 | Alternaria alternata | 5599 | Fungi | Fungi | 268 | 1.95e-67 | NTclustered | gi|1070541251|ref|XM_018536035.1| | 5599 | g13902 | i0 | 99.324 | 2.48739495798319 | 148 | 1 | 62 | 0 | 1 | 148 | 403 | 256 | Alternaria alternata hypothetical protein mRNA | blastn | 592 | 268 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 14745595 | 14745595 | PRJNA733995_P_NODE_6212_length_344_cov_1.420664_g6165_i0 | PRJNA733995 | 6212 | 344 | 1.420664 | 4.88708416 | Plenodomus biglobosus | 220672 | Fungi | Fungi | 54.7 | 0.009 | NTclustered | gi|702073506|emb|FO905880.1| | 225344 | g6165 | i0 | 100 | 0.328488372093023 | 29 | 0 | 8 | 0 | 201 | 229 | 76593 | 76565 | Leptosphaeria biglobosa Thlaspii ibcn65_scaffold00021 complete sequence | blastn | 113 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Leptosphaeriaceae | Plenodomus | Plenodomus biglobosus | |
| 15225318 | 15225318 | PRJNA733995_P_NODE_9632_length_278_cov_2.253659_g9585_i0 | PRJNA733995 | 9632 | 278 | 2.253659 | 6.26517202 | Pleosporales | 92860 | Fungi | Fungi | 514 | 2.7199999999999996e-141 | NTclustered | gi|31415585|gb|AY293788.1| | 73001 | g9585 | i0 | 100 | 100 | 278 | 0 | 100 | 0 | 1 | 278 | 590 | 313 | Phoma herbarum strain ATCC 26648 28S large subunit ribosomal RNA gene, partial sequence | blastn | 27800 | 514 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Phoma | Phoma herbarum | |
| 16019189 | 16019189 | PRJNA733995_P_NODE_6893_length_327_cov_1.212598_g6846_i0 | PRJNA733995 | 6893 | 327 | 1.212598 | 3.96519546 | Sporothrix brasiliensis | 545650 | Fungi | Fungi | 62.1 | 5.11e-5 | NTclustered | gi|2028064692|ref|XM_040762932.1| | 1398154 | g6846 | i0 | 88.679 | 0.162079510703364 | 53 | 3 | 15 | 2 | 161 | 210 | 2487 | 2539 | Sporothrix brasiliensis 5110 uncharacterized protein (SPBR_04655), partial mRNA | blastn | 53 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Sporothrix | Sporothrix brasiliensis | |
| 18568375 | 18568375 | PRJNA733995_P_NODE_11235_length_259_cov_1.424731_g11188_i0 | PRJNA733995 | 11235 | 259 | 1.424731 | 3.69005329 | Dipodascopsis tothii | 44089 | Fungi | Fungi | 139 | 1.76e-28 | NTclustered | gi|2781548653|ref|XM_066930225.1| | 44089 | g11188 | i0 | 84.354 | 3.82239382239382 | 147 | 18 | 56 | 4 | 13 | 157 | 409 | 266 | Dipodascopsis tothii ATP-dependent RNA helicase dhh1 (V1510DRAFT_108342), mRNA | blastn | 990 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Dipodascopsis | Dipodascopsis tothii | |
| 18568430 | 18568430 | PRJNA733995_P_NODE_6795_length_329_cov_1.480469_g6748_i0 | PRJNA733995 | 6795 | 329 | 1.480469 | 4.87074301 | Trichoderma harzianum | 5544 | Fungi | Fungi | 52.8 | 0.031 | NTclustered | gi|1383982129|ref|XM_024923988.1| | 983964 | g6748 | i0 | 100 | 0.0851063829787234 | 28 | 0 | 9 | 0 | 240 | 267 | 1070 | 1043 | Trichoderma harzianum CBS 226.95 hypothetical protein (M431DRAFT_89154), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma harzianum | |
| 21119218 | 21119218 | PRJNA733995_P_NODE_3077_length_506_cov_2.193995_g3030_i0 | PRJNA733995 | 3077 | 506 | 2.193995 | 11.1016147 | Aspergillus uvarum | 446911 | Fungi | Fungi | 67.6 | 1.77e-6 | NTclustered | gi|1419130548|ref|XM_025637955.1| | 1448315 | g3030 | i0 | 100 | 7.42687747035573 | 36 | 0 | 7 | 0 | 50 | 85 | 2435 | 2400 | Aspergillus uvarum CBS 121591 FAD/NAD(P)-binding domain-containing protein (BO82DRAFT_382704), mRNA | blastn | 3758 | 67.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus uvarum | |
| 22394148 | 22394148 | PRJNA733995_P_NODE_12538_length_248_cov_0.880000_g12491_i0 | PRJNA733995 | 12538 | 248 | 0.88 | 2.1824 | Alternaria alternata | 5599 | Fungi | Fungi | 233 | 7.459999999999999e-57 | NTclustered | gi|1070554827|ref|XM_018525346.1| | 5599 | g12491 | i0 | 97.778 | 0.544354838709677 | 135 | 3 | 54 | 0 | 114 | 248 | 1870 | 1736 | Alternaria alternata hypothetical protein mRNA | blastn | 135 | 233 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 23669655 | 23669655 | PRJNA733995_P_NODE_13699_length_242_cov_0.911243_g13652_i0 | PRJNA733995 | 13699 | 242 | 0.911243 | 2.20520806 | Alternaria alternata | 5599 | Fungi | Fungi | 279 | 9.19e-71 | NTclustered | gi|1070556659|ref|XM_018525511.1| | 5599 | g13652 | i0 | 98.125 | 3.58264462809917 | 160 | 3 | 66 | 0 | 83 | 242 | 1390 | 1231 | Alternaria alternata inositol monophosphatase mRNA | blastn | 867 | 279 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata |
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);;