contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJEB56027" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 991989 | 991989 | PRJEB56027_P_NODE_137201_length_228_cov_3.245161_g134392_i0 | PRJEB56027 | 137201 | 228 | 3.245161 | 7.39896708 | Opisthokonta | 33154 | Fungi | Fungi | 409 | 1.0500000000000001e-109 | NTclustered | gi|482716304|gb|KC509996.1| | 76775 | g134392 | i0 | 99.123 | 100.324561403509 | 228 | 0 | 100 | 1 | 1 | 228 | 239 | 14 | Malassezia restricta isolate ME2012042 large subunit ribosomal RNA gene, partial sequence | blastn | 22874 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 992022 | 992022 | PRJEB56027_P_NODE_80041_length_301_cov_4.447368_g77232_i0 | PRJEB56027 | 80041 | 301 | 4.447368 | 13.38657768 | root | 1 | Root_unresolved | Root_unresolved | 551 | 2.2699999999999992e-152 | NTclustered | gi|19908237|gb|AY083223.1| | 55194 | g77232 | i0 | 99.668 | 100.003322259136 | 301 | 1 | 100 | 0 | 1 | 301 | 744 | 1044 | Malassezia furfur strain NCPF 3349 18S ribosomal RNA gene, partial sequence | blastn | 30101 | 556 | 0.991007194244604 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 1398796 | 1398796 | PRJEB56027_P_NODE_91182_length_281_cov_1.322115_g88373_i0 | PRJEB56027 | 91182 | 281 | 1.322115 | 3.71514315 | Malassezia restricta | 76775 | Fungi | Fungi | 449 | 7.86e-122 | NTclustered | gi|1488178351|ref|NC_039455.1| | 76775 | g88373 | i0 | 94.932 | 5.51957295373666 | 296 | 0 | 100 | 13 | 1 | 281 | 17441 | 17736 | Malassezia restricta mitochondrion, complete genome | blastn | 1551 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3542489 | 3542489 | PRJEB56027_P_NODE_111703_length_253_cov_2.405556_g108894_i0 | PRJEB56027 | 111703 | 253 | 2.405556 | 6.08605668 | Cryptococcus | 5206 | Fungi | Fungi | 272 | 1.6199999999999996e-68 | NTclustered | gi|1338633128|gb|CP025718.1| | 5207 | g108894 | i0 | 85.985 | 147.928853754941 | 264 | 25 | 100 | 9 | 1 | 253 | 271465 | 271203 | Cryptococcus neoformans strain EN28 chromosome 2, complete sequence | blastn | 37426 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus neoformans | |
| 3948810 | 3948810 | PRJEB56027_P_NODE_129884_length_243_cov_0.905882_g127075_i0 | PRJEB56027 | 129884 | 243 | 0.905882 | 2.20129326 | Malassezia restricta | 76775 | Fungi | Fungi | 444 | 3.09e-120 | NTclustered | gi|1546630427|ref|XM_027626874.1| | 76775 | g127075 | i0 | 99.588 | 1 | 243 | 1 | 100 | 0 | 1 | 243 | 739 | 497 | Malassezia restricta RNA polymerase II subunit A C-terminal domain phosphatase (MRET_0247), partial mRNA | blastn | 243 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6502234 | 6502234 | PRJEB56027_P_NODE_76526_length_310_cov_3.042194_g73717_i0 | PRJEB56027 | 76526 | 310 | 3.042194 | 9.4308014 | Malassezia restricta | 76775 | Fungi | Fungi | 278 | 4.39e-70 | NTclustered | gi|1546631714|ref|XM_027627517.1| | 76775 | g73717 | i0 | 100 | 0.967741935483871 | 150 | 0 | 97 | 0 | 161 | 310 | 583 | 434 | Malassezia restricta FMN binding oxidoreductase (MRET_0890), partial mRNA | blastn | 300 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6502454 | 6502454 | PRJEB56027_P_NODE_85066_length_290_cov_1.419355_g82257_i0 | PRJEB56027 | 85066 | 290 | 1.419355 | 4.1161295 | Malassezia restricta | 76775 | Fungi | Fungi | 503 | 6.17e-138 | NTclustered | gi|1546635446|ref|XM_027629382.1| | 76775 | g82257 | i0 | 97.931 | 1 | 290 | 6 | 100 | 0 | 1 | 290 | 344 | 55 | Malassezia restricta diacylglycerol kinase catalytic domain protein (MRET_2755), partial mRNA | blastn | 290 | 503 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 7776873 | 7776873 | PRJEB56027_P_NODE_93867_length_277_cov_1.509804_g91058_i0 | PRJEB56027 | 93867 | 277 | 1.509804 | 4.18215708 | Rhodotorula graminis | 29898 | Fungi | Fungi | 224 | 5.1e-54 | NTclustered | gi|1069930811|ref|XM_018419087.1| | 578459 | g91058 | i0 | 88.235 | 0.675090252707581 | 187 | 22 | 68 | 0 | 85 | 271 | 1178 | 1364 | Rhodotorula graminis WP1 uncharacterized protein (RHOBADRAFT_66805), partial mRNA | blastn | 187 | 224 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 9051466 | 9051466 | PRJEB56027_P_NODE_85728_length_289_cov_1.425926_g82919_i0 | PRJEB56027 | 85728 | 289 | 1.425926 | 4.12092614 | Malassezia restricta | 76775 | Fungi | Fungi | 484 | 2.2299999999999998e-132 | NTclustered | gi|1546629969|ref|XM_027626645.1| | 76775 | g82919 | i0 | 96.886 | 1 | 289 | 9 | 100 | 0 | 1 | 289 | 2024 | 2312 | Malassezia restricta 6-phosphofructokinase 1 (MRET_0018), partial mRNA | blastn | 289 | 484 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10325190 | 10325190 | PRJEB56027_P_NODE_107909_length_258_cov_1.664865_g105100_i0 | PRJEB56027 | 107909 | 258 | 1.664865 | 4.2953517 | Malassezia restricta | 76775 | Fungi | Fungi | 477 | 3.2699999999999985e-130 | NTclustered | gi|1546634594|ref|XM_027628957.1| | 76775 | g105100 | i0 | 100 | 1 | 258 | 0 | 100 | 0 | 1 | 258 | 2485 | 2742 | Malassezia restricta ABC transporter (MRET_2330), partial mRNA | blastn | 258 | 477 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10325320 | 10325320 | PRJEB56027_P_NODE_112729_length_252_cov_1.720670_g109920_i0 | PRJEB56027 | 112729 | 252 | 1.72067 | 4.3360884 | Malassezia restricta | 76775 | Fungi | Fungi | 460 | 3.2e-125 | NTclustered | gi|1546630929|ref|XM_027627125.1| | 76775 | g109920 | i0 | 99.603 | 1 | 252 | 1 | 100 | 0 | 1 | 252 | 1562 | 1311 | Malassezia restricta lysophospholipase (MRET_0498), partial mRNA | blastn | 252 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10325381 | 10325381 | PRJEB56027_P_NODE_114809_length_251_cov_0.865169_g112000_i0 | PRJEB56027 | 114809 | 251 | 0.865169 | 2.17157419 | Malassezia globosa | 76773 | Fungi | Fungi | 431 | 2.4999999999999996e-116 | NTclustered | gi|164658913|ref|XM_001730530.1| | 425265 | g112000 | i0 | 97.619 | 1.00398406374502 | 252 | 5 | 100 | 1 | 1 | 251 | 1266 | 1517 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2378), partial mRNA | blastn | 252 | 431 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 12876516 | 12876516 | PRJEB56027_P_NODE_137451_length_227_cov_4.032468_g134642_i0 | PRJEB56027 | 137451 | 227 | 4.032468 | 9.15370236 | Malassezia restricta | 76775 | Fungi | Fungi | 398 | 2.25e-106 | NTclustered | gi|1546632428|ref|XM_027627874.1| | 76775 | g134642 | i0 | 98.238 | 1 | 227 | 4 | 100 | 0 | 1 | 227 | 861 | 1087 | Malassezia restricta transporter (MRET_1247), partial mRNA | blastn | 227 | 398 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 14151085 | 14151085 | PRJEB56027_P_NODE_128132_length_244_cov_0.865497_g125323_i0 | PRJEB56027 | 128132 | 244 | 0.865497 | 2.11181268 | Marasmius wynneae | 700783 | Fungi | Fungi | 263 | 9.34e-66 | NTclustered | gi|1859735591|gb|MT644909.1| | 700783 | g125323 | i0 | 86.235 | 129.52868852459 | 247 | 28 | 100 | 6 | 1 | 244 | 5519 | 5762 | Marasmius wynneae isolate DM1048 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 | 31605 | 263 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Marasmiaceae | Marasmius | Marasmius wynneae | |
| 16701152 | 16701152 | PRJEB56027_P_NODE_93854_length_277_cov_1.509804_g91045_i0 | PRJEB56027 | 93854 | 277 | 1.509804 | 4.18215708 | Lentinus tigrinus | 5365 | Fungi | Fungi | 457 | 4.62e-124 | NTclustered | gi|2666947193|gb|PP232036.1| | 5365 | g91045 | i0 | 96.39 | 4.1913357400721996 | 277 | 10 | 100 | 0 | 1 | 277 | 91140 | 91416 | Lentinus tigrinus strain strain ALCF2SS1-6 mitochondrion, partial genome | blastn | 1161 | 457 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lentinus | Lentinus tigrinus | |
| 17974075 | 17974075 | PRJEB56027_P_NODE_120115_length_248_cov_0.880000_g117306_i0 | PRJEB56027 | 120115 | 248 | 0.88 | 2.1824 | Filobasidium floriforme | 5210 | Fungi | Fungi | 411 | 3.2099999999999995e-110 | NTclustered | gi|2185527529|ref|XM_046184124.1| | 5210 | g117306 | i0 | 97.5 | 0.967741935483871 | 240 | 6 | 97 | 0 | 9 | 248 | 1440 | 1201 | Filobasidium floriforme uncharacterized protein (HD553DRAFT_367411), partial mRNA | blastn | 240 | 411 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 20118507 | 20118507 | PRJEB56027_P_NODE_79316_length_303_cov_2.547826_g76507_i0 | PRJEB56027 | 79316 | 303 | 2.547826 | 7.71991278 | Malassezia | 55193 | Fungi | Fungi | 560 | 3.79e-155 | NTclustered | gi|915512619|gb|KP825402.1| | 76775 | g76507 | i0 | 100 | 97.3696369636964 | 303 | 0 | 100 | 0 | 1 | 303 | 9 | 311 | Malassezia restricta strain ISOSEB46F 28S ribosomal RNA gene, partial sequence | blastn | 29503 | 560 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20524920 | 20524920 | PRJEB56027_P_NODE_76537_length_310_cov_2.945148_g73728_i0 | PRJEB56027 | 76537 | 310 | 2.945148 | 9.1299588 | Malassezia restricta | 76775 | Fungi | Fungi | 278 | 4.39e-70 | NTclustered | gi|1546633100|ref|XM_027628210.1| | 76775 | g73728 | i0 | 100 | 1.51612903225806 | 150 | 0 | 48 | 0 | 1 | 150 | 1112 | 1261 | Malassezia restricta translation initiation factor 5 (MRET_1583), partial mRNA | blastn | 470 | 278 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 21799540 | 21799540 | PRJEB56027_P_NODE_133758_length_241_cov_0.916667_g130949_i0 | PRJEB56027 | 133758 | 241 | 0.916667 | 2.20916747 | Rhodotorula graminis | 29898 | Fungi | Fungi | 368 | 1.9e-97 | NTclustered | gi|1069929218|ref|XM_018417477.1| | 578459 | g130949 | i0 | 94.191 | 2.54771784232365 | 241 | 14 | 100 | 0 | 1 | 241 | 1529 | 1289 | Rhodotorula graminis WP1 uncharacterized protein (RHOBADRAFT_54742), partial mRNA | blastn | 614 | 368 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis |
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);;