contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA1061474" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5281358 | 5281358 | PRJNA1061474_P_NODE_39365_length_283_cov_1.428571_g39119_i0 | PRJNA1061474 | 39365 | 283 | 1.428571 | 4.04285593 | Chytriomycetaceae | 1352827 | Fungi | Fungi | 134 | 4.7e-34 | NR | KAI9343993.1 | 110081 | g39119 | i0 | 67 | 3.98586572438163 | 94 | 31 | 99.6 | 0 | 1 | 282 | 131 | 224 | KAI9343993.1 carbamoyl-phosphate synthase L chain, ATP binding domain-containing protein [Obelidium mucronatum] | diamond | 1128 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Obelidium | Obelidium mucronatum | |
| 27161627 | 27161627 | PRJNA1061474_P_NODE_36242_length_300_cov_1.356828_g35996_i0 | PRJNA1061474 | 36242 | 300 | 1.356828 | 4.070484 | Nowakowskiella sp. JEL | 2012159 | Fungi | Fungi | 67 | 2.21e-10 | NR | KAJ3121537.1 | 2732418 | g35996 | i0 | 41.8 | 0.79 | 79 | 42 | 75 | 1 | 66 | 290 | 471 | 549 | KAJ3121537.1 hypothetical protein HK098_003602 [Nowakowskiella sp. JEL0407] | diamond | 237 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Nowakowskiellaceae | Nowakowskiella | Nowakowskiella sp. JEL0407 | |
| 27572600 | 27572600 | PRJNA1061474_P_NODE_53044_length_245_cov_0.895349_g52798_i0 | PRJNA1061474 | 53044 | 245 | 0.895349 | 2.19360505 | Zopfochytrium polystomum | 2211651 | Fungi | Fungi | 87.4 | 1.33e-18 | NR | KAI9364969.1 | 2211651 | g52798 | i0 | 61.8 | 1.70204081632653 | 68 | 26 | 83.3 | 0 | 42 | 245 | 4 | 71 | KAI9364969.1 nucleoside phosphorylase domain-containing protein [Zopfochytrium polystomum] | diamond | 417 | 87.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Zopfochytrium | Zopfochytrium polystomum | |
| 27951555 | 27951555 | PRJNA1061474_P_NODE_15945_length_506_cov_0.889145_g15699_i0 | PRJNA1061474 | 15945 | 506 | 0.889145 | 4.4990737 | Globomyces sp. JEL | 2786946 | Fungi | Fungi | 94 | 1.77e-20 | NR | KAJ2996896.1 | 2786946 | g15699 | i0 | 37.2 | 4.40513833992095 | 145 | 87 | 85.4 | 2 | 1 | 432 | 45 | 186 | KAJ2996896.1 hypothetical protein HDV02_006071 [Globomyces sp. JEL0801] | diamond | 2229 | 94 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces sp. JEL0801 |
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);;