contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA352850" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5500650 | 5500650 | PRJNA352850_P_NODE_9665_length_1116_cov_6.868791_g7426_i0 | PRJNA352850 | 9665 | 1116 | 6.868791 | 76.65570756 | Quaeritorhiza haematococci | 2654861 | Fungi | Fungi | 169 | 4.09e-45 | NR | KAJ3083143.1 | 2654861 | g7426 | i0 | 30.1 | 0.956989247311828 | 356 | 183 | 89 | 10 | 1027 | 35 | 28 | 342 | KAJ3083143.1 hypothetical protein HK102_001229 [Quaeritorhiza haematococci] | diamond | 1068 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Quaeritorhizaceae | Quaeritorhiza | Quaeritorhiza haematococci | ||
| 9325099 | 9325099 | PRJNA352850_P_NODE_8808_length_1203_cov_4.504333_g6650_i0 | PRJNA352850 | 8808 | 1203 | 4.504333 | 54.18712599 | Chytridiomycetes | 451435 | Fungi | Fungi | 460 | 7.619999999999998e-152 | NR | KAJ3187562.1 | 109884 | g6650 | i0 | 64.4 | 12.3341645885287 | 354 | 124 | 88 | 2 | 1202 | 144 | 483 | 835 | KAJ3187562.1 Suppressor of the cold-sensitive snRNP biogenesis mutant brr1-1 [Irineochytrium annulatum] | diamond | 14838 | 461 | 0.997830802603037 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Irineochytrium | Irineochytrium annulatum | |
| 27881618 | 27881618 | PRJNA352850_P_NODE_61285_length_295_cov_2.264228_g58452_i0 | PRJNA352850 | 61285 | 295 | 2.264228 | 6.6794726 | Neocallimastix | 4756 | Fungi | Fungi | 57.4 | 1.04e-7 | NR | ORY82281.1 | 1754190 | g58452 | i0 | 29.1 | 2.23728813559322 | 110 | 54 | 88.5 | 4 | 284 | 24 | 31 | 139 | ORY82281.1 hypothetical protein LY90DRAFT_664132 [Neocallimastix californiae] | diamond | 660 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix californiae | |
| 28274852 | 28274852 | PRJNA352850_P_NODE_20686_length_634_cov_2.955556_g17910_i0 | PRJNA352850 | 20686 | 634 | 2.955556 | 18.73822504 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 114 | 3.36e-25 | NR | KAJ3047294.1 | 64517 | g17910 | i0 | 32.9 | 1.03627760252366 | 219 | 123 | 94.2 | 5 | 628 | 32 | 395 | 609 | KAJ3047294.1 hypothetical protein HK097_011659 [Rhizophlyctis rosea] | diamond | 657 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 28748553 | 28748553 | PRJNA352850_P_NODE_69947_length_269_cov_0.927273_g67114_i0 | PRJNA352850 | 69947 | 269 | 0.927273 | 2.49436437 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 113 | 2.42e-29 | NR | KAH9252036.1 | 1357716 | g67114 | i0 | 64.8 | 0.981412639405205 | 88 | 29 | 98.1 | 1 | 3 | 266 | 8 | 93 | KAH9252036.1 hypothetical protein BASA81_010018 [Batrachochytrium salamandrivorans] | diamond | 264 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 28828720 | 28828720 | PRJNA352850_P_NODE_69968_length_268_cov_3.534247_g67135_i0 | PRJNA352850 | 69968 | 268 | 3.534247 | 9.47178196 | Kappamyces | 261096 | Fungi | Fungi | 63.9 | 1.63e-9 | NR | KAJ3345328.1 | 2724210 | g67135 | i0 | 58.6 | 2.02611940298507 | 58 | 23 | 63.8 | 1 | 265 | 95 | 316 | 373 | KAJ3345328.1 alpha subunit of pyruvate dehydrogenase [Kappamyces sp. JEL0680] | diamond | 543 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Kappamycetaceae | Kappamyces | Kappamyces sp. JEL0680 | |
| 29474486 | 29474486 | PRJNA352850_P_NODE_19530_length_661_cov_4.982026_g16776_i0 | PRJNA352850 | 19530 | 661 | 4.982026 | 32.93119186 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 123 | 8.35e-29 | NR | KAI9021253.1 | 82268 | g16776 | i0 | 36.9 | 2.74130105900151 | 206 | 114 | 89.9 | 7 | 56 | 649 | 303 | 500 | KAI9021253.1 WD40-repeat-containing domain protein [Hyaloraphidium curvatum] | diamond | 1812 | 123 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 29554883 | 29554883 | PRJNA352850_P_NODE_79570_length_250_cov_1.840796_g76737_i0 | PRJNA352850 | 79570 | 250 | 1.840796 | 4.60199 | Chytridiomycetes | 451435 | Fungi | Fungi | 64.7 | 7.17e-10 | NR | KAJ3199733.1 | 109932 | g76737 | i0 | 79.4 | 1.62 | 34 | 7 | 40.8 | 0 | 3 | 104 | 566 | 599 | KAJ3199733.1 hypothetical protein HDU82_000197 [Entophlyctis luteolus] | diamond | 405 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis luteolus | |
| 30391243 | 30391243 | PRJNA352850_P_NODE_28733_length_503_cov_3.797357_g25907_i0 | PRJNA352850 | 28733 | 503 | 3.797357 | 19.10070571 | Anaeromyces robustus | 1754192 | Fungi | Fungi | 66.2 | 2.99e-10 | NR | ORX81775.1 | 1754192 | g25907 | i0 | 35 | 1.43141153081511 | 120 | 70 | 71.6 | 4 | 31 | 390 | 12 | 123 | ORX81775.1 Sedlin [Anaeromyces robustus] | diamond | 720 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Anaeromyces | Anaeromyces robustus | |
| 31402218 | 31402218 | PRJNA352850_P_NODE_52116_length_331_cov_3.230496_g49283_i0 | PRJNA352850 | 52116 | 331 | 3.230496 | 10.69294176 | Piromyces sp. E2 | 73868 | Fungi | Fungi | 89.4 | 1.84e-19 | NR | OUM60502.1 | 73868 | g49283 | i0 | 50 | 0.761329305135952 | 84 | 40 | 74.3 | 1 | 318 | 73 | 116 | 199 | OUM60502.1 hypothetical protein PIROE2DRAFT_13698 [Piromyces sp. E2] | diamond | 252 | 89.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Piromyces | Piromyces sp. E2 | |
| 31450947 | 31450947 | PRJNA352850_P_NODE_85996_length_232_cov_4.032787_g83163_i0 | PRJNA352850 | 85996 | 232 | 4.032787 | 9.35606584 | Neocallimastigaceae | 29007 | Fungi | Fungi | 83.2 | 3.28e-18 | NR | ORX45407.1 | 1754191 | g83163 | i0 | 58.2 | 4.42241379310345 | 67 | 28 | 86.6 | 0 | 224 | 24 | 56 | 122 | ORX45407.1 phospholipid-binding protein [Piromyces finnis] | diamond | 1026 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Piromyces | Piromyces finnis | |
| 32382750 | 32382750 | PRJNA352850_P_NODE_73439_length_262_cov_0.957746_g70606_i0 | PRJNA352850 | 73439 | 262 | 0.957746 | 2.50929452 | Chytridiales sp. JEL | 2011832 | Fungi | Fungi | 77.8 | 2.08e-14 | NR | KAJ3403447.1 | 2786947 | g70606 | i0 | 72.2 | 4.94656488549618 | 54 | 9 | 61.8 | 1 | 45 | 206 | 251 | 298 | KAJ3403447.1 Non-essential glycogen phosphorylase, partial [Chytridiales sp. JEL 0842] | diamond | 1296 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiales sp. JEL 0842 |
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);;