contig_metadata
14 rows where bioproject = "PRJNA763243", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3294489 | 3294489 | PRJNA763243_P_NODE_3583_length_718_cov_4.361240_g3299_i0 | PRJNA763243 | 3583 | 718 | 4.36124 | 31.3137032 | Entomophthora muscae | 34485 | Fungi | Fungi | 165 | 8.84e-36 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g3299 | i0 | 85.987 | 30.2033426183844 | 157 | 19 | 22 | 3 | 557 | 712 | 2166 | 2320 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 21686 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 9672541 | 9672541 | PRJNA763243_P_NODE_7428_length_534_cov_6.156182_g7087_i0 | PRJNA763243 | 7428 | 534 | 6.156182 | 32.87401188 | Pandora neoaphidis | 76017 | Fungi | Fungi | 835 | 0 | NTclustered | gi|1390219702|gb|MH366634.1| | 76017 | g7087 | i0 | 99.563 | 73.5243445692884 | 458 | 2 | 99 | 0 | 75 | 532 | 50 | 507 | Pandora neoaphidis voucher Number 19 large subunit ribosomal RNA gene, partial sequence | blastn | 39262 | 835 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 13959199 | 13959199 | PRJNA763243_P_NODE_2851_length_793_cov_120.550000_g2584_i0 | PRJNA763243 | 2851 | 793 | 120.55 | 955.9615 | Opisthokonta | 33154 | Fungi | Fungi | 182 | 9.729999999999999e-41 | NTclustered | gi|1515573218|gb|MG764572.1| | 2012320 | g2584 | i0 | 86.391 | 21.4249684741488 | 169 | 19 | 21 | 4 | 1 | 168 | 1055 | 890 | Piptocephalis sp. strain Brazil2 large subunit ribosomal RNA gene, partial sequence | blastn | 16990 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis sp. | |
| 14771621 | 14771621 | PRJNA763243_P_NODE_16172_length_385_cov_7.435897_g15827_i0 | PRJNA763243 | 16172 | 385 | 7.435897 | 28.62820345 | Pandora neoaphidis | 76017 | Fungi | Fungi | 706 | 0 | NTclustered | gi|166812027|gb|EU267193.1| | 76017 | g15827 | i0 | 100 | 98.2103896103896 | 382 | 0 | 99 | 0 | 1 | 382 | 776 | 1157 | 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 | 37811 | 706 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 21607507 | 21607507 | PRJNA763243_P_NODE_66257_length_234_cov_2.503106_g65911_i0 | PRJNA763243 | 66257 | 234 | 2.503106 | 5.85726804 | Zoophthora | 34482 | Fungi | Fungi | 427 | 2.9799999999999993e-115 | NTclustered | gi|1669295027|gb|MK970714.1| | 42210 | g65911 | i0 | 100 | 93.2777777777778 | 231 | 0 | 99 | 0 | 4 | 234 | 61 | 291 | Zoophthora radicans strain ARSEF3376 large subunit ribosomal RNA gene, partial sequence | blastn | 21827 | 427 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Zoophthora | Zoophthora radicans | |
| 22420106 | 22420106 | PRJNA763243_P_NODE_20298_length_351_cov_5.895683_g19952_i0 | PRJNA763243 | 20298 | 351 | 5.895683 | 20.69384733 | Spiromyces aspiralis | 68401 | Fungi | Fungi | 163 | 2.99e-48 | NR | KAJ1679641.1 | 68401 | g19952 | i0 | 77.3 | 1.92307692307692 | 110 | 25 | 94 | 0 | 347 | 18 | 80 | 189 | KAJ1679641.1 40S ribosomal protein S6, partial [Spiromyces aspiralis] | diamond | 675 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces aspiralis | |
| 24970762 | 24970762 | PRJNA763243_P_NODE_9200_length_490_cov_10.577938_g8858_i0 | PRJNA763243 | 9200 | 490 | 10.577938 | 51.8318962 | Entomophthora muscae | 34485 | Fungi | Fungi | 381 | 5.369999999999998e-101 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g8858 | i0 | 81.188 | 41.9040816326531 | 505 | 67 | 99 | 20 | 5 | 490 | 1733 | 2228 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 20533 | 381 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 24970774 | 24970774 | PRJNA763243_P_NODE_9820_length_477_cov_5.027228_g9477_i0 | PRJNA763243 | 9820 | 477 | 5.027228 | 23.97987756 | Entomophthora muscae | 34485 | Fungi | Fungi | 398 | 5.1799999999999975e-106 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g9477 | i0 | 85.714 | 36.6540880503145 | 385 | 45 | 80 | 10 | 87 | 467 | 2061 | 1683 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 17484 | 398 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 26936192 | 26936192 | PRJNA763243_P_NODE_23502_length_331_cov_7.027132_g23156_i0 | PRJNA763243 | 23502 | 331 | 7.027132 | 23.25980692 | Eukaryota | 2759 | Fungi | Fungi | 134 | 2.98e-36 | NR | KAJ1677761.1 | 68401 | g23156 | i0 | 64.9 | 1.7583081570997 | 97 | 34 | 87.9 | 0 | 325 | 35 | 146 | 242 | KAJ1677761.1 40S ribosomal protein S4 [Spiromyces aspiralis] | diamond | 582 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces aspiralis | |
| 28663865 | 28663865 | PRJNA763243_P_NODE_48527_length_257_cov_2.489130_g48181_i0 | PRJNA763243 | 48527 | 257 | 2.48913 | 6.3970641 | Basidiobolus meristosporus CBS 931.73 | 1314790 | Fungi | Fungi | 73.2 | 7.93e-13 | NR | ORX94404.1 | 1314790 | g48181 | i0 | 55.6 | 1.4124513618677 | 63 | 28 | 73.5 | 0 | 253 | 65 | 367 | 429 | ORX94404.1 eukaryotic translation initiation factor 3, subunit 6 [Basidiobolus meristosporus CBS 931.73] | diamond | 363 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 31064470 | 31064470 | PRJNA763243_P_NODE_63075_length_241_cov_2.607143_g62729_i0 | PRJNA763243 | 63075 | 241 | 2.607143 | 6.28321463 | Ramicandelaber brevisporus | 304332 | Fungi | Fungi | 54.3 | 2.88e-6 | NR | KAI8867800.1 | 304332 | g62729 | i0 | 40 | 0.871369294605809 | 70 | 38 | 85.9 | 2 | 9 | 215 | 77 | 143 | KAI8867800.1 hypothetical protein GQ42DRAFT_50824 [Ramicandelaber brevisporus] | diamond | 210 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Ramicandelaberales | Ramicandelaberaceae | Ramicandelaber | Ramicandelaber brevisporus | ||
| 31949615 | 31949615 | PRJNA763243_P_NODE_72557_length_208_cov_6.607407_g72211_i0 | PRJNA763243 | 72557 | 208 | 6.607407 | 13.74340656 | Coemansia sp. RSA 2559 | 2663921 | Fungi | Fungi | 53.5 | 3.74e-6 | NR | KAJ2400795.1 | 2663921 | g72211 | i0 | 51 | 0.706730769230769 | 49 | 24 | 70.7 | 0 | 58 | 204 | 19 | 67 | KAJ2400795.1 hypothetical protein GGI23_001812, partial [Coemansia sp. RSA 2559] | diamond | 147 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 2559 | |
| 32329763 | 32329763 | PRJNA763243_P_NODE_60019_length_244_cov_0.900585_g59673_i0 | PRJNA763243 | 60019 | 244 | 0.900585 | 2.1974274 | Mycoemilia scoparia | 417184 | Fungi | Fungi | 41.6 | 0.0384 | NR | KAJ1913557.1 | 417184 | g59673 | i0 | 63.3 | 0.368852459016393 | 30 | 11 | 36.9 | 0 | 99 | 10 | 14 | 43 | KAJ1913557.1 hypothetical protein H4219_005160 [Mycoemilia scoparia] | diamond | 90 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Mycoemilia | Mycoemilia scoparia | |
| 32865782 | 32865782 | PRJNA763243_P_NODE_34120_length_293_cov_2.086364_g33774_i0 | PRJNA763243 | 34120 | 293 | 2.086364 | 6.11304652 | Coemansia sp. RSA 678 | 2790277 | Fungi | Fungi | 78.2 | 9.41e-15 | NR | KAJ2134335.1 | 2790277 | g33774 | i0 | 48.9 | 3.88054607508532 | 94 | 43 | 94.2 | 4 | 282 | 7 | 179 | 269 | KAJ2134335.1 coatomer subunit delta [Coemansia sp. RSA 678] | diamond | 1137 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 678 |
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);;