contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1808788 | 1808788 | PRJNA556992_P_NODE_796582_length_246_cov_1.716763_g794392_i0 | PRJNA556992 | 796582 | 246 | 1.716763 | 4.22323698 | Chytridiomycota sp. | 2012212 | Fungi | Fungi | 361 | 3.25e-95 | NTclustered | gi|1832315394|gb|MT353599.1| | 2012212 | g794392 | i0 | 98.537 | 73.390243902439 | 205 | 2 | 83 | 1 | 23 | 226 | 1 | 205 | Chytridiomycota sp. isolate F_OTU_414 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence | blastn | 18054 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycota sp. | |||||
| 9458261 | 9458261 | PRJNA556992_P_NODE_521208_length_265_cov_2.822917_g519019_i0 | PRJNA556992 | 521208 | 265 | 2.822917 | 7.48073005 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 161 | 3.86e-35 | NTclustered | gi|1026959854|ref|XM_016750634.1| | 645134 | g519019 | i0 | 95.098 | 38.3698113207547 | 102 | 5 | 38 | 0 | 151 | 252 | 207 | 308 | Spizellomyces punctatus DAOM BR117 histone H2B (SPPG_02345), mRNA | blastn | 10168 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 12004082 | 12004082 | PRJNA556992_P_NODE_188950_length_333_cov_2.942308_g186762_i0 | PRJNA556992 | 188950 | 333 | 2.942308 | 9.79788564 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 316 | 1.0099999999999999e-81 | NTclustered | gi|1027029543|ref|XR_001677161.1| | 645134 | g186762 | i0 | 93.458 | 53.6636636636637 | 214 | 13 | 64 | 1 | 121 | 333 | 4085 | 3872 | Spizellomyces punctatus DAOM BR117 28S ribosomal RNA (SPPG_11002), rRNA | blastn | 17870 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 15155356 | 15155356 | PRJNA556992_P_NODE_739312_length_249_cov_1.647727_g737123_i0 | PRJNA556992 | 739312 | 249 | 1.647727 | 4.10284023 | Chytridiomycetes | 451435 | Fungi | Fungi | 429 | 8.91e-116 | NTclustered | gi|1866582754|gb|MT730929.1| | 64517 | g737123 | i0 | 97.976 | 99.2008032128514 | 247 | 5 | 99 | 0 | 1 | 247 | 379 | 133 | Rhizophlyctis rosea isolate KP15 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 | 24701 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 19661094 | 19661094 | PRJNA556992_P_NODE_923076_length_238_cov_4.218182_g920886_i0 | PRJNA556992 | 923076 | 238 | 4.218182 | 10.03927316 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|1026950408|ref|XM_016749068.1| | 645134 | g920886 | i0 | 100 | 0.121848739495798 | 29 | 0 | 12 | 0 | 69 | 97 | 4119 | 4147 | Spizellomyces punctatus DAOM BR117 cytoskeletal protein-binding protein SLA1 (SPPG_00739), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 19661165 | 19661165 | PRJNA556992_P_NODE_92896_length_414_cov_3.803519_g90712_i0 | PRJNA556992 | 92896 | 414 | 3.803519 | 15.74656866 | Chytriomyces hyalinus | 4814 | Fungi | Fungi | 268 | 3.6299999999999996e-67 | NTclustered | gi|189909135|gb|DQ273836.2| | 4814 | g90712 | i0 | 78.708 | 104.859903381643 | 418 | 77 | 100 | 11 | 1 | 414 | 2867 | 2458 | Chytriomyces hyalinus isolate AFTOL-ID 1537 28S ribosomal RNA gene, partial sequence | blastn | 43412 | 268 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 22207061 | 22207061 | PRJNA556992_P_NODE_534278_length_264_cov_2.418848_g532089_i0 | PRJNA556992 | 534278 | 264 | 2.418848 | 6.38575872 | Gromochytrium mamkaevae | 1486924 | Fungi | Fungi | 73.1 | 1.85e-8 | NTclustered | gi|612507318|gb|KF586842.1| | 1486924 | g532089 | i0 | 100 | 3.17424242424242 | 39 | 0 | 15 | 0 | 1 | 39 | 6169 | 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 | 838 | 73.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Gromochytriales | Gromochytriaceae | Gromochytrium | Gromochytrium mamkaevae | |
| 22211164 | 22211164 | PRJNA556992_P_NODE_865878_length_242_cov_3.668639_g863688_i0 | PRJNA556992 | 865878 | 242 | 3.668639 | 8.87810638 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 67.6 | 7.78e-7 | NTclustered | gi|2432159932|ref|XM_053115047.1| | 110093 | g863688 | i0 | 100 | 0.590909090909091 | 36 | 0 | 15 | 0 | 173 | 208 | 634 | 599 | Polychytrium aggregatum uncharacterized protein (BJ171DRAFT_600912), mRNA | blastn | 143 | 67.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 23480285 | 23480285 | PRJNA556992_P_NODE_375099_length_279_cov_2.135922_g372910_i0 | PRJNA556992 | 375099 | 279 | 2.135922 | 5.95922238 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 265 | 3.03e-66 | NTclustered | gi|2432131711|ref|XM_053109357.1| | 110093 | g372910 | i0 | 89.474 | 65.3476702508961 | 209 | 22 | 75 | 0 | 12 | 220 | 334 | 126 | Polychytrium aggregatum calmodulin (BJ171DRAFT_488251), mRNA | blastn | 18232 | 265 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum |
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);;