contig_metadata
14 rows where bioproject = "PRJNA1146029", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4117257 | 4117257 | PRJNA1146029_P_NODE_824_length_988_cov_1.943169_g629_i0 | PRJNA1146029 | 824 | 988 | 1.943169 | 19.19850972 | Eukaryota | 2759 | Fungi | Fungi | 335 | 3.8599999999999997e-110 | NR | KAJ8326405.1 | 109871 | g629 | i0 | 63.6 | 16.3026315789474 | 316 | 109 | 95.6 | 4 | 1 | 945 | 53 | 363 | KAJ8326405.1 cross-pathway control WD-repeat protein cpc2 [Batrachochytrium dendrobatidis] | diamond | 16107 | 337 | 0.99406528189911 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 6136509 | 6136509 | PRJNA1146029_P_NODE_7185_length_333_cov_1.946154_g6907_i0 | PRJNA1146029 | 7185 | 333 | 1.946154 | 6.48069282 | Powellomycetaceae | 1134080 | Fungi | Fungi | 604 | 1.9199999999999991e-168 | NTclustered | gi|1866582454|gb|MT730629.1| | 109894 | g6907 | i0 | 99.399 | 100.138138138138 | 333 | 2 | 100 | 0 | 1 | 333 | 4457 | 4125 | Geranomyces variabilis isolate Barr350 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 | 33346 | 610 | 0.99016393442623 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 7943218 | 7943218 | PRJNA1146029_P_NODE_19947_length_245_cov_0.895349_g19666_i0 | PRJNA1146029 | 19947 | 245 | 0.895349 | 2.19360505 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 109 | 1.39e-25 | NR | KAJ3057492.1 | 64517 | g19666 | i0 | 59.5 | 2.93877551020408 | 79 | 32 | 96.7 | 0 | 243 | 7 | 182 | 260 | KAJ3057492.1 hypothetical protein HK097_004013 [Rhizophlyctis rosea] | diamond | 720 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 9218197 | 9218197 | PRJNA1146029_P_NODE_3148_length_481_cov_1.509804_g2871_i0 | PRJNA1146029 | 3148 | 481 | 1.509804 | 7.26215724 | Fungi | 4751 | Fungi | Fungi | 231 | 1.6199999999999999e-74 | NR | KAJ3410134.1 | 4814 | g2871 | i0 | 74.2 | 11.9126819126819 | 159 | 41 | 99.2 | 0 | 477 | 1 | 50 | 208 | KAJ3410134.1 60S ribosomal protein L18 [Chytriomyces hyalinus] | diamond | 5730 | 231 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 11768801 | 11768801 | PRJNA1146029_P_NODE_20310_length_244_cov_0.900585_g20029_i0 | PRJNA1146029 | 20310 | 244 | 0.900585 | 2.1974274 | Feramyces austinii | 2170546 | Fungi | Fungi | 351 | 1.9399999999999998e-92 | NTclustered | gi|1388116306|gb|MH043840.1| | 2170546 | g20029 | i0 | 92.623 | 16.1188524590164 | 244 | 18 | 100 | 0 | 1 | 244 | 59 | 302 | Feramyces austinii strain WSF3a Glycosyl hydrolase family 130 mRNA, partial cds | blastn | 3933 | 351 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Feramyces | Feramyces austinii | |
| 20691697 | 20691697 | PRJNA1146029_P_NODE_37_length_2781_cov_3.998892_g27_i0 | PRJNA1146029 | 37 | 2781 | 3.998892 | 111.20918652 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 624 | 1.34e-208 | NR | KAI8893489.1 | 382532 | g27 | i0 | 54.2 | 1.30636461704423 | 600 | 265 | 64 | 5 | 2607 | 829 | 25 | 621 | KAI8893489.1 P-loop containing nucleoside triphosphate hydrolase protein [Globomyces pollinis-pini] | diamond | 3633 | 624 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 28164967 | 28164967 | PRJNA1146029_P_NODE_19345_length_246_cov_0.890173_g19064_i0 | PRJNA1146029 | 19345 | 246 | 0.890173 | 2.18982558 | Chytridiomycetes | 451435 | Fungi | Fungi | 119 | 3.84e-29 | NR | KAI8912019.1 | 109895 | g19064 | i0 | 70.7 | 9.17073170731707 | 75 | 22 | 91.5 | 0 | 230 | 6 | 475 | 549 | KAI8912019.1 calponin homology domain-containing protein [Powellomyces hirtus] | diamond | 2256 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 28291079 | 28291079 | PRJNA1146029_P_NODE_14886_length_258_cov_1.664865_g14605_i0 | PRJNA1146029 | 14886 | 258 | 1.664865 | 4.2953517 | root | 1 | Root_unresolved | Root_unresolved | 151 | 2.319999999999999e-41 | NR | KAI9001831.1 | 82268 | g14605 | i0 | 83.5 | 5.93023255813953 | 85 | 14 | 98.8 | 0 | 257 | 3 | 252 | 336 | KAI9001831.1 putative MmgE/PrpD family domain-containing protein [Hyaloraphidium curvatum] | diamond | 1530 | 152 | 0.993421052631579 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 28838969 | 28838969 | PRJNA1146029_P_NODE_20088_length_244_cov_1.467836_g19807_i0 | PRJNA1146029 | 20088 | 244 | 1.467836 | 3.58151984 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 87 | 4.13e-19 | NR | KAJ3049393.1 | 64517 | g19807 | i0 | 56.2 | 2.70491803278689 | 73 | 30 | 89.8 | 1 | 26 | 244 | 44 | 114 | KAJ3049393.1 putative hydrolase rbbp9 [Rhizophlyctis rosea] | diamond | 660 | 87 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 29186591 | 29186591 | PRJNA1146029_P_NODE_22309_length_241_cov_0.916667_g22028_i0 | PRJNA1146029 | 22309 | 241 | 0.916667 | 2.20916747 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 66.6 | 1.35e-10 | NR | XP_052961875.1 | 110093 | g22028 | i0 | 42.3 | 2.87551867219917 | 78 | 45 | 97.1 | 0 | 7 | 240 | 342 | 419 | XP_052961875.1 uncharacterized protein BJ171DRAFT_35436 [Polychytrium aggregatum] | diamond | 693 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 29364833 | 29364833 | PRJNA1146029_P_NODE_15589_length_253_cov_1.433333_g15308_i0 | PRJNA1146029 | 15589 | 253 | 1.433333 | 3.62633249 | Fungi | 4751 | Fungi | Fungi | 75.1 | 1.7e-13 | NR | TPX62100.1 | 109895 | g15308 | i0 | 49.4 | 2.97628458498024 | 79 | 39 | 92.5 | 1 | 243 | 10 | 324 | 402 | TPX62100.1 hypothetical protein PhCBS80983_g00685 [Powellomyces hirtus] | diamond | 753 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 30355446 | 30355446 | PRJNA1146029_P_NODE_15952_length_251_cov_0.865169_g15671_i0 | PRJNA1146029 | 15952 | 251 | 0.865169 | 2.17157419 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 108 | 3.96e-25 | NR | KAI9028762.1 | 82268 | g15671 | i0 | 68.7 | 0.99203187250996006 | 83 | 26 | 99.2 | 0 | 1 | 249 | 704 | 786 | KAI9028762.1 hypothetical protein DFJ74DRAFT_641843 [Hyaloraphidium curvatum] | diamond | 249 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 31619149 | 31619149 | PRJNA1146029_P_NODE_16236_length_251_cov_0.865169_g15955_i0 | PRJNA1146029 | 16236 | 251 | 0.865169 | 2.17157419 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 52.8 | 1.09e-5 | NR | KAH6565710.1 | 1357716 | g15955 | i0 | 59.5 | 0.884462151394422 | 37 | 15 | 44.2 | 0 | 248 | 138 | 265 | 301 | KAH6565710.1 hypothetical protein BASA60_009829 [Batrachochytrium salamandrivorans] | diamond | 222 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 32335965 | 32335965 | PRJNA1146029_P_NODE_6019_length_358_cov_3.077193_g5741_i0 | PRJNA1146029 | 6019 | 358 | 3.077193 | 11.01635094 | Chytridiomycota | 4761 | Fungi | Fungi | 194 | 9.86e-60 | NR | KAI9005244.1 | 109897 | g5741 | i0 | 72.9 | 5.93296089385475 | 118 | 32 | 98.9 | 0 | 3 | 356 | 9 | 126 | KAI9005244.1 translation protein SH3-like domain-containing protein [Gaertneriomyces semiglobifer] | diamond | 2124 | 194 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces semiglobifer |
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);;