contig_metadata
11 rows where bioproject = "PRJNA788929", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 769390 | 769390 | PRJNA788929_P_NODE_32861_length_273_cov_4.765000_g32200_i0 | PRJNA788929 | 32861 | 273 | 4.765 | 13.00845 | Eryniopsis caroliniana | 181054 | Fungi | Fungi | 73.1 | 1.92e-8 | NTclustered | gi|145307820|gb|EF392387.1| | 181054 | g32200 | i0 | 93.75 | 16.4871794871795 | 48 | 3 | 18 | 0 | 214 | 261 | 631 | 678 | Eryniopsis caroliniana strain ARSEF 640 28S ribosomal RNA gene, partial sequence | blastn | 4501 | 73.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Eryniopsis | Eryniopsis caroliniana | |
| 8422843 | 8422843 | PRJNA788929_P_NODE_6347_length_762_cov_79.464441_g5729_i0 | PRJNA788929 | 6347 | 762 | 79.464441 | 605.51904042 | Fungi | 4751 | Fungi | Fungi | 125 | 1.36e-29 | NR | RKP37471.1 | 215637 | g5729 | i0 | 43 | 4.26377952755906 | 172 | 75 | 63.4 | 7 | 134 | 616 | 4 | 163 | RKP37471.1 hypothetical protein BJ085DRAFT_18905 [Dimargaris cristalligena] | diamond | 3249 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dimargaris | Dimargaris cristalligena | |
| 9697880 | 9697880 | PRJNA788929_P_NODE_42968_length_239_cov_9.734940_g42307_i0 | PRJNA788929 | 42968 | 239 | 9.73494 | 23.2665066 | Entomophaga aulicae | 39303 | Fungi | Fungi | 195 | 3.37e-45 | NTclustered | gi|1373048|gb|U35394.1|EAU35394 | 39303 | g42307 | i0 | 85.638 | 55.1799163179916 | 188 | 24 | 79 | 3 | 42 | 229 | 4949 | 5133 | Entomophaga aulicae 18S, ITS-1, 5.8S, ITS-2, and 25S ribosomal RNA genes | blastn | 13188 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophaga | Entomophaga aulicae | |
| 12248583 | 12248583 | PRJNA788929_P_NODE_11290_length_523_cov_18.660000_g10636_i0 | PRJNA788929 | 11290 | 523 | 18.66 | 97.5918 | Fungi | 4751 | Fungi | Fungi | 176 | 2.9e-53 | NR | ORX98001.1 | 1314790 | g10636 | i0 | 62.2 | 15.6309751434034 | 135 | 49 | 76.9 | 2 | 89 | 490 | 2 | 135 | ORX98001.1 hypothetical protein K493DRAFT_329371 [Basidiobolus meristosporus CBS 931.73] | diamond | 8175 | 177 | 0.994350282485876 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 27370075 | 27370075 | PRJNA788929_P_NODE_34243_length_266_cov_14.637306_g33582_i0 | PRJNA788929 | 34243 | 266 | 14.637306 | 38.93523396 | Dispira parvispora | 1520584 | Fungi | Fungi | 100 | 2.65e-24 | NR | KAJ1955369.1 | 1520584 | g33582 | i0 | 72.6 | 3.50751879699248 | 62 | 16 | 68.8 | 1 | 26 | 208 | 128 | 189 | KAJ1955369.1 COPII coat GTPase [Dispira parvispora] | diamond | 933 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dispira | Dispira parvispora | |
| 29431067 | 29431067 | PRJNA788929_P_NODE_13569_length_464_cov_47.109974_g12911_i0 | PRJNA788929 | 13569 | 464 | 47.109974 | 218.59027936 | Linderina | 4867 | Fungi | Fungi | 68.2 | 1.05e-11 | NR | KAJ1948796.1 | 4868 | g12911 | i0 | 48 | 1.45474137931034 | 75 | 33 | 45.3 | 2 | 378 | 169 | 24 | 97 | KAJ1948796.1 hypothetical protein FBU59_001427 [Linderina macrospora] | diamond | 675 | 68.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina macrospora | |
| 29895855 | 29895855 | PRJNA788929_P_NODE_23731_length_330_cov_26.490272_g23070_i0 | PRJNA788929 | 23731 | 330 | 26.490272 | 87.4178976 | Zancudomyces culisetae | 1213189 | Fungi | Fungi | 135 | 6.669999999999999e-37 | NR | OMH78741.1 | 1213189 | g23070 | i0 | 71.4 | 3.38181818181818 | 98 | 26 | 87.3 | 1 | 34 | 321 | 76 | 173 | OMH78741.1 60S ribosomal protein L6-3 [Zancudomyces culisetae] | diamond | 1116 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Zancudomyces | Zancudomyces culisetae | |
| 30875175 | 30875175 | PRJNA788929_P_NODE_37614_length_251_cov_19.044944_g36953_i0 | PRJNA788929 | 37614 | 251 | 19.044944 | 47.80280944 | Martensiomyces pterosporus | 61414 | Fungi | Fungi | 62.4 | 2.37e-10 | NR | KAI8325408.1 | 61414 | g36953 | i0 | 64.4 | 0.537848605577689 | 45 | 16 | 53.8 | 0 | 117 | 251 | 2 | 46 | KAI8325408.1 glutaredoxin 1 [Martensiomyces pterosporus] | diamond | 135 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Martensiomyces | Martensiomyces pterosporus | |
| 31349402 | 31349402 | PRJNA788929_P_NODE_15736_length_422_cov_46.257880_g15077_i0 | PRJNA788929 | 15736 | 422 | 46.25788 | 195.2082536 | Dispira parvispora | 1520584 | Fungi | Fungi | 69.7 | 7.83e-13 | NR | KAJ1964106.1 | 1520584 | g15077 | i0 | 47.7 | 0.853080568720379 | 65 | 28 | 41.9 | 1 | 360 | 184 | 1 | 65 | KAJ1964106.1 DNA-directed RNA polymerase core subunit rpc10 [Dispira parvispora] | diamond | 360 | 69.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dispira | Dispira parvispora | |
| 31412563 | 31412563 | PRJNA788929_P_NODE_5116_length_879_cov_51.717122_g4538_i0 | PRJNA788929 | 5116 | 879 | 51.717122 | 454.59350238 | Piptocephalis cylindrospora | 1907219 | Fungi | Fungi | 120 | 8.71e-29 | NR | RKP12125.1 | 1907219 | g4538 | i0 | 30.8 | 2.98976109215017 | 221 | 147 | 74.7 | 3 | 66 | 722 | 1 | 217 | RKP12125.1 vesicle-associated membrane protein [Piptocephalis cylindrospora] | diamond | 2628 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis cylindrospora | |
| 32140166 | 32140166 | PRJNA788929_P_NODE_14438_length_446_cov_3.855228_g13779_i0 | PRJNA788929 | 14438 | 446 | 3.855228 | 17.19431688 | Ramicandelaber brevisporus | 304332 | Fungi | Fungi | 179 | 6.169999999999999e-55 | NR | KAI8870081.1 | 304332 | g13779 | i0 | 61.3 | 0.92152466367713 | 137 | 53 | 92.2 | 0 | 21 | 431 | 2 | 138 | KAI8870081.1 ribosomal protein S19e [Ramicandelaber brevisporus] | diamond | 411 | 179 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Ramicandelaberales | Ramicandelaberaceae | Ramicandelaber | Ramicandelaber brevisporus |
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);;