contig_metadata
17 rows where bioproject = "PRJEB58983", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6503062 | 6503062 | PRJEB58983_P_NODE_20926_length_285_cov_1.150943_g20511_i0 | PRJEB58983 | 20926 | 285 | 1.150943 | 3.28018755 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 103 | 1.86e-23 | NR | KAI8893489.1 | 382532 | g20511 | i0 | 57 | 0.978947368421053 | 93 | 39 | 96.8 | 1 | 5 | 280 | 352 | 444 | KAI8893489.1 P-loop containing nucleoside triphosphate hydrolase protein [Globomyces pollinis-pini] | diamond | 279 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 7777446 | 7777446 | PRJEB58983_P_NODE_27767_length_253_cov_1.850000_g27352_i0 | PRJEB58983 | 27767 | 253 | 1.85 | 4.6805 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 165 | 2.83e-36 | NTclustered | gi|2432164628|ref|XM_053113621.1| | 110093 | g27352 | i0 | 80.531 | 57.6798418972332 | 226 | 34 | 86 | 8 | 25 | 242 | 1115 | 1338 | Polychytrium aggregatum Adenosylhomocysteinase (BJ171DRAFT_570225), mRNA | blastn | 14593 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 12878750 | 12878750 | PRJEB58983_P_NODE_34831_length_224_cov_4.006623_g34416_i0 | PRJEB58983 | 34831 | 224 | 4.006623 | 8.97483552 | Gromochytrium mamkaevae | 1486924 | Fungi | Fungi | 78.7 | 3.28e-10 | NTclustered | gi|612507318|gb|KF586842.1| | 1486924 | g34416 | i0 | 97.778 | 6.14732142857143 | 45 | 1 | 20 | 0 | 177 | 221 | 6131 | 6175 | 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 | 1377 | 78.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Gromochytriales | Gromochytriaceae | Gromochytrium | Gromochytrium mamkaevae | |
| 12878779 | 12878779 | PRJEB58983_P_NODE_4111_length_602_cov_25.750473_g3703_i0 | PRJEB58983 | 4111 | 602 | 25.750473 | 155.01784746 | Geranomyces variabilis | 109894 | Fungi | Fungi | 257 | 1.18e-63 | NTclustered | gi|1866582431|gb|MT730606.1| | 109894 | g3703 | i0 | 95.625 | 26.2259136212625 | 160 | 7 | 27 | 0 | 342 | 501 | 4464 | 4623 | Geranomyces variabilis isolate AF30 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 | 15788 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 15427009 | 15427009 | PRJEB58983_P_NODE_10133_length_392_cov_8.213166_g9718_i0 | PRJEB58983 | 10133 | 392 | 8.213166 | 32.19561072 | Gromochytrium mamkaevae | 1486924 | Fungi | Fungi | 135 | 3.62e-27 | NTclustered | gi|612507318|gb|KF586842.1| | 1486924 | g9718 | i0 | 84.028 | 34.0280612244898 | 144 | 20 | 36 | 3 | 250 | 392 | 5975 | 5834 | 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 | 13339 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Gromochytriales | Gromochytriaceae | Gromochytrium | Gromochytrium mamkaevae | |
| 16294749 | 16294749 | PRJEB58983_P_NODE_18613_length_299_cov_1.393805_g18198_i0 | PRJEB58983 | 18613 | 299 | 1.393805 | 4.16747695 | Fungi | 4751 | Fungi | Fungi | 171 | 1.28e-49 | NR | KAI8590501.1 | 109894 | g18198 | i0 | 77.6 | 12.7926421404682 | 98 | 21 | 97.3 | 1 | 4 | 294 | 218 | 315 | KAI8590501.1 ribosomal protein L3-domain-containing protein [Geranomyces variabilis] | diamond | 3825 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 20118712 | 20118712 | PRJEB58983_P_NODE_6356_length_488_cov_3.862651_g5942_i0 | PRJEB58983 | 6356 | 488 | 3.862651 | 18.84973688 | Nowakowskiella | 109880 | Fungi | Fungi | 145 | 7.63e-30 | NTclustered | gi|194241380|gb|EU828507.1| | 546781 | g5942 | i0 | 96.591 | 16.8893442622951 | 88 | 2 | 18 | 1 | 401 | 488 | 308 | 222 | Nowakowskiella sp. JH FR 28S large subunit ribosomal RNA gene, partial sequence | blastn | 8242 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Nowakowskiellaceae | Nowakowskiella | Nowakowskiella sp. JH FR | |
| 27374838 | 27374838 | PRJEB58983_P_NODE_27923_length_253_cov_0.866667_g27508_i0 | PRJEB58983 | 27923 | 253 | 0.866667 | 2.19266751 | Chytridiomycetes | 451435 | Fungi | Fungi | 134 | 1.3399999999999996e-34 | NR | KAI8917325.1 | 281842 | g27508 | i0 | 63.1 | 3.88932806324111 | 84 | 31 | 99.6 | 0 | 252 | 1 | 431 | 514 | KAI8917325.1 hypothetical protein BC831DRAFT_516559 [Entophlyctis helioformis] | diamond | 984 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis helioformis | |
| 27658869 | 27658869 | PRJEB58983_P_NODE_14484_length_334_cov_4.015326_g14069_i0 | PRJEB58983 | 14484 | 334 | 4.015326 | 13.41118884 | Fungi | 4751 | Fungi | Fungi | 119 | 4.009999999999999e-32 | NR | KAI9008584.1 | 82268 | g14069 | i0 | 59.6 | 25.8682634730539 | 94 | 38 | 84.4 | 0 | 317 | 36 | 13 | 106 | KAI9008584.1 50S ribosomal protein L30e-like protein [Hyaloraphidium curvatum] | diamond | 8640 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 28801882 | 28801882 | PRJEB58983_P_NODE_14368_length_336_cov_1.186312_g13953_i0 | PRJEB58983 | 14368 | 336 | 1.186312 | 3.98600832 | Borealophlyctis nickersoniae | 2735257 | Fungi | Fungi | 157 | 3.74e-46 | NR | KAJ3282232.1 | 2735257 | g13953 | i0 | 67.3 | 0.982142857142857 | 110 | 35 | 98.2 | 1 | 1 | 330 | 54 | 162 | KAJ3282232.1 hypothetical protein HK104_010995 [Borealophlyctis nickersoniae] | diamond | 330 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Borealophlyctidaceae | Borealophlyctis | Borealophlyctis nickersoniae | |
| 29054852 | 29054852 | PRJEB58983_P_NODE_12248_length_360_cov_1.623693_g11833_i0 | PRJEB58983 | 12248 | 360 | 1.623693 | 5.8452948 | Synchytrium endobioticum | 286115 | Fungi | Fungi | 98.2 | 2.1e-22 | NR | TPX40568.1 | 286115 | g11833 | i0 | 51.8 | 4.66666666666667 | 112 | 51 | 93.3 | 3 | 4 | 339 | 129 | 237 | TPX40568.1 hypothetical protein SeMB42_g05942 [Synchytrium endobioticum] | diamond | 1680 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum | |
| 29647438 | 29647438 | PRJEB58983_P_NODE_35130_length_213_cov_4.864286_g34715_i0 | PRJEB58983 | 35130 | 213 | 4.864286 | 10.36092918 | Fungi | 4751 | Fungi | Fungi | 79 | 2.5e-16 | NR | XP_016609134.1 | 645134 | g34715 | i0 | 50.7 | 5.97183098591549 | 71 | 35 | 100 | 0 | 1 | 213 | 5 | 75 | XP_016609134.1 60S ribosomal protein L20 [Spizellomyces punctatus DAOM BR117] | diamond | 1272 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 29970424 | 29970424 | PRJEB58983_P_NODE_7511_length_451_cov_2.425926_g7097_i0 | PRJEB58983 | 7511 | 451 | 2.425926 | 10.94092626 | Chytridium lagenaria | 64509 | Fungi | Fungi | 135 | 1.38e-37 | NR | KAI8853126.1 | 64509 | g7097 | i0 | 47.8 | 1.68292682926829 | 136 | 70 | 90.5 | 1 | 22 | 429 | 5 | 139 | KAI8853126.1 40S ribosomal protein S19-A [Chytridium lagenaria] | diamond | 759 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Chytridium | Chytridium lagenaria | |
| 30918436 | 30918436 | PRJEB58983_P_NODE_21054_length_284_cov_1.928910_g20639_i0 | PRJEB58983 | 21054 | 284 | 1.92891 | 5.4781044 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 84.7 | 3.91e-17 | NR | KAI9034634.1 | 82268 | g20639 | i0 | 48.2 | 2.67253521126761 | 85 | 43 | 88.7 | 1 | 12 | 263 | 18 | 102 | KAI9034634.1 ubiquitin-related domain-containing protein, partial [Hyaloraphidium curvatum] | diamond | 759 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 31297471 | 31297471 | PRJEB58983_P_NODE_20295_length_288_cov_2.418605_g19880_i0 | PRJEB58983 | 20295 | 288 | 2.418605 | 6.9655824 | Cladochytrium tenue | 1604274 | Fungi | Fungi | 120 | 7.180000000000001e-33 | NR | KAJ1568147.1 | 1604274 | g19880 | i0 | 64.2 | 0.989583333333333 | 95 | 34 | 99 | 0 | 286 | 2 | 4 | 98 | KAJ1568147.1 60S ribosomal protein L32 [Cladochytrium tenue] | diamond | 285 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium tenue | |
| 31866698 | 31866698 | PRJEB58983_P_NODE_29277_length_249_cov_1.772727_g28862_i0 | PRJEB58983 | 29277 | 249 | 1.772727 | 4.41409023 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 46.2 | 0.00234 | NR | KAI9002515.1 | 82268 | g28862 | i0 | 43.1 | 0.783132530120482 | 65 | 36 | 77.1 | 1 | 195 | 4 | 62 | 126 | KAI9002515.1 hypothetical protein DFJ74DRAFT_695896 [Hyaloraphidium curvatum] | diamond | 195 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 32563218 | 32563218 | PRJEB58983_P_NODE_31099_length_245_cov_0.906977_g30684_i0 | PRJEB58983 | 31099 | 245 | 0.906977 | 2.22209365 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 145 | 4.03e-38 | NR | KAJ1327207.1 | 1357716 | g30684 | i0 | 86.4 | 17.5836734693878 | 81 | 11 | 99.2 | 0 | 243 | 1 | 734 | 814 | KAJ1327207.1 pre-mRNA-processing-splicing factor 8 [Batrachochytrium salamandrivorans] | diamond | 4308 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans |
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);;