contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJEB43370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60181 | 60181 | PRJEB43370_P_NODE_1661_length_341_cov_1.746575_g1618_i0 | PRJEB43370 | 1661 | 341 | 1.746575 | 5.95582075 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 292 | 1.74e-74 | NTclustered | gi|1759154564|ref|XM_031169821.1| | 1806994 | g1618 | i0 | 85.612 | 68.0117302052786 | 278 | 40 | 82 | 0 | 51 | 328 | 7 | 284 | Synchytrium microbalum uncharacterized protein (SmJEL517_g03893), partial mRNA | blastn | 23192 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 1334554 | 1334554 | PRJEB43370_P_NODE_6782_length_176_cov_1.637795_g6739_i0 | PRJEB43370 | 6782 | 176 | 1.637795 | 2.8825192 | Rodmanochytrium sp. | 2750701 | Fungi | Fungi | 128 | 2.4e-25 | NTclustered | gi|1866582804|gb|MT730979.1| | 2750701 | g6739 | i0 | 81.356 | 45.8579545454545 | 177 | 16 | 99 | 6 | 1 | 175 | 4012 | 3851 | Rodmanochytrium sp. isolate UM1564 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 | 8071 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Rodmanochytrium | Rodmanochytrium sp. | |
| 10262996 | 10262996 | PRJEB43370_P_NODE_3269_length_241_cov_3.239583_g3226_i0 | PRJEB43370 | 3269 | 241 | 3.239583 | 7.80739503 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 204 | 5.66e-48 | NTclustered | gi|2432049332|ref|XM_053065092.1| | 1396493 | g3226 | i0 | 89.873 | 70.2738589211618 | 158 | 16 | 66 | 0 | 40 | 197 | 281 | 124 | Fimicolochytrium jonesii ribosomal protein L18e/L15P (EV422DRAFT_17183), mRNA | blastn | 16936 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 15017765 | 15017765 | PRJEB43370_P_NODE_5172_length_199_cov_1.380000_g5129_i0 | PRJEB43370 | 5172 | 199 | 1.38 | 2.7462 | Eukaryota | 2759 | Fungi | Fungi | 195 | 2.71e-45 | NTclustered | gi|311235598|ref|NG_027613.1| | 110093 | g5129 | i0 | 95.122 | 71.9949748743719 | 123 | 6 | 62 | 0 | 4 | 126 | 2725 | 2847 | Polychytrium aggregatum JEL 109 28S rRNA gene, partial sequence; from reference material | blastn | 14327 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 20461058 | 20461058 | PRJEB43370_P_NODE_6617_length_178_cov_1.635659_g6574_i0 | PRJEB43370 | 6617 | 178 | 1.635659 | 2.91147302 | Synchytrium sp. | 1971732 | Fungi | Fungi | 104 | 4.1e-18 | NTclustered | gi|1168020523|gb|KY800404.1| | 1971732 | g6574 | i0 | 78.981 | 0.882022471910112 | 157 | 29 | 88 | 4 | 23 | 178 | 906 | 1059 | Synchytrium sp. voucher BPI 893319 large subunit ribosomal RNA gene, partial sequence | blastn | 157 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium sp. | |
| 24285973 | 24285973 | PRJEB43370_P_NODE_10680_length_162_cov_0.920354_g10637_i0 | PRJEB43370 | 10680 | 162 | 0.920354 | 1.49097348 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 137 | 3.6199999999999997e-28 | NTclustered | gi|1026973001|ref|XM_016751749.1| | 645134 | g10637 | i0 | 86.4 | 45.0617283950617 | 125 | 17 | 77 | 0 | 38 | 162 | 807 | 683 | Spizellomyces punctatus DAOM BR117 60S ribosomal protein L8 (SPPG_03486), mRNA | blastn | 7300 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus |
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);;