contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJEB28062" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24250243 | 24250243 | PRJEB28062_P_NODE_26220_length_725_cov_52.300613_g23980_i0 | PRJEB28062 | 26220 | 725 | 52.300613 | 379.17944425 | Geranomyces variabilis | 109894 | Fungi | Fungi | 264 | 1.96e-83 | NR | KAI8586775.1 | 109894 | g23980 | i0 | 82.4 | 0.657931034482759 | 159 | 28 | 65.8 | 0 | 171 | 647 | 242 | 400 | KAI8586775.1 hypothetical protein BDZ88DRAFT_427685 [Geranomyces variabilis] | diamond | 477 | 264 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 28264795 | 28264795 | PRJEB28062_P_NODE_137086_length_207_cov_6.768657_g134722_i0 | PRJEB28062 | 137086 | 207 | 6.768657 | 14.01111999 | Powellomyces hirtus | 109895 | Fungi | Fungi | 55.1 | 3.32e-7 | NR | KAI8921257.1 | 109895 | g134722 | i0 | 54.2 | 0.695652173913043 | 48 | 22 | 69.6 | 0 | 26 | 169 | 86 | 133 | KAI8921257.1 hypothetical protein DFJ77DRAFT_545792 [Powellomyces hirtus] | diamond | 144 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 28770106 | 28770106 | PRJEB28062_P_NODE_73347_length_399_cov_20.328221_g70985_i0 | PRJEB28062 | 73347 | 399 | 20.328221 | 81.10960179 | Geranomyces michiganensis | 1134077 | Fungi | Fungi | 144 | 4.12e-42 | NR | KAJ3149288.1 | 1134077 | g70985 | i0 | 82.1 | 0.586466165413534 | 78 | 14 | 58.6 | 0 | 335 | 102 | 3 | 80 | KAJ3149288.1 hypothetical protein HDU86_007011 [Geranomyces michiganensis] | diamond | 234 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces michiganensis | |
| 29086066 | 29086066 | PRJEB28062_P_NODE_72848_length_401_cov_4.707317_g70486_i0 | PRJEB28062 | 72848 | 401 | 4.707317 | 18.87634117 | Powellomyces hirtus | 109895 | Fungi | Fungi | 79.3 | 3.31e-14 | NR | TPX61199.1 | 109895 | g70486 | i0 | 59.4 | 0.516209476309227 | 69 | 24 | 51.6 | 1 | 371 | 165 | 457 | 521 | TPX61199.1 hypothetical protein PhCBS80983_g01239 [Powellomyces hirtus] | diamond | 207 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 29117628 | 29117628 | PRJEB28062_P_NODE_122129_length_255_cov_10.626374_g119765_i0 | PRJEB28062 | 122129 | 255 | 10.626374 | 27.0972537 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 78.6 | 1.06e-14 | NR | KAH9252065.1 | 1357716 | g119765 | i0 | 67.2 | 0.682352941176471 | 58 | 17 | 68.2 | 1 | 23 | 196 | 654 | 709 | KAH9252065.1 hypothetical protein BASA81_010047 [Batrachochytrium salamandrivorans] | diamond | 174 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 29559388 | 29559388 | PRJEB28062_P_NODE_64030_length_434_cov_20.013850_g61669_i0 | PRJEB28062 | 64030 | 434 | 20.01385 | 86.860109 | Geranomyces variabilis | 109894 | Fungi | Fungi | 79.7 | 3.87e-14 | NR | KAJ3170478.1 | 109894 | g61669 | i0 | 41.8 | 0.84331797235023 | 122 | 57 | 77.4 | 3 | 409 | 74 | 1285 | 1402 | KAJ3170478.1 Endoplasmic reticulum metallopeptidase 1 [Geranomyces variabilis] | diamond | 366 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 30184657 | 30184657 | PRJEB28062_P_NODE_66372_length_425_cov_5.784091_g64011_i0 | PRJEB28062 | 66372 | 425 | 5.784091 | 24.58238675 | Eukaryota | 2759 | Fungi | Fungi | 112 | 8.91e-26 | NR | KAI9016760.1 | 82268 | g64011 | i0 | 74.6 | 4.10117647058824 | 67 | 17 | 47.3 | 0 | 237 | 37 | 778 | 844 | KAI9016760.1 P-loop containing nucleoside triphosphate hydrolase protein [Hyaloraphidium curvatum] | diamond | 1743 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 31708282 | 31708282 | PRJEB28062_P_NODE_126977_length_246_cov_17.358382_g124613_i0 | PRJEB28062 | 126977 | 246 | 17.358382 | 42.70161972 | Podochytrium sp. JEL | 2750441 | Fungi | Fungi | 50.4 | 6.92e-5 | NR | KAJ3062783.1 | 2724200 | g124613 | i0 | 41.4 | 2.84146341463415 | 58 | 33 | 70.7 | 1 | 229 | 56 | 290 | 346 | KAJ3062783.1 autophagy protein 5 [Podochytrium sp. JEL0797] | diamond | 699 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Podochytrium | Podochytrium sp. JEL0797 | |
| 31739767 | 31739767 | PRJEB28062_P_NODE_112137_length_280_cov_28.173913_g109774_i0 | PRJEB28062 | 112137 | 280 | 28.173913 | 78.8869564 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 55.5 | 1.39e-6 | NR | KAH9254665.1 | 1357716 | g109774 | i0 | 55.8 | 0.460714285714286 | 43 | 19 | 46.1 | 0 | 38 | 166 | 195 | 237 | KAH9254665.1 hypothetical protein BASA81_007432 [Batrachochytrium salamandrivorans] | diamond | 129 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 32556412 | 32556412 | PRJEB28062_P_NODE_16039_length_950_cov_4.399088_g14132_i0 | PRJEB28062 | 16039 | 950 | 4.399088 | 41.791336 | Fungi | 4751 | Fungi | Fungi | 229 | 3.87e-71 | NR | KAJ3410134.1 | 4814 | g14132 | i0 | 69.2 | 3.97578947368421 | 182 | 50 | 55.9 | 3 | 21 | 551 | 28 | 208 | KAJ3410134.1 60S ribosomal protein L18 [Chytriomyces hyalinus] | diamond | 3777 | 229 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus |
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);;