contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA280983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1058998 | 1058998 | PRJNA280983_P_NODE_10341_length_165_cov_0.879310_g10226_i0 | PRJNA280983 | 10341 | 165 | 0.87931 | 1.4508615 | root | 1 | Root_unresolved | Root_unresolved | 305 | 9.59e-79 | NTclustered | gi|2030893237|gb|CP063273.1| | 4932 | g10226 | i0 | 100 | 227.6 | 165 | 0 | 100 | 0 | 1 | 165 | 60797 | 60961 | Saccharomyces cerevisiae strain IMF17 mitochondrion, complete genome | blastn | 37554 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 2334209 | 2334209 | PRJNA280983_P_NODE_9222_length_175_cov_2.603175_g9107_i0 | PRJNA280983 | 9222 | 175 | 2.603175 | 4.55555625 | root | 1 | Root_unresolved | Root_unresolved | 324 | 2.83e-84 | NTclustered | gi|283827979|gb|DQ008163.2| | 5499 | g9107 | i0 | 100 | 106.005714285714 | 175 | 0 | 100 | 0 | 1 | 175 | 2600 | 2774 | Passalora fulva strain CBS 119.46 28S large subunit ribosomal RNA gene, partial sequence | blastn | 18551 | 324 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Fulvia | Fulvia fulva | |
| 2922317 | 2922317 | PRJNA280983_P_NODE_323_length_1229_cov_5.268644_g266_i0 | PRJNA280983 | 323 | 1229 | 5.268644 | 64.75163476 | Penicillium brevicompactum | 5074 | Fungi | Fungi | 351 | 1.1e-91 | NTclustered | gi|2515129507|ref|XM_056961262.1| | 5074 | g266 | i0 | 79.19 | 1.43287225386493 | 543 | 86 | 44 | 15 | 597 | 1131 | 1 | 524 | Penicillium brevicompactum uncharacterized protein (N7506_011971), partial mRNA | blastn | 1761 | 351 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium brevicompactum | |
| 6749336 | 6749336 | PRJNA280983_P_NODE_2466_length_449_cov_7.990000_g2351_i0 | PRJNA280983 | 2466 | 449 | 7.99 | 35.8751 | Penicillium brevicompactum | 5074 | Fungi | Fungi | 778 | 0 | NTclustered | gi|2515102845|ref|XM_056954329.1| | 5074 | g2351 | i0 | 99.532 | 17.0356347438753 | 427 | 2 | 95 | 0 | 18 | 444 | 427 | 1 | Penicillium brevicompactum Terpenoid synthase (N7506_005035), partial mRNA | blastn | 7649 | 778 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium brevicompactum | |
| 10575593 | 10575593 | PRJNA280983_P_NODE_10369_length_165_cov_0.879310_g10254_i0 | PRJNA280983 | 10369 | 165 | 0.87931 | 1.4508615 | Fusarium proliferatum | 948311 | Fungi | Fungi | 285 | 1.25e-72 | NTclustered | gi|1766900914|ref|XM_031222288.1| | 1227346 | g10254 | i0 | 97.619 | 2.01818181818182 | 168 | 1 | 100 | 1 | 1 | 165 | 960 | 1127 | Fusarium proliferatum ET1 uncharacterized protein (FPRO_08602), partial mRNA | blastn | 333 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium proliferatum | |
| 10575605 | 10575605 | PRJNA280983_P_NODE_2089_length_500_cov_2.944568_g1976_i0 | PRJNA280983 | 2089 | 500 | 2.944568 | 14.72284 | Colletotrichum paranaense | 1914294 | Fungi | Fungi | 279 | 2.06e-70 | NTclustered | gi|2608326222|ref|XM_060499027.1| | 1914294 | g1976 | i0 | 79.795 | 54.304 | 391 | 73 | 78 | 5 | 113 | 500 | 220 | 607 | Colletotrichum paranaense GTP-binding nuclear protein GSP1/Ran (CPAR01_14777), partial mRNA | blastn | 27152 | 279 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum paranaense | |
| 15086578 | 15086578 | PRJNA280983_P_NODE_6912_length_224_cov_1.102857_g6797_i0 | PRJNA280983 | 6912 | 224 | 1.102857 | 2.47039968 | Cladosporium | 5498 | Fungi | Fungi | 409 | 1.03e-109 | NTclustered | gi|283827952|gb|EU019262.2| | 29917 | g6797 | i0 | 99.554 | 70.125 | 224 | 1 | 100 | 0 | 1 | 224 | 3260 | 3037 | Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15708 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 17636589 | 17636589 | PRJNA280983_P_NODE_10494_length_164_cov_0.886957_g10379_i0 | PRJNA280983 | 10494 | 164 | 0.886957 | 1.45460948 | Ascomycota | 4890 | Fungi | Fungi | 292 | 7.41e-75 | NTclustered | gi|74135491|gb|DQ123637.1| | 5074 | g10379 | i0 | 98.78 | 100 | 164 | 2 | 100 | 0 | 1 | 164 | 700 | 537 | Penicillium brevicompactum strain NRRL 32579 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 | 16400 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium brevicompactum | |
| 18223318 | 18223318 | PRJNA280983_P_NODE_1975_length_519_cov_2.134043_g1862_i0 | PRJNA280983 | 1975 | 519 | 2.134043 | 11.07568317 | Australozyma saopauloensis | 291208 | Fungi | Fungi | 448 | 5.549999999999999e-121 | NTclustered | gi|2675362191|ref|XM_063021843.1| | 291208 | g1862 | i0 | 82.319 | 7.11753371868979 | 526 | 83 | 99 | 7 | 1 | 518 | 346 | 869 | [Candida] saopauloensis uncharacterized protein (PUMCH_002851), partial mRNA | blastn | 3694 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Australozyma | Australozyma saopauloensis | |
| 18223321 | 18223321 | PRJNA280983_P_NODE_2735_length_423_cov_1.401070_g2620_i0 | PRJNA280983 | 2735 | 423 | 1.40107 | 5.9265261 | Candidozyma haemuli | 45357 | Fungi | Fungi | 359 | 2.14e-94 | NTclustered | gi|1418621099|ref|XM_025486778.1| | 45357 | g2620 | i0 | 84.53 | 8.33096926713948 | 362 | 56 | 86 | 0 | 12 | 373 | 883 | 1244 | [Candida] haemulonis 3-ketoacyl-CoA thiolase B, peroxisomal (CXQ85_003122), partial mRNA | blastn | 3524 | 359 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Candidozyma | Candidozyma haemuli | |
| 20773150 | 20773150 | PRJNA280983_P_NODE_6917_length_224_cov_0.788571_g6802_i0 | PRJNA280983 | 6917 | 224 | 0.788571 | 1.76639904 | Wickerhamomyces lynferdii | 1041609 | Fungi | Fungi | 182 | 2.43e-41 | NTclustered | gi|156099621|gb|EF552566.1| | 1041609 | g6802 | i0 | 81.333 | 96.7008928571429 | 225 | 38 | 99 | 4 | 2 | 224 | 547 | 769 | Wickerhamomyces lynferdii strain NRRL Y-7723 translation elongation factor 1-alpha gene, partial cds | blastn | 21661 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Wickerhamomycetaceae | Wickerhamomyces | Wickerhamomyces lynferdii | |
| 21460712 | 21460712 | PRJNA280983_P_NODE_9297_length_174_cov_1.632000_g9182_i0 | PRJNA280983 | 9297 | 174 | 1.632 | 2.83968 | Penicillium | 5073 | Fungi | Fungi | 322 | 1.01e-83 | NTclustered | gi|2260618265|gb|ON876494.1| | 5081 | g9182 | i0 | 100 | 100 | 174 | 0 | 100 | 0 | 1 | 174 | 715 | 542 | Penicillium sp. isolate T8 small subunit ribosomal RNA gene, partial sequence | blastn | 17400 | 322 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium sp. | |
| 22048162 | 22048162 | PRJNA280983_P_NODE_9618_length_169_cov_1.541667_g9503_i0 | PRJNA280983 | 9618 | 169 | 1.541667 | 2.60541723 | Trichophyton rubrum | 5551 | Fungi | Fungi | 158 | 2.91e-34 | NTclustered | gi|2225443496|ref|XM_047747646.1| | 559305 | g9503 | i0 | 83.432 | 5.6094674556213 | 169 | 28 | 100 | 0 | 1 | 169 | 25 | 193 | Trichophyton rubrum CBS 118892 60S ribosomal protein L44 (TERG_00738), partial mRNA | blastn | 948 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Arthrodermataceae | Trichophyton | Trichophyton rubrum |
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);;