contig_metadata
6 rows where bioproject = "PRJNA682370", tax_clade = "Amoebozoa" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4492555 | 4492555 | PRJNA682370_S_NODE_9684_length_236_cov_2.258706_g9072_i0 | PRJNA682370 | 9684 | 236 | 2.258706 | 5.33054616 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 226 | 1.18e-54 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g9072 | i0 | 84.188 | 38.6228813559322 | 234 | 35 | 99 | 2 | 1 | 233 | 2390 | 2158 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 9115 | 226 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27840011 | 27840011 | PRJNA682370_S_NODE_16424_length_177_cov_1.112676_g15812_i0 | PRJNA682370 | 16424 | 177 | 1.112676 | 1.96943652 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 70.5 | 1.28e-12 | NR | XP_004341414.1 | 1257118 | g15812 | i0 | 61.1 | 0.915254237288136 | 54 | 20 | 91.5 | 1 | 3 | 164 | 77 | 129 | XP_004341414.1 Factin-capping protein subunit alpha-2, putative [Acanthamoeba castellanii str. Neff] | diamond | 162 | 70.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28029773 | 28029773 | PRJNA682370_S_NODE_17305_length_172_cov_1.751825_g16693_i0 | PRJNA682370 | 17305 | 172 | 1.751825 | 3.013139 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 84.7 | 6.49e-20 | NR | XP_004336976.1 | 1257118 | g16693 | i0 | 77.2 | 0.994186046511628 | 57 | 13 | 99.4 | 0 | 2 | 172 | 9 | 65 | XP_004336976.1 major vault protein [Acanthamoeba castellanii str. Neff] | diamond | 171 | 84.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28345377 | 28345377 | PRJNA682370_S_NODE_11746_length_211_cov_2.460227_g11134_i0 | PRJNA682370 | 11746 | 211 | 2.460227 | 5.19107897 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 67.8 | 3.52e-11 | NR | XP_004341947.1 | 1257118 | g11134 | i0 | 53.5 | 1.00947867298578 | 71 | 31 | 98.1 | 1 | 3 | 209 | 234 | 304 | XP_004341947.1 gelation factor, putative [Acanthamoeba castellanii str. Neff] | diamond | 213 | 67.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28440258 | 28440258 | PRJNA682370_S_NODE_13946_length_192_cov_1.662420_g13334_i0 | PRJNA682370 | 13946 | 192 | 1.66242 | 3.1918464 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 87.4 | 2.94e-19 | NR | XP_004349741.1 | 1257118 | g13334 | i0 | 61.9 | 1.96875 | 63 | 24 | 98.4 | 0 | 3 | 191 | 58 | 120 | XP_004349741.1 uncharacterized protein ACA1_034610 [Acanthamoeba castellanii str. Neff] | diamond | 378 | 87.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29355892 | 29355892 | PRJNA682370_S_NODE_8989_length_248_cov_1.685446_g8377_i0 | PRJNA682370 | 8989 | 248 | 1.685446 | 4.17990608 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 43.1 | 0.0282 | NR | XP_004338989.1 | 1257118 | g8377 | i0 | 39.7 | 0.762096774193548 | 63 | 32 | 69 | 1 | 247 | 77 | 373 | 435 | XP_004338989.1 encystationmediating serine proteinase [Acanthamoeba castellanii str. Neff] | diamond | 189 | 43.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;