contig_metadata
6 rows where bioproject = "PRJNA771359", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 747007 | 747007 | PRJNA771359_S_NODE_1201_length_307_cov_1.788889_g1118_i0 | PRJNA771359 | 1201 | 307 | 1.788889 | 5.49188923 | uncultured Chytridiomycota | 175247 | Fungi | Fungi | 78.7 | 4.73e-10 | NTclustered | gi|262235206|gb|GQ995417.1| | 175247 | g1118 | i0 | 81.633 | 20.3420195439739 | 98 | 15 | 32 | 3 | 171 | 267 | 830 | 925 | Uncultured Chytridiomycota clone T1P1AeC08 18S ribosomal RNA gene, partial sequence | blastn | 6245 | 78.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | uncultured Chytridiomycota | |||||
| 28673532 | 28673532 | PRJNA771359_S_NODE_3807_length_172_cov_2.474074_g3724_i0 | PRJNA771359 | 3807 | 172 | 2.474074 | 4.25540728 | Chytridiomycetes | 451435 | Fungi | Fungi | 63.2 | 4.13e-10 | NR | KAI9329449.1 | 110081 | g3724 | i0 | 67.4 | 1.55232558139535 | 46 | 15 | 80.2 | 0 | 171 | 34 | 188 | 233 | KAI9329449.1 ribosomal protein L6e-domain-containing protein [Obelidium mucronatum] | diamond | 267 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Obelidium | Obelidium mucronatum | |
| 28821489 | 28821489 | PRJNA771359_S_NODE_2188_length_226_cov_3.269841_g2105_i0 | PRJNA771359 | 2188 | 226 | 3.269841 | 7.38984066 | Cladochytrium replicatum | 109936 | Fungi | Fungi | 71.2 | 2.8e-13 | NR | KAI8799421.1 | 109936 | g2105 | i0 | 59.2 | 0.942477876106195 | 71 | 29 | 94.2 | 0 | 3 | 215 | 87 | 157 | KAI8799421.1 S25 ribosomal protein-domain-containing protein [Cladochytrium replicatum] | diamond | 213 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 29746714 | 29746714 | PRJNA771359_S_NODE_2210_length_225_cov_2.452128_g2127_i0 | PRJNA771359 | 2210 | 225 | 2.452128 | 5.517288 | Boothiomyces | 451452 | Fungi | Fungi | 97.8 | 1.17e-21 | NR | KAJ3315473.1 | 2724207 | g2127 | i0 | 68.9 | 4.93333333333333 | 74 | 22 | 98.7 | 1 | 224 | 3 | 486 | 558 | KAJ3315473.1 60S ribosomal protein L18 [Boothiomyces sp. JEL0838] | diamond | 1110 | 97.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Terramycetaceae | Boothiomyces | Boothiomyces sp. JEL0838 | |
| 32361436 | 32361436 | PRJNA771359_S_NODE_4719_length_157_cov_1.291667_g4636_i0 | PRJNA771359 | 4719 | 157 | 1.291667 | 2.02791719 | Gorgonomyces haynaldii | 382530 | Fungi | Fungi | 84.3 | 2.38e-17 | NR | KAI8905629.1 | 382530 | g4636 | i0 | 75 | 0.993630573248408 | 52 | 13 | 99.4 | 0 | 1 | 156 | 319 | 370 | KAI8905629.1 hypothetical protein EDD86DRAFT_193808 [Gorgonomyces haynaldii] | diamond | 156 | 84.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Gorgonomycetaceae | Gorgonomyces | Gorgonomyces haynaldii | |
| 32424499 | 32424499 | PRJNA771359_S_NODE_4139_length_166_cov_1.914729_g4056_i0 | PRJNA771359 | 4139 | 166 | 1.914729 | 3.17845014 | Blyttiomyces sp. JEL | 2750429 | Fungi | Fungi | 81.6 | 9.65e-18 | NR | KAJ3329793.1 | 2724214 | g4056 | i0 | 74.1 | 0.975903614457831 | 54 | 14 | 97.6 | 0 | 164 | 3 | 75 | 128 | KAJ3329793.1 60S ribosomal protein L18 [Blyttiomyces sp. JEL0837] | diamond | 162 | 81.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Blyttiomyces | Blyttiomyces sp. JEL0837 |
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);;