contig_metadata
8 rows where bioproject = "PRJNA401346", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2964900 | 2964900 | PRJNA401346_P_NODE_1803_length_364_cov_2.475248_g1782_i0 | PRJNA401346 | 1803 | 364 | 2.475248 | 9.00990272 | Apiotrichum porosum | 105984 | Fungi | Fungi | 217 | 1.16e-51 | NTclustered | gi|1607527352|ref|XM_028624905.1| | 105984 | g1782 | i0 | 82.591 | 68.206043956044 | 247 | 41 | 68 | 2 | 79 | 324 | 1992 | 1747 | Apiotrichum porosum uncharacterized protein (EHS24_009635), partial mRNA | blastn | 24827 | 217 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Apiotrichum | Apiotrichum porosum | |
| 9342399 | 9342399 | PRJNA401346_P_NODE_3928_length_266_cov_1.468293_g3907_i0 | PRJNA401346 | 3928 | 266 | 1.468293 | 3.90565938 | Pseudozyma hubeiensis | 327079 | Fungi | Fungi | 235 | 2.25e-57 | NTclustered | gi|808367964|ref|XM_012333956.1| | 1305764 | g3907 | i0 | 83.019 | 92.1992481203008 | 265 | 40 | 99 | 3 | 2 | 265 | 489 | 229 | Pseudozyma hubeiensis SY62 40S ribosomal protein partial mRNA | blastn | 24525 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma hubeiensis | |
| 9342457 | 9342457 | PRJNA401346_P_NODE_6008_length_214_cov_1.098039_g5987_i0 | PRJNA401346 | 6008 | 214 | 1.098039 | 2.34980346 | Jaminaea rosea | 1569628 | Fungi | Fungi | 159 | 1.08e-34 | NTclustered | gi|1418883847|ref|XM_025504946.1| | 1569628 | g5987 | i0 | 81.865 | 0.901869158878505 | 193 | 32 | 89 | 1 | 1 | 190 | 714 | 522 | Jaminaea rosea hypothetical protein (BDZ90DRAFT_229169), mRNA | blastn | 193 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Microstromatales | Jaminaea | Jaminaea rosea | ||
| 15716892 | 15716892 | PRJNA401346_P_NODE_2593_length_313_cov_1.619048_g2572_i0 | PRJNA401346 | 2593 | 313 | 1.619048 | 5.06762024 | Cystobasidium minutum | 29899 | Fungi | Fungi | 75 | 6.25e-9 | NTclustered | gi|2781627581|ref|XM_066964619.1| | 1397322 | g2572 | i0 | 77.953 | 0.856230031948882 | 127 | 22 | 39 | 2 | 73 | 193 | 1040 | 914 | Cystobasidium minutum MCA 4210 60S ribosomal protein uL10 (P389DRAFT_163466), mRNA | blastn | 268 | 75 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 18265930 | 18265930 | PRJNA401346_P_NODE_6715_length_208_cov_0.870748_g6694_i0 | PRJNA401346 | 6715 | 208 | 0.870748 | 1.81115584 | Cryptococcus gattii | 37769 | Fungi | Fungi | 95.3 | 2.98e-15 | NTclustered | gi|321264104|ref|XM_003196722.1| | 367775 | g6694 | i0 | 87.654 | 1.46634615384615 | 81 | 10 | 39 | 0 | 17 | 97 | 427 | 507 | Cryptococcus gattii WM276 RAB small monomeric GTPase, putative (CGB_K3630W), partial mRNA | blastn | 305 | 95.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus gattii | |
| 28370245 | 28370245 | PRJNA401346_P_NODE_6846_length_207_cov_0.876712_g6825_i0 | PRJNA401346 | 6846 | 207 | 0.876712 | 1.81479384 | Trametes polyzona | 239206 | Fungi | Fungi | 48.9 | 1.55e-4 | NR | KAI0629374.1 | 239206 | g6825 | i0 | 41.9 | 1.7536231884058 | 62 | 36 | 89.9 | 0 | 190 | 5 | 810 | 871 | KAI0629374.1 ARM repeat-containing protein [Trametes polyzona] | diamond | 363 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes polyzona | |
| 28654489 | 28654489 | PRJNA401346_P_NODE_3087_length_293_cov_2.163793_g3066_i0 | PRJNA401346 | 3087 | 293 | 2.163793 | 6.33991349 | Auriculariales sp. MPI-PUGE-AT- | 1916346 | Fungi | Fungi | 55.1 | 3.14e-7 | NR | KAH7106003.1 | 2829486 | g3066 | i0 | 51.7 | 0.593856655290102 | 58 | 27 | 59.4 | 1 | 284 | 111 | 20 | 76 | KAH7106003.1 hypothetical protein BKA62DRAFT_826399 [Auriculariales sp. MPI-PUGE-AT-0066] | diamond | 174 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariales sp. MPI-PUGE-AT-0066 | |||
| 30233394 | 30233394 | PRJNA401346_P_NODE_6432_length_209_cov_0.864865_g6411_i0 | PRJNA401346 | 6432 | 209 | 0.864865 | 1.80756785 | Cantharellus anzutake | 1750568 | Fungi | Fungi | 74.7 | 4.13e-14 | NR | XP_038917079.1 | 1750568 | g6411 | i0 | 54.4 | 0.976076555023923 | 68 | 27 | 97.6 | 1 | 207 | 4 | 181 | 244 | XP_038917079.1 40S ribosomal protein S1 [Cantharellus anzutake] | diamond | 204 | 74.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Hydnaceae | Cantharellus | Cantharellus anzutake |
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);;