contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA861969" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3397212 | 3397212 | PRJNA861969_P_NODE_33163_length_249_cov_0.875000_g32932_i0 | PRJNA861969 | 33163 | 249 | 0.875 | 2.17875 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 460 | 3.16e-125 | NTclustered | gi|2749601417|ref|XM_504062.2| | 4952 | g32932 | i0 | 100 | 7.86746987951807 | 249 | 0 | 100 | 0 | 1 | 249 | 513 | 761 | Yarrowia lipolytica uncharacterized protein (YALI1_E20677g), partial mRNA | blastn | 1959 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 5064474 | 5064474 | PRJNA861969_P_NODE_22484_length_287_cov_1.387850_g22253_i0 | PRJNA861969 | 22484 | 287 | 1.38785 | 3.9831295 | Pleosporales | 92860 | Fungi | Fungi | 520 | 6.049999999999999e-143 | NTclustered | gi|2708114021|gb|OR695074.1| | 5016 | g22253 | i0 | 99.303 | 102.738675958188 | 287 | 2 | 100 | 0 | 1 | 287 | 3122 | 2836 | Bipolaris maydis isolate ZM358 mitochondria, complete genome | blastn | 29486 | 520 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Bipolaris | Bipolaris maydis | |
| 5064555 | 5064555 | PRJNA861969_P_NODE_34304_length_248_cov_0.880000_g34073_i0 | PRJNA861969 | 34304 | 248 | 0.88 | 2.1824 | Lichenotheliaceae | 281210 | Fungi | Fungi | 459 | 1.13e-124 | NTclustered | gi|347664823|gb|JN040508.1| | 61459 | g34073 | i0 | 100 | 99.9233870967742 | 248 | 0 | 100 | 0 | 1 | 248 | 285 | 38 | Coniosporium apollinis strain CBS 352.98 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 | 24781 | 459 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Coniosporium | Coniosporium apollinis | |||
| 5949643 | 5949643 | PRJNA861969_P_NODE_26805_length_267_cov_1.587629_g26574_i0 | PRJNA861969 | 26805 | 267 | 1.587629 | 4.23896943 | Didymella exigua | 100019 | Fungi | Fungi | 333 | 7.789999999999999e-87 | NTclustered | gi|1832892611|ref|XM_033592429.1| | 1150837 | g26574 | i0 | 89.139 | 1.9812734082397 | 267 | 29 | 100 | 0 | 1 | 267 | 1106 | 1372 | Didymella exigua CBS 183.55 glycoside hydrolase family 32 protein (M421DRAFT_420301), mRNA | blastn | 529 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella exigua | |
| 5949862 | 5949862 | PRJNA861969_P_NODE_37965_length_244_cov_1.333333_g37734_i0 | PRJNA861969 | 37965 | 244 | 1.333333 | 3.25333252 | Aspergillus verrucosus | 3033834 | Fungi | Fungi | 390 | 4.11e-104 | NTclustered | gi|2666209008|dbj|LC797029.1| | 3033834 | g37734 | i0 | 95.492 | 71.0491803278689 | 244 | 11 | 100 | 0 | 1 | 244 | 101549 | 101792 | Aspergillus verrucosus NBRC 115547 mitochondrial DNA, complete genome | blastn | 17336 | 390 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus verrucosus | |
| 7614369 | 7614369 | PRJNA861969_P_NODE_12486_length_370_cov_8.360269_g12255_i0 | PRJNA861969 | 12486 | 370 | 8.360269 | 30.9329953 | Ascomycota | 4890 | Fungi | Fungi | 684 | 0 | NTclustered | gi|1840379205|gb|MT453271.1| | 5599 | g12255 | i0 | 100 | 100 | 370 | 0 | 100 | 0 | 1 | 370 | 934 | 565 | Alternaria alternata isolate DSM100286_DF09_RLCS10 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 | 37000 | 684 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 8499219 | 8499219 | PRJNA861969_P_NODE_24487_length_278_cov_1.180488_g24256_i0 | PRJNA861969 | 24487 | 278 | 1.180488 | 3.28175664 | Trichoderma reesei | 51453 | Fungi | Fungi | 228 | 3.959999999999999e-55 | NTclustered | gi|589100552|ref|XM_006962237.1| | 431241 | g24256 | i0 | 83.817 | 4.02158273381295 | 241 | 37 | 86 | 2 | 3 | 242 | 1870 | 2109 | Trichoderma reesei QM6a uncharacterized protein (TRIREDRAFT_55381), partial mRNA | blastn | 1118 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma reesei | |
| 12715909 | 12715909 | PRJNA861969_P_NODE_11730_length_380_cov_1.853420_g11499_i0 | PRJNA861969 | 11730 | 380 | 1.85342 | 7.042996 | Aspergillus | 5052 | Fungi | Fungi | 664 | 0 | NTclustered | gi|984294657|gb|KT390118.1| | 41959 | g11499 | i0 | 98.158 | 100.005263157895 | 380 | 7 | 100 | 0 | 1 | 380 | 854 | 1233 | Aspergillus penicillioides clone KJ34-0.2-39 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 | 38002 | 664 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus penicillioides | |
| 12716052 | 12716052 | PRJNA861969_P_NODE_36730_length_245_cov_3.267442_g36499_i0 | PRJNA861969 | 36730 | 245 | 3.267442 | 8.0052329 | Fungi | 4751 | Fungi | Fungi | 453 | 5.1900000000000006e-123 | NTclustered | gi|2612872|gb|AF010303.1| | 63354 | g36499 | i0 | 100 | 100 | 245 | 0 | 100 | 0 | 1 | 245 | 51 | 295 | Sclerotium sp. BSC-97 18S ribosomal RNA gene, partial sequence | blastn | 24500 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Sclerotiniaceae sp. BSC-97 | ||
| 14874575 | 14874575 | PRJNA861969_P_NODE_39232_length_243_cov_0.905882_g39001_i0 | PRJNA861969 | 39232 | 243 | 0.905882 | 2.20129326 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 449 | 6.65e-122 | NTclustered | gi|2837743746|ref|XM_069372924.1| | 1052096 | g39001 | i0 | 100 | 1.11934156378601 | 243 | 0 | 100 | 0 | 1 | 243 | 528 | 286 | Cladosporium halotolerans uncharacterized protein (WHR41_04318), mRNA | blastn | 272 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 16148816 | 16148816 | PRJNA861969_P_NODE_12853_length_365_cov_3.883562_g12622_i0 | PRJNA861969 | 12853 | 365 | 3.883562 | 14.1750013 | Dothideales sp. | 1769355 | Fungi | Fungi | 619 | 7.569999999999999e-173 | NTclustered | gi|2507143705|gb|OQ998386.1| | 1769355 | g12622 | i0 | 97.26 | 99.6657534246575 | 365 | 10 | 100 | 0 | 1 | 365 | 931 | 567 | Dothideales sp. voucher G.M. 2007-10-28.18 #1117 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 | 36378 | 619 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Dothideales sp. | |||
| 16149283 | 16149283 | PRJNA861969_P_NODE_39673_length_243_cov_0.905882_g39442_i0 | PRJNA861969 | 39673 | 243 | 0.905882 | 2.20129326 | Meyerozyma guilliermondii | 4929 | Fungi | Fungi | 449 | 6.65e-122 | NTclustered | gi|146415779|ref|XM_001483810.1| | 294746 | g39442 | i0 | 100 | 1 | 243 | 0 | 100 | 0 | 1 | 243 | 1723 | 1481 | Meyerozyma guilliermondii ATCC 6260 uncharacterized protein (PGUG_04589), partial mRNA | blastn | 243 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma guilliermondii | |
| 16538962 | 16538962 | PRJNA861969_P_NODE_18273_length_315_cov_1.136364_g18042_i0 | PRJNA861969 | 18273 | 315 | 1.136364 | 3.5795466 | Fungi | 4751 | Fungi | Fungi | 582 | 8.459999999999998e-162 | NTclustered | gi|880804871|gb|KT239030.1| | 5580 | g18042 | i0 | 100 | 100 | 315 | 0 | 100 | 0 | 1 | 315 | 196 | 510 | Aureobasidium pullulans strain YM25001 26S ribosomal RNA gene, partial sequence | blastn | 31500 | 582 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 21248409 | 21248409 | PRJNA861969_P_NODE_23637_length_281_cov_6.581731_g23406_i0 | PRJNA861969 | 23637 | 281 | 6.5817310000000004 | 18.49466411 | Alternaria alternata | 5599 | Fungi | Fungi | 520 | 5.909999999999999e-143 | NTclustered | gi|2791117515|gb|PQ217832.1| | 5599 | g23406 | i0 | 100 | 110.67615658363 | 281 | 0 | 100 | 0 | 1 | 281 | 5612 | 5332 | 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 | 31100 | 520 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 21248567 | 21248567 | PRJNA861969_P_NODE_31357_length_251_cov_0.865169_g31126_i0 | PRJNA861969 | 31357 | 251 | 0.865169 | 2.17157419 | Aureobasidium pullulans | 5580 | Fungi | Fungi | 339 | 1.56e-88 | NTclustered | gi|1701889845|ref|XM_029902944.1| | 1043002 | g31126 | i0 | 91.77 | 0.968127490039841 | 243 | 20 | 97 | 0 | 9 | 251 | 2748 | 2506 | Aureobasidium pullulans EXF-150 glutamine synthetase/guanido kinase (M438DRAFT_322069), partial mRNA | blastn | 243 | 339 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 21638468 | 21638468 | PRJNA861969_P_NODE_24857_length_276_cov_1.517241_g24626_i0 | PRJNA861969 | 24857 | 276 | 1.517241 | 4.18758516 | Fusarium | 5506 | Fungi | Fungi | 505 | 1.62e-138 | NTclustered | gi|1070315146|ref|XM_018377383.1| | 426428 | g24626 | i0 | 99.638 | 25 | 276 | 1 | 100 | 0 | 1 | 276 | 3760 | 4035 | Fusarium oxysporum f. sp. lycopersici 4287 uncharacterized protein (FOXG_00799), mRNA | blastn | 6900 | 505 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium oxysporum | |
| 21638481 | 21638481 | PRJNA861969_P_NODE_28757_length_258_cov_3.821622_g28526_i0 | PRJNA861969 | 28757 | 258 | 3.821622 | 9.85978476 | Dothideomycetes | 147541 | Fungi | Fungi | 472 | 1.52e-128 | NTclustered | gi|2471598664|gb|OP265220.1| | 105696 | g28526 | i0 | 99.612 | 100 | 258 | 1 | 100 | 0 | 1 | 258 | 498 | 241 | Epicoccum nigrum isolate HE7 large subunit ribosomal RNA gene, partial sequence | blastn | 25800 | 472 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Epicoccum | Epicoccum nigrum | |
| 22522801 | 22522801 | PRJNA861969_P_NODE_10058_length_407_cov_6.236527_g9827_i0 | PRJNA861969 | 10058 | 407 | 6.236527 | 25.38266489 | Phialophora verrucosa | 39412 | Fungi | Fungi | 350 | 1.24e-91 | NTclustered | gi|336088198|dbj|AB550777.1| | 39412 | g9827 | i0 | 93.305 | 64.6904176904177 | 239 | 13 | 58 | 3 | 1 | 237 | 4291 | 4528 | Phialophora verrucosa genes for ITS1, 5.8S rRNA, ITS2 and large subunit rRNA, partial and complete sequence, strain: IFM 41779 | blastn | 26329 | 350 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Phialophora | Phialophora verrucosa | |
| 24187877 | 24187877 | PRJNA861969_P_NODE_13159_length_361_cov_3.072917_g12928_i0 | PRJNA861969 | 13159 | 361 | 3.072917 | 11.09323037 | Ascomycota | 4890 | Fungi | Fungi | 662 | 0 | NTclustered | gi|156510660|gb|EU091012.1| | 5507 | g12928 | i0 | 99.723 | 100 | 361 | 1 | 100 | 0 | 1 | 361 | 462 | 822 | Fusarium oxysporum isolate F38 internal transcribed space 1 gene, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 36100 | 662 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium oxysporum | |
| 25463096 | 25463096 | PRJNA861969_P_NODE_24780_length_276_cov_2.275862_g24549_i0 | PRJNA861969 | 24780 | 276 | 2.275862 | 6.28137912 | Opisthokonta | 33154 | Fungi | Fungi | 505 | 1.62e-138 | NTclustered | gi|2086743560|ref|XR_006253225.1| | 182096 | g24549 | i0 | 99.638 | 107.06884057971 | 276 | 1 | 100 | 0 | 1 | 276 | 2149 | 1874 | Aspergillus chevalieri 28S ribosomal RNA (ACHE_r70002S), rRNA | blastn | 29551 | 510 | 0.990196078431373 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri |
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);;