contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA603943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 577777 | 577777 | PRJNA603943_P_NODE_60241_length_247_cov_0.885057_g60049_i0 | PRJNA603943 | 60241 | 247 | 0.885057 | 2.18609079 | Leucosporidium sp. AY30 | 662878 | Fungi | Fungi | 412 | 8.89e-111 | NTclustered | gi|254927417|gb|GQ336996.1| | 662878 | g60049 | i0 | 96.761 | 98.085020242915 | 247 | 8 | 100 | 0 | 1 | 247 | 4377 | 4131 | Leucosporidium sp. AY30 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 24227 | 412 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium sp. AY30 | |
| 1852341 | 1852341 | PRJNA603943_P_NODE_17962_length_399_cov_1.447853_g17770_i0 | PRJNA603943 | 17962 | 399 | 1.447853 | 5.77693347 | Pseudozyma hubeiensis | 327079 | Fungi | Fungi | 244 | 5.88e-60 | NTclustered | gi|808361265|ref|XM_012331044.1| | 1305764 | g17770 | i0 | 83.65 | 7.70927318295739 | 263 | 39 | 65 | 3 | 1 | 261 | 757 | 1017 | Pseudozyma hubeiensis SY62 S-adenosylmethionine synthetase partial mRNA | blastn | 3076 | 244 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma hubeiensis | |
| 5681420 | 5681420 | PRJNA603943_P_NODE_56045_length_249_cov_0.875000_g55853_i0 | PRJNA603943 | 56045 | 249 | 0.875 | 2.17875 | Malassezia restricta | 76775 | Fungi | Fungi | 460 | 3.16e-125 | NTclustered | gi|1546633208|ref|XM_027628264.1| | 76775 | g55853 | i0 | 100 | 1 | 249 | 0 | 100 | 0 | 1 | 249 | 7 | 255 | Malassezia restricta uncharacterized protein (MRET_1637), partial mRNA | blastn | 249 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6956405 | 6956405 | PRJNA603943_P_NODE_68126_length_242_cov_0.911243_g67934_i0 | PRJNA603943 | 68126 | 242 | 0.911243 | 2.20520806 | Malassezia restricta | 76775 | Fungi | Fungi | 381 | 2.449999999999999e-101 | NTclustered | gi|1546637747|ref|XM_027630515.1| | 76775 | g67934 | i0 | 100 | 0.851239669421488 | 206 | 0 | 85 | 0 | 37 | 242 | 1 | 206 | Malassezia restricta ribonuclease P/MRP protein subunit POP5 (MRET_3888), partial mRNA | blastn | 206 | 381 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 8231098 | 8231098 | PRJNA603943_P_NODE_61567_length_246_cov_0.890173_g61375_i0 | PRJNA603943 | 61567 | 246 | 0.890173 | 2.18982558 | Malassezia restricta | 76775 | Fungi | Fungi | 424 | 4.09e-114 | NTclustered | gi|1546635226|ref|XM_027629272.1| | 76775 | g61375 | i0 | 98.739 | 0.967479674796748 | 238 | 3 | 97 | 0 | 9 | 246 | 1 | 238 | Malassezia restricta uncharacterized protein (MRET_2645), partial mRNA | blastn | 238 | 424 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 8795918 | 8795918 | PRJNA603943_P_NODE_33767_length_314_cov_1.282158_g33575_i0 | PRJNA603943 | 33767 | 314 | 1.282158 | 4.02597612 | Naganishia | 1851509 | Fungi | Fungi | 580 | 3.0299999999999992e-161 | NTclustered | gi|2715816871|dbj|LC810246.1| | 92952 | g33575 | i0 | 100 | 99.8184713375796 | 314 | 0 | 100 | 0 | 1 | 314 | 599 | 912 | Naganishia adeliensis NIPR-00477 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2 and 28S rRNA, partial and complete sequence | blastn | 31343 | 580 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia adeliensis | |
| 10071683 | 10071683 | PRJNA603943_P_NODE_32148_length_320_cov_5.704453_g31956_i0 | PRJNA603943 | 32148 | 320 | 5.704453 | 18.2542496 | Malassezia | 55193 | Fungi | Fungi | 592 | 1.4299999999999996e-164 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g31956 | i0 | 100 | 98.00625 | 320 | 0 | 100 | 0 | 1 | 320 | 33 | 352 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 31362 | 592 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10780764 | 10780764 | PRJNA603943_P_NODE_13289_length_450_cov_0.938992_g13097_i0 | PRJNA603943 | 13289 | 450 | 0.938992 | 4.225464 | Moesziomyces antarcticus | 84753 | Fungi | Fungi | 250 | 1.44e-61 | NTclustered | gi|955494727|ref|XM_014802187.1| | 84753 | g13097 | i0 | 78.88 | 42.7311111111111 | 393 | 65 | 85 | 17 | 33 | 416 | 1479 | 1096 | Moesziomyces antarcticus 40S ribosomal protein S9 (PAN0_004d2242), partial mRNA | blastn | 19229 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces antarcticus | |
| 10781920 | 10781920 | PRJNA603943_P_NODE_5449_length_650_cov_1.724437_g5267_i0 | PRJNA603943 | 5449 | 650 | 1.724437 | 11.2088405 | uncultured Filobasidiella | 1503101 | Fungi | Fungi | 846 | 0 | NTclustered | gi|387156411|emb|HE806144.1| | 1503101 | g5267 | i0 | 96.139 | 140.789230769231 | 518 | 20 | 89 | 0 | 1 | 518 | 1416 | 1933 | Uncultured Filobasidiella partial 26S rRNA gene, clone Ao0Yyyy6 | blastn | 91513 | 846 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | uncultured Filobasidiella | ||
| 10781933 | 10781933 | PRJNA603943_P_NODE_54969_length_250_cov_0.870056_g54777_i0 | PRJNA603943 | 54969 | 250 | 0.870056 | 2.17514 | Malassezia restricta | 76775 | Fungi | Fungi | 462 | 8.83e-126 | NTclustered | gi|1546635284|ref|XM_027629301.1| | 76775 | g54777 | i0 | 100 | 1 | 250 | 0 | 100 | 0 | 1 | 250 | 5180 | 5429 | Malassezia restricta nuclear pore complex protein Nup205 (MRET_2674), partial mRNA | blastn | 250 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 16445811 | 16445811 | PRJNA603943_P_NODE_34013_length_313_cov_1.283333_g33821_i0 | PRJNA603943 | 34013 | 313 | 1.283333 | 4.01683229 | Dioszegia | 165440 | Fungi | Fungi | 361 | 4.28e-95 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g33821 | i0 | 87.658 | 125.613418530351 | 316 | 31 | 100 | 8 | 1 | 313 | 2982 | 3292 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 39317 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 18429625 | 18429625 | PRJNA603943_P_NODE_53675_length_251_cov_0.865169_g53483_i0 | PRJNA603943 | 53675 | 251 | 0.865169 | 2.17157419 | Malassezia restricta | 76775 | Fungi | Fungi | 459 | 1.1499999999999996e-124 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g53483 | i0 | 99.602 | 72.6414342629482 | 251 | 1 | 100 | 0 | 1 | 251 | 2221 | 1971 | Malassezia restricta mitochondrion, complete genome | blastn | 18233 | 459 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19703819 | 19703819 | PRJNA603943_P_NODE_40736_length_289_cov_1.125000_g40544_i0 | PRJNA603943 | 40736 | 289 | 1.125 | 3.25125 | Malassezia restricta | 76775 | Fungi | Fungi | 473 | 4.819999999999999e-129 | NTclustered | gi|1546630069|ref|XM_027626695.1| | 76775 | g40544 | i0 | 96.194 | 1 | 289 | 11 | 100 | 0 | 1 | 289 | 1846 | 1558 | Malassezia restricta dehydrogenase (MRET_0068), partial mRNA | blastn | 289 | 473 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19704174 | 19704174 | PRJNA603943_P_NODE_52756_length_251_cov_0.865169_g52564_i0 | PRJNA603943 | 52756 | 251 | 0.865169 | 2.17157419 | Malassezia restricta | 76775 | Fungi | Fungi | 403 | 5.45e-108 | NTclustered | gi|1546638439|ref|XM_027630861.1| | 76775 | g52564 | i0 | 95.618 | 1 | 251 | 11 | 100 | 0 | 1 | 251 | 2190 | 2440 | Malassezia restricta RalA-binding protein 1 (MRET_4234), partial mRNA | blastn | 251 | 403 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 21545198 | 21545198 | PRJNA603943_P_NODE_64457_length_244_cov_0.900585_g64265_i0 | PRJNA603943 | 64457 | 244 | 0.900585 | 2.1974274 | Hymenochaetales | 139380 | Fungi | Fungi | 451 | 1.86e-122 | NTclustered | gi|2472531740|gb|OQ723339.1| | 50381 | g64265 | i0 | 100 | 99.7827868852459 | 244 | 0 | 100 | 0 | 1 | 244 | 348 | 591 | Trichaptum biforme voucher SVER-691133 large subunit ribosomal RNA gene, partial sequence | blastn | 24347 | 451 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hirschioporaceae | Pallidohirschioporus | Pallidohirschioporus biformis | |
| 22820355 | 22820355 | PRJNA603943_P_NODE_31358_length_323_cov_2.452000_g31166_i0 | PRJNA603943 | 31358 | 323 | 2.452 | 7.91996 | Opisthokonta | 33154 | Fungi | Fungi | 597 | 3.11e-166 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g31166 | i0 | 100 | 99.9721362229102 | 323 | 0 | 100 | 0 | 1 | 323 | 203 | 525 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 32291 | 597 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 23529852 | 23529852 | PRJNA603943_P_NODE_44839_length_276_cov_1.394089_g44647_i0 | PRJNA603943 | 44839 | 276 | 1.394089 | 3.84768564 | Malassezia restricta | 76775 | Fungi | Fungi | 372 | 1.72e-98 | NTclustered | gi|1546635625|ref|XM_027629455.1| | 76775 | g44647 | i0 | 97.26 | 0.793478260869565 | 219 | 6 | 79 | 0 | 1 | 219 | 61 | 279 | Malassezia restricta uncharacterized protein (MRET_2828), partial mRNA | blastn | 219 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 23530682 | 23530682 | PRJNA603943_P_NODE_9699_length_511_cov_1.721461_g9509_i0 | PRJNA603943 | 9699 | 511 | 1.721461 | 8.79666571 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 91.6 | 1.06e-13 | NTclustered | gi|1423569936|ref|XM_025739965.1| | 58919 | g9509 | i0 | 84.211 | 8.76320939334638 | 95 | 13 | 18 | 2 | 375 | 468 | 132 | 39 | Tilletiopsis washingtonensis ribosomal protein S14 (FA09DRAFT_290831), partial mRNA | blastn | 4478 | 91.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 24804123 | 24804123 | PRJNA603943_P_NODE_64380_length_244_cov_0.900585_g64188_i0 | PRJNA603943 | 64380 | 244 | 0.900585 | 2.1974274 | Malassezia globosa | 76773 | Fungi | Fungi | 451 | 1.86e-122 | NTclustered | gi|164658412|ref|XM_001730280.1| | 425265 | g64188 | i0 | 100 | 1 | 244 | 0 | 100 | 0 | 1 | 244 | 231 | 474 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2714), partial mRNA | blastn | 244 | 451 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa |
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);;