contig_metadata
10 rows where bioproject = "PRJNA474911" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 447684 | 447684 | PRJNA474911_P_NODE_8161_length_202_cov_0.907801_g8034_i0 | PRJNA474911 | 8161 | 202 | 0.907801 | 1.83375802 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 107 | 7.74e-26 | NR | KAI8898306.1 | 382532 | g8034 | i0 | 74.2 | 3.92079207920792 | 66 | 17 | 98 | 0 | 199 | 2 | 219 | 284 | KAI8898306.1 phospho-2-dehydro-3-deoxyheptonate aldolase [Globomyces pollinis-pini] | diamond | 792 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 16399641 | 16399641 | PRJNA474911_P_NODE_1733_length_481_cov_3.616667_g1609_i0 | PRJNA474911 | 1733 | 481 | 3.616667 | 17.39616827 | Nowakowskiella | 109880 | Fungi | Fungi | 143 | 2.7e-29 | NTclustered | gi|194241380|gb|EU828507.1| | 546781 | g1609 | i0 | 96.552 | 16.9209979209979 | 87 | 2 | 18 | 1 | 395 | 481 | 308 | 223 | Nowakowskiella sp. JH FR 28S large subunit ribosomal RNA gene, partial sequence | blastn | 8139 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Nowakowskiellaceae | Nowakowskiella | Nowakowskiella sp. JH FR | |
| 24048991 | 24048991 | PRJNA474911_P_NODE_6419_length_219_cov_3.253165_g6292_i0 | PRJNA474911 | 6419 | 219 | 3.253165 | 7.12443135 | Fungi | 4751 | Fungi | Fungi | 99 | 2.45e-16 | NTclustered | gi|1866582454|gb|MT730629.1| | 109894 | g6292 | i0 | 98.214 | 25.7123287671233 | 56 | 1 | 26 | 0 | 2 | 57 | 4780 | 4725 | 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 | 5631 | 100 | 0.99 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 26854997 | 26854997 | PRJNA474911_P_NODE_4341_length_279_cov_1.536697_g4214_i0 | PRJNA474911 | 4341 | 279 | 1.536697 | 4.28738463 | Neocallimastix frontalis | 4757 | Fungi | Fungi | 137 | 1.7999999999999998e-36 | NR | P42894.1 | 4757 | g4214 | i0 | 72 | 3.95698924731183 | 93 | 26 | 100 | 0 | 279 | 1 | 206 | 298 | P42894.1 RecName: Full=Enolase; AltName: Full=2-phospho-D-glycerate hydro-lyase; AltName: Full=2-phosphoglycerate dehydratase [Neocallimastix frontalis] | diamond | 1104 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix frontalis | |
| 28907629 | 28907629 | PRJNA474911_P_NODE_8128_length_202_cov_0.907801_g8001_i0 | PRJNA474911 | 8128 | 202 | 0.907801 | 1.83375802 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 82.8 | 1.71e-16 | NR | KAJ3043804.1 | 64517 | g8001 | i0 | 56.7 | 1.9752475247524801 | 67 | 29 | 99.5 | 0 | 201 | 1 | 1863 | 1929 | KAJ3043804.1 Protein RRP5 [Rhizophlyctis rosea] | diamond | 399 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 29397595 | 29397595 | PRJNA474911_P_NODE_6449_length_219_cov_1.215190_g6322_i0 | PRJNA474911 | 6449 | 219 | 1.21519 | 2.6612661 | root | 1 | Root_unresolved | Root_unresolved | 114 | 4.65e-29 | NR | KAI9027894.1 | 82268 | g6322 | i0 | 82.1 | 10.3150684931507 | 67 | 12 | 91.8 | 0 | 215 | 15 | 178 | 244 | KAI9027894.1 40S ribosomal protein S2 [Hyaloraphidium curvatum] | diamond | 2259 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 30581581 | 30581581 | PRJNA474911_P_NODE_7493_length_206_cov_0.882759_g7366_i0 | PRJNA474911 | 7493 | 206 | 0.882759 | 1.81848354 | Gaertneriomyces semiglobifer | 109897 | Fungi | Fungi | 42 | 0.0426 | NR | KAI8998237.1 | 109897 | g7366 | i0 | 36.1 | 1.04854368932039 | 72 | 41 | 97.6 | 2 | 5 | 205 | 174 | 245 | KAI8998237.1 hypothetical protein BC832DRAFT_623328 [Gaertneriomyces semiglobifer] | diamond | 216 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces semiglobifer | |
| 31403637 | 31403637 | PRJNA474911_P_NODE_4456_length_275_cov_1.196262_g4329_i0 | PRJNA474911 | 4456 | 275 | 1.196262 | 3.2897205 | Lobulomycetales sp. | 2058121 | Fungi | Fungi | 91.7 | 3.48e-19 | NR | KAL3896030.1 | 2058121 | g4329 | i0 | 61.5 | 0.992727272727273 | 91 | 35 | 99.3 | 0 | 3 | 275 | 577 | 667 | KAL3896030.1 MAG: hypothetical protein SGCHY_004340 [Lobulomycetales sp.] | diamond | 273 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetales sp. | |||
| 31704239 | 31704239 | PRJNA474911_P_NODE_7777_length_204_cov_0.895105_g7650_i0 | PRJNA474911 | 7777 | 204 | 0.895105 | 1.8260142 | Opisthokonta | 33154 | Fungi | Fungi | 85.9 | 1.27e-17 | NR | KAJ3160661.1 | 1134077 | g7650 | i0 | 69.4 | 4.55882352941176 | 62 | 19 | 91.2 | 0 | 3 | 188 | 154 | 215 | KAJ3160661.1 hypothetical protein HDU86_000420 [Geranomyces michiganensis] | diamond | 930 | 85.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces michiganensis | |
| 31909594 | 31909594 | PRJNA474911_P_NODE_8077_length_202_cov_1.113475_g7950_i0 | PRJNA474911 | 8077 | 202 | 1.113475 | 2.2492195 | Gonapodya sp. JEL | 2107737 | Fungi | Fungi | 42 | 0.0416 | NR | KAJ3336358.1 | 2725673 | g7950 | i0 | 40.7 | 0.801980198019802 | 54 | 22 | 65.3 | 1 | 71 | 202 | 100 | 153 | KAJ3336358.1 hypothetical protein HDU93_003029 [Gonapodya sp. JEL0774] | diamond | 162 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya sp. JEL0774 |
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);;