contig_metadata
15 rows where bioproject = "PRJEB28062", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24042 | 24042 | PRJEB28062_P_NODE_133301_length_232_cov_2.113208_g130937_i0 | PRJEB28062 | 133301 | 232 | 2.113208 | 4.90264256 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 137 | 5.569999999999999e-28 | NTclustered | gi|2432156890|ref|XM_053107738.1| | 110093 | g130937 | i0 | 84.459 | 8.26724137931035 | 148 | 13 | 60 | 5 | 39 | 178 | 602 | 747 | Polychytrium aggregatum 60S ribosomal protein L2 (BJ171DRAFT_425809), partial mRNA | blastn | 1918 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 987923 | 987923 | PRJEB28062_P_NODE_88781_length_349_cov_1.565217_g86419_i0 | PRJEB28062 | 88781 | 349 | 1.565217 | 5.46260733 | Fungi | 4751 | Fungi | Fungi | 503 | 7.57e-138 | NTclustered | gi|1866582755|gb|MT730930.1| | 64517 | g86419 | i0 | 93.529 | 97.1174785100286 | 340 | 18 | 97 | 4 | 12 | 349 | 4027 | 4364 | Rhizophlyctis rosea isolate KP18 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 | 33894 | 503 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 8951973 | 8951973 | PRJEB28062_P_NODE_51668_length_494_cov_22.992874_g49317_i0 | PRJEB28062 | 51668 | 494 | 22.992874 | 113.58479756 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 316 | 1.55e-81 | NTclustered | gi|1026947610|ref|XM_016748378.1| | 645134 | g49317 | i0 | 81.114 | 21.9676113360324 | 413 | 63 | 82 | 14 | 70 | 473 | 686 | 280 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S8 (SPPG_00042), mRNA | blastn | 10852 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 20426310 | 20426310 | PRJEB28062_P_NODE_84677_length_362_cov_2.394464_g82315_i0 | PRJEB28062 | 84677 | 362 | 2.394464 | 8.66795968 | Endochytrium sp. JEL 324 | 281852 | Fungi | Fungi | 198 | 4.1699999999999996e-46 | NTclustered | gi|82398552|gb|DQ273816.1| | 281852 | g82315 | i0 | 96.639 | 64.0303867403315 | 119 | 4 | 58 | 0 | 241 | 359 | 1959 | 2077 | Endochytrium sp. JEL324 isolate AFTOL-ID 631 28S ribosomal RNA gene, partial sequence | blastn | 23179 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Endochytriaceae | Endochytrium | Endochytrium sp. JEL 324 | |
| 22664829 | 22664829 | PRJEB28062_P_NODE_92038_length_338_cov_117.811321_g89676_i0 | PRJEB28062 | 92038 | 338 | 117.811321 | 398.20226498 | Powellomycetaceae | 1134080 | Fungi | Fungi | 549 | 9.279999999999997e-152 | NTclustered | gi|1866582454|gb|MT730629.1| | 109894 | g89676 | i0 | 98.095 | 92.792899408284 | 315 | 6 | 93 | 0 | 1 | 315 | 4538 | 4224 | 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 | 31364 | 549 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 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);;