contig_metadata
15 rows where bioproject = "PRJNA658591" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1901647 | 1901647 | PRJNA658591_S_NODE_10022_length_163_cov_1.719298_g9959_i0 | PRJNA658591 | 10022 | 163 | 1.719298 | 2.80245574 | Kneiffiella pilaecystidiata | 2530210 | Fungi | Fungi | 291 | 2.64e-74 | NTclustered | gi|2316022357|gb|OP620789.1| | 2530210 | g9959 | i0 | 98.773 | 105.975460122699 | 163 | 2 | 100 | 0 | 1 | 163 | 2335 | 2173 | Kneiffiella pilaecystidiata voucher Helo_1517 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 | 17274 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Kneiffiella | Kneiffiella pilaecystidiata | ||
| 5728920 | 5728920 | PRJNA658591_S_NODE_2165_length_288_cov_1.715481_g2102_i0 | PRJNA658591 | 2165 | 288 | 1.715481 | 4.94058528 | Malassezia restricta | 76775 | Fungi | Fungi | 494 | 3.68e-135 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g2102 | i0 | 97.578 | 80.8090277777778 | 289 | 6 | 100 | 1 | 1 | 288 | 3271 | 2983 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 23273 | 494 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 5728927 | 5728927 | PRJNA658591_S_NODE_3845_length_229_cov_1.355556_g3782_i0 | PRJNA658591 | 3845 | 229 | 1.355556 | 3.10422324 | Malassezia restricta | 76775 | Fungi | Fungi | 416 | 6.289999999999999e-112 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g3782 | i0 | 99.563 | 92.8602620087336 | 229 | 0 | 100 | 1 | 1 | 229 | 1520 | 1747 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 21265 | 416 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 7004075 | 7004075 | PRJNA658591_S_NODE_1566_length_330_cov_4.224199_g1503_i0 | PRJNA658591 | 1566 | 330 | 4.224199 | 13.9398567 | Dioszegia hungarica | 4972 | Fungi | Fungi | 599 | 8.849999999999995e-167 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g1503 | i0 | 99.394 | 137.993939393939 | 330 | 2 | 100 | 0 | 1 | 330 | 1641 | 1312 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 45538 | 599 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 7539309 | 7539309 | PRJNA658591_S_NODE_10086_length_163_cov_0.912281_g10023_i0 | PRJNA658591 | 10086 | 163 | 0.912281 | 1.48701803 | Malassezia | 55193 | Fungi | Fungi | 296 | 5.68e-76 | NTclustered | gi|398360769|gb|JX132826.1| | 338567 | g10023 | i0 | 99.39 | 101.993865030675 | 164 | 0 | 100 | 1 | 1 | 163 | 165 | 2 | Uncultured Malassezia clone CEas161 26S ribosomal RNA gene, partial sequence | blastn | 16625 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | uncultured Malassezia | ||
| 8814381 | 8814381 | PRJNA658591_S_NODE_8867_length_168_cov_28.882353_g8804_i0 | PRJNA658591 | 8867 | 168 | 28.882353 | 48.52235304 | Eukaryota | 2759 | Fungi | Fungi | 307 | 2.73e-79 | NTclustered | gi|2558627581|gb|OR405830.1| | 76775 | g8804 | i0 | 100 | 100.785714285714 | 166 | 0 | 99 | 0 | 3 | 168 | 495 | 330 | Malassezia restricta strain GSVCC20Z3-2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 16932 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 12640594 | 12640594 | PRJNA658591_S_NODE_1990_length_298_cov_4.297189_g1927_i0 | PRJNA658591 | 1990 | 298 | 4.297189 | 12.80562322 | Dioszegia | 165440 | Fungi | Fungi | 414 | 3.07e-111 | NTclustered | gi|98991732|gb|DQ513276.1| | 4974 | g1927 | i0 | 95.367 | 86.9597315436242 | 259 | 12 | 87 | 0 | 40 | 298 | 362 | 104 | Dioszegia crocea strain CRUB 1279 26S ribosomal RNA gene, partial sequence | blastn | 25914 | 414 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia crocea | |
| 14654434 | 14654434 | PRJNA658591_S_NODE_6772_length_185_cov_3.441176_g6709_i0 | PRJNA658591 | 6772 | 185 | 3.441176 | 6.3661756 | Dioszegia hungarica | 4972 | Fungi | Fungi | 324 | 3.03e-84 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g6709 | i0 | 98.37 | 113.324324324324 | 184 | 3 | 99 | 0 | 1 | 184 | 1943 | 2126 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 20965 | 324 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 18477787 | 18477787 | PRJNA658591_S_NODE_6475_length_188_cov_5.223022_g6412_i0 | PRJNA658591 | 6475 | 188 | 5.223022 | 9.81928136 | uncultured Agaricomycetidae | 585505 | Fungi | Fungi | 331 | 1.85e-86 | NTclustered | gi|219812624|gb|FJ552838.1| | 585505 | g6412 | i0 | 98.404 | 100.106382978723 | 188 | 3 | 100 | 0 | 1 | 188 | 1 | 188 | Uncultured Agaricomycetidae clone LTSP_EUKA_P1H12 18S ribosomal RNA, 18S-25/28S ribosomal RNA intergenic spacer, partial sequence | blastn | 18820 | 331 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | uncultured Agaricomycetidae | ||||
| 19012937 | 19012937 | PRJNA658591_S_NODE_11695_length_150_cov_4.029703_g11632_i0 | PRJNA658591 | 11695 | 150 | 4.029703 | 6.0445545 | Fungi | 4751 | Fungi | Fungi | 276 | 6.660000000000001e-70 | NTclustered | gi|1497815244|ref|NG_062030.1| | 4973 | g11632 | i0 | 100 | 99.3333333333333 | 149 | 0 | 99 | 0 | 1 | 149 | 909 | 761 | Dioszegia aurantiaca JCM 2956 18S rRNA gene, partial sequence; from TYPE material | blastn | 14900 | 276 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia aurantiaca | |
| 19012946 | 19012946 | PRJNA658591_S_NODE_5815_length_196_cov_3.292517_g5752_i0 | PRJNA658591 | 5815 | 196 | 3.292517 | 6.45333332 | Microbotryomycetes | 162481 | Fungi | Fungi | 195 | 2.66e-45 | NTclustered | gi|1358186634|gb|MH047191.1| | 5278 | g5752 | i0 | 89.103 | 62.5357142857143 | 156 | 17 | 80 | 0 | 29 | 184 | 3878 | 4033 | Leucosporidium scottii 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 | 12257 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium scottii | |
| 19752483 | 19752483 | PRJNA658591_S_NODE_1636_length_324_cov_4.516364_g1573_i0 | PRJNA658591 | 1636 | 324 | 4.516364 | 14.63301936 | Dioszegia hungarica | 4972 | Fungi | Fungi | 536 | 6.889999999999998e-148 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g1573 | i0 | 96.605 | 139.450617283951 | 324 | 9 | 99 | 2 | 1 | 323 | 3063 | 3385 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 45182 | 536 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 20287742 | 20287742 | PRJNA658591_S_NODE_2796_length_259_cov_1.347619_g2733_i0 | PRJNA658591 | 2796 | 259 | 1.347619 | 3.49033321 | Polyporaceae | 5317 | Fungi | Fungi | 363 | 9.589999999999999e-96 | NTclustered | gi|77379308|gb|DQ208413.1| | 5315 | g2733 | i0 | 91.923 | 104.200772200772 | 260 | 19 | 100 | 2 | 1 | 259 | 1846 | 1588 | Ganoderma lucidum strain C-2 large subunit ribosomal RNA gene, partial sequence | blastn | 26988 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma lucidum | |
| 22302757 | 22302757 | PRJNA658591_S_NODE_3458_length_238_cov_1.777778_g3395_i0 | PRJNA658591 | 3458 | 238 | 1.777778 | 4.23111164 | Dioszegia hungarica | 4972 | Fungi | Fungi | 440 | 3.899999999999999e-119 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g3395 | i0 | 100 | 147.40756302521 | 238 | 0 | 100 | 0 | 1 | 238 | 1594 | 1831 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 35083 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 23578136 | 23578136 | PRJNA658591_S_NODE_4899_length_209_cov_1.900000_g4836_i0 | PRJNA658591 | 4899 | 209 | 1.9 | 3.971 | Exobasidium vaccinii | 5407 | Fungi | Fungi | 298 | 2.13e-76 | NTclustered | gi|501438071|gb|FJ644526.2| | 5407 | g4836 | i0 | 92.344 | 22.6650717703349 | 209 | 16 | 100 | 0 | 1 | 209 | 1971 | 2179 | Exobasidium vaccinii voucher TUB 019109 28S ribosomal RNA gene, partial sequence | blastn | 4737 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Exobasidiaceae | Exobasidium | Exobasidium vaccinii |
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);;