contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA415636" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 419109 | 419109 | PRJNA415636_S_NODE_4161_length_245_cov_1.545455_g4114_i0 | PRJNA415636 | 4161 | 245 | 1.545455 | 3.78636475 | Pseudozyma flocculosa | 84751 | Fungi | Fungi | 84.2 | 7.84e-12 | NTclustered | gi|630964345|ref|XM_007880390.1| | 1277687 | g4114 | i0 | 84.524 | 0.342857142857143 | 84 | 13 | 34 | 0 | 27 | 110 | 217 | 300 | Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_02877), partial mRNA | blastn | 84 | 84.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 6796860 | 6796860 | PRJNA415636_S_NODE_4066_length_247_cov_2.295000_g4019_i0 | PRJNA415636 | 4066 | 247 | 2.295 | 5.66865 | Malassezia globosa | 76773 | Fungi | Fungi | 281 | 2.62e-71 | NTclustered | gi|164662814|ref|XM_001732477.1| | 425265 | g4019 | i0 | 98.137 | 2.02834008097166 | 161 | 3 | 65 | 0 | 87 | 247 | 411 | 251 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_0304), partial mRNA | blastn | 501 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 9347247 | 9347247 | PRJNA415636_S_NODE_5468_length_220_cov_0.919075_g5421_i0 | PRJNA415636 | 5468 | 220 | 0.919075 | 2.021965 | Malassezia restricta | 76775 | Fungi | Fungi | 390 | 3.629999999999999e-104 | NTclustered | gi|1546638449|ref|XM_027630866.1| | 76775 | g5421 | i0 | 98.636 | 1 | 220 | 3 | 100 | 0 | 1 | 220 | 1728 | 1947 | Malassezia restricta 25S rRNA (cytosine2870-C5)-methyltransferase (MRET_4239), partial mRNA | blastn | 220 | 390 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20820835 | 20820835 | PRJNA415636_S_NODE_5217_length_224_cov_2.016949_g5170_i0 | PRJNA415636 | 5217 | 224 | 2.016949 | 4.51796576 | Malassezia restricta | 76775 | Fungi | Fungi | 392 | 1.0299999999999999e-104 | NTclustered | gi|1546630665|ref|XM_027626993.1| | 76775 | g5170 | i0 | 98.214 | 1 | 224 | 4 | 100 | 0 | 1 | 224 | 1474 | 1697 | Malassezia restricta uncharacterized protein (MRET_0366), partial mRNA | blastn | 224 | 392 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24035019 | 24035019 | PRJNA415636_S_NODE_2159_length_315_cov_1.902985_g2112_i0 | PRJNA415636 | 2159 | 315 | 1.902985 | 5.99440275 | Ustilaginaceae | 5268 | Fungi | Fungi | 171 | 7.8e-38 | NTclustered | gi|758975134|ref|XM_011389320.1| | 5270 | g2112 | i0 | 88.732 | 11.2666666666667 | 142 | 12 | 44 | 3 | 4 | 143 | 305 | 444 | Mycosarcoma maydis 60S ribosomal protein eL19 (UMAG_01634), partial mRNA | blastn | 3549 | 172 | 0.994186046511628 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Mycosarcoma | Mycosarcoma maydis | |
| 24645524 | 24645524 | PRJNA415636_S_NODE_6040_length_211_cov_1.628049_g5993_i0 | PRJNA415636 | 6040 | 211 | 1.628049 | 3.43518339 | Malassezia restricta | 76775 | Fungi | Fungi | 390 | 3.459999999999999e-104 | NTclustered | gi|1546633326|ref|XM_027628323.1| | 76775 | g5993 | i0 | 100 | 1 | 211 | 0 | 100 | 0 | 1 | 211 | 1213 | 1003 | Malassezia restricta beta-1,4-mannosyltransferase (MRET_1696), partial mRNA | blastn | 211 | 390 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 25309418 | 25309418 | PRJNA415636_S_NODE_2300_length_307_cov_2.211538_g2253_i0 | PRJNA415636 | 2300 | 307 | 2.211538 | 6.78942166 | Malassezia | 55193 | Fungi | Fungi | 556 | 4.98e-154 | NTclustered | gi|1321659599|gb|KY911093.1| | 76775 | g2253 | i0 | 99.351 | 43.1302931596091 | 308 | 0 | 100 | 2 | 1 | 307 | 382 | 688 | Malassezia restricta mitochondrion, complete genome | blastn | 13241 | 556 | 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);;