contig_metadata
11 rows where bioproject = "PRJNA564013", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8205013 | 8205013 | PRJNA564013_P_NODE_37767_length_628_cov_16.869489_g35088_i0 | PRJNA564013 | 37767 | 628 | 16.869489 | 105.94039092 | Entomophthora muscae | 34485 | Fungi | Fungi | 374 | 1.17e-98 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g35088 | i0 | 84.675 | 31.7691082802548 | 385 | 48 | 61 | 11 | 220 | 599 | 2061 | 1683 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 19951 | 374 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 10754455 | 10754455 | PRJNA564013_P_NODE_270529_length_245_cov_5.548913_g267677_i0 | PRJNA564013 | 270529 | 245 | 5.548913 | 13.59483685 | Pandora neoaphidis | 76017 | Fungi | Fungi | 436 | 5.229999999999999e-118 | NTclustered | gi|1390219702|gb|MH366634.1| | 76017 | g267677 | i0 | 100 | 84.2857142857143 | 236 | 0 | 96 | 0 | 1 | 236 | 377 | 142 | Pandora neoaphidis voucher Number 19 large subunit ribosomal RNA gene, partial sequence | blastn | 20650 | 436 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 18404075 | 18404075 | PRJNA564013_P_NODE_37475_length_630_cov_31.655536_g34798_i0 | PRJNA564013 | 37475 | 630 | 31.655536 | 199.4298768 | Entomophthora muscae | 34485 | Fungi | Fungi | 420 | 1.4899999999999995e-112 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g34798 | i0 | 80.033 | 39.915873015873 | 606 | 89 | 93 | 25 | 11 | 596 | 2281 | 1688 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 25147 | 420 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 27079231 | 27079231 | PRJNA564013_P_NODE_165462_length_337_cov_38.202899_g162612_i0 | PRJNA564013 | 165462 | 337 | 38.202899 | 128.74376963 | Dipsacomyces acuminosporus | 4866 | Fungi | Fungi | 60.1 | 4.94e-8 | NR | KAJ1962210.1 | 4866 | g162612 | i0 | 49.1 | 1.56676557863501 | 57 | 29 | 50.7 | 0 | 138 | 308 | 83 | 139 | KAJ1962210.1 RNA-binding RNA annealing protein [Dipsacomyces acuminosporus] | diamond | 528 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Dipsacomyces | Dipsacomyces acuminosporus | |
| 27332313 | 27332313 | PRJNA564013_P_NODE_308503_length_220_cov_2.723270_g305651_i0 | PRJNA564013 | 308503 | 220 | 2.72327 | 5.991194 | Neoconidiobolus thromboides FSU 785 | 1314799 | Fungi | Fungi | 120 | 2.07e-31 | NR | KAI9295736.1 | 1314799 | g305651 | i0 | 98.5 | 0.913636363636364 | 67 | 1 | 91.4 | 0 | 201 | 1 | 230 | 296 | KAI9295736.1 hypothetical protein K502DRAFT_364770 [Neoconidiobolus thromboides FSU 785] | diamond | 201 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 29257979 | 29257979 | PRJNA564013_P_NODE_54749_length_538_cov_1.693920_g51978_i0 | PRJNA564013 | 54749 | 538 | 1.69392 | 9.1132896 | Mycoemilia scoparia | 417184 | Fungi | Fungi | 46.6 | 0.029 | NR | KAJ1913092.1 | 417184 | g51978 | i0 | 42.9 | 0.273234200743494 | 49 | 23 | 24.5 | 1 | 476 | 345 | 342 | 390 | KAJ1913092.1 hypothetical protein H4219_005352 [Mycoemilia scoparia] | diamond | 147 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Mycoemilia | Mycoemilia scoparia | |
| 29763205 | 29763205 | PRJNA564013_P_NODE_206091_length_300_cov_7.008368_g203240_i0 | PRJNA564013 | 206091 | 300 | 7.008368 | 21.025104 | Basidiobolus meristosporus CBS 931.73 | 1314790 | Fungi | Fungi | 63.9 | 2.7e-9 | NR | ORX90887.1 | 1314790 | g203240 | i0 | 55.4 | 2.8 | 56 | 25 | 56 | 0 | 274 | 107 | 2233 | 2288 | ORX90887.1 hypothetical protein K493DRAFT_409623 [Basidiobolus meristosporus CBS 931.73] | diamond | 840 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 29777053 | 29777053 | PRJNA564013_P_NODE_4791_length_1487_cov_20.348527_g3695_i0 | PRJNA564013 | 4791 | 1487 | 20.348527 | 302.58259649 | Opisthokonta | 33154 | Fungi | Fungi | 144 | 5.45e-33 | NR | PVU94649.1 | 133385 | g3695 | i0 | 29 | 2.34633490248823 | 389 | 201 | 78.5 | 14 | 297 | 1463 | 94 | 407 | PVU94649.1 hypothetical protein BB561_002379 [Smittium simulii] | diamond | 3489 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium simulii | |
| 30364031 | 30364031 | PRJNA564013_P_NODE_198212_length_308_cov_2.283401_g195361_i0 | PRJNA564013 | 198212 | 308 | 2.283401 | 7.03287508 | Basidiobolus ranarum | 34480 | Fungi | Fungi | 95.5 | 5.480000000000001e-21 | NR | KAK9761616.1 | 34480 | g195361 | i0 | 54.4 | 2.70779220779221 | 79 | 34 | 76 | 2 | 12 | 245 | 240 | 317 | KAK9761616.1 asparagine-linked glycosylation protein, partial [Basidiobolus ranarum] | diamond | 834 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 30742725 | 30742725 | PRJNA564013_P_NODE_161454_length_341_cov_6.114286_g158604_i0 | PRJNA564013 | 161454 | 341 | 6.114286 | 20.84971526 | Entomophthora muscae | 34485 | Fungi | Fungi | 87.8 | 6.98e-18 | NR | KAJ9083418.1 | 34485 | g158604 | i0 | 42.9 | 0.98533724340176 | 112 | 64 | 98.5 | 0 | 1 | 336 | 195 | 306 | KAJ9083418.1 hypothetical protein DSO57_1034866 [Entomophthora muscae] | diamond | 336 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 32748142 | 32748142 | PRJNA564013_P_NODE_154280_length_347_cov_26.178322_g151431_i0 | PRJNA564013 | 154280 | 347 | 26.178322 | 90.83877734 | Fungi | 4751 | Fungi | Fungi | 50.4 | 8.78e-5 | NR | KAJ1956255.1 | 4866 | g151431 | i0 | 56.1 | 2.18731988472622 | 41 | 18 | 35.4 | 0 | 187 | 65 | 123 | 163 | KAJ1956255.1 hypothetical protein GGI12_005354 [Dipsacomyces acuminosporus] | diamond | 759 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Dipsacomyces | Dipsacomyces acuminosporus |
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);;