contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA596870" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1844125 | 1844125 | PRJNA596870_P_NODE_32762_length_248_cov_0.880000_g32629_i0 | PRJNA596870 | 32762 | 248 | 0.88 | 2.1824 | Kwoniella heveanensis | 89924 | Fungi | Fungi | 52.8 | 0.022 | NTclustered | gi|2678472070|gb|CP144514.1| | 1296119 | g32629 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 117 | 144 | 12523288 | 12523261 | Kwoniella heveanensis CBS 569 chromosome 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella heveanensis | |
| 3119346 | 3119346 | PRJNA596870_P_NODE_24223_length_275_cov_1.524752_g24090_i0 | PRJNA596870 | 24223 | 275 | 1.524752 | 4.193068 | Malassezia restricta | 76775 | Fungi | Fungi | 470 | 5.89e-128 | NTclustered | gi|1546631071|ref|XM_027627196.1| | 76775 | g24090 | i0 | 97.455 | 1 | 275 | 7 | 100 | 0 | 1 | 275 | 640 | 914 | Malassezia restricta small subunit ribosomal protein S9 (MRET_0569), partial mRNA | blastn | 275 | 470 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6244193 | 6244193 | PRJNA596870_P_NODE_6605_length_477_cov_1.168317_g6472_i0 | PRJNA596870 | 6605 | 477 | 1.168317 | 5.57287209 | Basidiomycota | 5204 | Fungi | Fungi | 52.8 | 0.046 | NTclustered | gi|2436889723|ref|XM_053160902.1| | 208348 | g6472 | i0 | 100 | 0.117400419287212 | 28 | 0 | 6 | 0 | 3 | 30 | 549 | 576 | Puccinia triticina uncharacterized protein (PtA15_10A69), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia triticina | |
| 6946655 | 6946655 | PRJNA596870_P_NODE_27486_length_258_cov_1.664865_g27353_i0 | PRJNA596870 | 27486 | 258 | 1.664865 | 4.2953517 | Malassezia restricta | 76775 | Fungi | Fungi | 477 | 3.2699999999999985e-130 | NTclustered | gi|1546638213|ref|XM_027630748.1| | 76775 | g27353 | i0 | 100 | 1 | 258 | 0 | 100 | 0 | 1 | 258 | 1079 | 822 | Malassezia restricta type II protein arginine methyltransferase (MRET_4121), partial mRNA | blastn | 258 | 477 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 9496628 | 9496628 | PRJNA596870_P_NODE_17788_length_314_cov_1.535270_g17655_i0 | PRJNA596870 | 17788 | 314 | 1.53527 | 4.8207478 | Kwoniella newhampshirensis | 1651941 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2781603244|ref|XM_066944995.1| | 1651941 | g17655 | i0 | 96.97 | 1.17515923566879 | 33 | 1 | 11 | 0 | 272 | 304 | 2891 | 2923 | Kwoniella newhampshirensis uncharacterized protein (IAR55_001872), partial mRNA | blastn | 369 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella newhampshirensis | |
| 9496894 | 9496894 | PRJNA596870_P_NODE_31668_length_249_cov_0.875000_g31535_i0 | PRJNA596870 | 31668 | 249 | 0.875 | 2.17875 | Malassezia restricta | 76775 | Fungi | Fungi | 460 | 3.16e-125 | NTclustered | gi|1546633512|ref|XM_027628416.1| | 76775 | g31535 | i0 | 100 | 1 | 249 | 0 | 100 | 0 | 1 | 249 | 160 | 408 | Malassezia restricta uncharacterized protein (MRET_1789), partial mRNA | blastn | 249 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10772377 | 10772377 | PRJNA596870_P_NODE_10409_length_392_cov_1.567398_g10276_i0 | PRJNA596870 | 10409 | 392 | 1.567398 | 6.14420016 | Cystobasidium minutum | 29899 | Fungi | Fungi | 237 | 9.64e-58 | NTclustered | gi|2781608710|ref|XM_066965482.1| | 1397322 | g10276 | i0 | 82.955 | 55.4438775510204 | 264 | 43 | 67 | 2 | 50 | 312 | 425 | 163 | Cystobasidium minutum MCA 4210 heat shock protein 70 (P389DRAFT_170372), mRNA | blastn | 21734 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 10772680 | 10772680 | PRJNA596870_P_NODE_25629_length_268_cov_1.579487_g25496_i0 | PRJNA596870 | 25629 | 268 | 1.579487 | 4.23302516 | Malassezia restricta | 76775 | Fungi | Fungi | 178 | 3.88e-40 | NTclustered | gi|1546632654|ref|XM_027627987.1| | 76775 | g25496 | i0 | 100 | 0.645522388059702 | 96 | 0 | 36 | 0 | 173 | 268 | 1 | 96 | Malassezia restricta cell cycle checkpoint protein (MRET_1360), partial mRNA | blastn | 173 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 12047737 | 12047737 | PRJNA596870_P_NODE_37330_length_243_cov_2.700000_g37197_i0 | PRJNA596870 | 37330 | 243 | 2.7 | 6.561 | Melampsora laricis-populina | 203908 | Fungi | Fungi | 187 | 5.7499999999999985e-43 | NTclustered | gi|599419710|ref|XM_007416118.1| | 747676 | g37197 | i0 | 81.092 | 0.979423868312757 | 238 | 41 | 97 | 3 | 3 | 238 | 725 | 490 | Melampsora larici-populina 98AG31 uncharacterized protein (MELLADRAFT_93205), partial mRNA | blastn | 238 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora laricis-populina | |
| 13322336 | 13322336 | PRJNA596870_P_NODE_27111_length_260_cov_1.647059_g26978_i0 | PRJNA596870 | 27111 | 260 | 1.647059 | 4.2823534 | Malassezia globosa | 76773 | Fungi | Fungi | 470 | 5.519999999999998e-128 | NTclustered | gi|164658472|ref|XM_001730310.1| | 425265 | g26978 | i0 | 99.231 | 1 | 260 | 2 | 100 | 0 | 1 | 260 | 552 | 293 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2744), partial mRNA | blastn | 260 | 470 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 20970714 | 20970714 | PRJNA596870_P_NODE_30597_length_250_cov_0.870056_g30464_i0 | PRJNA596870 | 30597 | 250 | 0.870056 | 2.17514 | Desarmillaria tabescens | 1929756 | Fungi | Fungi | 52.8 | 0.023 | NTclustered | gi|2607614582|ref|XM_060483979.1| | 1929756 | g30464 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 217 | 244 | 3017 | 3044 | Desarmillaria tabescens SNF2 family N-terminal domain-containing protein (EV420DRAFT_915806), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Desarmillaria | Desarmillaria tabescens | |
| 22245252 | 22245252 | PRJNA596870_P_NODE_12378_length_365_cov_1.051370_g12245_i0 | PRJNA596870 | 12378 | 365 | 1.05137 | 3.8375005 | Pseudozyma hubeiensis | 327079 | Fungi | Fungi | 241 | 6.89e-59 | NTclustered | gi|808377227|ref|XM_012337993.1| | 1305764 | g12245 | i0 | 87.864 | 15.7369863013699 | 206 | 23 | 56 | 2 | 61 | 265 | 464 | 260 | Pseudozyma hubeiensis SY62 hypothetical protein partial mRNA | blastn | 5744 | 241 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma hubeiensis | |
| 23520780 | 23520780 | PRJNA596870_P_NODE_28179_length_255_cov_1.269231_g28046_i0 | PRJNA596870 | 28179 | 255 | 1.269231 | 3.23653905 | Ustilago aff. syntherismae | 2031075 | Fungi | Fungi | 259 | 1.27e-64 | NTclustered | gi|1240175428|gb|KY930199.1| | 2031075 | g28046 | i0 | 85.772 | 96.6549019607843 | 246 | 34 | 96 | 1 | 8 | 253 | 113 | 357 | Ustilago aff. syntherismae voucher GLM-F107436 F1F0-ATPase complex F1 beta subunit (atp2) gene, partial cds | blastn | 24647 | 259 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Ustilago | Ustilago aff. syntherismae | |
| 24092456 | 24092456 | PRJNA596870_P_NODE_22519_length_284_cov_1.383886_g22386_i0 | PRJNA596870 | 22519 | 284 | 1.383886 | 3.93023624 | Ustilaginaceae | 5268 | Fungi | Fungi | 243 | 1.45e-59 | NTclustered | gi|955498604|ref|XM_014803304.1| | 84753 | g22386 | i0 | 82.168 | 61.0704225352113 | 286 | 47 | 100 | 4 | 1 | 284 | 1077 | 1360 | Moesziomyces antarcticus valosin-containing protein (PAN0_002d1137), partial mRNA | blastn | 17344 | 243 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Moesziomyces | Moesziomyces antarcticus |
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);;