contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA547066" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 511528 | 511528 | PRJNA547066_P_NODE_3681_length_220_cov_1.762162_g3587_i0 | PRJNA547066 | 3681 | 220 | 1.762162 | 3.8767564 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 147 | 8.689999999999999e-31 | NTclustered | gi|2837752410|ref|XM_069373706.1| | 1052096 | g3587 | i0 | 98.78 | 10.1 | 82 | 1 | 37 | 0 | 3 | 84 | 235 | 316 | Cladosporium halotolerans 40S ribosomal protein eS30 (RPS30), mRNA | blastn | 2222 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 3670790 | 3670790 | PRJNA547066_P_NODE_4623_length_183_cov_1.081081_g4529_i0 | PRJNA547066 | 4623 | 183 | 1.081081 | 1.97837823 | Alternaria | 5598 | Fungi | Fungi | 339 | 1.07e-88 | NTclustered | gi|1070544369|ref|XM_018529592.1| | 5599 | g4529 | i0 | 100 | 5.16939890710383 | 183 | 0 | 100 | 0 | 1 | 183 | 434 | 252 | Alternaria alternata hypothetical protein mRNA | blastn | 946 | 339 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 5615393 | 5615393 | PRJNA547066_P_NODE_4285_length_193_cov_1.772152_g4191_i0 | PRJNA547066 | 4285 | 193 | 1.772152 | 3.42025336 | Alternaria alternata | 5599 | Fungi | Fungi | 97.1 | 7.58e-16 | NTclustered | gi|1070560073|ref|XM_018529284.1| | 5599 | g4191 | i0 | 78.313 | 0.860103626943005 | 166 | 25 | 83 | 9 | 16 | 176 | 1050 | 891 | Alternaria alternata C-4 methylsterol oxidase partial mRNA | blastn | 166 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 6223149 | 6223149 | PRJNA547066_P_NODE_2485_length_300_cov_3.826415_g2391_i0 | PRJNA547066 | 2485 | 300 | 3.826415 | 11.479245 | Candida | 5475 | Fungi | Fungi | 490 | 4.99e-134 | NTclustered | gi|404333759|gb|JX441611.1| | 5480 | g2391 | i0 | 96.622 | 98.6666666666667 | 296 | 9 | 98 | 1 | 2 | 296 | 42 | 337 | Candida parapsilosis clone MROJIY10 26S ribosomal RNA gene, partial sequence | blastn | 29600 | 490 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida parapsilosis | |
| 6223150 | 6223150 | PRJNA547066_P_NODE_2645_length_285_cov_1.872000_g2551_i0 | PRJNA547066 | 2645 | 285 | 1.872 | 5.3352 | Alternaria | 5598 | Fungi | Fungi | 424 | 4.84e-114 | NTclustered | gi|1070559755|ref|XM_018529941.1| | 5599 | g2551 | i0 | 94.834 | 4.44561403508772 | 271 | 14 | 95 | 0 | 15 | 285 | 482 | 212 | Alternaria alternata hydrophobin-like protein mRNA | blastn | 1267 | 427 | 0.992974238875878 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 6223153 | 6223153 | PRJNA547066_P_NODE_3585_length_225_cov_1.473684_g3491_i0 | PRJNA547066 | 3585 | 225 | 1.473684 | 3.315789 | Alternaria | 5598 | Fungi | Fungi | 411 | 2.869999999999999e-110 | NTclustered | gi|1070550265|ref|XM_018534364.1| | 5599 | g3491 | i0 | 99.556 | 20.9688888888889 | 225 | 1 | 100 | 0 | 1 | 225 | 622 | 398 | Alternaria alternata aquaporin partial mRNA | blastn | 4718 | 411 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 6889269 | 6889269 | PRJNA547066_P_NODE_526_length_671_cov_7.194969_g390_i1 | PRJNA547066 | 526 | 671 | 7.194969 | 48.27824199 | Alternaria alternata | 5599 | Fungi | Fungi | 1234 | 0 | NTclustered | gi|2791117515|gb|PQ217832.1| | 5599 | g390 | i1 | 99.851 | 120.089418777943 | 671 | 1 | 100 | 0 | 1 | 671 | 4383 | 3713 | Alternaria alternata isolate Karbala-1 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and external transcribed spacer, partial sequence | blastn | 80580 | 1234 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 7497660 | 7497660 | PRJNA547066_P_NODE_4106_length_201_cov_1.204819_g4012_i0 | PRJNA547066 | 4106 | 201 | 1.204819 | 2.42168619 | Sordariomycetes | 147550 | Fungi | Fungi | 372 | 1.18e-98 | NTclustered | gi|1473253337|gb|MH866281.1| | 5128 | g4012 | i0 | 100 | 100 | 201 | 0 | 100 | 0 | 1 | 201 | 219 | 19 | Fusarium sambucinum culture CBS:136.24 strain CBS 136.24 large subunit ribosomal RNA gene, partial sequence | blastn | 20100 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium sambucinum | |
| 8164403 | 8164403 | PRJNA547066_P_NODE_5167_length_169_cov_1.194030_g5073_i0 | PRJNA547066 | 5167 | 169 | 1.19403 | 2.0179107 | Alternaria alternata | 5599 | Fungi | Fungi | 307 | 2.73e-79 | NTclustered | gi|1070550823|ref|XM_018523540.1| | 5599 | g5073 | i0 | 99.408 | 9.59763313609468 | 169 | 1 | 100 | 0 | 1 | 169 | 864 | 696 | Alternaria alternata RraA-like protein partial mRNA | blastn | 1622 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 9439940 | 9439940 | PRJNA547066_P_NODE_568_length_649_cov_6.776873_g390_i2 | PRJNA547066 | 568 | 649 | 6.776873 | 43.98190577 | Alternaria alternata | 5599 | Fungi | Fungi | 1044 | 0 | NTclustered | gi|2791117515|gb|PQ217832.1| | 5599 | g390 | i2 | 95.699 | 116.437596302003 | 651 | 24 | 100 | 4 | 1 | 649 | 4361 | 3713 | Alternaria alternata isolate Karbala-1 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and external transcribed spacer, partial sequence | blastn | 75568 | 1044 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 13265411 | 13265411 | PRJNA547066_P_NODE_5091_length_171_cov_1.139706_g4997_i0 | PRJNA547066 | 5091 | 171 | 1.139706 | 1.94889726 | Alternaria burnsii | 1187904 | Fungi | Fungi | 300 | 4.63e-77 | NTclustered | gi|1955450495|ref|XM_038935937.1| | 1187904 | g4997 | i0 | 98.246 | 5.9766081871345 | 171 | 3 | 100 | 0 | 1 | 171 | 846 | 1016 | Alternaria burnsii nad-binding protein (GT037_010890), partial mRNA | blastn | 1022 | 300 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria burnsii | |
| 14540360 | 14540360 | PRJNA547066_P_NODE_1412_length_410_cov_1.901333_g1319_i0 | PRJNA547066 | 1412 | 410 | 1.901333 | 7.7954653 | Alternaria alternata | 5599 | Fungi | Fungi | 719 | 0 | NTclustered | gi|1070554223|ref|XM_018525295.1| | 5599 | g1319 | i0 | 98.293 | 5.67317073170732 | 410 | 7 | 100 | 0 | 1 | 410 | 481 | 890 | Alternaria alternata hypothetical protein mRNA | blastn | 2326 | 719 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 14540362 | 14540362 | PRJNA547066_P_NODE_2212_length_327_cov_1.424658_g2118_i0 | PRJNA547066 | 2212 | 327 | 1.424658 | 4.65863166 | Alternaria alternata | 5599 | Fungi | Fungi | 604 | 1.8799999999999993e-168 | NTclustered | gi|1070564381|ref|XM_018535926.1| | 5599 | g2118 | i0 | 100 | 12.9633027522936 | 327 | 0 | 100 | 0 | 1 | 327 | 908 | 582 | Alternaria alternata peroxisomal membrane protein pex16 partial mRNA | blastn | 4239 | 604 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 14540364 | 14540364 | PRJNA547066_P_NODE_2592_length_290_cov_2.094118_g2498_i0 | PRJNA547066 | 2592 | 290 | 2.094118 | 6.0729422 | Alternaria burnsii | 1187904 | Fungi | Fungi | 492 | 1.3399999999999996e-134 | NTclustered | gi|1955451276|ref|XM_038936140.1| | 1187904 | g2498 | i0 | 97.241 | 99.6620689655172 | 290 | 8 | 100 | 0 | 1 | 290 | 406 | 117 | Alternaria burnsii major allergen alt a 1 subunit (GT037_011093), partial mRNA | blastn | 28902 | 492 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria burnsii | |
| 14540366 | 14540366 | PRJNA547066_P_NODE_3432_length_232_cov_1.609137_g3338_i0 | PRJNA547066 | 3432 | 232 | 1.609137 | 3.73319784 | Alternaria alternata | 5599 | Fungi | Fungi | 418 | 1.7799999999999995e-112 | NTclustered | gi|1070554223|ref|XM_018525295.1| | 5599 | g3338 | i0 | 99.138 | 13.7413793103448 | 232 | 2 | 100 | 0 | 1 | 232 | 507 | 276 | Alternaria alternata hypothetical protein mRNA | blastn | 3188 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 15814378 | 15814378 | PRJNA547066_P_NODE_3733_length_218_cov_0.874317_g3639_i0 | PRJNA547066 | 3733 | 218 | 0.874317 | 1.90601106 | Penicillium samsonianum | 1882272 | Fungi | Fungi | 106 | 1.46e-18 | NTclustered | gi|2517888377|ref|XM_057282331.1| | 1882272 | g3639 | i0 | 83.471 | 0.729357798165138 | 121 | 12 | 53 | 3 | 34 | 149 | 1680 | 1563 | Penicillium samsonianum uncharacterized protein (N7471_009612), mRNA | blastn | 159 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium samsonianum | |
| 17089052 | 17089052 | PRJNA547066_P_NODE_3874_length_210_cov_1.577143_g3780_i0 | PRJNA547066 | 3874 | 210 | 1.577143 | 3.3120003 | Fusarium vanettenii | 2747968 | Fungi | Fungi | 350 | 5.84e-92 | NTclustered | gi|302914903|ref|XM_003051217.1| | 660122 | g3780 | i0 | 96.667 | 88.7428571428571 | 210 | 7 | 100 | 0 | 1 | 210 | 492 | 701 | Fusarium vanettenii 77-13-4 60S ribosomal protein L10 (NECHADRAFT_69563), mRNA | blastn | 18636 | 350 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium vanettenii | |
| 17697444 | 17697444 | PRJNA547066_P_NODE_6054_length_152_cov_1.025641_g5960_i0 | PRJNA547066 | 6054 | 152 | 1.025641 | 1.55897432 | Alternaria | 5598 | Fungi | Fungi | 281 | 1.46e-71 | NTclustered | gi|1070553051|ref|XM_018525212.1| | 5599 | g5960 | i0 | 100 | 99.5197368421053 | 152 | 0 | 100 | 0 | 1 | 152 | 311 | 160 | Alternaria alternata ribosomal protein S3Ae mRNA | blastn | 15127 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 18363143 | 18363143 | PRJNA547066_P_NODE_455_length_716_cov_6.229075_g390_i0 | PRJNA547066 | 455 | 716 | 6.229075 | 44.600177 | Alternaria alternata | 5599 | Fungi | Fungi | 935 | 0 | NTclustered | gi|2791117515|gb|PQ217832.1| | 5599 | g390 | i0 | 99.417 | 84.0055865921788 | 515 | 3 | 72 | 0 | 1 | 515 | 3713 | 4227 | Alternaria alternata isolate Karbala-1 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and external transcribed spacer, partial sequence | blastn | 60148 | 935 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 20913622 | 20913622 | PRJNA547066_P_NODE_6097_length_151_cov_1.724138_g6003_i0 | PRJNA547066 | 6097 | 151 | 1.724138 | 2.60344838 | Alternaria postmessia | 1187938 | Fungi | Fungi | 268 | 1.12e-67 | NTclustered | gi|2324890026|ref|XM_051737652.1| | 1187938 | g6003 | i0 | 98.675 | 8.5364238410596 | 151 | 2 | 100 | 0 | 1 | 151 | 1220 | 1070 | Alternaria postmessia uncharacterized protein (J4E82_011446), partial mRNA | blastn | 1289 | 268 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria postmessia | |
| 20913625 | 20913625 | PRJNA547066_P_NODE_997_length_497_cov_1.792208_g909_i0 | PRJNA547066 | 997 | 497 | 1.792208 | 8.90727376 | Alternaria alternata | 5599 | Fungi | Fungi | 900 | 0 | NTclustered | gi|1070557693|ref|XM_018528700.1| | 5599 | g909 | i0 | 99.395 | 3.95774647887324 | 496 | 3 | 99 | 0 | 2 | 497 | 769 | 274 | Alternaria alternata hypothetical protein partial mRNA | blastn | 1967 | 900 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 21521559 | 21521559 | PRJNA547066_P_NODE_3817_length_213_cov_1.573034_g3723_i0 | PRJNA547066 | 3817 | 213 | 1.573034 | 3.35056242 | Alternaria | 5598 | Fungi | Fungi | 394 | 2.7e-105 | NTclustered | gi|1070552471|ref|XM_018525156.1| | 5599 | g3723 | i0 | 100 | 24.3192488262911 | 213 | 0 | 100 | 0 | 1 | 213 | 486 | 274 | Alternaria alternata mitochondrial import translocase, subunit Tom22 mRNA | blastn | 5180 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 22188397 | 22188397 | PRJNA547066_P_NODE_3558_length_226_cov_1.513089_g3464_i0 | PRJNA547066 | 3558 | 226 | 1.513089 | 3.41958114 | Alternaria ventricosa | 1187951 | Fungi | Fungi | 385 | 1.75e-102 | NTclustered | gi|2272413821|ref|XM_049338779.1| | 1187951 | g3464 | i0 | 97.345 | 40.0044247787611 | 226 | 6 | 100 | 0 | 1 | 226 | 624 | 399 | Alternaria ventricosa uncharacterized protein (J4E93_000822), partial mRNA | blastn | 9041 | 385 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria ventricosa | |
| 24737581 | 24737581 | PRJNA547066_P_NODE_3100_length_251_cov_1.060185_g3006_i0 | PRJNA547066 | 3100 | 251 | 1.060185 | 2.66106435 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 351 | 2e-92 | NTclustered | gi|2725224494|ref|XM_064896381.1| | 1690604 | g3006 | i0 | 98.98 | 0.780876494023904 | 196 | 2 | 78 | 0 | 54 | 249 | 1281 | 1086 | Lithohypha guttulata uncharacterized protein (LTR64_002006), partial mRNA | blastn | 196 | 351 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata |
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);;