contig_metadata
10 rows where bioproject = "PRJNA382357", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6781557 | 6781557 | PRJNA382357_P_NODE_45666_length_342_cov_1.462633_g44927_i0 | PRJNA382357 | 45666 | 342 | 1.462633 | 5.00220486 | Monoblepharis insignis | 109953 | Fungi | Fungi | 632 | 9.079999999999999e-177 | NTclustered | gi|19386988|gb|AF450112.1| | 109953 | g44927 | i0 | 100 | 93.3538011695906 | 342 | 0 | 100 | 0 | 1 | 342 | 350 | 691 | Monoblepharis insignis translation elongation factor 1-alpha gene, partial cds | blastn | 31927 | 632 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Monoblepharidaceae | Monoblepharis | Monoblepharis insignis | |
| 10607738 | 10607738 | PRJNA382357_P_NODE_50369_length_327_cov_1.954887_g49630_i0 | PRJNA382357 | 50369 | 327 | 1.954887 | 6.39248049 | Phlyctochytrium arcticum | 1117335 | Fungi | Fungi | 75.5 | 2.23e-13 | NR | KAI9099539.1 | 1117335 | g49630 | i0 | 67.3 | 0.504587155963303 | 55 | 17 | 49.5 | 1 | 162 | 1 | 184 | 238 | KAI9099539.1 Metallo-dependent phosphatase-like protein [Phlyctochytrium arcticum] | diamond | 165 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Phlyctochytrium | Phlyctochytrium arcticum | |
| 20805473 | 20805473 | PRJNA382357_P_NODE_48597_length_332_cov_23499.121771_g47858_i0 | PRJNA382357 | 48597 | 332 | 23499.121771 | 78017.08427972 | uncultured Chytridiomycota | 175247 | Fungi | Fungi | 191 | 6.35e-44 | NTclustered | gi|541905186|gb|KC561973.1| | 175247 | g47858 | i0 | 99.065 | 62.8192771084337 | 107 | 0 | 64 | 1 | 1 | 107 | 1514 | 1619 | Uncultured Chytridiomycota isolate T31b_03 18S ribosomal RNA gene, partial sequence | blastn | 20856 | 191 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | uncultured Chytridiomycota | |||||
| 27169635 | 27169635 | PRJNA382357_P_NODE_145382_length_206_cov_1.751724_g144643_i0 | PRJNA382357 | 145382 | 206 | 1.751724 | 3.60855144 | Cladochytrium replicatum | 109936 | Fungi | Fungi | 62 | 3.3e-9 | NR | KAI8805847.1 | 109936 | g144643 | i0 | 51.9 | 0.757281553398058 | 52 | 25 | 75.7 | 0 | 51 | 206 | 292 | 343 | KAI8805847.1 cation efflux protein [Cladochytrium replicatum] | diamond | 156 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 28780313 | 28780313 | PRJNA382357_P_NODE_93047_length_250_cov_1.328042_g92308_i0 | PRJNA382357 | 93047 | 250 | 1.328042 | 3.320105 | Podochytrium sp. JEL | 2750441 | Fungi | Fungi | 46.2 | 0.00229 | NR | KAJ3060938.1 | 2724200 | g92308 | i0 | 48.9 | 2.388 | 47 | 17 | 56.4 | 1 | 108 | 248 | 65 | 104 | KAJ3060938.1 hypothetical protein HDU98_003129 [Podochytrium sp. JEL0797] | diamond | 597 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Podochytrium | Podochytrium sp. JEL0797 | |
| 28860430 | 28860430 | PRJNA382357_P_NODE_50708_length_326_cov_2.071698_g49969_i0 | PRJNA382357 | 50708 | 326 | 2.071698 | 6.75373548 | Fungi | 4751 | Fungi | Fungi | 59.7 | 1.12e-7 | NR | KAI8814028.1 | 109936 | g49969 | i0 | 39.4 | 4.54601226993865 | 71 | 43 | 65.3 | 0 | 264 | 52 | 328 | 398 | KAI8814028.1 Hsp70 protein-domain-containing protein [Cladochytrium replicatum] | diamond | 1482 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 29790534 | 29790534 | PRJNA382357_P_NODE_126091_length_217_cov_62.493590_g125352_i0 | PRJNA382357 | 126091 | 217 | 62.49359 | 135.6110903 | Gonapodya sp. JEL | 2107737 | Fungi | Fungi | 42 | 0.0498 | NR | KAJ3336660.1 | 2725673 | g125352 | i0 | 30.8 | 0.898617511520737 | 65 | 45 | 89.9 | 0 | 12 | 206 | 644 | 708 | KAJ3336660.1 hypothetical protein HDU93_002392 [Gonapodya sp. JEL0774] | diamond | 195 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya sp. JEL0774 | |
| 31609086 | 31609086 | PRJNA382357_P_NODE_139536_length_209_cov_0.878378_g138797_i0 | PRJNA382357 | 139536 | 209 | 0.878378 | 1.83581002 | Opisthokonta | 33154 | Fungi | Fungi | 47.4 | 5.11e-4 | NR | KAI9032068.1 | 82268 | g138797 | i0 | 42.9 | 2.69856459330144 | 42 | 24 | 60.3 | 0 | 153 | 28 | 230 | 271 | KAI9032068.1 kinase-like domain-containing protein, partial [Hyaloraphidium curvatum] | diamond | 564 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 32224873 | 32224873 | PRJNA382357_P_NODE_146318_length_206_cov_0.896552_g145579_i0 | PRJNA382357 | 146318 | 206 | 0.896552 | 1.84689712 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 42.4 | 0.0297 | NR | KAH9249524.1 | 1357716 | g145579 | i0 | 45.5 | 0.480582524271845 | 33 | 18 | 48.1 | 0 | 103 | 5 | 79 | 111 | KAH9249524.1 hypothetical protein BASA81_012697 [Batrachochytrium salamandrivorans] | diamond | 99 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 32305369 | 32305369 | PRJNA382357_P_NODE_5939_length_819_cov_1.711082_g5300_i0 | PRJNA382357 | 5939 | 819 | 1.711082 | 14.01376158 | Eukaryota | 2759 | Fungi | Fungi | 84.3 | 1.07e-14 | NR | TPX49763.1 | 286115 | g5300 | i0 | 44 | 1.73260073260073 | 100 | 52 | 36.6 | 2 | 57 | 356 | 97 | 192 | TPX49763.1 hypothetical protein SeMB42_g02488 [Synchytrium endobioticum] | diamond | 1419 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium endobioticum |
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);;