contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA562549" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 545638 | 545638 | PRJNA562549_P_NODE_16301_length_286_cov_1.462222_g16068_i0 | PRJNA562549 | 16301 | 286 | 1.462222 | 4.18195492 | Wallemia mellicola | 1708541 | Fungi | Fungi | 143 | 1.52e-29 | NTclustered | gi|588258154|ref|XM_006958176.1| | 671144 | g16068 | i0 | 81.356 | 2.82517482517482 | 177 | 31 | 62 | 2 | 74 | 249 | 569 | 394 | Wallemia mellicola CBS 633.66 ribosomal protein L1 partial mRNA | blastn | 808 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia mellicola | |
| 545696 | 545696 | PRJNA562549_P_NODE_23261_length_243_cov_1.043956_g23028_i0 | PRJNA562549 | 23261 | 243 | 1.043956 | 2.53681308 | Kwoniella pini | 453459 | Fungi | Fungi | 62.1 | 3.64e-5 | NTclustered | gi|2866166778|ref|XM_070203597.1| | 1296096 | g23028 | i0 | 97.222 | 0.148148148148148 | 36 | 1 | 15 | 0 | 81 | 116 | 378 | 343 | Kwoniella pini CBS 10737 uncharacterized protein (I206_107798), partial mRNA | blastn | 36 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella pini | |
| 4373259 | 4373259 | PRJNA562549_P_NODE_32744_length_209_cov_0.878378_g32511_i0 | PRJNA562549 | 32744 | 209 | 0.878378 | 1.83581002 | Pleurotus ostreatus | 5322 | Fungi | Fungi | 75 | 3.91e-9 | NTclustered | gi|1919706236|ref|XM_036774375.1| | 5322 | g32511 | i0 | 89.655 | 0.674641148325359 | 58 | 6 | 28 | 0 | 86 | 143 | 46 | 103 | Pleurotus ostreatus uncharacterized protein (PC9H_004793), partial mRNA | blastn | 141 | 75 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus ostreatus | |
| 4958841 | 4958841 | PRJNA562549_P_NODE_11784_length_334_cov_1.095238_g11551_i0 | PRJNA562549 | 11784 | 334 | 1.095238 | 3.65809492 | Malassezia | 55193 | Fungi | Fungi | 579 | 1.1699999999999997e-160 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g11551 | i0 | 97.91 | 98.7544910179641 | 335 | 6 | 100 | 1 | 1 | 334 | 352 | 18 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 32984 | 579 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 13299915 | 13299915 | PRJNA562549_P_NODE_36351_length_202_cov_1.340426_g36118_i0 | PRJNA562549 | 36351 | 202 | 1.340426 | 2.70766052 | Meira miltonrushii | 1280837 | Fungi | Fungi | 196 | 7.68e-46 | NTclustered | gi|1418873652|ref|XM_025499258.1| | 1280837 | g36118 | i0 | 84.236 | 106.722772277228 | 203 | 30 | 100 | 2 | 1 | 202 | 957 | 1158 | Meira miltonrushii Actin/actin-like protein (FA14DRAFT_161729), mRNA | blastn | 21558 | 196 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 13884729 | 13884729 | PRJNA562549_P_NODE_30331_length_214_cov_2.562092_g30098_i0 | PRJNA562549 | 30331 | 214 | 2.562092 | 5.48287688 | Microbotryomycetes | 162481 | Fungi | Fungi | 396 | 7.559999999999996e-106 | NTclustered | gi|8096248|dbj|AB021693.1| | 5004 | g30098 | i0 | 100 | 100.046728971963 | 214 | 0 | 100 | 0 | 1 | 214 | 279 | 66 | Sporidiobolus ruineniae gene for 18S ribosomal RNA, partial sequence | blastn | 21410 | 396 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodosporidiobolus | Rhodosporidiobolus ruineniae | |
| 15158828 | 15158828 | PRJNA562549_P_NODE_18592_length_269_cov_1.528846_g18359_i0 | PRJNA562549 | 18592 | 269 | 1.528846 | 4.11259574 | Cryptococcus | 5206 | Fungi | Fungi | 213 | 1.07e-50 | NTclustered | gi|1102233851|ref|XM_019178392.1| | 1295528 | g18359 | i0 | 82.143 | 53.1524163568773 | 252 | 41 | 93 | 4 | 16 | 265 | 719 | 968 | Tsuchiyaea wingfieldii CBS 7118 S-adenosylmethionine synthase (L198_06326), partial mRNA | blastn | 14298 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus wingfieldii | |
| 15848684 | 15848684 | PRJNA562549_P_NODE_34833_length_205_cov_0.902778_g34600_i0 | PRJNA562549 | 34833 | 205 | 0.902778 | 1.8506949 | Kwoniella botswanensis | 1268659 | Fungi | Fungi | 143 | 1.03e-29 | NTclustered | gi|2725054073|ref|XM_064893418.1| | 1268659 | g34600 | i0 | 79.327 | 10.2243902439024 | 208 | 40 | 100 | 2 | 1 | 205 | 979 | 1186 | Kwoniella botswanensis transitional endoplasmic reticulum ATPase (L199_007732), partial mRNA | blastn | 2096 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella botswanensis | |
| 17123535 | 17123535 | PRJNA562549_P_NODE_37794_length_192_cov_3.580153_g37561_i0 | PRJNA562549 | 37794 | 192 | 3.580153 | 6.87389376 | Kwoniella shivajii | 564305 | Fungi | Fungi | 76.8 | 9.81e-10 | NTclustered | gi|2670908263|ref|XM_062933113.1| | 564305 | g37561 | i0 | 92.453 | 1.50520833333333 | 53 | 4 | 28 | 0 | 24 | 76 | 137 | 85 | Kwoniella shivajii uncharacterized protein (IL334_001356), partial mRNA | blastn | 289 | 76.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shivajii | |
| 23498174 | 23498174 | PRJNA562549_P_NODE_33319_length_208_cov_0.884354_g33086_i0 | PRJNA562549 | 33319 | 208 | 0.884354 | 1.83945632 | Malassezia restricta | 76775 | Fungi | Fungi | 296 | 7.62e-76 | NTclustered | gi|1546637923|ref|XM_027630603.1| | 76775 | g33086 | i0 | 99.387 | 0.783653846153846 | 163 | 1 | 78 | 0 | 1 | 163 | 163 | 1 | Malassezia restricta GRAM domain protein (MRET_3976), partial mRNA | blastn | 163 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;