contig_metadata
8 rows where bioproject = "PRJEB75227", tax_kingdom = "Fungi" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27381976 | 27381976 | PRJEB75227_P_NODE_3943_length_360_cov_1.641115_g3772_i0 | PRJEB75227 | 3943 | 360 | 1.641115 | 5.908014 | Rhizoclosmatium globosum | 329046 | Fungi | Fungi | 44.7 | 0.0172 | NR | ORY45546.1 | 329046 | g3772 | i0 | 45 | 0.5 | 60 | 26 | 44.2 | 2 | 321 | 163 | 94 | 153 | ORY45546.1 glucocorticoid receptor-like (DNA-binding domain) [Rhizoclosmatium globosum] | diamond | 180 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Rhizoclosmatium | Rhizoclosmatium globosum | |
| 27571285 | 27571285 | PRJEB75227_P_NODE_1644_length_613_cov_1.507407_g1473_i0 | PRJEB75227 | 1644 | 613 | 1.507407 | 9.24040491 | Spizellomyces sp. 'palustris' | 117820 | Fungi | Fungi | 109 | 8.35e-24 | NR | TPX72646.1 | 117820 | g1473 | i0 | 34.5 | 2.16802610114192 | 229 | 113 | 94.9 | 6 | 611 | 30 | 318 | 544 | TPX72646.1 hypothetical protein SpCBS45565_g00404 [Spizellomyces sp. 'palustris'] | diamond | 1329 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces sp. 'palustris' | |
| 28234104 | 28234104 | PRJEB75227_P_NODE_4186_length_348_cov_1.134545_g4015_i0 | PRJEB75227 | 4186 | 348 | 1.134545 | 3.9482166 | Irineochytrium annulatum | 109884 | Fungi | Fungi | 66.6 | 5.45e-10 | NR | KAJ3167489.1 | 109884 | g4015 | i0 | 46.7 | 0.793103448275862 | 92 | 43 | 78.4 | 3 | 317 | 45 | 21 | 107 | KAJ3167489.1 hypothetical protein HK101_011768 [Irineochytrium annulatum] | diamond | 276 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Irineochytrium | Irineochytrium annulatum | |
| 28732370 | 28732370 | PRJEB75227_P_NODE_11607_length_242_cov_1.384615_g11436_i0 | PRJEB75227 | 11607 | 242 | 1.384615 | 3.3507683 | Geranomyces | 1126249 | Fungi | Fungi | 53.5 | 5.55e-6 | NR | KAJ3150941.1 | 109894 | g11436 | i0 | 39.4 | 6.64462809917355 | 66 | 40 | 81.8 | 0 | 3 | 200 | 279 | 344 | KAJ3150941.1 hypothetical protein HDU89_002939 [Geranomyces variabilis] | diamond | 1608 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 29497320 | 29497320 | PRJEB75227_P_NODE_2450_length_482_cov_1.273839_g2279_i0 | PRJEB75227 | 2450 | 482 | 1.273839 | 6.13990398 | Chytriomyces hyalinus | 4814 | Fungi | Fungi | 60.5 | 3.03e-7 | NR | KAJ3249272.1 | 4814 | g2279 | i0 | 27.5 | 1.13278008298755 | 182 | 106 | 98.3 | 6 | 479 | 6 | 470 | 649 | KAJ3249272.1 hypothetical protein HDU78_005412 [Chytriomyces hyalinus] | diamond | 546 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 30160345 | 30160345 | PRJEB75227_P_NODE_4072_length_354_cov_0.928826_g3901_i0 | PRJEB75227 | 4072 | 354 | 0.928826 | 3.28804404 | Entophlyctis luteolus | 109932 | Fungi | Fungi | 104 | 2.0199999999999994e-23 | NR | KAJ3195072.1 | 109932 | g3901 | i0 | 48.5 | 3.11864406779661 | 97 | 49 | 81.4 | 1 | 290 | 3 | 31 | 127 | KAJ3195072.1 hypothetical protein HDU82_002239, partial [Entophlyctis luteolus] | diamond | 1104 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis luteolus | |
| 32215582 | 32215582 | PRJEB75227_P_NODE_7038_length_271_cov_1.515152_g6867_i0 | PRJEB75227 | 7038 | 271 | 1.515152 | 4.10606192 | Neocallimastix lanati (nom. inval.) | 2767002 | Fungi | Fungi | 77.4 | 2.22e-14 | NR | KAG4095430.1 | 2767002 | g6867 | i0 | 48.7 | 0.863468634686347 | 78 | 40 | 86.3 | 0 | 240 | 7 | 133 | 210 | KAG4095430.1 TPR-like protein [Neocallimastix lanati (nom. inval.)] | diamond | 234 | 77.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix lanati (nom. inval.) | |
| 32429829 | 32429829 | PRJEB75227_P_NODE_6919_length_273_cov_1.550000_g6748_i0 | PRJEB75227 | 6919 | 273 | 1.55 | 4.2315 | Chytridiomycetes | 451435 | Fungi | Fungi | 85.9 | 3.35e-17 | NR | KAI9099326.1 | 1117335 | g6748 | i0 | 51.5 | 6.45054945054945 | 66 | 32 | 72.5 | 0 | 74 | 271 | 7 | 72 | KAI9099326.1 acyl-CoA dehydrogenase/oxidase [Phlyctochytrium arcticum] | diamond | 1761 | 86.3 | 0.995365005793743 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Phlyctochytrium | Phlyctochytrium arcticum |
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);;