contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA1247234" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 351086 | 351086 | PRJNA1247234_P_NODE_10381_length_337_cov_1.181818_g10225_i0 | PRJNA1247234 | 10381 | 337 | 1.181818 | 3.98272666 | Acaromyces ingoldii | 215250 | Fungi | Fungi | 296 | 1.33e-75 | NTclustered | gi|1418949390|ref|XM_025525590.1| | 215250 | g10225 | i0 | 96.648 | 53.0830860534125 | 179 | 5 | 53 | 1 | 1 | 179 | 877 | 700 | Acaromyces ingoldii hypothetical protein (FA10DRAFT_59207), mRNA | blastn | 17889 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Cryptobasidiaceae | Acaromyces | Acaromyces ingoldii | |
| 351291 | 351291 | PRJNA1247234_P_NODE_21861_length_251_cov_0.876404_g21705_i0 | PRJNA1247234 | 21861 | 251 | 0.876404 | 2.19977404 | Entyloma ficariae | 84747 | Fungi | Fungi | 200 | 7.679999999999999e-47 | NTclustered | gi|1859735553|gb|MT644871.1| | 84747 | g21705 | i0 | 81.349 | 68.7011952191235 | 252 | 42 | 100 | 4 | 1 | 251 | 5941 | 5694 | Entyloma ficariae isolate DM1162 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 | 17244 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Entylomataceae | Entyloma | Entyloma ficariae | |
| 2902216 | 2902216 | PRJNA1247234_P_NODE_17843_length_269_cov_1.163265_g17687_i0 | PRJNA1247234 | 17843 | 269 | 1.163265 | 3.12918285 | Kalmanozyma brasiliensis | 1392244 | Fungi | Fungi | 165 | 3.03e-36 | NTclustered | gi|2576843289|ref|XM_016436560.2| | 1365824 | g17687 | i0 | 79.237 | 0.877323420074349 | 236 | 49 | 88 | 0 | 6 | 241 | 365 | 130 | Kalmanozyma brasiliensis GHG001 Alpha-D-phosphohexomutase, C-terminal (PSEUBRA_003407), partial mRNA | blastn | 236 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Kalmanozyma | Kalmanozyma brasiliensis | |
| 4879744 | 4879744 | PRJNA1247234_P_NODE_17824_length_269_cov_1.193878_g17668_i0 | PRJNA1247234 | 17824 | 269 | 1.193878 | 3.21153182 | Ustilaginaceae | 5268 | Fungi | Fungi | 159 | 1.41e-34 | NTclustered | gi|758977865|ref|XM_011390682.1| | 5270 | g17668 | i0 | 84.242 | 1.23791821561338 | 165 | 24 | 61 | 2 | 9 | 172 | 2773 | 2936 | Mycosarcoma maydis putative H+-transporting P-type ATPase (UMAG_02581), partial mRNA | blastn | 333 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Mycosarcoma | Mycosarcoma maydis | |
| 9279665 | 9279665 | PRJNA1247234_P_NODE_20848_length_252_cov_0.871508_g20692_i0 | PRJNA1247234 | 20848 | 252 | 0.871508 | 2.19620016 | Mycosarcoma maydis | 5270 | Fungi | Fungi | 315 | 2.6399999999999992e-81 | NTclustered | gi|758973325|ref|XM_011388420.1| | 5270 | g20692 | i0 | 89.243 | 11.9126984126984 | 251 | 27 | 99 | 0 | 2 | 252 | 973 | 1223 | Mycosarcoma maydis putative NADH2 dehydrogenase (ubiquinone) flavoprotein 1 (UMAG_11170), partial mRNA | blastn | 3002 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Mycosarcoma | Mycosarcoma maydis | |
| 9279768 | 9279768 | PRJNA1247234_P_NODE_26608_length_244_cov_0.912281_g26452_i0 | PRJNA1247234 | 26608 | 244 | 0.912281 | 2.22596564 | Thecaphora frezii | 1269715 | Fungi | Fungi | 287 | 5.54e-73 | NTclustered | gi|2221572550|gb|MW691409.1| | 1269715 | g26452 | i0 | 88.559 | 3.24180327868852 | 236 | 27 | 97 | 0 | 1 | 236 | 1074 | 839 | Thecaphora frezii clone V_5 putative nad binding dehydrogenase mRNA, complete cds | blastn | 791 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Urocystidales | Glomosporiaceae | Thecaphora | Thecaphora frezii | |
| 10555574 | 10555574 | PRJNA1247234_P_NODE_23989_length_247_cov_1.580460_g23833_i0 | PRJNA1247234 | 23989 | 247 | 1.58046 | 3.9037362 | Kalmanozyma brasiliensis | 1392244 | Fungi | Fungi | 250 | 7.38e-62 | NTclustered | gi|1023184729|ref|XM_016437881.1| | 1365824 | g23833 | i0 | 85.477 | 2.48987854251012 | 241 | 33 | 97 | 2 | 5 | 244 | 240 | 1 | Kalmanozyma brasiliensis GHG001 CsbD-like protein (PSEUBRA_004332), partial mRNA | blastn | 615 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Kalmanozyma | Kalmanozyma brasiliensis | |
| 11254975 | 11254975 | PRJNA1247234_P_NODE_17989_length_267_cov_2.979381_g17833_i0 | PRJNA1247234 | 17989 | 267 | 2.979381 | 7.95494727 | Polyporaceae | 5317 | Fungi | Fungi | 483 | 7.31e-132 | NTclustered | gi|77379308|gb|DQ208413.1| | 5315 | g17833 | i0 | 99.251 | 107.868913857678 | 267 | 2 | 100 | 0 | 1 | 267 | 1601 | 1867 | Ganoderma lucidum strain C-2 large subunit ribosomal RNA gene, partial sequence | blastn | 28801 | 483 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma lucidum | |
| 11829988 | 11829988 | PRJNA1247234_P_NODE_17330_length_272_cov_3.432161_g17174_i0 | PRJNA1247234 | 17330 | 272 | 3.432161 | 9.33547792 | Ganoderma lucidum | 5315 | Fungi | Fungi | 429 | 9.869999999999999e-116 | NTclustered | gi|2724480650|gb|PP467489.1| | 5315 | g17174 | i0 | 95.238 | 104.761029411765 | 273 | 10 | 100 | 3 | 1 | 272 | 6402 | 6672 | Ganoderma lucidum strain Red Reishi No.6 intergenic spacer 2, partial sequence; 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S large subunit ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, intergenic spacer 2, 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S large subunit ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, and intergenic spacer 2, complete sequence; and 18S small subunit ribosomal RNA gene, partial sequence | blastn | 28495 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma lucidum | |
| 13805027 | 13805027 | PRJNA1247234_P_NODE_11751_length_321_cov_1.294355_g11595_i0 | PRJNA1247234 | 11751 | 321 | 1.294355 | 4.15487955 | Trametes | 5324 | Fungi | Fungi | 588 | 1.8599999999999994e-163 | NTclustered | gi|2055954241|gb|MZ424285.1| | 5327 | g11595 | i0 | 99.688 | 100 | 321 | 1 | 100 | 0 | 1 | 321 | 268 | 588 | Trametes hirsuta strain 575 large subunit ribosomal RNA gene, partial sequence | blastn | 32100 | 588 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes hirsuta | |
| 13805122 | 13805122 | PRJNA1247234_P_NODE_24191_length_247_cov_0.896552_g24035_i0 | PRJNA1247234 | 24191 | 247 | 0.896552 | 2.21448344 | Malassezia | 55193 | Fungi | Fungi | 457 | 4.05e-124 | NTclustered | gi|1859980207|gb|MT645548.1| | 76775 | g24035 | i0 | 100 | 100 | 247 | 0 | 100 | 0 | 1 | 247 | 222 | 468 | Malassezia restricta strain RM11 large subunit ribosomal RNA gene, partial sequence | blastn | 24700 | 457 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 15654374 | 15654374 | PRJNA1247234_P_NODE_18073_length_267_cov_1.206186_g17917_i0 | PRJNA1247234 | 18073 | 267 | 1.206186 | 3.22051662 | Kalmanozyma brasiliensis | 1392244 | Fungi | Fungi | 193 | 1.38e-44 | NTclustered | gi|1023177687|ref|XM_016436031.1| | 1365824 | g17917 | i0 | 93.13 | 36.8913857677903 | 131 | 9 | 49 | 0 | 1 | 131 | 131 | 1 | Kalmanozyma brasiliensis GHG001 Small GTPase superfamily, ARF/SAR type (PSEUBRA_000406), partial mRNA | blastn | 9850 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Kalmanozyma | Kalmanozyma brasiliensis | |
| 17629395 | 17629395 | PRJNA1247234_P_NODE_13374_length_304_cov_1.350649_g13218_i0 | PRJNA1247234 | 13374 | 304 | 1.350649 | 4.10597296 | Ustilaginaceae | 5268 | Fungi | Fungi | 139 | 2.11e-28 | NTclustered | gi|1701847647|ref|XM_029882114.1| | 280036 | g13218 | i0 | 89.189 | 1.57565789473684 | 111 | 12 | 37 | 0 | 1 | 111 | 418 | 528 | Sporisorium graminicola uncharacterized protein (EX895_001515), partial mRNA | blastn | 479 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Sporisorium | Sporisorium graminicola | |
| 17629494 | 17629494 | PRJNA1247234_P_NODE_24874_length_246_cov_0.901734_g24718_i0 | PRJNA1247234 | 24874 | 246 | 0.901734 | 2.21826564 | Ustilaginaceae | 5268 | Fungi | Fungi | 237 | 5.72e-58 | NTclustered | gi|758981057|ref|XM_011391933.1| | 5270 | g24718 | i0 | 90.503 | 68.9593495934959 | 179 | 17 | 73 | 0 | 1 | 179 | 179 | 1 | Mycosarcoma maydis Hsp70 family ATPase (UMAG_03791), partial mRNA | blastn | 16964 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Mycosarcoma | Mycosarcoma maydis | |
| 17629590 | 17629590 | PRJNA1247234_P_NODE_9794_length_345_cov_0.860294_g9638_i0 | PRJNA1247234 | 9794 | 345 | 0.860294 | 2.9680143 | Ustilaginaceae | 5268 | Fungi | Fungi | 503 | 7.5e-138 | NTclustered | gi|307602965|gb|HQ013028.1| | 882789 | g9638 | i0 | 93.255 | 98.3333333333333 | 341 | 23 | 99 | 0 | 3 | 343 | 564 | 904 | Macalpinomyces spermophorus voucher BRIP 51858 elongation factor 1-alpha gene, partial cds | blastn | 33925 | 507 | 0.992110453648915 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Macalpinomyces | Macalpinomyces spermophorus | |
| 18203229 | 18203229 | PRJNA1247234_P_NODE_25715_length_245_cov_0.906977_g25559_i0 | PRJNA1247234 | 25715 | 245 | 0.906977 | 2.22209365 | Sporisorium graminicola | 280036 | Fungi | Fungi | 156 | 1.64e-33 | NTclustered | gi|1701847421|ref|XM_029882001.1| | 280036 | g25559 | i0 | 78.884 | 1.45714285714286 | 251 | 37 | 98 | 15 | 4 | 243 | 2642 | 2397 | Sporisorium graminicola uncharacterized protein (EX895_001402), partial mRNA | blastn | 357 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Sporisorium | Sporisorium graminicola | |
| 19477598 | 19477598 | PRJNA1247234_P_NODE_25756_length_245_cov_0.906977_g25600_i0 | PRJNA1247234 | 25756 | 245 | 0.906977 | 2.22209365 | Kalmanozyma brasiliensis | 1392244 | Fungi | Fungi | 169 | 2.1e-37 | NTclustered | gi|1023181355|ref|XM_016435595.1| | 1365824 | g25600 | i0 | 79.352 | 6.26122448979592 | 247 | 45 | 99 | 6 | 1 | 244 | 736 | 493 | Kalmanozyma brasiliensis GHG001 Glucosamine/galactosamine-6-phosphate isomerase (PSEUBRA_002436), partial mRNA | blastn | 1534 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Kalmanozyma | Kalmanozyma brasiliensis | |
| 22028246 | 22028246 | PRJNA1247234_P_NODE_25278_length_245_cov_2.325581_g25122_i0 | PRJNA1247234 | 25278 | 245 | 2.325581 | 5.69767345 | Pseudozyma hubeiensis | 327079 | Fungi | Fungi | 200 | 7.46e-47 | NTclustered | gi|808370299|ref|XM_012334980.1| | 1305764 | g25122 | i0 | 83.105 | 0.893877551020408 | 219 | 37 | 89 | 0 | 1 | 219 | 2517 | 2299 | Pseudozyma hubeiensis SY62 hypothetical protein partial mRNA | blastn | 219 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma hubeiensis | |
| 24003665 | 24003665 | PRJNA1247234_P_NODE_13159_length_306_cov_1.339056_g13003_i0 | PRJNA1247234 | 13159 | 306 | 1.339056 | 4.09751136 | Basidiomycota | 5204 | Fungi | Fungi | 564 | 2.96e-156 | NTclustered | gi|1545773614|ref|NG_063541.1| | 105988 | g13003 | i0 | 100 | 99.6764705882353 | 305 | 0 | 99 | 0 | 2 | 306 | 1104 | 800 | Leucosporidium fellii JCM 9887 18S rRNA gene, partial sequence; from TYPE material | blastn | 30501 | 564 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium fellii | |
| 24577617 | 24577617 | PRJNA1247234_P_NODE_13660_length_302_cov_1.021834_g13504_i0 | PRJNA1247234 | 13660 | 302 | 1.021834 | 3.08593868 | Sporisorium graminicola | 280036 | Fungi | Fungi | 431 | 3.09e-116 | NTclustered | gi|1701859235|ref|XM_029886883.1| | 280036 | g13504 | i0 | 92.691 | 88.6059602649007 | 301 | 18 | 99 | 3 | 1 | 299 | 818 | 520 | Sporisorium graminicola uncharacterized protein (EX895_006291), partial mRNA | blastn | 26759 | 431 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Sporisorium | Sporisorium graminicola | |
| 24577691 | 24577691 | PRJNA1247234_P_NODE_17920_length_268_cov_1.256410_g17764_i0 | PRJNA1247234 | 17920 | 268 | 1.25641 | 3.3671788 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 202 | 2.3e-47 | NTclustered | gi|630966347|ref|XM_007881391.1| | 1277687 | g17764 | i0 | 87.791 | 21.9925373134328 | 172 | 21 | 64 | 0 | 83 | 254 | 139 | 310 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_03868), partial mRNA | blastn | 5894 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa |
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);;