contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA692200" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3731111 | 3731111 | PRJNA692200_S_NODE_5863_length_273_cov_3.928571_g5806_i0 | PRJNA692200 | 5863 | 273 | 3.928571 | 10.72499883 | Polyporales | 5303 | Fungi | Fungi | 58.4 | 5.39e-4 | NTclustered | gi|166798401|gb|EU402543.1| | 500524 | g5806 | i0 | 100 | 0.227106227106227 | 31 | 0 | 11 | 0 | 144 | 174 | 243 | 273 | Polyporus cf. talpae PR-2 large subunit ribosomal RNA gene, partial sequence | blastn | 62 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Polyporus | Polyporus cf. talpae PR-2 | |
| 7051199 | 7051199 | PRJNA692200_S_NODE_1286_length_420_cov_17.204852_g1236_i0 | PRJNA692200 | 1286 | 420 | 17.204852 | 72.2603784 | Filobasidium floriforme | 5210 | Fungi | Fungi | 222 | 2.91e-53 | NTclustered | gi|2185538222|ref|XM_046181949.1| | 5210 | g1236 | i0 | 81.206 | 46.5714285714286 | 282 | 47 | 66 | 4 | 140 | 418 | 531 | 253 | Filobasidium floriforme cyclophilin-like domain-containing protein (HD553DRAFT_329960), partial mRNA | blastn | 19560 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 7557164 | 7557164 | PRJNA692200_S_NODE_19586_length_168_cov_1.260504_g19529_i0 | PRJNA692200 | 19586 | 168 | 1.260504 | 2.11764672 | Heterobasidion | 13562 | Fungi | Fungi | 135 | 1.3600000000000002e-27 | NTclustered | gi|2524649381|ref|NC_080339.1| | 13563 | g19529 | i0 | 93.548 | 52.0595238095238 | 93 | 3 | 55 | 3 | 35 | 127 | 20604 | 20693 | Heterobasidion annosum isolate Sa16_4 mitochondrion, complete genome | blastn | 8746 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Bondarzewiaceae | Heterobasidion | Heterobasidion annosum | |
| 8326146 | 8326146 | PRJNA692200_S_NODE_9287_length_230_cov_316.480663_g9230_i0 | PRJNA692200 | 9287 | 230 | 316.480663 | 727.9055249 | Vanrija albida | 181172 | Fungi | Fungi | 87.9 | 5.63e-13 | NTclustered | gi|2837743760|ref|XM_069356141.1| | 181172 | g9230 | i0 | 78.014 | 18.8086956521739 | 141 | 29 | 61 | 2 | 91 | 230 | 444 | 305 | Vanrija albida Ubiquitin-conjugating enzyme E2 4 (UBC4), partial mRNA | blastn | 4326 | 87.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija albida | |
| 10107910 | 10107910 | PRJNA692200_S_NODE_11188_length_213_cov_1.780488_g11131_i0 | PRJNA692200 | 11188 | 213 | 1.780488 | 3.79243944 | Tulasnella | 5240 | Fungi | Fungi | 346 | 7.68e-91 | NTclustered | gi|2566940750|gb|OR470887.1| | 5241 | g11131 | i0 | 100 | 70.5821596244132 | 187 | 0 | 88 | 0 | 1 | 187 | 905 | 1091 | Tulasnella violea isolate HHB3860 SV1 small subunit ribosomal RNA gene, partial sequence | blastn | 15034 | 346 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella violea | |
| 10107934 | 10107934 | PRJNA692200_S_NODE_21428_length_163_cov_2.087719_g21371_i0 | PRJNA692200 | 21428 | 163 | 2.087719 | 3.40298197 | Sporobolomyces | 5429 | Fungi | Fungi | 283 | 4.43e-72 | NTclustered | gi|92111142|gb|DQ459616.1| | 5003 | g21371 | i0 | 99.359 | 95.7055214723926 | 156 | 1 | 96 | 0 | 1 | 156 | 315 | 470 | Sporidiobolus pararoseus isolate C44 18S small subunit ribosomal RNA gene, partial sequence | blastn | 15600 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces pararoseus | |
| 15975290 | 15975290 | PRJNA692200_S_NODE_12833_length_201_cov_1.078947_g12776_i0 | PRJNA692200 | 12833 | 201 | 1.078947 | 2.16868347 | Tubulicium raphidisporum | 2547720 | Fungi | Fungi | 283 | 5.69e-72 | NTclustered | gi|2184415283|gb|OM422801.1| | 2547720 | g12776 | i0 | 92.079 | 11.9004975124378 | 202 | 15 | 100 | 1 | 1 | 201 | 473 | 272 | Tubulicium raphidisporum voucher He3191 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 2392 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Corticiales | Corticiaceae | Tubulicium | Tubulicium raphidisporum | |
| 17250615 | 17250615 | PRJNA692200_S_NODE_20654_length_165_cov_1.741379_g20597_i0 | PRJNA692200 | 20654 | 165 | 1.741379 | 2.87327535 | Wallemia mellicola | 1708541 | Fungi | Fungi | 52.8 | 0.014 | NTclustered | gi|588261096|ref|XM_006959640.1| | 671144 | g20597 | i0 | 100 | 0.16969696969697 | 28 | 0 | 17 | 0 | 9 | 36 | 519 | 546 | Wallemia mellicola CBS 633.66 Gar1-domain-containing protein mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia mellicola | |
| 17757124 | 17757124 | PRJNA692200_S_NODE_8854_length_235_cov_1.569892_g8797_i0 | PRJNA692200 | 8854 | 235 | 1.569892 | 3.6892462 | Favolaschia | 139071 | Fungi | Fungi | 418 | 1.8e-112 | NTclustered | gi|2694739250|gb|PP447551.1| | 3127936 | g8797 | i0 | 98.723 | 100.004255319149 | 235 | 3 | 100 | 0 | 1 | 235 | 40 | 274 | Favolaschia sp. QYZ-2024a voucher Dai 26824 large subunit ribosomal RNA gene, partial sequence | blastn | 23501 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Favolaschia | Favolaschia sp. QYZ-2024a | |
| 21075105 | 21075105 | PRJNA692200_S_NODE_16217_length_182_cov_1.503759_g16160_i0 | PRJNA692200 | 16217 | 182 | 1.503759 | 2.73684138 | Auricularia villosula | 1579976 | Fungi | Fungi | 220 | 4.01e-53 | NTclustered | gi|2258688624|ref|NC_064342.1| | 1579976 | g16160 | i0 | 92.903 | 71.2417582417582 | 155 | 6 | 84 | 3 | 30 | 182 | 91634 | 91483 | Auricularia villosula mitochondrion, complete genome | blastn | 12966 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariaceae | Auricularia | Auricularia villosula | |
| 21075470 | 21075470 | PRJNA692200_S_NODE_8337_length_240_cov_3.178010_g8280_i0 | PRJNA692200 | 8337 | 240 | 3.17801 | 7.627224 | Puccinia triticina | 208348 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2436879268|ref|XM_053168003.1| | 208348 | g8280 | i0 | 89.362 | 0.195833333333333 | 47 | 2 | 19 | 3 | 131 | 176 | 1129 | 1085 | Puccinia triticina uncharacterized protein (PtA15_4A149), partial mRNA | blastn | 47 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia triticina | |
| 22349946 | 22349946 | PRJNA692200_S_NODE_13758_length_195_cov_1.616438_g13701_i0 | PRJNA692200 | 13758 | 195 | 1.616438 | 3.1520541 | Cystobasidium sp. CCFEE 5186 | 1221549 | Fungi | Fungi | 139 | 1.26e-28 | NTclustered | gi|401022415|gb|JX124722.1| | 1221549 | g13701 | i0 | 83.333 | 80.2 | 156 | 20 | 80 | 6 | 1 | 156 | 6 | 155 | Cystobasidium sp. CCFEE 5186 large subunit ribosomal RNA gene, partial sequence | blastn | 15639 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium sp. CCFEE 5186 | |
| 24898881 | 24898881 | PRJNA692200_S_NODE_13120_length_199_cov_1.333333_g13063_i0 | PRJNA692200 | 13120 | 199 | 1.333333 | 2.65333267 | uncultured Tulasnella | 229420 | Fungi | Fungi | 276 | 9.41e-70 | NTclustered | gi|32265062|gb|AY192442.1| | 229420 | g13063 | i0 | 96.951 | 45.6884422110553 | 164 | 5 | 82 | 0 | 2 | 165 | 827 | 990 | Uncultured Tulasnella sp. clone 2455 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 9092 | 276 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | uncultured Tulasnella | ||
| 25405729 | 25405729 | PRJNA692200_S_NODE_23420_length_155_cov_2.301887_g23363_i0 | PRJNA692200 | 23420 | 155 | 2.301887 | 3.56792485 | Sporidiobolaceae | 1799696 | Fungi | Fungi | 278 | 1.93e-70 | NTclustered | gi|827515687|gb|KP346957.1| | 5003 | g23363 | i0 | 100 | 96.7741935483871 | 150 | 0 | 97 | 0 | 1 | 150 | 187 | 38 | Sporidiobolus pararoseus strain CBS 13692 26S ribosomal RNA gene, partial sequence | blastn | 15000 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces pararoseus |
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);;