contig_metadata
7 rows where bioproject = "PRJNA278119", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5474485 | 5474485 | PRJNA278119_P_NODE_16265_length_263_cov_0.971963_g16016_i0 | PRJNA278119 | 16265 | 263 | 0.971963 | 2.55626269 | Fungi | 4751 | Fungi | Fungi | 120 | 4.989999999999999e-31 | NR | KAI9140511.1 | 1500003 | g16016 | i0 | 71.4 | 3.44486692015209 | 77 | 22 | 87.8 | 0 | 233 | 3 | 2 | 78 | KAI9140511.1 WD40-repeat-containing domain protein [Paraphysoderma sedebokerense] | diamond | 906 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 11850139 | 11850139 | PRJNA278119_P_NODE_4750_length_551_cov_5.503984_g4506_i0 | PRJNA278119 | 4750 | 551 | 5.503984 | 30.32695184 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 292 | 1.2399999999999996e-96 | NR | KNE67055.1 | 578462 | g4506 | i0 | 84.5 | 2.8529945553539 | 174 | 27 | 94.7 | 0 | 29 | 550 | 8 | 181 | KNE67055.1 mitochondrial substrate carrier family protein ancA [Allomyces macrogynus ATCC 38327] | diamond | 1572 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 27849712 | 27849712 | PRJNA278119_P_NODE_31824_length_176_cov_1.228346_g31575_i0 | PRJNA278119 | 31824 | 176 | 1.228346 | 2.16188896 | root | 1 | Root_unresolved | Root_unresolved | 54.3 | 1.23e-6 | NR | KAI9141380.1 | 1500003 | g31575 | i0 | 52.4 | 1.92613636363636 | 42 | 20 | 71.6 | 0 | 13 | 138 | 226 | 267 | KAI9141380.1 hypothetical protein BKA69DRAFT_1038505 [Paraphysoderma sedebokerense] | diamond | 339 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29049823 | 29049823 | PRJNA278119_P_NODE_29308_length_183_cov_1.164179_g29059_i0 | PRJNA278119 | 29308 | 183 | 1.164179 | 2.13044757 | Opisthokonta | 33154 | Fungi | Fungi | 65.9 | 1.3e-11 | NR | KAI9216354.1 | 64508 | g29059 | i0 | 65.9 | 6.95081967213115 | 44 | 15 | 72.1 | 0 | 48 | 179 | 4 | 47 | KAI9216354.1 ribosomal protein L34e-domain-containing protein [Blastocladiella britannica] | diamond | 1272 | 66.2 | 0.995468277945619 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 29537147 | 29537147 | PRJNA278119_P_NODE_28110_length_187_cov_1.043478_g27861_i0 | PRJNA278119 | 28110 | 187 | 1.043478 | 1.95130386 | Blastocladiella britannica | 64508 | Fungi | Fungi | 65.1 | 1.77e-11 | NR | KAI9221742.1 | 64508 | g27861 | i0 | 65.1 | 0.689839572192513 | 43 | 15 | 69 | 0 | 182 | 54 | 60 | 102 | KAI9221742.1 profilin [Blastocladiella britannica] | diamond | 129 | 65.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 32129073 | 32129073 | PRJNA278119_P_NODE_30498_length_179_cov_1.600000_g30249_i0 | PRJNA278119 | 30498 | 179 | 1.6 | 2.864 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 65.9 | 1.1e-10 | NR | ORZ41168.1 | 765915 | g30249 | i0 | 69.8 | 1.4413407821229 | 43 | 13 | 72.1 | 0 | 50 | 178 | 9 | 51 | ORZ41168.1 peptidase M24, structural domain-containing protein [Catenaria anguillulae PL171] | diamond | 258 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 32778223 | 32778223 | PRJNA278119_P_NODE_31220_length_177_cov_1.835938_g30971_i0 | PRJNA278119 | 31220 | 177 | 1.835938 | 3.24961026 | Opisthokonta | 33154 | Fungi | Fungi | 70.1 | 9.37e-14 | NR | KNE66705.1 | 578462 | g30971 | i0 | 72.5 | 3.47457627118644 | 51 | 14 | 86.4 | 0 | 159 | 7 | 1 | 51 | KNE66705.1 60S acidic ribosomal protein P2 [Allomyces macrogynus ATCC 38327] | diamond | 615 | 70.5 | 0.994326241134752 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus |
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);;