contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA557436" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 535645 | 535645 | PRJNA557436_S_NODE_4181_length_196_cov_4.968944_g4133_i0 | PRJNA557436 | 4181 | 196 | 4.968944 | 9.73913024 | Verticillium dahliae | 27337 | Fungi | Fungi | 329 | 6.99e-86 | NTclustered | gi|6537145|gb|AF104926.1|AF104926 | 27337 | g4133 | i0 | 96.954 | 100.484693877551 | 197 | 4 | 100 | 2 | 1 | 196 | 5239 | 5434 | Verticillium dahliae 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 19695 | 329 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Plectosphaerellaceae | Verticillium | Verticillium dahliae | |
| 1128240 | 1128240 | PRJNA557436_S_NODE_2561_length_237_cov_11.985149_g2513_i0 | PRJNA557436 | 2561 | 237 | 11.985149 | 28.40480313 | Eukaryota | 2759 | Fungi | Fungi | 409 | 1.1e-109 | NTclustered | gi|1280049812|gb|MF072571.1| | 29917 | g2513 | i0 | 100 | 93.2489451476793 | 221 | 0 | 93 | 0 | 1 | 221 | 260 | 40 | Cladosporium cladosporioides strain 007 small subunit ribosomal RNA gene, partial sequence | blastn | 22100 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 2403681 | 2403681 | PRJNA557436_S_NODE_5062_length_183_cov_6.337838_g5014_i0 | PRJNA557436 | 5062 | 183 | 6.337838 | 11.59824354 | Ascomycota | 4890 | Fungi | Fungi | 339 | 1.07e-88 | NTclustered | gi|2310839299|gb|OP550095.1| | 5059 | g5014 | i0 | 100 | 100 | 183 | 0 | 100 | 0 | 1 | 183 | 565 | 747 | Aspergillus flavus isolate Re-10 large subunit ribosomal RNA gene, partial sequence | blastn | 18300 | 339 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus flavus | |
| 2403693 | 2403693 | PRJNA557436_S_NODE_8542_length_154_cov_4.705882_g8494_i0 | PRJNA557436 | 8542 | 154 | 4.705882 | 7.24705828 | Fungi | 4751 | Fungi | Fungi | 285 | 1.14e-72 | NTclustered | gi|2047428661|gb|MZ330753.1| | 5599 | g8494 | i0 | 100 | 100 | 154 | 0 | 100 | 0 | 1 | 154 | 1365 | 1212 | Alternaria alternata strain SALIM.A.H small subunit ribosomal RNA gene, partial sequence | blastn | 15400 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 4362981 | 4362981 | PRJNA557436_S_NODE_6264_length_170_cov_1.925926_g6216_i0 | PRJNA557436 | 6264 | 170 | 1.925926 | 3.2740742 | Pseudocercospora fijiensis | 1873960 | Fungi | Fungi | 65.8 | 1.83e-6 | NTclustered | gi|631387901|ref|XM_007930140.1| | 383855 | g6216 | i0 | 97.368 | 70.3176470588235 | 38 | 1 | 22 | 0 | 123 | 160 | 3468 | 3431 | Pseudocercospora fijiensis CIRAD86 uncharacterized protein (MYCFIDRAFT_176360), partial mRNA | blastn | 11954 | 65.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora fijiensis | |
| 6231950 | 6231950 | PRJNA557436_S_NODE_925_length_372_cov_8.893175_g877_i0 | PRJNA557436 | 925 | 372 | 8.893175 | 33.082611 | Ascomycota | 4890 | Fungi | Fungi | 621 | 2.1499999999999998e-173 | NTclustered | gi|1078193887|gb|KU844333.1| | 38038 | g877 | i0 | 96.783 | 100.274193548387 | 373 | 11 | 100 | 1 | 1 | 372 | 751 | 1123 | Rhynchosporium secalis isolate 02CH4-6a.1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 37302 | 627 | 0.990430622009569 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Ploettnerulaceae | Rhynchosporium | Rhynchosporium secalis | |
| 7506312 | 7506312 | PRJNA557436_S_NODE_1406_length_309_cov_4.299270_g1358_i0 | PRJNA557436 | 1406 | 309 | 4.29927 | 13.2847443 | Plectosphaerellaceae | 1033978 | Fungi | Fungi | 521 | 1.8299999999999998e-143 | NTclustered | gi|1473259642|gb|MH872586.1| | 132135 | g1358 | i0 | 99.649 | 91.3915857605178 | 285 | 1 | 92 | 0 | 25 | 309 | 15 | 299 | Musicillium theobromae culture CBS:243.74 strain CBS 243.74 large subunit ribosomal RNA gene, partial sequence | blastn | 28240 | 521 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Plectosphaerellaceae | Musicillium | Musicillium theobromae | |
| 7506324 | 7506324 | PRJNA557436_S_NODE_7106_length_163_cov_10.531250_g7058_i0 | PRJNA557436 | 7106 | 163 | 10.53125 | 17.1659375 | root | 1 | Root_unresolved | Root_unresolved | 302 | 1.22e-77 | NTclustered | gi|1280049812|gb|MF072571.1| | 29917 | g7058 | i0 | 100 | 100 | 163 | 0 | 100 | 0 | 1 | 163 | 553 | 715 | Cladosporium cladosporioides strain 007 small subunit ribosomal RNA gene, partial sequence | blastn | 16300 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 8188577 | 8188577 | PRJNA557436_S_NODE_4067_length_198_cov_3.398773_g4019_i0 | PRJNA557436 | 4067 | 198 | 3.398773 | 6.72957054 | uncultured Readeriella | 1193705 | Fungi | Fungi | 361 | 2.51e-95 | NTclustered | gi|453201589|gb|JQ999569.1| | 1193705 | g4019 | i0 | 99.495 | 105.444444444444 | 198 | 1 | 100 | 0 | 1 | 198 | 414 | 217 | Uncultured Readeriella clone GKJWQY101AXTXW 28S ribosomal RNA gene, partial sequence | blastn | 20878 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Capnodiales | uncultured Readeriella | |||
| 10739836 | 10739836 | PRJNA557436_S_NODE_6849_length_165_cov_2.515385_g6801_i0 | PRJNA557436 | 6849 | 165 | 2.515385 | 4.15038525 | Alternaria conjuncta | 181017 | Fungi | Fungi | 56.5 | 0.001 | NTclustered | gi|2323894461|ref|XM_051472797.1| | 181017 | g6801 | i0 | 100 | 1.04848484848485 | 30 | 0 | 18 | 0 | 128 | 157 | 2468 | 2439 | Alternaria conjuncta uncharacterized protein (J4E85_008573), partial mRNA | blastn | 173 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria conjuncta | |
| 13882189 | 13882189 | PRJNA557436_S_NODE_2771_length_229_cov_23.324742_g2723_i0 | PRJNA557436 | 2771 | 229 | 23.324742 | 53.41365918 | Ascomycota | 4890 | Fungi | Fungi | 235 | 1.89e-57 | NTclustered | gi|283827979|gb|DQ008163.2| | 5499 | g2723 | i0 | 100 | 103.056768558952 | 127 | 0 | 100 | 0 | 103 | 229 | 2371 | 2497 | Passalora fulva strain CBS 119.46 28S large subunit ribosomal RNA gene, partial sequence | blastn | 23600 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Fulvia | Fulvia fulva | |
| 13882190 | 13882190 | PRJNA557436_S_NODE_2871_length_226_cov_7.287958_g2823_i0 | PRJNA557436 | 2871 | 226 | 7.287958 | 16.47078508 | Cladosporium | 5498 | Fungi | Fungi | 414 | 2.23e-111 | NTclustered | gi|283827952|gb|EU019262.2| | 29917 | g2823 | i0 | 100 | 25.5929203539823 | 224 | 0 | 99 | 0 | 3 | 226 | 3275 | 3052 | Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence | blastn | 5784 | 414 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 13882191 | 13882191 | PRJNA557436_S_NODE_3051_length_221_cov_21.134409_g3003_i0 | PRJNA557436 | 3051 | 221 | 21.134409 | 46.70704389 | Eukaryota | 2759 | Fungi | Fungi | 287 | 4.93e-73 | NTclustered | gi|1759050544|gb|CP039677.1| | 13684 | g3003 | i0 | 98.758 | 96.2398190045249 | 161 | 2 | 89 | 0 | 41 | 201 | 1301484 | 1301324 | Parastagonospora nodorum strain Sn79 chromosome 12 | blastn | 21269 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora nodorum | |
| 15838473 | 15838473 | PRJNA557436_S_NODE_4253_length_195_cov_2.662500_g4205_i0 | PRJNA557436 | 4253 | 195 | 2.6625 | 5.191875 | Musicillium theobromae | 132135 | Fungi | Fungi | 361 | 2.46e-95 | NTclustered | gi|1561109618|emb|LR025909.1| | 132135 | g4205 | i0 | 100 | 99.9948717948718 | 195 | 0 | 100 | 0 | 1 | 195 | 408 | 602 | Musicillium theobromae genomic DNA sequence contains 28S rRNA gene | blastn | 19499 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Plectosphaerellaceae | Musicillium | Musicillium theobromae | |
| 17706212 | 17706212 | PRJNA557436_S_NODE_2134_length_257_cov_13.941441_g2086_i0 | PRJNA557436 | 2134 | 257 | 13.941441 | 35.82950337 | Eukaryota | 2759 | Fungi | Fungi | 470 | 5.45e-128 | NTclustered | gi|2532687033|gb|OR243761.1| | 29917 | g2086 | i0 | 99.611 | 99.9805447470817 | 257 | 1 | 100 | 0 | 1 | 257 | 3662 | 3918 | 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 | 25695 | 470 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 24080182 | 24080182 | PRJNA557436_S_NODE_4359_length_193_cov_28.474684_g4311_i0 | PRJNA557436 | 4359 | 193 | 28.474684 | 54.95614012 | root | 1 | Root_unresolved | Root_unresolved | 351 | 1.46e-92 | NTclustered | gi|1331395967|gb|MG815782.1| | 5539 | g4311 | i0 | 99.482 | 100 | 193 | 1 | 100 | 0 | 1 | 193 | 5034 | 4842 | Scytalidium lignicola strain DSM 105466 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 | 19300 | 351 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Scytalidium | Scytalidium lignicola | |||
| 25354522 | 25354522 | PRJNA557436_S_NODE_2160_length_256_cov_8.846154_g2112_i0 | PRJNA557436 | 2160 | 256 | 8.846154 | 22.64615424 | Ascomycota | 4890 | Fungi | Fungi | 462 | 9.07e-126 | NTclustered | gi|283827952|gb|EU019262.2| | 29917 | g2112 | i0 | 99.219 | 100.0078125 | 256 | 2 | 100 | 0 | 1 | 256 | 1919 | 2174 | Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence | blastn | 25602 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 25354531 | 25354531 | PRJNA557436_S_NODE_4180_length_196_cov_17.118012_g4132_i0 | PRJNA557436 | 4180 | 196 | 17.118012 | 33.55130352 | Eukaryota | 2759 | Fungi | Fungi | 363 | 6.899999999999998e-96 | NTclustered | gi|2532687033|gb|OR243761.1| | 29917 | g4132 | i0 | 100 | 100.239795918367 | 196 | 0 | 100 | 0 | 1 | 196 | 4089 | 3894 | 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 | 19647 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 25354547 | 25354547 | PRJNA557436_S_NODE_8540_length_154_cov_9.058824_g8492_i0 | PRJNA557436 | 8540 | 154 | 9.058824 | 13.95058896 | Eukaryota | 2759 | Fungi | Fungi | 285 | 1.14e-72 | NTclustered | gi|2532687033|gb|OR243761.1| | 29917 | g8492 | i0 | 100 | 99.0974025974026 | 154 | 0 | 100 | 0 | 1 | 154 | 3673 | 3520 | 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 | 15261 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides |
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);;