contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA263496" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2919736 | 2919736 | PRJNA263496_P_NODE_13943_length_209_cov_1.768750_g13690_i0 | PRJNA263496 | 13943 | 209 | 1.76875 | 3.6966875 | Rasamsonia byssochlamydoides | 89139 | Fungi | Fungi | 100 | 6.45e-17 | NTclustered | gi|2837856384|ref|XM_069425115.1| | 89139 | g13690 | i0 | 83.333 | 2.75598086124402 | 108 | 18 | 52 | 0 | 40 | 147 | 25 | 132 | Rasamsonia byssochlamydoides 60S ribosomal protein eL39 (VTN77DRAFT_860), partial mRNA | blastn | 576 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Rasamsonia | Rasamsonia byssochlamydoides | |
| 2920325 | 2920325 | PRJNA263496_P_NODE_9703_length_254_cov_0.960976_g9450_i0 | PRJNA263496 | 9703 | 254 | 0.960976 | 2.44087904 | Ascochyta rabiei | 5454 | Fungi | Fungi | 176 | 1.31e-39 | NTclustered | gi|1955494155|ref|XM_038937035.1| | 5454 | g9450 | i0 | 84.444 | 51.7716535433071 | 180 | 26 | 70 | 2 | 76 | 254 | 245 | 67 | Ascochyta rabiei RNA helicase (EKO05_0000631), partial mRNA | blastn | 13150 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Ascochyta | Ascochyta rabiei | |
| 5472758 | 5472758 | PRJNA263496_P_NODE_24325_length_163_cov_0.894737_g24072_i0 | PRJNA263496 | 24325 | 163 | 0.894737 | 1.45842131 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 291 | 2.64e-74 | NTclustered | gi|2725214432|ref|XM_064894595.1| | 1690604 | g24072 | i0 | 98.773 | 1 | 163 | 2 | 100 | 0 | 1 | 163 | 1413 | 1251 | Lithohypha guttulata uncharacterized protein (LTR64_000209), partial mRNA | blastn | 163 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 6159996 | 6159996 | PRJNA263496_P_NODE_21665_length_166_cov_1.307692_g21412_i0 | PRJNA263496 | 21665 | 166 | 1.307692 | 2.17076872 | Cladosporium | 5498 | Fungi | Fungi | 307 | 2.69e-79 | NTclustered | gi|34304222|gb|AY291273.1| | 29917 | g21412 | i0 | 100 | 99.9879518072289 | 166 | 0 | 100 | 0 | 1 | 166 | 457 | 292 | Cladosporium cladosporioides strain ALI 50 small subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product | blastn | 16598 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 8022829 | 8022829 | PRJNA263496_P_NODE_25627_length_161_cov_0.910714_g25374_i0 | PRJNA263496 | 25627 | 161 | 0.910714 | 1.46624954 | Didymella exigua | 100019 | Fungi | Fungi | 259 | 7.34e-65 | NTclustered | gi|1832860506|ref|XM_033587190.1| | 1150837 | g25374 | i0 | 95.652 | 1.93167701863354 | 161 | 7 | 100 | 0 | 1 | 161 | 628 | 788 | Didymella exigua CBS 183.55 uncharacterized protein (M421DRAFT_110675), mRNA | blastn | 311 | 259 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Didymella | Didymella exigua | |
| 9297460 | 9297460 | PRJNA263496_P_NODE_24968_length_162_cov_0.902655_g24715_i0 | PRJNA263496 | 24968 | 162 | 0.902655 | 1.4623011 | Aureobasidium namibiae | 559561 | Fungi | Fungi | 108 | 2.84e-19 | NTclustered | gi|918800255|ref|XM_013568445.1| | 1043004 | g24715 | i0 | 86.139 | 3.02469135802469 | 101 | 12 | 62 | 2 | 63 | 162 | 1 | 100 | Aureobasidium namibiae CBS 147.97 uncharacterized protein (M436DRAFT_55443), partial mRNA | blastn | 490 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium namibiae | |
| 11260400 | 11260400 | PRJNA263496_P_NODE_2249_length_614_cov_9.162832_g568_i1 | PRJNA263496 | 2249 | 614 | 9.162832 | 56.25978848 | Didymellaceae | 683158 | Fungi | Fungi | 1118 | 0 | NTclustered | gi|162415180|gb|EU167600.1| | 5454 | g568 | i1 | 99.511 | 99.814332247557 | 614 | 3 | 100 | 0 | 1 | 614 | 2774 | 2161 | Ascochyta rabiei strain CBS 237.37 small subunit ribosomal RNA gene, 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 | 61286 | 1129 | 0.990256864481842 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Ascochyta | Ascochyta rabiei | |
| 11847768 | 11847768 | PRJNA263496_P_NODE_16490_length_192_cov_1.174825_g16237_i0 | PRJNA263496 | 16490 | 192 | 1.174825 | 2.255664 | Kazachstania africana | 432096 | Fungi | Fungi | 143 | 9.539999999999999e-30 | NTclustered | gi|410078589|ref|XM_003956827.1| | 1071382 | g16237 | i0 | 82.822 | 39.796875 | 163 | 24 | 84 | 4 | 26 | 186 | 10 | 170 | Kazachstania africana CBS 2517 actin (KAFR0D00940), partial mRNA | blastn | 7641 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Kazachstania | Kazachstania africana | |
| 13123134 | 13123134 | PRJNA263496_P_NODE_21831_length_166_cov_0.871795_g21578_i0 | PRJNA263496 | 21831 | 166 | 0.871795 | 1.4471797 | Aureobasidium melanogenum | 46634 | Fungi | Fungi | 283 | 4.53e-72 | NTclustered | gi|2028509357|ref|XM_041026332.1| | 1043003 | g21578 | i0 | 97.576 | 0.993975903614458 | 165 | 4 | 99 | 0 | 1 | 165 | 165 | 1 | Aureobasidium melanogenum CBS 110374 uncharacterized protein (M437DRAFT_74973), partial mRNA | blastn | 165 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 13123195 | 13123195 | PRJNA263496_P_NODE_24071_length_163_cov_0.894737_g23818_i0 | PRJNA263496 | 24071 | 163 | 0.894737 | 1.45842131 | Penicillium angulare | 116970 | Fungi | Fungi | 113 | 6.14e-21 | NTclustered | gi|2515012955|ref|XM_056929387.1| | 116970 | g23818 | i0 | 87.129 | 10.9509202453988 | 101 | 11 | 61 | 2 | 51 | 150 | 138 | 39 | Penicillium angulare uncharacterized protein (N7478_013177), partial mRNA | blastn | 1785 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium angulare | |
| 13810651 | 13810651 | PRJNA263496_P_NODE_23751_length_163_cov_1.464912_g23498_i0 | PRJNA263496 | 23751 | 163 | 1.464912 | 2.38780656 | Eukaryota | 2759 | Fungi | Fungi | 302 | 1.22e-77 | NTclustered | gi|2532687033|gb|OR243761.1| | 29917 | g23498 | i0 | 100 | 99.4539877300613 | 163 | 0 | 100 | 0 | 1 | 163 | 3721 | 3883 | 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 | 16211 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 14398094 | 14398094 | PRJNA263496_P_NODE_13412_length_213_cov_2.762195_g13159_i0 | PRJNA263496 | 13412 | 213 | 2.762195 | 5.88347535 | Phoma sp. 1 OB-2014 | 1573585 | Fungi | Fungi | 383 | 5.8499999999999996e-102 | NTclustered | gi|724090723|gb|KM387394.1| | 1573585 | g13159 | i0 | 99.061 | 108.741784037559 | 213 | 2 | 100 | 0 | 1 | 213 | 7258 | 7470 | Phoma sp. 1 OB-2014 28S-18S ribosomal RNA 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 | 23162 | 383 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Phoma | Phoma sp. 1 OB-2014 | |
| 15084768 | 15084768 | PRJNA263496_P_NODE_14852_length_203_cov_0.961039_g14599_i0 | PRJNA263496 | 14852 | 203 | 0.961039 | 1.95090917 | Dothideomycetes | 147541 | Fungi | Fungi | 193 | 9.99e-45 | NTclustered | gi|2749640508|ref|XR_010715598.1| | 5022 | g14599 | i0 | 98.182 | 58.8866995073892 | 110 | 2 | 54 | 0 | 94 | 203 | 3418 | 3309 | Leptosphaeria maculans 28S ribosomal RNA (IAQ61_009836), rRNA | blastn | 11954 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Leptosphaeriaceae | Plenodomus | Plenodomus lingam | |
| 15084782 | 15084782 | PRJNA263496_P_NODE_9232_length_260_cov_2.293839_g8979_i0 | PRJNA263496 | 9232 | 260 | 2.293839 | 5.9639814 | Cladosporium | 5498 | Fungi | Fungi | 481 | 2.55e-131 | NTclustered | gi|283827952|gb|EU019262.2| | 29917 | g8979 | i0 | 100 | 76.2692307692308 | 260 | 0 | 100 | 0 | 1 | 260 | 2999 | 3258 | Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence | blastn | 19830 | 481 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 16359669 | 16359669 | PRJNA263496_P_NODE_11353_length_232_cov_2.748634_g11100_i0 | PRJNA263496 | 11353 | 232 | 2.748634 | 6.37683088 | Fungi | 4751 | Fungi | Fungi | 429 | 8.2e-116 | NTclustered | gi|33302361|gb|AY337712.1| | 73001 | g11100 | i0 | 100 | 100 | 232 | 0 | 100 | 0 | 1 | 232 | 133 | 364 | Phoma herbarum 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 | 23200 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Phoma | Phoma herbarum | |
| 16946388 | 16946388 | PRJNA263496_P_NODE_12834_length_218_cov_3.621302_g12581_i0 | PRJNA263496 | 12834 | 218 | 3.621302 | 7.89443836 | Clavispora lusitaniae | 36911 | Fungi | Fungi | 158 | 3.969999999999999e-34 | NTclustered | gi|2749661533|ref|XM_002614449.2| | 36911 | g12581 | i0 | 86.207 | 87.2660550458716 | 145 | 20 | 93 | 0 | 16 | 160 | 1141 | 997 | Clavispora lusitaniae Ubiquitin (UBI4), partial mRNA | blastn | 19024 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Clavispora | Clavispora lusitaniae | |
| 17634826 | 17634826 | PRJNA263496_P_NODE_15274_length_200_cov_1.059603_g15021_i0 | PRJNA263496 | 15274 | 200 | 1.059603 | 2.119206 | Ascochyta | 5453 | Fungi | Fungi | 337 | 4.28e-88 | NTclustered | gi|2289385083|gb|CP095310.1| | 5454 | g15021 | i0 | 97.03 | 75.115 | 202 | 3 | 100 | 3 | 1 | 200 | 699 | 499 | Ascochyta rabiei isolate Me14 mitochondrion, complete genome | blastn | 15023 | 337 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Ascochyta | Ascochyta rabiei | |
| 18221044 | 18221044 | PRJNA263496_P_NODE_24295_length_163_cov_0.894737_g24042_i0 | PRJNA263496 | 24295 | 163 | 0.894737 | 1.45842131 | Alternaria alternata | 5599 | Fungi | Fungi | 302 | 1.22e-77 | NTclustered | gi|1070559059|ref|XM_018525719.1| | 5599 | g24042 | i0 | 100 | 12.0736196319018 | 163 | 0 | 100 | 0 | 1 | 163 | 141 | 303 | Alternaria alternata hypothetical protein mRNA | blastn | 1968 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 22734018 | 22734018 | PRJNA263496_P_NODE_15158_length_200_cov_11.112583_g14905_i0 | PRJNA263496 | 15158 | 200 | 11.112583 | 22.225166 | Dothideomycetes | 147541 | Fungi | Fungi | 370 | 4.22e-98 | NTclustered | gi|33302361|gb|AY337712.1| | 73001 | g14905 | i0 | 100 | 100 | 200 | 0 | 100 | 0 | 1 | 200 | 1620 | 1421 | Phoma herbarum 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 | 20000 | 370 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Phoma | Phoma herbarum | |
| 23321425 | 23321425 | PRJNA263496_P_NODE_25859_length_161_cov_0.910714_g25606_i0 | PRJNA263496 | 25859 | 161 | 0.910714 | 1.46624954 | Starmerella bombicola | 75736 | Fungi | Fungi | 130 | 6.01e-26 | NTclustered | gi|390195319|gb|JQ699088.1| | 75736 | g25606 | i0 | 81.595 | 92.7888198757764 | 163 | 24 | 99 | 6 | 2 | 161 | 7 | 166 | Starmerella bombicola strain NRRL Y-17069 translation elongation factor 1-alpha gene, partial cds | blastn | 14939 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Starmerella | Starmerella bombicola | |
| 24595605 | 24595605 | PRJNA263496_P_NODE_25440_length_161_cov_0.910714_g25187_i0 | PRJNA263496 | 25440 | 161 | 0.910714 | 1.46624954 | Lachnellula hyalina | 1316788 | Fungi | Fungi | 158 | 2.76e-34 | NTclustered | gi|1759127801|ref|XM_031149836.1| | 1316788 | g25187 | i0 | 85.065 | 64.5403726708075 | 154 | 23 | 96 | 0 | 7 | 160 | 961 | 808 | Lachnellula hyalina ATP synthase subunit beta, mitochondrial (atp-2), partial mRNA | blastn | 10391 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Lachnaceae | Lachnellula | Lachnellula hyalina |
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);;