contig_metadata
6 rows where bioproject = "PRJNA886442", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 861858 | 861858 | PRJNA886442_P_NODE_10201_length_253_cov_1.477778_g10037_i0 | PRJNA886442 | 10201 | 253 | 1.477778 | 3.73877834 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 52.8 | 0.023 | NTclustered | gi|1759162618|ref|XM_031171126.1| | 1806994 | g10037 | i0 | 100 | 0.110671936758893 | 28 | 0 | 11 | 0 | 173 | 200 | 604 | 631 | Synchytrium microbalum uncharacterized protein (SmJEL517_g05199), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 26865906 | 26865906 | PRJNA886442_P_NODE_12281_length_248_cov_1.337143_g12117_i0 | PRJNA886442 | 12281 | 248 | 1.337143 | 3.31611464 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 47 | 0.00125 | NR | KAI8894042.1 | 382532 | g12117 | i0 | 34.9 | 2.35887096774194 | 63 | 41 | 76.2 | 0 | 5 | 193 | 204 | 266 | KAI8894042.1 hypothetical protein BC833DRAFT_531060 [Globomyces pollinis-pini] | diamond | 585 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 29203005 | 29203005 | PRJNA886442_P_NODE_8529_length_275_cov_2.039604_g8365_i0 | PRJNA886442 | 8529 | 275 | 2.039604 | 5.608911 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 68.9 | 1.13e-11 | NR | KXS10613.1 | 1344416 | g8365 | i0 | 61.1 | 1.17818181818182 | 54 | 21 | 58.9 | 0 | 164 | 3 | 1 | 54 | KXS10613.1 NAD(P)-binding protein [Gonapodya prolifera JEL478] | diamond | 324 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 29360775 | 29360775 | PRJNA886442_P_NODE_689_length_825_cov_16.493351_g536_i0 | PRJNA886442 | 689 | 825 | 16.493351 | 136.07014575 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 56.6 | 1.93e-6 | NR | XP_052925105.1 | 1396493 | g536 | i0 | 51 | 0.549090909090909 | 51 | 25 | 18.5 | 0 | 749 | 597 | 1 | 51 | XP_052925105.1 putative cruciform DNA binding protein [Fimicolochytrium jonesii] | diamond | 453 | 56.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 29549974 | 29549974 | PRJNA886442_P_NODE_6490_length_307_cov_1.333333_g6326_i0 | PRJNA886442 | 6490 | 307 | 1.333333 | 4.09333231 | Borealophlyctis nickersoniae | 2735257 | Fungi | Fungi | 145 | 4.89e-38 | NR | KAJ3287891.1 | 2735257 | g6326 | i0 | 67.3 | 0.986970684039088 | 101 | 33 | 98.7 | 0 | 305 | 3 | 797 | 897 | KAJ3287891.1 hypothetical protein HK104_008414 [Borealophlyctis nickersoniae] | diamond | 303 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Borealophlyctidaceae | Borealophlyctis | Borealophlyctis nickersoniae | |
| 31509342 | 31509342 | PRJNA886442_P_NODE_10996_length_252_cov_0.871508_g10832_i0 | PRJNA886442 | 10996 | 252 | 0.871508 | 2.19620016 | Quaeritorhiza haematococci | 2654861 | Fungi | Fungi | 64.7 | 7.75e-10 | NR | KAJ3081408.1 | 2654861 | g10832 | i0 | 53.7 | 1.29761904761905 | 54 | 25 | 64.3 | 0 | 249 | 88 | 327 | 380 | KAJ3081408.1 hypothetical protein HK102_002360 [Quaeritorhiza haematococci] | diamond | 327 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Quaeritorhizaceae | Quaeritorhiza | Quaeritorhiza haematococci |
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);;