contig_metadata
17 rows where bioproject = "PRJNA380416" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2349453 | 2349453 | PRJNA380416_P_NODE_8582_length_195_cov_1.020548_g8435_i0 | PRJNA380416 | 8582 | 195 | 1.020548 | 1.9900686 | Ascomycota | 4890 | Fungi | Fungi | 361 | 2.46e-95 | NTclustered | gi|1338684535|gb|MG889595.1| | 5061 | g8435 | i0 | 100 | 100 | 195 | 0 | 100 | 0 | 1 | 195 | 888 | 694 | Aspergillus niger isolate soil small subunit ribosomal RNA gene, partial sequence | blastn | 19500 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 2952631 | 2952631 | PRJNA380416_P_NODE_10263_length_177_cov_1.187500_g10116_i0 | PRJNA380416 | 10263 | 177 | 1.1875 | 2.101875 | Spathaspora passalidarum | 340170 | Fungi | Fungi | 119 | 1.45e-22 | NTclustered | gi|598072100|ref|XM_007376817.1| | 619300 | g10116 | i0 | 87.037 | 30.2768361581921 | 108 | 10 | 60 | 4 | 72 | 177 | 57 | 162 | Spathaspora passalidarum NRRL Y-27907 40S ribosomal protein S14-B (SPAPADRAFT_62713), mRNA | blastn | 5359 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Spathaspora | Spathaspora passalidarum | |
| 5505679 | 5505679 | PRJNA380416_P_NODE_6605_length_223_cov_3.195402_g6458_i0 | PRJNA380416 | 6605 | 223 | 3.195402 | 7.12574646 | Fusarium proliferatum | 948311 | Fungi | Fungi | 401 | 1.7099999999999992e-107 | NTclustered | gi|1206257034|emb|LT841250.1| | 948311 | g6458 | i0 | 99.103 | 92.8071748878924 | 223 | 2 | 100 | 0 | 1 | 223 | 5528 | 5306 | Fusarium proliferatum partial 18S rRNA gene for 18S ribosomal RNA, strain ITEM2287 | blastn | 20696 | 401 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium proliferatum | |
| 8726828 | 8726828 | PRJNA380416_P_NODE_2607_length_374_cov_4.067692_g2460_i0 | PRJNA380416 | 2607 | 374 | 4.067692 | 15.21316808 | Ascomycota | 4890 | Fungi | Fungi | 689 | 0 | NTclustered | gi|18147209|dbj|AB053248.1| | 52249 | g2460 | i0 | 100 | 101.700534759358 | 373 | 0 | 99 | 0 | 2 | 374 | 1084 | 712 | Candida silvae gene for 18S rRNA, partial sequence | blastn | 38036 | 689 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Saturnispora | Saturnispora silvae | |
| 13827566 | 13827566 | PRJNA380416_P_NODE_11911_length_166_cov_0.871795_g11764_i0 | PRJNA380416 | 11911 | 166 | 0.871795 | 1.4471797 | Phaeosphaeriaceae | 5020 | Fungi | Fungi | 285 | 1.26e-72 | NTclustered | gi|154563029|gb|EF590320.2| | 13684 | g11764 | i0 | 97.59 | 107 | 166 | 4 | 100 | 0 | 1 | 166 | 1281 | 1446 | Phaeosphaeria nodorum strain S-80-603 large subunit ribosomal RNA gene, partial sequence | blastn | 17762 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora nodorum | |
| 13827570 | 13827570 | PRJNA380416_P_NODE_12631_length_164_cov_0.886957_g12484_i0 | PRJNA380416 | 12631 | 164 | 0.886957 | 1.45460948 | Podospora | 5144 | Fungi | Fungi | 52.8 | 0.014 | NTclustered | gi|2670686776|ref|XM_062880916.1| | 2093777 | g12484 | i0 | 100 | 0.682926829268293 | 28 | 0 | 17 | 0 | 16 | 43 | 451 | 478 | Podospora bellae-mahoneyi inositol polyphosphate kinase kcs1 (KCS1), mRNA | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Podosporaceae | Podospora | Podospora bellae-mahoneyi | |
| 14430773 | 14430773 | PRJNA380416_P_NODE_13092_length_163_cov_0.894737_g12945_i0 | PRJNA380416 | 13092 | 163 | 0.894737 | 1.45842131 | Exophiala oligosperma | 215243 | Fungi | Fungi | 185 | 1.28e-42 | NTclustered | gi|1022877233|ref|XM_016406092.1| | 215243 | g12945 | i0 | 99.029 | 1.03067484662577 | 103 | 1 | 63 | 0 | 1 | 103 | 3012 | 2910 | Exophiala oligosperma uncharacterized protein (PV06_05122), partial mRNA | blastn | 168 | 185 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala oligosperma | |
| 14430785 | 14430785 | PRJNA380416_P_NODE_5632_length_244_cov_1.497436_g5485_i0 | PRJNA380416 | 5632 | 244 | 1.497436 | 3.65374384 | Sordaria macrospora | 5147 | Fungi | Fungi | 102 | 2.15e-17 | NTclustered | gi|2749654334|ref|XM_003344831.2| | 5147 | g5485 | i0 | 95.312 | 9.07786885245902 | 64 | 3 | 26 | 0 | 117 | 180 | 598 | 535 | Sordaria macrospora 60S ribosomal protein eL18 (SMAC4_06165), mRNA | blastn | 2215 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Sordariaceae | Sordaria | Sordaria macrospora | |
| 15704717 | 15704717 | PRJNA380416_P_NODE_12153_length_165_cov_0.879310_g12006_i0 | PRJNA380416 | 12153 | 165 | 0.87931 | 1.4508615 | Candida parapsilosis | 5480 | Fungi | Fungi | 305 | 9.59e-79 | NTclustered | gi|1919684751|ref|XM_036807190.1| | 5480 | g12006 | i0 | 100 | 8.00606060606061 | 165 | 0 | 100 | 0 | 1 | 165 | 380 | 544 | Candida parapsilosis uncharacterized protein (CPAR2_601350), partial mRNA | blastn | 1321 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida parapsilosis | |
| 15704729 | 15704729 | PRJNA380416_P_NODE_2053_length_424_cov_2.994667_g1906_i0 | PRJNA380416 | 2053 | 424 | 2.994667 | 12.69738808 | Saturnispora silvae | 52249 | Fungi | Fungi | 778 | 0 | NTclustered | gi|156099828|gb|EF550353.1| | 52249 | g1906 | i0 | 99.764 | 100.308962264151 | 424 | 1 | 100 | 0 | 1 | 424 | 1131 | 1554 | Saturnispora silvae strain NRRL Y-6725 18S ribosomal RNA gene, partial sequence | blastn | 42531 | 778 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Saturnispora | Saturnispora silvae | |
| 22078555 | 22078555 | PRJNA380416_P_NODE_4998_length_260_cov_2.677725_g4851_i0 | PRJNA380416 | 4998 | 260 | 2.677725 | 6.962085 | Saturnispora silvae | 52249 | Fungi | Fungi | 455 | 1.55e-123 | NTclustered | gi|1208297526|ref|NG_055098.1| | 52249 | g4851 | i0 | 99.598 | 116.234615384615 | 249 | 1 | 96 | 0 | 1 | 249 | 2850 | 3098 | Saturnispora silvae NRRL Y-6725 28S rRNA, partial sequence; from TYPE material | blastn | 30221 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Saturnispora | Saturnispora silvae | |
| 22750946 | 22750946 | PRJNA380416_P_NODE_1838_length_450_cov_1.620948_g1691_i0 | PRJNA380416 | 1838 | 450 | 1.620948 | 7.294266 | Schizosaccharomyces | 4895 | Fungi | Fungi | 217 | 1.46e-51 | NTclustered | gi|2524387879|emb|OY101113.1| | 4897 | g1691 | i0 | 80.634 | 18.5511111111111 | 284 | 52 | 63 | 3 | 12 | 295 | 2986913 | 2987193 | Schizosaccharomyces japonicus genome assembly, chromosome: 3 | blastn | 8348 | 217 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces japonicus | |
| 22750958 | 22750958 | PRJNA380416_P_NODE_9578_length_184_cov_1.437037_g9431_i0 | PRJNA380416 | 9578 | 184 | 1.437037 | 2.64414808 | Sordariomycetes | 147550 | Fungi | Fungi | 320 | 3.9e-83 | NTclustered | gi|2798605368|gb|PQ285334.1| | 5127 | g9431 | i0 | 97.849 | 101.070652173913 | 186 | 2 | 100 | 1 | 1 | 184 | 280 | 95 | Fusarium fujikuroi isolate PB33 large subunit ribosomal RNA gene, partial sequence | blastn | 18597 | 320 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium fujikuroi | |
| 26933816 | 26933816 | PRJNA380416_P_NODE_11842_length_166_cov_0.871795_g11695_i0 | PRJNA380416 | 11842 | 166 | 0.871795 | 1.4471797 | Eukaryota | 2759 | Fungi | Fungi | 42 | 0.025 | NR | TKX22715.1 | 40998 | g11695 | i0 | 42 | 6.72289156626506 | 50 | 29 | 90.4 | 0 | 17 | 166 | 309 | 358 | TKX22715.1 actin-related protein 2/3 complex subunit 1 [Elsinoe australis] | diamond | 1116 | 42.4 | 0.990566037735849 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Myriangiales | Elsinoaceae | Elsinoe | Elsinoe australis | |
| 29853947 | 29853947 | PRJNA380416_P_NODE_2571_length_378_cov_1.650456_g2424_i0 | PRJNA380416 | 2571 | 378 | 1.650456 | 6.23872368 | Friedmanniomyces endolithicus | 329885 | Fungi | Fungi | 219 | 1.77e-71 | NR | KAK0340137.1 | 329885 | g2424 | i0 | 100 | 0.888888888888889 | 112 | 0 | 88.9 | 0 | 35 | 370 | 1 | 112 | KAK0340137.1 hypothetical protein LTR94_031749, partial [Friedmanniomyces endolithicus] | diamond | 336 | 219 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Friedmanniomyces | Friedmanniomyces endolithicus | |
| 30770254 | 30770254 | PRJNA380416_P_NODE_6674_length_222_cov_1.751445_g6527_i0 | PRJNA380416 | 6674 | 222 | 1.751445 | 3.8882079 | Friedmanniomyces endolithicus | 329885 | Fungi | Fungi | 105 | 1.05e-25 | NR | KAK0360406.1 | 329885 | g6527 | i0 | 71.6 | 1.09459459459459 | 81 | 15 | 98.6 | 1 | 219 | 1 | 55 | 135 | KAK0360406.1 hypothetical protein LTR94_027428, partial [Friedmanniomyces endolithicus] | diamond | 243 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Friedmanniomyces | Friedmanniomyces endolithicus | |
| 30991393 | 30991393 | PRJNA380416_P_NODE_4654_length_272_cov_1.659193_g4507_i0 | PRJNA380416 | 4654 | 272 | 1.659193 | 4.51300496 | Friedmanniomyces endolithicus | 329885 | Fungi | Fungi | 125 | 3.37e-33 | NR | KAK0360406.1 | 329885 | g4507 | i0 | 95.2 | 0.694852941176471 | 63 | 3 | 69.5 | 0 | 271 | 83 | 191 | 253 | KAK0360406.1 hypothetical protein LTR94_027428, partial [Friedmanniomyces endolithicus] | diamond | 189 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Friedmanniomyces | Friedmanniomyces endolithicus |
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);;