contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA758398" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9668002 | 9668002 | PRJNA758398_S_NODE_11648_length_285_cov_3.495763_g11507_i0 | PRJNA758398 | 11648 | 285 | 3.495763 | 9.96292455 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 165 | 3.2400000000000004e-36 | NTclustered | gi|2432159776|ref|XM_053111801.1| | 110093 | g11507 | i0 | 90.4 | 38.7929824561404 | 125 | 12 | 44 | 0 | 13 | 137 | 269 | 393 | Polychytrium aggregatum ribosomal protein S8e/ribosomal biogenesis NSA2 (BJ171DRAFT_514033), mRNA | blastn | 11056 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 13493792 | 13493792 | PRJNA758398_S_NODE_5891_length_392_cov_1.685131_g5750_i0 | PRJNA758398 | 5891 | 392 | 1.685131 | 6.60571352 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 56.5 | 0.003 | NTclustered | gi|2897839259|gb|CP161931.1| | 109871 | g5750 | i0 | 100 | 0.076530612244898 | 30 | 0 | 8 | 0 | 7 | 36 | 710928 | 710957 | Batrachochytrium dendrobatidis strain JEL423 chromosome 9 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 17318257 | 17318257 | PRJNA758398_S_NODE_55034_length_158_cov_2.275229_g54893_i0 | PRJNA758398 | 55034 | 158 | 2.275229 | 3.59486182 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 75 | 2.79e-9 | NTclustered | gi|2432143220|ref|XM_053115507.1| | 110093 | g54893 | i0 | 100 | 1.24683544303797 | 40 | 0 | 34 | 0 | 42 | 81 | 1155 | 1194 | Polychytrium aggregatum uncharacterized protein (BJ171DRAFT_62544), mRNA | blastn | 197 | 75 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 17782019 | 17782019 | PRJNA758398_S_NODE_33294_length_185_cov_1.875000_g33153_i0 | PRJNA758398 | 33294 | 185 | 1.875 | 3.46875 | Eukaryota | 2759 | Fungi | Fungi | 172 | 1.16e-38 | NTclustered | gi|387233096|gb|JN033858.1| | 4757 | g33153 | i0 | 83.696 | 38.2378378378378 | 184 | 28 | 99 | 2 | 3 | 185 | 853 | 671 | Neocallimastix frontalis strain PMA02 isocitrate dehydrogenase (IDH1) mRNA, complete cds | blastn | 7074 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix frontalis | |
| 19866483 | 19866483 | PRJNA758398_S_NODE_19036_length_231_cov_2.434066_g18895_i0 | PRJNA758398 | 19036 | 231 | 2.434066 | 5.62269246 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 174 | 4.22e-39 | NTclustered | gi|1759161090|ref|XM_031170872.1| | 1806994 | g18895 | i0 | 82.039 | 81.1038961038961 | 206 | 35 | 89 | 2 | 27 | 231 | 1238 | 1034 | Synchytrium microbalum succinate dehydrogenase (SmJEL517_g04944), partial mRNA | blastn | 18735 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 23692936 | 23692936 | PRJNA758398_S_NODE_53099_length_161_cov_1.366071_g52958_i0 | PRJNA758398 | 53099 | 161 | 1.366071 | 2.19937431 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 60.2 | 7.99e-5 | NTclustered | gi|1759150185|ref|XM_031168908.1| | 1806994 | g52958 | i0 | 100 | 0.198757763975155 | 32 | 0 | 20 | 0 | 43 | 74 | 1555 | 1586 | Synchytrium microbalum uncharacterized protein (SmJEL517_g02980), partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 24966337 | 24966337 | PRJNA758398_S_NODE_34840_length_182_cov_1.150376_g34699_i0 | PRJNA758398 | 34840 | 182 | 1.150376 | 2.09368432 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 135 | 1.4900000000000002e-27 | NTclustered | gi|575471771|ref|XM_006675116.1| | 684364 | g34699 | i0 | 83.916 | 78.5824175824176 | 143 | 21 | 78 | 2 | 2 | 143 | 788 | 929 | Batrachochytrium dendrobatidis JAM81 protein phosphatase 2A (BATDEDRAFT_18460), mRNA | blastn | 14302 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis |
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);;