contig_metadata
20 rows where bioproject = "PRJNA290839" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2334743 | 2334743 | PRJNA290839_P_NODE_922_length_265_cov_1.619792_g901_i0 | PRJNA290839 | 922 | 265 | 1.619792 | 4.2924488 | Aspergillus | 5052 | Fungi | Fungi | 488 | 1.5599999999999996e-133 | NTclustered | gi|2588676|dbj|AB008407.1| | 5064 | g901 | i0 | 100 | 99.622641509434 | 264 | 0 | 99 | 0 | 2 | 265 | 325 | 62 | Aspergillus restrictus gene for 18S rRNA, partial sequence | blastn | 26400 | 488 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus restrictus | |
| 2923584 | 2923584 | PRJNA290839_P_NODE_1143_length_250_cov_1.661017_g1122_i0 | PRJNA290839 | 1143 | 250 | 1.661017 | 4.1525425 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 267 | 7.43e-67 | NTclustered | gi|1338078511|ref|XM_023766008.1| | 112498 | g1122 | i0 | 86.056 | 34.64 | 251 | 32 | 99 | 1 | 2 | 249 | 2330 | 2080 | Ramularia collo-cygni probable vacuolar H+-ATPase V0 sector, subunit a (RCC_00818), partial mRNA | blastn | 8660 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 2923588 | 2923588 | PRJNA290839_P_NODE_1503_length_244_cov_0.912281_g1482_i0 | PRJNA290839 | 1503 | 244 | 0.912281 | 2.22596564 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 161 | 3.5e-35 | NTclustered | gi|1338080485|ref|XM_023766995.1| | 112498 | g1482 | i0 | 92.793 | 45.0409836065574 | 111 | 8 | 45 | 0 | 1 | 111 | 343 | 453 | Ramularia collo-cygni probable CRP-2 40S ribosomal protein S14 (RCC_01707), partial mRNA | blastn | 10990 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 6162291 | 6162291 | PRJNA290839_P_NODE_1345_length_247_cov_0.896552_g1324_i0 | PRJNA290839 | 1345 | 247 | 0.896552 | 2.21448344 | Aspergillus | 5052 | Fungi | Fungi | 222 | 1.61e-53 | NTclustered | gi|2915766347|ref|XM_041295588.2| | 5059 | g1324 | i0 | 82.927 | 4.98785425101215 | 246 | 42 | 99 | 0 | 2 | 247 | 1056 | 1301 | Aspergillus flavus DnaJ domain protein (F9C07_2287042), mRNA | blastn | 1232 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus flavus | |
| 11851578 | 11851578 | PRJNA290839_P_NODE_430_length_394_cov_1.750779_g409_i0 | PRJNA290839 | 430 | 394 | 1.750779 | 6.89806926 | Pyronema omphalodes CBS 1 | 337075 | Fungi | Fungi | 186 | 9.099999999999997e-55 | NR | CCX32792.1 | 1076935 | g409 | i0 | 70.1 | 15.0837563451777 | 134 | 33 | 99 | 2 | 2 | 391 | 65 | 195 | CCX32792.1 Similar to 60S ribosomal protein L3; acc. no. Q8NKF4 [Pyronema omphalodes CBS 100304] | diamond | 5943 | 186 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pyronemataceae | Pyronema | Pyronema omphalodes | |
| 13126710 | 13126710 | PRJNA290839_P_NODE_1051_length_252_cov_0.871508_g1030_i0 | PRJNA290839 | 1051 | 252 | 0.871508 | 2.19620016 | Histoplasma mississippiense (nom. inval.) | 2059318 | Fungi | Fungi | 145 | 3.66e-30 | NTclustered | gi|154279747|ref|XM_001540637.1| | 2059318 | g1030 | i0 | 78.39 | 70.6507936507936 | 236 | 41 | 92 | 10 | 1 | 231 | 678 | 448 | Histoplasma capsulatum NAm1 14-3-3 family protein ArtA partial mRNA | blastn | 17804 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ajellomycetaceae | Histoplasma | Histoplasma mississippiense (nom. inval.) | |
| 13126721 | 13126721 | PRJNA290839_P_NODE_971_length_257_cov_2.532609_g950_i0 | PRJNA290839 | 971 | 257 | 2.532609 | 6.50880513 | Zymoseptoria tritici | 1047171 | Fungi | Fungi | 470 | 5.45e-128 | NTclustered | gi|283827972|gb|EU019298.2| | 1047171 | g950 | i0 | 100 | 98.8249027237354 | 254 | 0 | 99 | 0 | 1 | 254 | 1846 | 2099 | Zymoseptoria tritici strain CBS 110744 28S large subunit ribosomal RNA gene, partial sequence | blastn | 25398 | 470 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zymoseptoria | Zymoseptoria tritici | |
| 16950301 | 16950301 | PRJNA290839_P_NODE_714_length_303_cov_1.673913_g693_i0 | PRJNA290839 | 714 | 303 | 1.673913 | 5.07195639 | Fusarium | 5506 | Fungi | Fungi | 157 | 2.2799999999999998e-46 | NR | KAJ3522460.1 | 57161 | g693 | i0 | 74 | 25.4059405940594 | 100 | 26 | 99 | 0 | 1 | 300 | 47 | 146 | KAJ3522460.1 hypothetical protein NM208_g12851 [Fusarium decemcellulare] | diamond | 7698 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium decemcellulare | |
| 23324958 | 23324958 | PRJNA290839_P_NODE_399_length_409_cov_1.601190_g378_i0 | PRJNA290839 | 399 | 409 | 1.60119 | 6.5488671 | Candida metapsilosis | 273372 | Fungi | Fungi | 289 | 2.75e-73 | NTclustered | gi|2797500673|ref|XM_067693905.1| | 273372 | g378 | i0 | 79.612 | 22.0171149144254 | 412 | 76 | 99 | 8 | 1 | 408 | 974 | 1381 | Candida metapsilosis EFT1 (I9W82_004797), partial mRNA | blastn | 9005 | 289 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida metapsilosis | |
| 25285580 | 25285580 | PRJNA290839_P_NODE_200_length_610_cov_4.033520_g179_i0 | PRJNA290839 | 200 | 610 | 4.03352 | 24.604472 | Ascomycota | 4890 | Fungi | Fungi | 1112 | 0 | NTclustered | gi|17426671|emb|AJ301970.1| | 5462 | g179 | i0 | 99.671 | 98.3885245901639 | 608 | 2 | 99 | 0 | 3 | 610 | 1442 | 835 | Glomerella lagenaria 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), internal transcribed spacer 1 (ITS1) and internal transcribed spacer 2 (ITS2), strain BBA 71047 | blastn | 60017 | 1122 | 0.991087344028521 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum lagenaria | |
| 25285581 | 25285581 | PRJNA290839_P_NODE_960_length_259_cov_1.247312_g939_i0 | PRJNA290839 | 960 | 259 | 1.247312 | 3.23053808 | Fungi | 4751 | Fungi | Fungi | 134 | 1.75e-37 | NR | KAG6272318.1 | 5111 | g939 | i0 | 75.3 | 61.7374517374517 | 85 | 21 | 98.5 | 0 | 5 | 259 | 130 | 214 | KAG6272318.1 hypothetical protein E4U48_003178 [Claviceps purpurea] | diamond | 15990 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Claviceps | Claviceps purpurea | |
| 26915980 | 26915980 | PRJNA290839_P_NODE_1042_length_252_cov_0.871508_g1021_i0 | PRJNA290839 | 1042 | 252 | 0.871508 | 2.19620016 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 60.1 | 3.24e-8 | NR | XP_023631220.1 | 112498 | g1021 | i0 | 65.7 | 0.797619047619048 | 67 | 15 | 79.8 | 2 | 206 | 6 | 1 | 59 | XP_023631220.1 related to serine/threonine-specific protein kinase KIN1 [Ramularia collo-cygni] | diamond | 201 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 27010808 | 27010808 | PRJNA290839_P_NODE_1642_length_242_cov_0.917160_g1621_i0 | PRJNA290839 | 1642 | 242 | 0.91716 | 2.2195272 | Aureobasidium namibiae CBS 147.97 | 1043004 | Fungi | Fungi | 129 | 7.68e-33 | NR | XP_013422394.1 | 1043004 | g1621 | i0 | 79.7 | 0.979338842975207 | 79 | 16 | 97.9 | 0 | 239 | 3 | 414 | 492 | XP_013422394.1 CoA-transferase family III [Aureobasidium namibiae CBS 147.97] | diamond | 237 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium namibiae | |
| 27060203 | 27060203 | PRJNA290839_P_NODE_1122_length_251_cov_0.870787_g1101_i0 | PRJNA290839 | 1122 | 251 | 0.870787 | 2.18567537 | Ascomycota | 4890 | Fungi | Fungi | 46.2 | 0.00238 | NR | XP_043027831.1 | 83186 | g1101 | i0 | 33.8 | 1.85258964143426 | 77 | 50 | 90.8 | 1 | 8 | 235 | 37 | 113 | XP_043027831.1 uncharacterized protein INS49_005911 [Diaporthe citri] | diamond | 465 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Diaporthaceae | Diaporthe | Diaporthe citri | |
| 27597469 | 27597469 | PRJNA290839_P_NODE_1024_length_253_cov_0.866667_g1003_i0 | PRJNA290839 | 1024 | 253 | 0.866667 | 2.19266751 | Penicillium | 5073 | Fungi | Fungi | 143 | 2.08e-38 | NR | KGO76372.1 | 40296 | g1003 | i0 | 84.5 | 8.95256916996047 | 84 | 13 | 99.6 | 0 | 253 | 2 | 46 | 129 | KGO76372.1 Major facilitator superfamily domain, general substrate transporter [Penicillium italicum] | diamond | 2265 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium italicum | |
| 27597470 | 27597470 | PRJNA290839_P_NODE_524_length_356_cov_1.558304_g503_i0 | PRJNA290839 | 524 | 356 | 1.558304 | 5.54756224 | Fungi | 4751 | Fungi | Fungi | 155 | 1.1999999999999998e-44 | NR | KAI5787631.1 | 61495 | g503 | i0 | 62.4 | 32.5449438202247 | 117 | 44 | 98.6 | 0 | 353 | 3 | 8 | 124 | KAI5787631.1 putative 40S ribosomal protein S6-B [Peziza echinospora] | diamond | 11586 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pezizaceae | Peziza | Peziza echinospora | |
| 27769406 | 27769406 | PRJNA290839_P_NODE_1484_length_245_cov_0.895349_g1463_i0 | PRJNA290839 | 1484 | 245 | 0.895349 | 2.19360505 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 127 | 5.489999999999999e-32 | NR | XP_023624035.1 | 112498 | g1463 | i0 | 91.5 | 1.00408163265306 | 82 | 6 | 99.2 | 1 | 244 | 2 | 461 | 542 | XP_023624035.1 related to transcription factor MBP1 [Ramularia collo-cygni] | diamond | 246 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 28891660 | 28891660 | PRJNA290839_P_NODE_1428_length_246_cov_0.890173_g1407_i0 | PRJNA290839 | 1428 | 246 | 0.890173 | 2.18982558 | Sordariomycetes | 147550 | Fungi | Fungi | 107 | 6.79e-25 | NR | OTA63215.1 | 1001937 | g1407 | i0 | 59.8 | 17 | 82 | 33 | 100 | 0 | 246 | 1 | 179 | 260 | OTA63215.1 nonsense-mediated mRNA decay protein 3 [Hypoxylon sp. EC38] | diamond | 4182 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Hypoxylaceae | Hypoxylon | Hypoxylon sp. EC38 | |
| 31387588 | 31387588 | PRJNA290839_P_NODE_476_length_375_cov_0.837748_g455_i0 | PRJNA290839 | 476 | 375 | 0.837748 | 3.141555 | Fungi | 4751 | Fungi | Fungi | 144 | 5.53e-40 | NR | KKA27399.1 | 72032 | g455 | i0 | 57.9 | 18.152 | 126 | 51 | 99.2 | 1 | 2 | 373 | 45 | 170 | KKA27399.1 hypothetical protein TD95_000487 [Thielaviopsis punctulata] | diamond | 6807 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Ceratocystidaceae | Thielaviopsis | Thielaviopsis punctulata | |
| 31938987 | 31938987 | PRJNA290839_P_NODE_1157_length_250_cov_0.881356_g1136_i0 | PRJNA290839 | 1157 | 250 | 0.881356 | 2.20339 | Aspergillus glaucus CBS 516.65 | 1160497 | Fungi | Fungi | 44.3 | 0.0109 | NR | XP_022399688.1 | 1160497 | g1136 | i0 | 44.1 | 0.708 | 59 | 29 | 67.2 | 2 | 9 | 176 | 3 | 60 | XP_022399688.1 uncharacterized protein ASPGLDRAFT_48317 [Aspergillus glaucus CBS 516.65] | diamond | 177 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus |
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);;