contig_metadata
13 rows where bioproject = "PRJNA506002", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3035286 | 3035286 | PRJNA506002_S_NODE_67623_length_229_cov_4.012821_g67377_i0 | PRJNA506002 | 67623 | 229 | 4.012821 | 9.18936009 | Suillus luteus | 5384 | Fungi | Fungi | 58.4 | 4.39e-4 | NTclustered | gi|998623171|emb|LN999935.1| | 5384 | g67377 | i0 | 97.143 | 0.655021834061135 | 35 | 0 | 15 | 1 | 188 | 222 | 34 | 1 | Suillus luteus mRNA for Isocitrate lyase (ICL gene), isolate sp9 | blastn | 150 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Suillaceae | Suillus | Suillus luteus | |
| 4310931 | 4310931 | PRJNA506002_S_NODE_44464_length_272_cov_2.376884_g44218_i0 | PRJNA506002 | 44464 | 272 | 2.376884 | 6.46512448 | Malassezia restricta | 76775 | Fungi | Fungi | 425 | 1.28e-114 | NTclustered | gi|1546638515|ref|XM_027630899.1| | 76775 | g44218 | i0 | 100 | 0.845588235294118 | 230 | 0 | 85 | 0 | 35 | 264 | 630 | 401 | Malassezia restricta large subunit ribosomal protein L13e (MRET_4272), partial mRNA | blastn | 230 | 425 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 5587794 | 5587794 | PRJNA506002_S_NODE_51025_length_259_cov_2.795699_g50779_i0 | PRJNA506002 | 51025 | 259 | 2.795699 | 7.24086041 | Malassezia restricta | 76775 | Fungi | Fungi | 464 | 2.5599999999999998e-126 | NTclustered | gi|1546631674|ref|XM_027627497.1| | 76775 | g50779 | i0 | 100 | 1.89189189189189 | 251 | 0 | 97 | 0 | 1 | 251 | 767 | 517 | Malassezia restricta large subunit ribosomal protein L15 (MRET_0870), partial mRNA | blastn | 490 | 464 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6214025 | 6214025 | PRJNA506002_S_NODE_38485_length_285_cov_4.924528_g38239_i0 | PRJNA506002 | 38485 | 285 | 4.924528 | 14.0349048 | Phenoliferia sp. Uapishka_3 | 3038894 | Fungi | Fungi | 59.3 | 8.72e-8 | NR | KAK4705419.1 | 3038894 | g38239 | i0 | 55.1 | 0.515789473684211 | 49 | 21 | 51.6 | 1 | 33 | 179 | 121 | 168 | KAK4705419.1 hypothetical protein P7C70_g780, partial [Phenoliferia sp. Uapishka_3] | diamond | 147 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Kriegeriales | Kriegeriaceae | Phenoliferia | Phenoliferia sp. Uapishka_3 | |
| 9411897 | 9411897 | PRJNA506002_S_NODE_21148_length_340_cov_1.333333_g20902_i0 | PRJNA506002 | 21148 | 340 | 1.333333 | 4.5333322 | Malassezia restricta | 76775 | Fungi | Fungi | 501 | 2.649999999999999e-137 | NTclustered | gi|1546637503|ref|XM_027630394.1| | 76775 | g20902 | i0 | 99.635 | 2.45294117647059 | 274 | 1 | 81 | 0 | 9 | 282 | 6 | 279 | Malassezia restricta uncharacterized protein (MRET_3767), partial mRNA | blastn | 834 | 501 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10687745 | 10687745 | PRJNA506002_S_NODE_41249_length_279_cov_2.422330_g41003_i0 | PRJNA506002 | 41249 | 279 | 2.42233 | 6.7583007 | Malassezia restricta | 76775 | Fungi | Fungi | 459 | 1.3000000000000002e-124 | NTclustered | gi|1546637217|ref|XM_027630251.1| | 76775 | g41003 | i0 | 98.099 | 0.942652329749104 | 263 | 5 | 94 | 0 | 9 | 271 | 560 | 822 | Malassezia restricta RNA recognition motif domain protein (MRET_3624), partial mRNA | blastn | 263 | 459 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 15786422 | 15786422 | PRJNA506002_S_NODE_12993_length_385_cov_2.958333_g12747_i0 | PRJNA506002 | 12993 | 385 | 2.958333 | 11.38958205 | Malassezia restricta | 76775 | Fungi | Fungi | 444 | 5.1899999999999996e-120 | NTclustered | gi|1546632402|ref|XM_027627861.1| | 76775 | g12747 | i0 | 99.187 | 47.5558441558442 | 246 | 2 | 64 | 0 | 8 | 253 | 1138 | 1383 | Malassezia restricta elongation factor 1-alpha (MRET_1234), partial mRNA | blastn | 18309 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17061321 | 17061321 | PRJNA506002_S_NODE_43594_length_274_cov_1.781095_g43348_i0 | PRJNA506002 | 43594 | 274 | 1.781095 | 4.8802003 | Malassezia restricta | 76775 | Fungi | Fungi | 106 | 1.9e-18 | NTclustered | gi|1546630263|ref|XM_027626792.1| | 76775 | g43348 | i0 | 100 | 0.208029197080292 | 57 | 0 | 21 | 0 | 8 | 64 | 586 | 642 | Malassezia restricta uncharacterized protein (MRET_0165), partial mRNA | blastn | 57 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20885851 | 20885851 | PRJNA506002_S_NODE_19417_length_348_cov_1.621818_g19171_i0 | PRJNA506002 | 19417 | 348 | 1.621818 | 5.64392664 | Malassezia globosa | 76773 | Fungi | Fungi | 625 | 1.5499999999999995e-174 | NTclustered | gi|164658472|ref|XM_001730310.1| | 425265 | g19171 | i0 | 99.707 | 0.979885057471264 | 341 | 1 | 98 | 0 | 1 | 341 | 105 | 445 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2744), partial mRNA | blastn | 341 | 625 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 24709851 | 24709851 | PRJNA506002_S_NODE_30660_length_306_cov_1.648069_g30414_i0 | PRJNA506002 | 30660 | 306 | 1.648069 | 5.04309114 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 179 | 4.6099999999999996e-54 | NR | XP_017990928.1 | 77020 | g30414 | i0 | 87.9 | 4.85294117647059 | 99 | 12 | 97.1 | 0 | 8 | 304 | 172 | 270 | XP_017990928.1 proteasome endopeptidase complex beta subunit [Malassezia pachydermatis] | diamond | 1485 | 179 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 27819272 | 27819272 | PRJNA506002_S_NODE_26244_length_320_cov_1.157895_g25998_i0 | PRJNA506002 | 26244 | 320 | 1.157895 | 3.705264 | Kwoniella | 490731 | Fungi | Fungi | 47.8 | 0.00157 | NR | XP_031862267.1 | 1734106 | g25998 | i0 | 51.2 | 1.425 | 43 | 18 | 37.5 | 1 | 2 | 121 | 584 | 626 | XP_031862267.1 uncharacterized protein CI109_105511 [Kwoniella shandongensis] | diamond | 456 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella shandongensis | |
| 28940496 | 28940496 | PRJNA506002_S_NODE_29808_length_308_cov_3.719149_g29562_i0 | PRJNA506002 | 29808 | 308 | 3.719149 | 11.45497892 | Rhodotorula toruloides | 5286 | Fungi | Fungi | 49.7 | 3.05e-4 | NR | KAJ8294897.1 | 5286 | g29562 | i0 | 38.4 | 0.711038961038961 | 73 | 43 | 71.1 | 1 | 226 | 8 | 65 | 135 | KAJ8294897.1 Serine/threonine-protein kinase SCH9 [Rhodotorula toruloides] | diamond | 219 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 30661243 | 30661243 | PRJNA506002_S_NODE_45633_length_270_cov_1.172589_g45387_i0 | PRJNA506002 | 45633 | 270 | 1.172589 | 3.1659903 | root | 1 | Root_unresolved | Root_unresolved | 51.2 | 2.59e-5 | NR | GJN94735.1 | 86838 | g45387 | i0 | 65.7 | 3.12222222222222 | 35 | 12 | 38.9 | 0 | 2 | 106 | 153 | 187 | GJN94735.1 hypothetical protein Rhopal_007826-T1 [Rhodotorula paludigena] | diamond | 843 | 51.6 | 0.992248062015504 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula paludigena |
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);;