contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1800792 | 1800792 | PRJNA556992_P_NODE_184622_length_336_cov_1.171103_g182434_i0 | PRJNA556992 | 184622 | 336 | 1.171103 | 3.93490608 | Pandora neoaphidis | 76017 | Fungi | Fungi | 621 | 1.9299999999999997e-173 | NTclustered | gi|1390219702|gb|MH366634.1| | 76017 | g182434 | i0 | 100 | 89.2321428571429 | 336 | 0 | 100 | 0 | 1 | 336 | 394 | 59 | Pandora neoaphidis voucher Number 19 large subunit ribosomal RNA gene, partial sequence | blastn | 29982 | 621 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 3080964 | 3080964 | PRJNA556992_P_NODE_54223_length_497_cov_3.233491_g52059_i0 | PRJNA556992 | 54223 | 497 | 3.233491 | 16.07045027 | Entomophthora muscae | 34485 | Fungi | Fungi | 379 | 1.96e-100 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g52059 | i0 | 86.441 | 29.8591549295775 | 354 | 38 | 70 | 9 | 11 | 360 | 1707 | 2054 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 14840 | 379 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 4349105 | 4349105 | PRJNA556992_P_NODE_1013764_length_229_cov_2.858974_g1011574_i0 | PRJNA556992 | 1013764 | 229 | 2.858974 | 6.54705046 | Linderina pennispora | 61395 | Fungi | Fungi | 104 | 5.56e-18 | NTclustered | gi|2028317630|ref|XM_040884570.1| | 61395 | g1011574 | i0 | 90.909 | 0.458515283842795 | 77 | 7 | 34 | 0 | 48 | 124 | 1509 | 1433 | Linderina pennispora uncharacterized protein (DL89DRAFT_222131), partial mRNA | blastn | 105 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 17103612 | 17103612 | PRJNA556992_P_NODE_238334_length_310_cov_2.396624_g236146_i0 | PRJNA556992 | 238334 | 310 | 2.396624 | 7.4295344 | Dimargaris bacillispora | 78925 | Fungi | Fungi | 311 | 4.33e-80 | NTclustered | gi|11034720|dbj|AB016020.1| | 78925 | g236146 | i0 | 84.308 | 18.9354838709677 | 325 | 23 | 100 | 4 | 1 | 310 | 1593 | 1282 | Dimargaris bacillispora 18S rRNA gene, strain NRRL 2808, partial sequence | blastn | 5870 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dimargaris | Dimargaris bacillispora | |
| 22200815 | 22200815 | PRJNA556992_P_NODE_1159938_length_199_cov_6.087302_g1157747_i0 | PRJNA556992 | 1159938 | 199 | 6.087302 | 12.11373098 | Kickxella alabastrina | 61397 | Fungi | Fungi | 62.1 | 2.87e-5 | NTclustered | gi|2324016486|ref|XM_051538925.1| | 61397 | g1157747 | i0 | 97.222 | 0.180904522613065 | 36 | 1 | 18 | 0 | 145 | 180 | 169 | 134 | Kickxella alabastrina uncharacterized protein (BX661DRAFT_224946), partial mRNA | blastn | 36 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 23474499 | 23474499 | PRJNA556992_P_NODE_1022279_length_228_cov_3.290323_g1020089_i0 | PRJNA556992 | 1022279 | 228 | 3.290323 | 7.50193644 | Conidiobolus taihushanensis | 2721185 | Fungi | Fungi | 171 | 5.38e-38 | NTclustered | gi|2127863558|ref|NC_058641.1| | 2721185 | g1020089 | i0 | 86.076 | 19.2850877192982 | 158 | 22 | 69 | 0 | 71 | 228 | 21273 | 21116 | Conidiobolus taihushanensis mitochondrion, complete genome | blastn | 4397 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus taihushanensis |
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);;