contig_metadata
12 rows where bioproject = "PRJNA1120060" and tax_phylum = "Candidatus Bathyarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5374459 | 5374459 | PRJNA1120060_P_NODE_803585_length_320_cov_1.502024_g785697_i0 | PRJNA1120060 | 803585 | 320 | 1.502024 | 4.8064768 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 52.8 | 0.03 | NTclustered | gi|2874254015|emb|OY970340.1| | 2026714 | g785697 | i0 | 100 | 0.0875 | 28 | 0 | 9 | 0 | 48 | 75 | 2174934 | 2174907 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD04492.bin.c.5 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27859202 | 27859202 | PRJNA1120060_P_NODE_3397585_length_216_cov_6.111888_g3379465_i0 | PRJNA1120060 | 3397585 | 216 | 6.111888 | 13.20167808 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 43.5 | 0.00171 | NR | MCK4424884.1 | 2026714 | g3379465 | i0 | 29.7 | 0.888888888888889 | 64 | 45 | 88.9 | 0 | 194 | 3 | 4 | 67 | MCK4424884.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 192 | 43.5 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 28080278 | 28080278 | PRJNA1120060_P_NODE_3492225_length_207_cov_6.776119_g3474099_i0 | PRJNA1120060 | 3492225 | 207 | 6.776119 | 14.02656633 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 42.4 | 0.0303 | NR | MCK4477139.1 | 2026714 | g3474099 | i0 | 33.9 | 0.855072463768116 | 59 | 39 | 85.5 | 0 | 24 | 200 | 101 | 159 | MCK4477139.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 177 | 42.4 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 28680328 | 28680328 | PRJNA1120060_P_NODE_3259547_length_228_cov_8.219355_g3241439_i0 | PRJNA1120060 | 3259547 | 228 | 8.219355 | 18.7401294 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 42.7 | 0.0303 | NR | MBS7649192.1 | 2026714 | g3241439 | i0 | 31.3 | 0.842105263157895 | 64 | 43 | 84.2 | 1 | 223 | 32 | 229 | 291 | MBS7649192.1 glycine--tRNA ligase [Candidatus Bathyarchaeota archaeon] | diamond | 192 | 42.7 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 29657998 | 29657998 | PRJNA1120060_P_NODE_2340850_length_259_cov_4.666667_g2322789_i0 | PRJNA1120060 | 2340850 | 259 | 4.666667 | 12.08666753 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 42.7 | 0.0408 | NR | HMK82860.1 | 3045160 | g2322789 | i0 | 32.5 | 0.463320463320463 | 40 | 27 | 46.3 | 0 | 201 | 82 | 199 | 238 | HMK82860.1 PrsW family glutamic-type intramembrane protease [Candidatus Bathyarchaeia archaeon] | diamond | 120 | 42.7 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 29879469 | 29879469 | PRJNA1120060_P_NODE_2131671_length_267_cov_3.907216_g2113625_i0 | PRJNA1120060 | 2131671 | 267 | 3.907216 | 10.43226672 | Candidatus Hecatella orcuttiae | 1935119 | Archaea | Archaea | 43.5 | 0.00834 | NR | WP_309492366.1 | 1935119 | g2113625 | i0 | 36.7 | 0.674157303370786 | 60 | 38 | 67.4 | 0 | 266 | 87 | 42 | 101 | WP_309492366.1 reverse transcriptase-like protein [Candidatus Hecatella orcuttiae] | diamond | 180 | 43.5 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Hecatellales | Candidatus Hecatellaceae | Candidatus Hecatella | Candidatus Hecatella orcuttiae | ||
| 30827569 | 30827569 | PRJNA1120060_P_NODE_2851094_length_245_cov_0.901163_g2833008_i0 | PRJNA1120060 | 2851094 | 245 | 0.901163 | 2.20784935 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 42 | 0.0335 | NR | MBM3292037.1 | 2026714 | g2833008 | i0 | 32.3 | 0.795918367346939 | 65 | 41 | 75.9 | 1 | 220 | 35 | 72 | 136 | MBM3292037.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 195 | 42 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 31111545 | 31111545 | PRJNA1120060_P_NODE_2582935_length_251_cov_2.769663_g2564858_i0 | PRJNA1120060 | 2582935 | 251 | 2.769663 | 6.95185413 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 43.5 | 0.0201 | NR | MCK4400306.1 | 2026714 | g2564858 | i0 | 48.8 | 0.9800796812749 | 41 | 19 | 49 | 1 | 237 | 115 | 171 | 209 | MCK4400306.1 DUF169 domain-containing protein [Candidatus Bathyarchaeota archaeon] | diamond | 246 | 43.5 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 31522181 | 31522181 | PRJNA1120060_P_NODE_1419416_length_297_cov_2.830357_g1401434_i0 | PRJNA1120060 | 1419416 | 297 | 2.830357 | 8.40616029 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 42.7 | 0.0205 | NR | MEJ2240569.1 | 2026714 | g1401434 | i0 | 43.8 | 0.323232323232323 | 32 | 18 | 32.3 | 0 | 112 | 207 | 59 | 90 | MEJ2240569.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 96 | 42.7 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 31649895 | 31649895 | PRJNA1120060_P_NODE_591057_length_350_cov_2.425993_g573337_i0 | PRJNA1120060 | 591057 | 350 | 2.425993 | 8.4909755 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 44.3 | 0.0258 | NR | MBC8223020.1 | 2026714 | g573337 | i0 | 34.9 | 0.54 | 63 | 39 | 52.3 | 2 | 272 | 90 | 19 | 81 | MBC8223020.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 189 | 44.3 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32218291 | 32218291 | PRJNA1120060_P_NODE_1678718_length_286_cov_1.295775_g1660717_i0 | PRJNA1120060 | 1678718 | 286 | 1.295775 | 3.7059165 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 43.9 | 0.0232 | NR | MCD6239898.1 | 2026714 | g1660717 | i0 | 35.8 | 1.6993006993007 | 81 | 46 | 80.8 | 2 | 285 | 55 | 214 | 292 | MCD6239898.1 pyridoxal-phosphate dependent enzyme [Candidatus Bathyarchaeota archaeon] | diamond | 486 | 43.9 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32251142 | 32251142 | PRJNA1120060_P_NODE_3086298_length_236_cov_6.251534_g3068197_i0 | PRJNA1120060 | 3086298 | 236 | 6.251534 | 14.75362024 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 42.4 | 0.0376 | NR | HMK84018.1 | 3045160 | g3068197 | i0 | 28.2 | 0.902542372881356 | 71 | 51 | 90.3 | 0 | 13 | 225 | 74 | 144 | HMK84018.1 LysE family transporter [Candidatus Bathyarchaeia archaeon] | diamond | 213 | 42.4 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon |
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);;