contig_metadata
9 rows where bioproject = "PRJNA827593" and tax_phylum = "Heterolobosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4649604 | 4649604 | PRJNA827593_P_NODE_3904_length_1167_cov_2.050274_g3689_i0 | PRJNA827593 | 3904 | 1167 | 2.050274 | 23.92669758 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 269 | 1.45e-76 | NR | XP_002672840.1 | 5762 | g3689 | i0 | 57.6 | 1.22622107969152 | 238 | 83 | 56.6 | 3 | 662 | 3 | 164 | 401 | XP_002672840.1 uncharacterized protein NAEGRDRAFT_59151 [Naegleria gruberi] | diamond | 1431 | 269 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 9748991 | 9748991 | PRJNA827593_P_NODE_24508_length_424_cov_2.552707_g24209_i0 | PRJNA827593 | 24508 | 424 | 2.552707 | 10.82347768 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 119 | 5.58e-28 | NR | NP_066511.1 | 5762 | g24209 | i0 | 44.4 | 1.0188679245283 | 144 | 54 | 99.1 | 2 | 1 | 420 | 132 | 253 | NP_066511.1 NADH dehydrogenase subunit 5 [Naegleria gruberi] | diamond | 432 | 119 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 14849096 | 14849096 | PRJNA827593_P_NODE_31072_length_370_cov_4.895623_g30773_i0 | PRJNA827593 | 31072 | 370 | 4.895623 | 18.1138051 | Stachyamoeba lipophora | 463046 | Heterolobosea | other_Eukaryota | 140 | 8.58e-36 | NR | YP_009118152.1 | 463046 | g30773 | i0 | 55.7 | 0.989189189189189 | 122 | 54 | 98.9 | 0 | 4 | 369 | 23 | 144 | YP_009118152.1 NADH dehydrogenase subunit 5 [Stachyamoeba lipophora] | diamond | 366 | 140 | 1 | Eukaryota | Discoba | Heterolobosea | Gruberellidae | Stachyamoeba | Stachyamoeba lipophora | ||||
| 22498358 | 22498358 | PRJNA827593_P_NODE_61178_length_251_cov_0.865169_g60879_i0 | PRJNA827593 | 61178 | 251 | 0.865169 | 2.17157419 | Stachyamoeba lipophora | 463046 | Heterolobosea | other_Eukaryota | 124 | 1.02e-31 | NR | YP_009118164.1 | 463046 | g60879 | i0 | 66.3 | 1.94820717131474 | 83 | 28 | 99.2 | 0 | 3 | 251 | 177 | 259 | YP_009118164.1 apocytochrome b [Stachyamoeba lipophora] | diamond | 489 | 124 | 1 | Eukaryota | Discoba | Heterolobosea | Gruberellidae | Stachyamoeba | Stachyamoeba lipophora | ||||
| 29012743 | 29012743 | PRJNA827593_P_NODE_17568_length_512_cov_1.920273_g17270_i0 | PRJNA827593 | 17568 | 512 | 1.920273 | 9.83179776 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 84.3 | 6.42e-16 | NR | KAL0491076.1 | 1008807 | g17270 | i0 | 71.4 | 0.287109375 | 49 | 14 | 28.7 | 0 | 198 | 52 | 262 | 310 | KAL0491076.1 ubiquitin-like 1-activating enzyme E1 [Acrasis kona] | diamond | 147 | 84.3 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 29264885 | 29264885 | PRJNA827593_P_NODE_48709_length_287_cov_1.757009_g48410_i0 | PRJNA827593 | 48709 | 287 | 1.757009 | 5.04261583 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 56.2 | 1.18e-6 | NR | XP_002679547.1 | 5762 | g48410 | i0 | 61.1 | 1.31707317073171 | 36 | 14 | 37.6 | 0 | 283 | 176 | 203 | 238 | XP_002679547.1 uncharacterized protein NAEGRDRAFT_57455 [Naegleria gruberi] | diamond | 378 | 56.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30528421 | 30528421 | PRJNA827593_P_NODE_66913_length_242_cov_2.047337_g66614_i0 | PRJNA827593 | 66913 | 242 | 2.047337 | 4.95455554 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 76.3 | 5.45e-14 | NR | YP_007890052.1 | 5763 | g66614 | i0 | 57 | 0.979338842975207 | 79 | 33 | 97.9 | 1 | 3 | 239 | 336 | 413 | YP_007890052.1 NADH dehydrogenase subunit 4 [Naegleria fowleri] | diamond | 237 | 76.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 31729619 | 31729619 | PRJNA827593_P_NODE_7637_length_808_cov_2.778231_g7364_i0 | PRJNA827593 | 7637 | 808 | 2.778231 | 22.44810648 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 82.8 | 9.93e-14 | NR | CAG4708788.1 | 5763 | g7364 | i0 | 23.8 | 0.998762376237624 | 269 | 187 | 98.8 | 5 | 3 | 800 | 1097 | 1350 | CAG4708788.1 unnamed protein product [Naegleria fowleri] | diamond | 807 | 82.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 31824361 | 31824361 | PRJNA827593_P_NODE_3937_length_1160_cov_2.683533_g3722_i0 | PRJNA827593 | 3937 | 1160 | 2.683533 | 31.1289828 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 207 | 5.0299999999999993e-57 | NR | KAL0491389.1 | 1008807 | g3722 | i0 | 39.9 | 1.60086206896552 | 308 | 173 | 78.1 | 5 | 12 | 917 | 28 | 329 | KAL0491389.1 NHL repeat-containing protein, partial [Acrasis kona] | diamond | 1857 | 207 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona |
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);;