contig_metadata
11 rows where bioproject = "PRJNA688414" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4494961 | 4494961 | PRJNA688414_P_NODE_6324_length_251_cov_1.039326_g6290_i0 | PRJNA688414 | 6324 | 251 | 1.039326 | 2.60870826 | Aspergillus puulaauensis | 1220207 | Fungi | Fungi | 459 | 1.1499999999999996e-124 | NTclustered | gi|2833777549|gb|PQ475852.1| | 1220207 | g6290 | i0 | 99.602 | 106.362549800797 | 251 | 1 | 100 | 0 | 1 | 251 | 6040 | 6290 | Aspergillus puulaauensis strain F77 internal transcribed spacer region, partial sequence | blastn | 26697 | 459 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus puulaauensis | |
| 6280836 | 6280836 | PRJNA688414_P_NODE_685_length_646_cov_2.869110_g653_i0 | PRJNA688414 | 685 | 646 | 2.86911 | 18.5344506 | Alternaria | 5598 | Fungi | Fungi | 1188 | 0 | NTclustered | gi|2181828641|gb|OM337556.1| | 5599 | g653 | i0 | 99.845 | 99.0588235294118 | 646 | 1 | 100 | 0 | 1 | 646 | 1283 | 638 | Alternaria alternata strain SRC1lrK2f 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 | 63992 | 1188 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 13930785 | 13930785 | PRJNA688414_P_NODE_2851_length_345_cov_1.819853_g2817_i0 | PRJNA688414 | 2851 | 345 | 1.819853 | 6.27849285 | Ascomycota | 4890 | Fungi | Fungi | 632 | 9.17e-177 | NTclustered | gi|2217003568|gb|ON153396.1| | 34409 | g2817 | i0 | 99.71 | 99.9913043478261 | 345 | 1 | 100 | 0 | 1 | 345 | 831 | 487 | Colletotrichum sp. isolate PT1848 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 34497 | 632 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum sp. | |
| 15205477 | 15205477 | PRJNA688414_P_NODE_2052_length_396_cov_1.572755_g2018_i0 | PRJNA688414 | 2052 | 396 | 1.572755 | 6.2281098 | Cordycipitaceae | 474943 | Fungi | Fungi | 708 | 0 | NTclustered | gi|476001871|gb|KC510278.1| | 89141 | g2018 | i0 | 98.987 | 99.3282828282828 | 395 | 4 | 99 | 0 | 1 | 395 | 2278 | 2672 | Isaria farinosa strain STH3 28S-18S rRNA intergenic spacer, partial sequence; 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 39334 | 708 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Cordyceps | Cordyceps farinosa | |
| 19028509 | 19028509 | PRJNA688414_P_NODE_2795_length_348_cov_0.989091_g2761_i0 | PRJNA688414 | 2795 | 348 | 0.989091 | 3.44203668 | Fungi | 4751 | Fungi | Fungi | 593 | 4.369999999999998e-165 | NTclustered | gi|1535923951|ref|NG_062925.1| | 45245 | g2761 | i0 | 97.414 | 100.008620689655 | 348 | 9 | 100 | 0 | 1 | 348 | 860 | 1207 | Emericellopsis minima CBS 190.55 18S rRNA gene, partial sequence; from TYPE material | blastn | 34803 | 593 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Bionectriaceae | Emericellopsis | Emericellopsis minima | |
| 19028528 | 19028528 | PRJNA688414_P_NODE_7035_length_248_cov_0.891429_g7001_i0 | PRJNA688414 | 7035 | 248 | 0.891429 | 2.21074392 | root | 1 | Root_unresolved | Root_unresolved | 459 | 1.13e-124 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g7001 | i0 | 100 | 62.2661290322581 | 248 | 0 | 100 | 0 | 1 | 248 | 3477166 | 3477413 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 15442 | 459 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 21579055 | 21579055 | PRJNA688414_P_NODE_6937_length_248_cov_1.942857_g6903_i0 | PRJNA688414 | 6937 | 248 | 1.942857 | 4.81828536 | Opisthokonta | 33154 | Fungi | Fungi | 459 | 1.13e-124 | NTclustered | gi|2791117515|gb|PQ217832.1| | 5599 | g6903 | i0 | 100 | 118.677419354839 | 248 | 0 | 100 | 0 | 1 | 248 | 3767 | 4014 | 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 | 29432 | 459 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 22854215 | 22854215 | PRJNA688414_P_NODE_5778_length_254_cov_1.712707_g5744_i0 | PRJNA688414 | 5778 | 254 | 1.712707 | 4.35027578 | Aspergillus | 5052 | Fungi | Fungi | 468 | 1.93e-127 | NTclustered | gi|1938233242|gb|MW299292.1| | 5065 | g5744 | i0 | 100 | 99.6023622047244 | 253 | 0 | 99 | 0 | 1 | 253 | 723 | 975 | Aspergillus sp. isolate 880367-01 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 25299 | 468 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus sp. | |
| 24128791 | 24128791 | PRJNA688414_P_NODE_5459_length_262_cov_2.333333_g5425_i0 | PRJNA688414 | 5459 | 262 | 2.333333 | 6.11333246 | Cladosporium | 5498 | Fungi | Fungi | 468 | 1.9999999999999996e-127 | NTclustered | gi|284158823|gb|GU214410.1| | 29918 | g5425 | i0 | 98.855 | 72.9045801526718 | 262 | 3 | 100 | 0 | 1 | 262 | 3233 | 2972 | Cladosporium herbarum strain CBS 723.79 28S large subunit ribosomal RNA gene, partial sequence | blastn | 19101 | 468 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium herbarum | |
| 29450374 | 29450374 | PRJNA688414_P_NODE_7130_length_248_cov_0.891429_g7096_i0 | PRJNA688414 | 7130 | 248 | 0.891429 | 2.21074392 | Setomelanomma holmii | 210430 | Fungi | Fungi | 162 | 7.249999999999999e-45 | NR | KAF2023980.1 | 210430 | g7096 | i0 | 97.6 | 0.991935483870968 | 82 | 2 | 99.2 | 0 | 247 | 2 | 97 | 178 | KAF2023980.1 phenylalanyl-tRNA synthetase beta chain [Setomelanomma holmii] | diamond | 246 | 162 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Setomelanomma | Setomelanomma holmii | |
| 30714105 | 30714105 | PRJNA688414_P_NODE_8314_length_242_cov_0.923077_g8280_i0 | PRJNA688414 | 8314 | 242 | 0.923077 | 2.23384634 | Exophiala mesophila | 212818 | Fungi | Fungi | 66.6 | 1.37e-10 | NR | XP_016229435.1 | 212818 | g8280 | i0 | 72.7 | 3 | 44 | 12 | 54.5 | 0 | 109 | 240 | 14 | 57 | XP_016229435.1 hypothetical protein, variant [Exophiala mesophila] | diamond | 726 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala mesophila |
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);;