contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA379145" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2951181 | 2951181 | PRJNA379145_P_NODE_12603_length_827_cov_5.013854_g11193_i0 | PRJNA379145 | 12603 | 827 | 5.013854 | 41.46457258 | Linderina pennispora | 61395 | Fungi | Fungi | 333 | 2.6500000000000002e-86 | NTclustered | gi|2028325604|ref|XM_040889545.1| | 61395 | g11193 | i0 | 80 | 26.8863361547763 | 455 | 87 | 55 | 4 | 91 | 543 | 46 | 498 | Linderina pennispora 40S ribosomal protein S9 (DL89DRAFT_279070), partial mRNA | blastn | 22235 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 11879305 | 11879305 | PRJNA379145_P_NODE_16690_length_680_cov_329.596600_g14978_i0 | PRJNA379145 | 16690 | 680 | 329.5966 | 2241.25688 | Pandora neoaphidis | 76017 | Fungi | Fungi | 1251 | 0 | NTclustered | gi|1390219702|gb|MH366634.1| | 76017 | g14978 | i0 | 99.853 | 78.8132352941176 | 680 | 1 | 100 | 0 | 1 | 680 | 713 | 34 | Pandora neoaphidis voucher Number 19 large subunit ribosomal RNA gene, partial sequence | blastn | 53593 | 1251 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 11879916 | 11879916 | PRJNA379145_P_NODE_71130_length_157_cov_1.330645_g68975_i0 | PRJNA379145 | 71130 | 157 | 1.330645 | 2.08911265 | Microconidiobolus nodosus | 1167817 | Fungi | Fungi | 97.1 | 5.9e-16 | NTclustered | gi|2032035993|gb|MW795365.1| | 1167817 | g68975 | i0 | 95.082 | 0.764331210191083 | 61 | 3 | 39 | 0 | 1 | 61 | 13244 | 13304 | Microconidiobolus nodosus strain ATCC 16577 mitochondrion, complete genome | blastn | 120 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Microconidiobolus | Microconidiobolus nodosus | |
| 13154341 | 13154341 | PRJNA379145_P_NODE_17551_length_656_cov_5.512039_g15796_i0 | PRJNA379145 | 17551 | 656 | 5.512039 | 36.15897584 | Capillidium heterosporum | 1167838 | Fungi | Fungi | 904 | 0 | NTclustered | gi|1583106424|ref|NC_040967.1| | 1167838 | g15796 | i0 | 91.896 | 51.7057926829268 | 654 | 42 | 98 | 7 | 8 | 653 | 2481 | 1831 | Conidiobolus heterosporus strain RCEF6331 mitochondrion, complete genome | blastn | 33919 | 904 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium heterosporum | |
| 14429502 | 14429502 | PRJNA379145_P_NODE_28352_length_440_cov_287.501229_g26259_i0 | PRJNA379145 | 28352 | 440 | 287.501229 | 1265.0054076 | Entomophaga aulicae | 39303 | Fungi | Fungi | 228 | 6.589999999999999e-55 | NTclustered | gi|1373048|gb|U35394.1|EAU35394 | 39303 | g26259 | i0 | 88.83 | 41.5409090909091 | 188 | 18 | 42 | 3 | 2 | 187 | 5874 | 6060 | Entomophaga aulicae 18S, ITS-1, 5.8S, ITS-2, and 25S ribosomal RNA genes | blastn | 18278 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophaga | Entomophaga aulicae | |
| 15703312 | 15703312 | PRJNA379145_P_NODE_16853_length_676_cov_5.223950_g15133_i0 | PRJNA379145 | 16853 | 676 | 5.22395 | 35.313902 | Pandora kondoiensis | 176681 | Fungi | Fungi | 673 | 0 | NTclustered | gi|402230189|gb|JX242642.1| | 176681 | g15133 | i0 | 99.196 | 37.1213017751479 | 373 | 3 | 55 | 0 | 304 | 676 | 490 | 118 | Pandora kondoiensis strain CBS 642.92 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 25094 | 673 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora kondoiensis | |
| 16977970 | 16977970 | PRJNA379145_P_NODE_16974_length_673_cov_2.684375_g15247_i0 | PRJNA379145 | 16974 | 673 | 2.684375 | 18.06584375 | Capillidium heterosporum | 1167838 | Fungi | Fungi | 514 | 7.12e-141 | NTclustered | gi|1583106424|ref|NC_040967.1| | 1167838 | g15247 | i0 | 89.183 | 19.3150074294205 | 416 | 40 | 62 | 4 | 1 | 414 | 689 | 1101 | Conidiobolus heterosporus strain RCEF6331 mitochondrion, complete genome | blastn | 12999 | 514 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium heterosporum | |
| 18925475 | 18925475 | PRJNA379145_P_NODE_34915_length_353_cov_4.562500_g32769_i0 | PRJNA379145 | 34915 | 353 | 4.5625 | 16.105625 | Ancylistaceae | 34486 | Fungi | Fungi | 375 | 1.7399999999999998e-99 | NTclustered | gi|2032035963|gb|MW795364.1| | 76012 | g32769 | i0 | 87.834 | 21.9150141643059 | 337 | 19 | 95 | 9 | 1 | 335 | 33793 | 34109 | Neoconidiobolus thromboides strain ATCC 12587 mitochondrion, complete genome | blastn | 7736 | 375 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 20802214 | 20802214 | PRJNA379145_P_NODE_29557_length_422_cov_3.005141_g27444_i0 | PRJNA379145 | 29557 | 422 | 3.005141 | 12.68169502 | Neoconidiobolus thromboides | 76012 | Fungi | Fungi | 420 | 9.67e-113 | NTclustered | gi|2032035963|gb|MW795364.1| | 76012 | g27444 | i0 | 84.793 | 3.87440758293839 | 434 | 48 | 99 | 10 | 1 | 420 | 32435 | 32864 | Neoconidiobolus thromboides strain ATCC 12587 mitochondrion, complete genome | blastn | 1635 | 420 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 22077447 | 22077447 | PRJNA379145_P_NODE_44478_length_267_cov_253.461538_g42326_i0 | PRJNA379145 | 44478 | 267 | 253.461538 | 676.74230646 | Pandora neoaphidis | 76017 | Fungi | Fungi | 462 | 9.519999999999999e-126 | NTclustered | gi|166812027|gb|EU267193.1| | 76017 | g42326 | i0 | 98.113 | 97.5917602996255 | 265 | 5 | 99 | 0 | 3 | 267 | 1714 | 1450 | Pandora neoaphidis ARSEF 7939 pn7939-3 MboI- pattern 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 25S ribosomal RNA gene, partial sequence | blastn | 26057 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 23352709 | 23352709 | PRJNA379145_P_NODE_25639_length_484_cov_127.070953_g23594_i0 | PRJNA379145 | 25639 | 484 | 127.070953 | 615.02341252 | Smittium mucronatum | 133383 | Fungi | Fungi | 180 | 2.07e-40 | NTclustered | gi|666440451|gb|KF848910.1| | 133383 | g23594 | i0 | 90.071 | 19.1322314049587 | 141 | 11 | 36 | 2 | 1 | 140 | 2761 | 2899 | Smittium mucronatum strain FRA-12-3 28S ribosomal RNA gene, partial sequence | blastn | 9260 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium mucronatum | |
| 23352947 | 23352947 | PRJNA379145_P_NODE_47139_length_250_cov_3.087558_g44986_i0 | PRJNA379145 | 47139 | 250 | 3.087558 | 7.718895 | Kickxella alabastrina | 61397 | Fungi | Fungi | 139 | 1.6899999999999999e-28 | NTclustered | gi|2324005516|ref|XM_051534838.1| | 61397 | g44986 | i0 | 80.663 | 9.3 | 181 | 33 | 72 | 2 | 12 | 191 | 338 | 159 | Kickxella alabastrina 50S ribosomal protein L30e-like protein (BX661DRAFT_178169), mRNA | blastn | 2325 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina |
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);;