contig_metadata
26 rows where analysis = "blastn", bioproject = "PRJNA564810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 554078 | 554078 | PRJNA564810_S_NODE_3781_length_278_cov_1.915493_g3759_i0 | PRJNA564810 | 3781 | 278 | 1.915493 | 5.32507054 | Botrytis cinerea | 40559 | Fungi | Fungi | 52.8 | 0.026 | NTclustered | gi|1377706441|ref|XM_024692410.1| | 332648 | g3759 | i0 | 100 | 0.100719424460432 | 28 | 0 | 10 | 0 | 16 | 43 | 1380 | 1407 | Botrytis cinerea B05.10 hypothetical protein (BCIN_04g01810), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 1829644 | 1829644 | PRJNA564810_S_NODE_1522_length_360_cov_11.772881_g1500_i0 | PRJNA564810 | 1522 | 360 | 11.772881 | 42.3823716 | Arthrobotrys flagrans | 97331 | Fungi | Fungi | 167 | 1.17e-36 | NTclustered | gi|2797357528|ref|XM_067630255.1| | 97331 | g1500 | i0 | 85.987 | 10.4277777777778 | 157 | 20 | 43 | 2 | 205 | 360 | 419 | 264 | Arthrobotrys flagrans 40S ribosomal protein uS11 (DFL_001609), partial mRNA | blastn | 3754 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Arthrobotrys | Arthrobotrys flagrans | |
| 4381633 | 4381633 | PRJNA564810_S_NODE_3224_length_292_cov_1.797357_g3202_i0 | PRJNA564810 | 3224 | 292 | 1.797357 | 5.24828244 | Candida albicans | 5476 | Fungi | Fungi | 508 | 1.34e-139 | NTclustered | gi|2530258974|gb|CP115799.1| | 5476 | g3202 | i0 | 97.959 | 3.92123287671233 | 294 | 4 | 100 | 1 | 1 | 292 | 1813721 | 1814014 | Candida albicans strain Fungi-01 chromosome 2 | blastn | 1145 | 508 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida albicans | |
| 4381637 | 4381637 | PRJNA564810_S_NODE_3604_length_282_cov_2.193548_g3582_i0 | PRJNA564810 | 3604 | 282 | 2.193548 | 6.18580536 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 363 | 1.0599999999999999e-95 | NTclustered | gi|2837746722|ref|XM_069373243.1| | 1052096 | g3582 | i0 | 100 | 0.695035460992908 | 196 | 0 | 70 | 0 | 1 | 196 | 196 | 1 | Cladosporium halotolerans uncharacterized protein (WHR41_04637), partial mRNA | blastn | 196 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 5657981 | 5657981 | PRJNA564810_S_NODE_385_length_535_cov_2.723404_g366_i0 | PRJNA564810 | 385 | 535 | 2.723404 | 14.5702114 | Trichoderma atroviride | 63577 | Fungi | Fungi | 86.1 | 5.18e-12 | NTclustered | gi|2749703766|ref|XM_014090103.2| | 63577 | g366 | i0 | 88 | 0.824299065420561 | 75 | 6 | 14 | 1 | 402 | 476 | 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 | |
| 5657992 | 5657992 | PRJNA564810_S_NODE_5805_length_240_cov_2.074286_g5783_i0 | PRJNA564810 | 5805 | 240 | 2.074286 | 4.9782864 | Aureobasidium pullulans | 5580 | Fungi | Fungi | 213 | 9.36e-51 | NTclustered | gi|1701898879|ref|XM_029901250.1| | 1043002 | g5783 | i0 | 93.103 | 2.23333333333333 | 145 | 10 | 60 | 0 | 96 | 240 | 372 | 228 | Aureobasidium pullulans EXF-150 FKBP-type peptidyl-prolyl isomeras-like protein (M438DRAFT_281554), partial mRNA | blastn | 536 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 6237115 | 6237115 | PRJNA564810_S_NODE_5425_length_246_cov_1.453039_g5403_i0 | PRJNA564810 | 5425 | 246 | 1.453039 | 3.57447594 | Penicillium | 5073 | Fungi | Fungi | 335 | 1.9699999999999992e-87 | NTclustered | gi|2799019476|gb|PQ285861.1| | 60171 | g5403 | i0 | 91.463 | 92.0243902439024 | 246 | 17 | 100 | 4 | 1 | 246 | 3127 | 2886 | Penicillium verrucosum mitochondrion, complete genome | blastn | 22638 | 335 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium verrucosum | |
| 6932228 | 6932228 | PRJNA564810_S_NODE_7126_length_222_cov_0.859873_g7104_i0 | PRJNA564810 | 7126 | 222 | 0.859873 | 1.90891806 | Stemphylium lycopersici | 183478 | Fungi | Fungi | 152 | 1.89e-32 | NTclustered | gi|1267170312|ref|NC_036039.1| | 183478 | g7104 | i0 | 94 | 16.4189189189189 | 100 | 6 | 45 | 0 | 63 | 162 | 1419 | 1320 | Stemphylium lycopersici strain CIDEFI-216 mitochondrion, complete genome | blastn | 3645 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Stemphylium | Stemphylium lycopersici | |
| 9482540 | 9482540 | PRJNA564810_S_NODE_2728_length_307_cov_1.404959_g2706_i0 | PRJNA564810 | 2728 | 307 | 1.404959 | 4.31322413 | Cucurbitaria berberidis | 45142 | Fungi | Fungi | 372 | 1.94e-98 | NTclustered | gi|2027958014|ref|XM_040933488.1| | 1168544 | g2706 | i0 | 88.673 | 51.9641693811075 | 309 | 30 | 99 | 4 | 4 | 307 | 460 | 152 | Cucurbitaria berberidis CBS 394.84 ribosomal protein S21e (K460DRAFT_366986), mRNA | blastn | 15953 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Cucurbitariaceae | Cucurbitaria | Cucurbitaria berberidis | |
| 9482544 | 9482544 | PRJNA564810_S_NODE_4348_length_266_cov_1.014925_g4326_i0 | PRJNA564810 | 4348 | 266 | 1.014925 | 2.6997005 | Penicillium chrysogenum | 5076 | Fungi | Fungi | 444 | 3.43e-120 | NTclustered | gi|2513249237|ref|XM_056711007.1| | 5076 | g4326 | i0 | 100 | 2.75563909774436 | 240 | 0 | 90 | 0 | 27 | 266 | 58 | 297 | Penicillium chrysogenum uncharacterized protein (N7489_005255), partial mRNA | blastn | 733 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium chrysogenum | |
| 10062078 | 10062078 | PRJNA564810_S_NODE_1068_length_397_cov_5.481928_g1046_i0 | PRJNA564810 | 1068 | 397 | 5.481928 | 21.76325416 | Aspergillus | 5052 | Fungi | Fungi | 130 | 1.71e-25 | NTclustered | gi|2582610878|ref|XM_001389612.3| | 5061 | g1046 | i0 | 84.328 | 5.67254408060453 | 134 | 19 | 34 | 2 | 216 | 348 | 478 | 346 | Aspergillus niger 60S ribosomal protein uL22 (An01g12420), partial mRNA | blastn | 2252 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 11336729 | 11336729 | PRJNA564810_S_NODE_1309_length_376_cov_5.684887_g1287_i0 | PRJNA564810 | 1309 | 376 | 5.684887 | 21.37517512 | Apiospora | 1811811 | Fungi | Fungi | 159 | 2.0499999999999998e-34 | NTclustered | gi|2781297729|ref|XM_066836987.1| | 335848 | g1287 | i0 | 83.529 | 2.97872340425532 | 170 | 28 | 45 | 0 | 12 | 181 | 168 | 337 | Apiospora aurea 60S ribosomal protein eL43 (PG986_000765), partial mRNA | blastn | 1120 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Apiosporaceae | Apiospora | Apiospora aurea | |
| 13308229 | 13308229 | PRJNA564810_S_NODE_2611_length_311_cov_3.528455_g2589_i0 | PRJNA564810 | 2611 | 311 | 3.528455 | 10.97349505 | Penicillium vulpinum | 29845 | Fungi | Fungi | 239 | 2.08e-58 | NTclustered | gi|2517858897|ref|XM_057252630.1| | 29845 | g2589 | i0 | 93.252 | 10.4308681672026 | 163 | 9 | 52 | 2 | 150 | 311 | 1374 | 1213 | Penicillium vulpinum uncharacterized protein (N7479_004933), mRNA | blastn | 3244 | 239 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium vulpinum | |
| 15161660 | 15161660 | PRJNA564810_S_NODE_4072_length_271_cov_6.320388_g4050_i0 | PRJNA564810 | 4072 | 271 | 6.320388 | 17.12825148 | Dothideomycetes | 147541 | Fungi | Fungi | 104 | 6.76e-18 | NTclustered | gi|1701902543|ref|XM_029906493.1| | 1043002 | g4050 | i0 | 83.186 | 17.9815498154982 | 113 | 19 | 42 | 0 | 120 | 232 | 476 | 364 | Aureobasidium pullulans EXF-150 ribosomal protein S8 (M438DRAFT_349871), mRNA | blastn | 4873 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 15856855 | 15856855 | PRJNA564810_S_NODE_5653_length_242_cov_2.909605_g5631_i0 | PRJNA564810 | 5653 | 242 | 2.909605 | 7.0412441 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 309 | 1.17e-79 | NTclustered | gi|2837751996|ref|XM_069373636.1| | 1052096 | g5631 | i0 | 89.958 | 92.0165289256198 | 239 | 24 | 99 | 0 | 1 | 239 | 317 | 555 | Cladosporium halotolerans 60S ribosomal protein uL11 (rpl-12), mRNA | blastn | 22268 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 17131878 | 17131878 | PRJNA564810_S_NODE_4514_length_262_cov_2.071066_g4492_i0 | PRJNA564810 | 4514 | 262 | 2.071066 | 5.42619292 | Alternaria alternata | 5599 | Fungi | Fungi | 484 | 1.99e-132 | NTclustered | gi|1070556365|ref|XM_018525479.1| | 5599 | g4492 | i0 | 100 | 2.69083969465649 | 262 | 0 | 100 | 0 | 1 | 262 | 1386 | 1647 | Alternaria alternata hypothetical protein mRNA | blastn | 705 | 484 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 19680649 | 19680649 | PRJNA564810_S_NODE_1716_length_350_cov_2.147368_g1694_i0 | PRJNA564810 | 1716 | 350 | 2.147368 | 7.515788 | Macroventuria anomochaeta | 301207 | Fungi | Fungi | 117 | 1.16e-21 | NTclustered | gi|1833408557|ref|XM_033709588.1| | 301207 | g1694 | i0 | 88.542 | 0.468571428571429 | 96 | 11 | 27 | 0 | 255 | 350 | 3518 | 3423 | Macroventuria anomochaeta uncharacterized protein (BU25DRAFT_448174), mRNA | blastn | 164 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Macroventuria | Macroventuria anomochaeta | |
| 19680651 | 19680651 | PRJNA564810_S_NODE_3576_length_283_cov_0.912844_g3554_i0 | PRJNA564810 | 3576 | 283 | 0.912844 | 2.58334852 | Macroventuria anomochaeta | 301207 | Fungi | Fungi | 80.5 | 1.2e-10 | NTclustered | gi|1833415616|ref|XM_033708728.1| | 301207 | g3554 | i0 | 79.487 | 1.4452296819788 | 117 | 20 | 41 | 3 | 1 | 115 | 50 | 164 | Macroventuria anomochaeta uncharacterized protein (BU25DRAFT_432551), partial mRNA | blastn | 409 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Macroventuria | Macroventuria anomochaeta | |
| 19680652 | 19680652 | PRJNA564810_S_NODE_4116_length_271_cov_0.941748_g4094_i0 | PRJNA564810 | 4116 | 271 | 0.941748 | 2.55213708 | Alternaria alternata | 5599 | Fungi | Fungi | 318 | 2.2199999999999995e-82 | NTclustered | gi|1070562981|ref|XM_018526072.1| | 5599 | g4094 | i0 | 89.879 | 2.64944649446494 | 247 | 25 | 91 | 0 | 25 | 271 | 830 | 584 | Alternaria alternata hypothetical protein mRNA | blastn | 718 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 20956273 | 20956273 | PRJNA564810_S_NODE_337_length_560_cov_11.002020_g318_i0 | PRJNA564810 | 337 | 560 | 11.00202 | 61.611312 | Thermothielavioides terrestris | 2587410 | Fungi | Fungi | 169 | 5.25e-37 | NTclustered | gi|367054815|ref|XM_003657738.1| | 578455 | g318 | i0 | 88.028 | 25.5732142857143 | 142 | 17 | 25 | 0 | 31 | 172 | 402 | 543 | Thermothielavioides terrestris NRRL 8126 60S ribosomal protein L15 (THITE_2083064), mRNA | blastn | 14321 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Thermothielavioides | Thermothielavioides terrestris | |
| 20956276 | 20956276 | PRJNA564810_S_NODE_5297_length_248_cov_2.229508_g5275_i0 | PRJNA564810 | 5297 | 248 | 2.229508 | 5.52917984 | Aureobasidium pullulans | 5580 | Fungi | Fungi | 453 | 5.2600000000000005e-123 | NTclustered | gi|1701863371|ref|XM_029904501.1| | 1043002 | g5275 | i0 | 99.597 | 42.1653225806452 | 248 | 1 | 100 | 0 | 1 | 248 | 630 | 383 | Aureobasidium pullulans EXF-150 60S ribosomal protein L23a (M438DRAFT_341420), mRNA | blastn | 10457 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 21535542 | 21535542 | PRJNA564810_S_NODE_4057_length_272_cov_1.314010_g4035_i0 | PRJNA564810 | 4057 | 272 | 1.31401 | 3.5741072 | Exophiala | 5583 | Fungi | Fungi | 503 | 5.729999999999998e-138 | NTclustered | gi|229614745|gb|FJ225743.1| | 215243 | g4035 | i0 | 100 | 100.459558823529 | 272 | 0 | 100 | 0 | 1 | 272 | 400 | 129 | Exophiala oligosperma isolate CBS 725.88 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 27325 | 503 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala oligosperma | |
| 22231264 | 22231264 | PRJNA564810_S_NODE_1118_length_392_cov_15.532110_g1096_i0 | PRJNA564810 | 1118 | 392 | 15.53211 | 60.8858712 | Aspergillus pseudodeflectus | 176178 | Fungi | Fungi | 255 | 2.66e-63 | NTclustered | gi|2897739916|ref|XM_071040180.1| | 176178 | g1096 | i0 | 84.151 | 57.4362244897959 | 265 | 40 | 67 | 2 | 1 | 264 | 242 | 505 | Aspergillus pseudodeflectus 40S ribosomal protein uS15 (BJX68DRAFT_237339), mRNA | blastn | 22515 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus pseudodeflectus | |
| 22231279 | 22231279 | PRJNA564810_S_NODE_7478_length_218_cov_1.777778_g7456_i0 | PRJNA564810 | 7478 | 218 | 1.777778 | 3.87555604 | Purpureocillium takamizusanense | 2060973 | Fungi | Fungi | 54.7 | 0.005 | NTclustered | gi|2234653463|ref|XM_047983593.1| | 2060973 | g7456 | i0 | 100 | 0.522935779816514 | 29 | 0 | 13 | 0 | 130 | 158 | 1203 | 1175 | Purpureocillium takamizusanense uncharacterized protein (JDV02_002556), mRNA | blastn | 114 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium takamizusanense | |
| 24780395 | 24780395 | PRJNA564810_S_NODE_2140_length_330_cov_4.011321_g2118_i0 | PRJNA564810 | 2140 | 330 | 4.011321 | 13.2373593 | Rhinocladiella mackenziei | 86056 | Fungi | Fungi | 84.2 | 1.1e-11 | NTclustered | gi|915089880|ref|XM_013420623.1| | 1442369 | g2118 | i0 | 90.476 | 0.436363636363636 | 63 | 6 | 19 | 0 | 243 | 305 | 1881 | 1819 | Rhinocladiella mackenziei CBS 650.93 hsp72-like protein (Z518_00019), partial mRNA | blastn | 144 | 84.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Rhinocladiella | Rhinocladiella mackenziei | |
| 24780410 | 24780410 | PRJNA564810_S_NODE_5740_length_241_cov_2.704545_g5718_i0 | PRJNA564810 | 5740 | 241 | 2.704545 | 6.51795345 | Alternaria alternata | 5599 | Fungi | Fungi | 440 | 3.959999999999999e-119 | NTclustered | gi|1850539|gb|U87806.1|AAU87806 | 5599 | g5718 | i0 | 99.585 | 36.6182572614108 | 241 | 1 | 100 | 0 | 1 | 241 | 250 | 490 | Alternaria alternata ribosomal P2 phosphoprotein mRNA, complete cds | blastn | 8825 | 440 | 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);;