contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA429937" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18278025 | 18278025 | PRJNA429937_P_NODE_27955_length_692_cov_2.128205_g16857_i0 | PRJNA429937 | 27955 | 692 | 2.128205 | 14.7271786 | Thoreauomyces humboldtii | 1396496 | Fungi | Fungi | 226 | 1.6199999999999998e-66 | NR | KAJ3013248.1 | 1396496 | g16857 | i0 | 63.6 | 0.845375722543353 | 195 | 63 | 81.1 | 3 | 2 | 562 | 216 | 410 | KAJ3013248.1 Dihydroxyacetone kinase 2 [Thoreauomyces humboldtii] | diamond | 585 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Thoreauomyces | Thoreauomyces humboldtii | |
| 19552815 | 19552815 | PRJNA429937_P_NODE_5136_length_1517_cov_7.583333_g3036_i0 | PRJNA429937 | 5136 | 1517 | 7.583333 | 115.03916161 | Thoreauomyces humboldtii | 1396496 | Fungi | Fungi | 745 | 1.52e-267 | NR | KAJ3023624.1 | 1396496 | g3036 | i0 | 76.9 | 2.74686882003955 | 463 | 104 | 91 | 1 | 43 | 1422 | 1 | 463 | KAJ3023624.1 hypothetical protein HKX48_002173 [Thoreauomyces humboldtii] | diamond | 4167 | 745 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Thoreauomyces | Thoreauomyces humboldtii | |
| 24653499 | 24653499 | PRJNA429937_P_NODE_67920_length_411_cov_3.853403_g46723_i0 | PRJNA429937 | 67920 | 411 | 3.853403 | 15.83748633 | Chytridiomycota | 4761 | Fungi | Fungi | 108 | 3.0900000000000003e-27 | NR | XP_052968709.1 | 110093 | g46723 | i0 | 67.1 | 1.65693430656934 | 76 | 25 | 55.5 | 0 | 25 | 252 | 27 | 102 | XP_052968709.1 ribosomal protein L34e-domain-containing protein [Polychytrium aggregatum] | diamond | 681 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 26632535 | 26632535 | PRJNA429937_P_NODE_34641_length_616_cov_2.490630_g21452_i0 | PRJNA429937 | 34641 | 616 | 2.49063 | 15.3422808 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 214 | 2.38e-60 | NR | KAH9259671.1 | 1357716 | g21452 | i0 | 47.5 | 1.18831168831169 | 244 | 88 | 99.4 | 3 | 5 | 616 | 525 | 768 | KAH9259671.1 hypothetical protein BASA81_002093 [Batrachochytrium salamandrivorans] | diamond | 732 | 214 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 27360331 | 27360331 | PRJNA429937_P_NODE_144223_length_198_cov_5.733728_g121596_i0 | PRJNA429937 | 144223 | 198 | 5.733728 | 11.35278144 | Blyttiomyces sp. JEL | 2750429 | Fungi | Fungi | 40.8 | 0.0172 | NR | KAJ3311181.1 | 2724214 | g121596 | i0 | 43.6 | 0.590909090909091 | 39 | 22 | 59.1 | 0 | 75 | 191 | 35 | 73 | KAJ3311181.1 hypothetical protein HDU76_003193, partial [Blyttiomyces sp. JEL0837] | diamond | 117 | 40.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Blyttiomyces | Blyttiomyces sp. JEL0837 | |||
| 28465452 | 28465452 | PRJNA429937_P_NODE_48906_length_507_cov_22.822176_g31877_i0 | PRJNA429937 | 48906 | 507 | 22.822176 | 115.70843232 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 46.2 | 0.0215 | NR | KAI9003365.1 | 82268 | g31877 | i0 | 46.2 | 0.230769230769231 | 39 | 21 | 23.1 | 0 | 206 | 322 | 203 | 241 | KAI9003365.1 hypothetical protein DFJ74DRAFT_435861 [Hyaloraphidium curvatum] | diamond | 117 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 29254419 | 29254419 | PRJNA429937_P_NODE_38909_length_579_cov_2.510909_g24493_i0 | PRJNA429937 | 38909 | 579 | 2.510909 | 14.53816311 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 197 | 2.3e-54 | NR | KAH9259671.1 | 1357716 | g24493 | i0 | 45.3 | 1.2020725388601 | 232 | 87 | 99.5 | 3 | 4 | 579 | 537 | 768 | KAH9259671.1 hypothetical protein BASA81_002093 [Batrachochytrium salamandrivorans] | diamond | 696 | 197 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 29317770 | 29317770 | PRJNA429937_P_NODE_61029_length_442_cov_3.598063_g41129_i0 | PRJNA429937 | 61029 | 442 | 3.598063 | 15.90343846 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 91.3 | 2.55e-20 | NR | XP_052928359.1 | 1396493 | g41129 | i0 | 43.5 | 1.61538461538462 | 115 | 61 | 76 | 2 | 428 | 93 | 1 | 114 | XP_052928359.1 ribosomal L28e/Mak16 [Fimicolochytrium jonesii] | diamond | 714 | 91.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 30960469 | 30960469 | PRJNA429937_P_NODE_72554_length_393_cov_2.156593_g50725_i0 | PRJNA429937 | 72554 | 393 | 2.156593 | 8.47541049 | Thoreauomyces humboldtii | 1396496 | Fungi | Fungi | 116 | 2.88e-27 | NR | KAJ3013248.1 | 1396496 | g50725 | i0 | 76.3 | 2.3206106870229 | 76 | 18 | 58 | 0 | 230 | 3 | 14 | 89 | KAJ3013248.1 Dihydroxyacetone kinase 2 [Thoreauomyces humboldtii] | diamond | 912 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Thoreauomyces | Thoreauomyces humboldtii | |
| 31877223 | 31877223 | PRJNA429937_P_NODE_22657_length_772_cov_4.051144_g13470_i0 | PRJNA429937 | 22657 | 772 | 4.051144 | 31.27483168 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 55.1 | 1.02e-4 | NR | XP_052969325.1 | 110093 | g13470 | i0 | 40.8 | 0.823834196891192 | 71 | 25 | 27.6 | 2 | 282 | 70 | 38 | 91 | XP_052969325.1 programmed cell death protein 2 [Polychytrium aggregatum] | diamond | 636 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 32415410 | 32415410 | PRJNA429937_P_NODE_42079_length_554_cov_2.038095_g26757_i0 | PRJNA429937 | 42079 | 554 | 2.038095 | 11.2910463 | Thoreauomyces humboldtii | 1396496 | Fungi | Fungi | 118 | 3.94e-27 | NR | KAJ3013248.1 | 1396496 | g26757 | i0 | 76.6 | 1.66787003610108 | 77 | 18 | 41.7 | 0 | 2 | 232 | 14 | 90 | KAJ3013248.1 Dihydroxyacetone kinase 2 [Thoreauomyces humboldtii] | diamond | 924 | 118 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Thoreauomyces | Thoreauomyces humboldtii | |
| 32542084 | 32542084 | PRJNA429937_P_NODE_154259_length_166_cov_2.547445_g131632_i0 | PRJNA429937 | 154259 | 166 | 2.547445 | 4.2287587 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 66.6 | 2.61e-11 | NR | KAJ3047908.1 | 64517 | g131632 | i0 | 60 | 1.62650602409639 | 45 | 18 | 81.3 | 0 | 135 | 1 | 100 | 144 | KAJ3047908.1 hypothetical protein HK097_011046 [Rhizophlyctis rosea] | diamond | 270 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea |
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);;