contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA635874" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 608203 | 608203 | PRJNA635874_P_NODE_69141_length_242_cov_0.911243_g68994_i0 | PRJNA635874 | 69141 | 242 | 0.911243 | 2.20520806 | Auricularia delicata | 160860 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|2258688609|ref|NC_064341.1| | 160860 | g68994 | i0 | 92.308 | 0.276859504132231 | 39 | 2 | 16 | 1 | 3 | 41 | 12663 | 12626 | Auricularia delicata mitochondrion, complete genome | blastn | 67 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariaceae | Auricularia | Auricularia delicata | |
| 1883552 | 1883552 | PRJNA635874_P_NODE_33862_length_288_cov_1.427907_g33715_i0 | PRJNA635874 | 33862 | 288 | 1.427907 | 4.11237216 | Malassezia restricta | 76775 | Fungi | Fungi | 532 | 7.8e-147 | NTclustered | gi|1546631193|ref|XM_027627257.1| | 76775 | g33715 | i0 | 100 | 3 | 288 | 0 | 100 | 0 | 1 | 288 | 917 | 630 | Malassezia restricta vacuolar protein sorting-associated protein 35 (MRET_0630), partial mRNA | blastn | 864 | 532 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3157715 | 3157715 | PRJNA635874_P_NODE_16023_length_384_cov_0.771704_g15876_i0 | PRJNA635874 | 16023 | 384 | 0.771704 | 2.96334336 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 167 | 1.25e-36 | NTclustered | gi|1423578398|ref|XM_025742461.1| | 58919 | g15876 | i0 | 78.244 | 55.2578125 | 262 | 55 | 68 | 2 | 13 | 273 | 337 | 77 | Tilletiopsis washingtonensis mitochondrial carrier (FA09DRAFT_330093), mRNA | blastn | 21219 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 3159028 | 3159028 | PRJNA635874_P_NODE_65483_length_244_cov_0.900585_g65336_i0 | PRJNA635874 | 65483 | 244 | 0.900585 | 2.1974274 | Malassezia restricta | 76775 | Fungi | Fungi | 451 | 1.86e-122 | NTclustered | gi|1546633702|ref|XM_027628511.1| | 76775 | g65336 | i0 | 100 | 1 | 244 | 0 | 100 | 0 | 1 | 244 | 966 | 1209 | Malassezia restricta WD repeat protein JIP5 (MRET_1884), partial mRNA | blastn | 244 | 451 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 5711526 | 5711526 | PRJNA635874_P_NODE_53665_length_248_cov_0.880000_g53518_i0 | PRJNA635874 | 53665 | 248 | 0.88 | 2.1824 | Dichomitus squalens | 114155 | Fungi | Fungi | 220 | 5.81e-53 | NTclustered | gi|597981882|ref|XM_007363560.1| | 732165 | g53518 | i0 | 90 | 3.87903225806452 | 170 | 17 | 69 | 0 | 79 | 248 | 366 | 197 | Dichomitus squalens LYAD-421 SS1 40S ribosomal protein S26 (DICSQDRAFT_54484), partial mRNA | blastn | 962 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Dichomitus | Dichomitus squalens | |
| 6986329 | 6986329 | PRJNA635874_P_NODE_51486_length_249_cov_0.875000_g51339_i0 | PRJNA635874 | 51486 | 249 | 0.875 | 2.17875 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 171 | 5.96e-38 | NTclustered | gi|1423564538|ref|XM_025740742.1| | 58919 | g51339 | i0 | 79.283 | 54.5983935742972 | 251 | 47 | 99 | 3 | 2 | 248 | 580 | 331 | Tilletiopsis washingtonensis beta subunit of ribonucleotide reductase (FA09DRAFT_313799), mRNA | blastn | 13595 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 6986432 | 6986432 | PRJNA635874_P_NODE_55626_length_248_cov_0.880000_g55479_i0 | PRJNA635874 | 55626 | 248 | 0.88 | 2.1824 | Malassezia restricta | 76775 | Fungi | Fungi | 145 | 3.6e-30 | NTclustered | gi|1546631824|ref|XM_027627572.1| | 76775 | g55479 | i0 | 97.619 | 0.57258064516129 | 84 | 2 | 34 | 0 | 165 | 248 | 1 | 84 | Malassezia restricta multidrug resistance protein, MATE family (MRET_0945), partial mRNA | blastn | 142 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6986810 | 6986810 | PRJNA635874_P_NODE_71786_length_241_cov_0.916667_g71639_i0 | PRJNA635874 | 71786 | 241 | 0.916667 | 2.20916747 | Malassezia globosa | 76773 | Fungi | Fungi | 429 | 8.58e-116 | NTclustered | gi|164659152|ref|XM_001730649.1| | 425265 | g71639 | i0 | 98.755 | 1 | 241 | 3 | 100 | 0 | 1 | 241 | 1664 | 1424 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2155), partial mRNA | blastn | 241 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 8260705 | 8260705 | PRJNA635874_P_NODE_39247_length_271_cov_1.545455_g39100_i0 | PRJNA635874 | 39247 | 271 | 1.545455 | 4.18818305 | Malassezia globosa | 76773 | Fungi | Fungi | 468 | 2.08e-127 | NTclustered | gi|164656378|ref|XM_001729265.1| | 425265 | g39100 | i0 | 97.786 | 1.88560885608856 | 271 | 6 | 100 | 0 | 1 | 271 | 922 | 1192 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_3352), partial mRNA | blastn | 511 | 468 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 9536600 | 9536600 | PRJNA635874_P_NODE_63628_length_244_cov_1.350877_g63481_i0 | PRJNA635874 | 63628 | 244 | 1.350877 | 3.29613988 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 137 | 5.91e-28 | NTclustered | gi|630965995|ref|XM_007881215.1| | 1277687 | g63481 | i0 | 79.592 | 32.405737704918 | 196 | 36 | 80 | 4 | 13 | 206 | 55 | 248 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_03696), partial mRNA | blastn | 7907 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 13908358 | 13908358 | PRJNA635874_P_NODE_31011_length_298_cov_2.066667_g30864_i0 | PRJNA635874 | 31011 | 298 | 2.066667 | 6.15866766 | Fungi | 4751 | Fungi | Fungi | 139 | 2.07e-28 | NTclustered | gi|1767309247|gb|MK457344.1| | 231939 | g30864 | i0 | 81.503 | 17.1140939597315 | 173 | 28 | 57 | 4 | 14 | 184 | 778 | 948 | Phanerochaete pseudomagnoliae clone UTP_PHA53383_c0_g1_i1 catalase mRNA, partial cds | blastn | 5100 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phanerochaete | Phanerochaete pseudomagnoliae | |
| 17732369 | 17732369 | PRJNA635874_P_NODE_36294_length_280_cov_1.487923_g36147_i0 | PRJNA635874 | 36294 | 280 | 1.487923 | 4.1661844 | Melampsora | 5260 | Fungi | Fungi | 518 | 2.12e-142 | NTclustered | gi|21702999|gb|AY123294.1| | 190605 | g36147 | i0 | 100 | 99.8857142857143 | 280 | 0 | 100 | 0 | 1 | 280 | 1091 | 812 | Melampsora euphorbiae isolate ECS48 18S ribosomal RNA gene, partial sequence | blastn | 27968 | 518 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora euphorbiae | |
| 19005649 | 19005649 | PRJNA635874_P_NODE_15995_length_384_cov_1.054662_g15848_i0 | PRJNA635874 | 15995 | 384 | 1.054662 | 4.04990208 | Fungi | 4751 | Fungi | Fungi | 237 | 9.43e-58 | NTclustered | gi|2234695355|ref|XM_047920327.1| | 34475 | g15848 | i0 | 80.696 | 73.7265625 | 316 | 51 | 81 | 10 | 72 | 382 | 73 | 383 | Fomitopsis rosea ribosomal protein S5, N-terminal domain-containing protein (C8Q71DRAFT_703616), partial mRNA | blastn | 28311 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Fomitopsidaceae | Rhodofomes | Rhodofomes roseus | |
| 19733623 | 19733623 | PRJNA635874_P_NODE_20436_length_350_cov_1.072202_g20289_i0 | PRJNA635874 | 20436 | 350 | 1.072202 | 3.752707 | Rhodotorula graminis | 29898 | Fungi | Fungi | 270 | 8.38e-68 | NTclustered | gi|1069924879|ref|XM_018414273.1| | 578459 | g20289 | i0 | 83.849 | 4.64857142857143 | 291 | 39 | 82 | 7 | 3 | 289 | 323 | 37 | Rhodotorula graminis WP1 uncharacterized protein (RHOBADRAFT_43715), partial mRNA | blastn | 1627 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 21010493 | 21010493 | PRJNA635874_P_NODE_63977_length_244_cov_0.900585_g63830_i0 | PRJNA635874 | 63977 | 244 | 0.900585 | 2.1974274 | Malassezia restricta | 76775 | Fungi | Fungi | 399 | 6.819999999999998e-107 | NTclustered | gi|1546636977|ref|XM_027630131.1| | 76775 | g63830 | i0 | 99.543 | 0.897540983606557 | 219 | 1 | 90 | 0 | 1 | 219 | 1261 | 1479 | Malassezia restricta uncharacterized protein (MRET_3504), partial mRNA | blastn | 219 | 399 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24106450 | 24106450 | PRJNA635874_P_NODE_40179_length_268_cov_1.579487_g40032_i0 | PRJNA635874 | 40179 | 268 | 1.579487 | 4.23302516 | Melampsora | 5260 | Fungi | Fungi | 496 | 9.429999999999999e-136 | NTclustered | gi|595389183|gb|KF780659.1| | 1470880 | g40032 | i0 | 100 | 99.9029850746269 | 268 | 0 | 100 | 0 | 1 | 268 | 299 | 566 | Melampsora sp. 960829 28S ribosomal RNA gene, partial sequence | blastn | 26774 | 496 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Melampsoraceae | Melampsora | Melampsora sp. 960829 |
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);;