contig_metadata
14 rows where bioproject = "PRJNA436017", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 430897 | 430897 | PRJNA436017_P_NODE_29181_length_151_cov_1.368421_g28883_i0 | PRJNA436017 | 29181 | 151 | 1.368421 | 2.06631571 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 102 | 6.3499999999999995e-25 | NR | KAH6572344.1 | 1357716 | g28883 | i0 | 91.7 | 0.95364238410596 | 48 | 4 | 95.4 | 0 | 3 | 146 | 71 | 118 | KAH6572344.1 hypothetical protein BASA62_003436 [Batrachochytrium salamandrivorans] | diamond | 144 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 8084201 | 8084201 | PRJNA436017_P_NODE_29267_length_151_cov_1.210526_g28969_i0 | PRJNA436017 | 29267 | 151 | 1.210526 | 1.82789426 | Rhizophydiales sp. | 2011922 | Fungi | Fungi | 150 | 4.2499999999999996e-32 | NTclustered | gi|1866582663|gb|MT730838.1| | 2011922 | g28969 | i0 | 88.372 | 112.867549668874 | 129 | 9 | 85 | 2 | 23 | 151 | 4152 | 4030 | Rhizophydiales sp. isolate JEL0830 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 17043 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Rhizophydiales sp. | |||
| 10634524 | 10634524 | PRJNA436017_P_NODE_13489_length_228_cov_1.633508_g13191_i0 | PRJNA436017 | 13489 | 228 | 1.633508 | 3.72439824 | Gromochytrium mamkaevae | 1486924 | Fungi | Fungi | 97.1 | 9.26e-16 | NTclustered | gi|612507318|gb|KF586842.1| | 1486924 | g13191 | i0 | 96.552 | 8.23245614035088 | 58 | 2 | 25 | 0 | 7 | 64 | 6188 | 6131 | Gromochytrium mamkaevae strain CALU x-51 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 1877 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Gromochytriales | Gromochytriaceae | Gromochytrium | Gromochytrium mamkaevae | |
| 13184387 | 13184387 | PRJNA436017_P_NODE_1831_length_700_cov_7.224736_g1604_i0 | PRJNA436017 | 1831 | 700 | 7.224736 | 50.573152 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 65.8 | 8.98e-6 | NTclustered | gi|1027029571|ref|XR_001677165.1| | 645134 | g1604 | i0 | 89.286 | 1.70142857142857 | 56 | 1 | 12 | 3 | 272 | 327 | 2853 | 2803 | Spizellomyces punctatus DAOM BR117 28S ribosomal RNA (SPPG_11007), partial rRNA | blastn | 1191 | 65.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 18282583 | 18282583 | PRJNA436017_P_NODE_5575_length_382_cov_2.927536_g5279_i0 | PRJNA436017 | 5575 | 382 | 2.927536 | 11.18318752 | Neocallimastigaceae | 29007 | Fungi | Fungi | 147 | 6.009999999999999e-40 | NR | ORX72588.1 | 1754192 | g5279 | i0 | 68 | 3.23560209424084 | 103 | 29 | 80.9 | 1 | 381 | 73 | 269 | 367 | ORX72588.1 S-adenosylmethionine synthase, partial [Anaeromyces robustus] | diamond | 1236 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Anaeromyces | Anaeromyces robustus | |
| 20215194 | 20215194 | PRJNA436017_P_NODE_10776_length_261_cov_8.571429_g10478_i0 | PRJNA436017 | 10776 | 261 | 8.571429 | 22.37142969 | Alphamycetaceae | 1167809 | Fungi | Fungi | 200 | 8.029999999999999e-47 | NTclustered | gi|2897839614|gb|CP161932.1| | 109871 | g10478 | i0 | 93.333 | 57.5900383141762 | 135 | 9 | 52 | 0 | 125 | 259 | 1053741 | 1053607 | Batrachochytrium dendrobatidis strain JEL423 chromosome 10 | blastn | 15031 | 202 | 0.99009900990099 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 26648916 | 26648916 | PRJNA436017_P_NODE_19781_length_184_cov_1.047619_g19483_i0 | PRJNA436017 | 19781 | 184 | 1.047619 | 1.92761896 | Rhizophydiales | 451442 | Fungi | Fungi | 58.9 | 3.12e-8 | NR | KAI8906014.1 | 382530 | g19483 | i0 | 50 | 1.85869565217391 | 52 | 26 | 84.8 | 0 | 184 | 29 | 271 | 322 | KAI8906014.1 isoprenoid synthase domain-containing protein [Gorgonomyces haynaldii] | diamond | 342 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Gorgonomycetaceae | Gorgonomyces | Gorgonomyces haynaldii | |
| 27928701 | 27928701 | PRJNA436017_P_NODE_13085_length_232_cov_1.584615_g12787_i0 | PRJNA436017 | 13085 | 232 | 1.584615 | 3.6763068 | Physocladia obscura | 109957 | Fungi | Fungi | 68.9 | 1.62e-11 | NR | KAJ3126330.1 | 109957 | g12787 | i0 | 41.6 | 2.01724137931034 | 77 | 45 | 99.6 | 0 | 2 | 232 | 259 | 335 | KAJ3126330.1 hypothetical protein HK100_010315 [Physocladia obscura] | diamond | 468 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Physocladia | Physocladia obscura | |
| 27928713 | 27928713 | PRJNA436017_P_NODE_7165_length_333_cov_1.861486_g6868_i0 | PRJNA436017 | 7165 | 333 | 1.861486 | 6.19874838 | Phlyctochytrium bullatum | 1352834 | Fungi | Fungi | 102 | 1.23e-22 | NR | KAJ3117658.1 | 1352834 | g6868 | i0 | 52 | 0.918918918918919 | 102 | 49 | 91.9 | 0 | 307 | 2 | 905 | 1006 | KAJ3117658.1 60S ribosomal protein L14 [Phlyctochytrium bullatum] | diamond | 306 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Phlyctochytrium | Phlyctochytrium bullatum | |
| 28481884 | 28481884 | PRJNA436017_P_NODE_7266_length_330_cov_1.877133_g6969_i0 | PRJNA436017 | 7266 | 330 | 1.877133 | 6.1945389 | Fungi | 4751 | Fungi | Fungi | 140 | 8.21e-40 | NR | KAJ3127717.1 | 109957 | g6969 | i0 | 74.2 | 36.2636363636364 | 97 | 25 | 88.2 | 0 | 293 | 3 | 1 | 97 | KAJ3127717.1 60S ribosomal protein L12 [Physocladia obscura] | diamond | 11967 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Physocladia | Physocladia obscura | |
| 29696450 | 29696450 | PRJNA436017_P_NODE_23330_length_169_cov_1.174242_g23032_i0 | PRJNA436017 | 23330 | 169 | 1.174242 | 1.98446898 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 78.2 | 4.39e-15 | NR | KAI9024085.1 | 82268 | g23032 | i0 | 66.1 | 31.810650887574 | 56 | 19 | 99.4 | 0 | 169 | 2 | 425 | 480 | KAI9024085.1 putative myo-inositol-phosphate synthase [Hyaloraphidium curvatum] | diamond | 5376 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 30865633 | 30865633 | PRJNA436017_P_NODE_14314_length_220_cov_1.693989_g14016_i0 | PRJNA436017 | 14314 | 220 | 1.693989 | 3.7267758 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 60.8 | 1.16e-8 | NR | XP_052965857.1 | 110093 | g14016 | i0 | 52.7 | 1.00909090909091 | 74 | 34 | 99.5 | 1 | 1 | 219 | 265 | 338 | XP_052965857.1 elongation factor EF-3 [Polychytrium aggregatum] | diamond | 222 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 32194001 | 32194001 | PRJNA436017_P_NODE_6138_length_362_cov_1.686154_g5842_i0 | PRJNA436017 | 6138 | 362 | 1.686154 | 6.10387748 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 125 | 5.15e-34 | NR | KAH9259198.1 | 1357716 | g5842 | i0 | 55.3 | 3.49723756906077 | 103 | 46 | 85.4 | 0 | 34 | 342 | 38 | 140 | KAH9259198.1 hypothetical protein BASA82_001271 [Batrachochytrium salamandrivorans] | diamond | 1266 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 32478915 | 32478915 | PRJNA436017_P_NODE_4459_length_437_cov_2.525000_g4164_i0 | PRJNA436017 | 4459 | 437 | 2.525 | 11.03425 | Gorgonomyces haynaldii | 382530 | Fungi | Fungi | 100 | 9.25e-23 | NR | KAI8911730.1 | 382530 | g4164 | i0 | 61.4 | 0.693363844393593 | 101 | 33 | 69.3 | 2 | 303 | 1 | 4 | 98 | KAI8911730.1 50S ribosomal protein L30e-like protein [Gorgonomyces haynaldii] | diamond | 303 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Gorgonomycetaceae | Gorgonomyces | Gorgonomyces haynaldii |
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);;