contig_metadata
8 rows where bioproject = "PRJNA340009", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9319920 | 9319920 | PRJNA340009_P_NODE_16448_length_294_cov_1.902041_g16141_i0 | PRJNA340009 | 16448 | 294 | 1.902041 | 5.59200054 | Entomophaga aulicae | 39303 | Fungi | Fungi | 512 | 1.04e-140 | NTclustered | gi|1373048|gb|U35394.1|EAU35394 | 39303 | g16141 | i0 | 99.296 | 5.47959183673469 | 284 | 0 | 97 | 1 | 11 | 294 | 4555 | 4836 | Entomophaga aulicae 18S, ITS-1, 5.8S, ITS-2, and 25S ribosomal RNA genes | blastn | 1611 | 512 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophaga | Entomophaga aulicae | |
| 14420733 | 14420733 | PRJNA340009_P_NODE_20472_length_267_cov_2.834862_g20165_i0 | PRJNA340009 | 20472 | 267 | 2.834862 | 7.56908154 | Harpella melusinae | 370264 | Fungi | Fungi | 110 | 1.43e-19 | NTclustered | gi|666440445|gb|KF848904.1| | 370264 | g20165 | i0 | 84.874 | 19.6741573033708 | 119 | 7 | 44 | 6 | 150 | 267 | 2851 | 2743 | Harpella melusinae 28S ribosomal RNA gene, partial sequence | blastn | 5253 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Harpella | Harpella melusinae | |
| 14421162 | 14421162 | PRJNA340009_P_NODE_60752_length_168_cov_1.714286_g60445_i0 | PRJNA340009 | 60752 | 168 | 1.714286 | 2.88000048 | Kickxella alabastrina | 61397 | Fungi | Fungi | 102 | 1.38e-17 | NTclustered | gi|2323997718|ref|XM_051533246.1| | 61397 | g60445 | i0 | 81.102 | 1.60714285714286 | 127 | 24 | 76 | 0 | 26 | 152 | 1110 | 1236 | Kickxella alabastrina pseudouridine synthase (BX661DRAFT_153), mRNA | blastn | 270 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 19518141 | 19518141 | PRJNA340009_P_NODE_5296_length_467_cov_3.607656_g4989_i0 | PRJNA340009 | 5296 | 467 | 3.607656 | 16.84775352 | Spiromyces aspiralis | 68401 | Fungi | Fungi | 222 | 9.700000000000001e-72 | NR | KAJ1676764.1 | 68401 | g4989 | i0 | 74.1 | 6.41755888650964 | 143 | 34 | 90.6 | 2 | 1 | 423 | 12 | 153 | KAJ1676764.1 Peptidyl-prolyl cis-trans isomerase 7, partial [Spiromyces aspiralis] | diamond | 2997 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces aspiralis | |
| 27200946 | 27200946 | PRJNA340009_P_NODE_43962_length_193_cov_2.486111_g43655_i0 | PRJNA340009 | 43962 | 193 | 2.486111 | 4.79819423 | Coemansia erecta | 147472 | Fungi | Fungi | 86.3 | 5.1e-18 | NR | KAJ2830554.1 | 147472 | g43655 | i0 | 62.5 | 6.96373056994819 | 64 | 24 | 99.5 | 0 | 193 | 2 | 269 | 332 | KAJ2830554.1 actin [Coemansia erecta] | diamond | 1344 | 86.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia erecta | |
| 30692155 | 30692155 | PRJNA340009_P_NODE_43273_length_194_cov_9.455172_g42966_i0 | PRJNA340009 | 43273 | 194 | 9.455172 | 18.34303368 | Fungi | 4751 | Fungi | Fungi | 94 | 1.78e-20 | NR | KAJ2832533.1 | 417177 | g42966 | i0 | 67.2 | 30.7886597938144 | 64 | 21 | 99 | 0 | 3 | 194 | 1540 | 1603 | KAJ2832533.1 AAA ATPase midasin, partial [Coemansia furcata] | diamond | 5973 | 94.7 | 0.992608236536431 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia furcata | |
| 30913586 | 30913586 | PRJNA340009_P_NODE_55154_length_175_cov_52.888889_g54847_i0 | PRJNA340009 | 55154 | 175 | 52.888889 | 92.55555575 | Fungi | 4751 | Fungi | Fungi | 70.9 | 4.1e-13 | NR | RKP10519.1 | 78915 | g54847 | i0 | 64.6 | 3.29142857142857 | 48 | 17 | 82.3 | 0 | 165 | 22 | 167 | 214 | RKP10519.1 60S ribosomal protein L10-A [Thamnocephalis sphaerospora] | diamond | 576 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Sigmoideomycetaceae | Thamnocephalis | Thamnocephalis sphaerospora | |
| 32855768 | 32855768 | PRJNA340009_P_NODE_80520_length_152_cov_7.961165_g80213_i0 | PRJNA340009 | 80520 | 152 | 7.961165 | 12.1009708 | Kickxella alabastrina | 61397 | Fungi | Fungi | 67 | 7.09e-12 | NR | KAJ1893545.1 | 61397 | g80213 | i0 | 82.4 | 3.35526315789474 | 34 | 6 | 67.1 | 0 | 150 | 49 | 156 | 189 | KAJ1893545.1 AP-1 adaptor complex mu subunit Apm1 [Kickxella alabastrina] | diamond | 510 | 67 | 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);;