contig_metadata
10 rows where bioproject = "PRJNA429937", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6803450 | 6803450 | PRJNA429937_P_NODE_118606_length_252_cov_2.219731_g95980_i0 | PRJNA429937 | 118606 | 252 | 2.219731 | 5.59372212 | Entomophaga aulicae | 39303 | Fungi | Fungi | 63.9 | 1.06e-5 | NTclustered | gi|1373048|gb|U35394.1|EAU35394 | 39303 | g95980 | i0 | 93.182 | 0.174603174603175 | 44 | 2 | 17 | 1 | 66 | 108 | 6017 | 6060 | Entomophaga aulicae 18S, ITS-1, 5.8S, ITS-2, and 25S ribosomal RNA genes | blastn | 44 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophaga | Entomophaga aulicae | |
| 18277524 | 18277524 | PRJNA429937_P_NODE_135355_length_213_cov_26.445652_g112728_i0 | PRJNA429937 | 135355 | 213 | 26.445652 | 56.32923876 | Entomophthora culicis | 181049 | Fungi | Fungi | 241 | 3.7300000000000004e-59 | NTclustered | gi|20385355|gb|AF368516.1| | 181049 | g112728 | i0 | 97.857 | 65.7276995305164 | 140 | 1 | 65 | 2 | 76 | 213 | 1858 | 1719 | Entomophthora culicis small subunit ribosomal RNA gene, partial sequence | blastn | 14000 | 241 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora culicis | |
| 26791002 | 26791002 | PRJNA429937_P_NODE_57641_length_459_cov_3.246512_g13217_i1 | PRJNA429937 | 57641 | 459 | 3.246512 | 14.90149008 | Entomophthora muscae | 34485 | Fungi | Fungi | 72.4 | 8.07e-12 | NR | KAJ9073612.1 | 34485 | g13217 | i1 | 41.4 | 1.94117647058824 | 99 | 42 | 54.2 | 1 | 11 | 259 | 99 | 197 | KAJ9073612.1 DNA damage-inducible protein 1 [Entomophthora muscae] | diamond | 891 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 27644633 | 27644633 | PRJNA429937_P_NODE_88304_length_339_cov_2.361290_g65737_i0 | PRJNA429937 | 88304 | 339 | 2.36129 | 8.0047731 | Entomophthora muscae | 34485 | Fungi | Fungi | 61.2 | 1.91e-9 | NR | KAJ9086005.1 | 34485 | g65737 | i0 | 49.1 | 0.48672566371681403 | 55 | 28 | 48.7 | 0 | 169 | 5 | 42 | 96 | KAJ9086005.1 hypothetical protein DSO57_1008520 [Entomophthora muscae] | diamond | 165 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 27991816 | 27991816 | PRJNA429937_P_NODE_152625_length_172_cov_2.545455_g129998_i0 | PRJNA429937 | 152625 | 172 | 2.545455 | 4.3781826 | Entomophthora muscae | 34485 | Fungi | Fungi | 53.1 | 1.34e-6 | NR | KAJ9069702.1 | 34485 | g129998 | i0 | 60 | 3.6453488372093 | 40 | 16 | 69.8 | 0 | 123 | 4 | 2 | 41 | KAJ9069702.1 hypothetical protein DSO57_1015781 [Entomophthora muscae] | diamond | 627 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 28180877 | 28180877 | PRJNA429937_P_NODE_24866_length_736_cov_4.905233_g14417_i1 | PRJNA429937 | 24866 | 736 | 4.905233 | 36.10251488 | Entomophthora muscae | 34485 | Fungi | Fungi | 75.9 | 8.05e-12 | NR | KAJ9071155.1 | 34485 | g14417 | i1 | 27.5 | 0.68070652173913 | 167 | 121 | 68.1 | 0 | 5 | 505 | 210 | 376 | KAJ9071155.1 DNA damage-inducible protein 1 [Entomophthora muscae] | diamond | 501 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 28749498 | 28749498 | PRJNA429937_P_NODE_62747_length_434_cov_3.624691_g13217_i2 | PRJNA429937 | 62747 | 434 | 3.624691 | 15.73115894 | Entomophthora muscae | 34485 | Fungi | Fungi | 82.8 | 9.25e-16 | NR | KAJ9073612.1 | 34485 | g13217 | i2 | 50 | 1.46543778801843 | 78 | 39 | 53.9 | 0 | 434 | 201 | 120 | 197 | KAJ9073612.1 DNA damage-inducible protein 1 [Entomophthora muscae] | diamond | 636 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 28844002 | 28844002 | PRJNA429937_P_NODE_22248_length_780_cov_3.009321_g13217_i0 | PRJNA429937 | 22248 | 780 | 3.009321 | 23.4727038 | Entomophthora muscae | 34485 | Fungi | Fungi | 83.6 | 2.86e-14 | NR | KAJ9060048.1 | 34485 | g13217 | i0 | 28 | 0.823076923076923 | 214 | 117 | 71.2 | 7 | 23 | 577 | 144 | 349 | KAJ9060048.1 hypothetical protein DSO57_1035039 [Entomophthora muscae] | diamond | 642 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 30675841 | 30675841 | PRJNA429937_P_NODE_105233_length_287_cov_3.062016_g82615_i0 | PRJNA429937 | 105233 | 287 | 3.062016 | 8.78798592 | Entomophthora muscae | 34485 | Fungi | Fungi | 44.3 | 0.00859 | NR | KAJ9073373.1 | 34485 | g82615 | i0 | 46.5 | 0.898954703832753 | 43 | 23 | 44.9 | 0 | 3 | 131 | 12 | 54 | KAJ9073373.1 hypothetical protein DSO57_1017253 [Entomophthora muscae] | diamond | 258 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 32542090 | 32542090 | PRJNA429937_P_NODE_24139_length_747_cov_4.863510_g14417_i0 | PRJNA429937 | 24139 | 747 | 4.86351 | 36.3304197 | Entomophthora muscae | 34485 | Fungi | Fungi | 48.1 | 0.0218 | NR | KAJ9069750.1 | 34485 | g14417 | i0 | 36.1 | 0.979919678714859 | 61 | 39 | 24.5 | 0 | 334 | 516 | 339 | 399 | KAJ9069750.1 hypothetical protein DSO57_1015434 [Entomophthora muscae] | diamond | 732 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae |
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);;