contig_metadata
9 rows where bioproject = "PRJNA1237347", tax_kingdom = "Nanobdellati" and tax_phylum = "Nanobdellota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27407868 | 27407868 | PRJNA1237347_P_NODE_331903_length_313_cov_2.745833_g325330_i0 | PRJNA1237347 | 331903 | 313 | 2.745833 | 8.59445729 | root | 1 | Root_unresolved | Root_unresolved | 122 | 5.489999999999999e-31 | NR | MDE1848693.1 | 2026764 | g325330 | i0 | 58 | 4.77316293929712 | 100 | 42 | 95.8 | 0 | 313 | 14 | 153 | 252 | MDE1848693.1 cysteine desulfurase [Nanoarchaeota archaeon] | diamond | 1494 | 122 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 28683963 | 28683963 | PRJNA1237347_P_NODE_393827_length_282_cov_1.473684_g387254_i0 | PRJNA1237347 | 393827 | 282 | 1.473684 | 4.15578888 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 45.1 | 0.00913 | NR | MFC1801664.1 | 2026764 | g387254 | i0 | 41.2 | 0.723404255319149 | 68 | 31 | 62.8 | 3 | 61 | 237 | 356 | 423 | MFC1801664.1 metallophosphoesterase [Nanoarchaeota archaeon] | diamond | 204 | 45.1 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 28809590 | 28809590 | PRJNA1237347_P_NODE_309128_length_328_cov_1.145098_g302555_i0 | PRJNA1237347 | 309128 | 328 | 1.145098 | 3.75592144 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 76.3 | 1.73e-13 | NR | MBU2639138.1 | 2026764 | g302555 | i0 | 53.1 | 0.585365853658537 | 64 | 30 | 58.5 | 0 | 5 | 196 | 260 | 323 | MBU2639138.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 192 | 76.3 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29820284 | 29820284 | PRJNA1237347_P_NODE_445031_length_261_cov_1.595745_g438458_i0 | PRJNA1237347 | 445031 | 261 | 1.595745 | 4.16489445 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 45.8 | 0.00337 | NR | MFC1690596.1 | 2026764 | g438458 | i0 | 35.7 | 1.54022988505747 | 70 | 41 | 80.5 | 2 | 13 | 222 | 12 | 77 | MFC1690596.1 exosome complex protein Rrp42 [Nanoarchaeota archaeon] | diamond | 402 | 45.8 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 30609845 | 30609845 | PRJNA1237347_P_NODE_188513_length_451_cov_1.293651_g181941_i0 | PRJNA1237347 | 188513 | 451 | 1.293651 | 5.83436601 | Nanopusillaceae archaeon | 3058032 | Archaea | Archaea | 107 | 8.85e-24 | NR | MEM1684651.1 | 3058032 | g181941 | i0 | 44.1 | 0.784922394678492 | 118 | 66 | 78.5 | 0 | 3 | 356 | 578 | 695 | MEM1684651.1 phage/plasmid primase, P4 family [Nanopusillaceae archaeon] | diamond | 354 | 107 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Nanoarchaeales | Nanopusillaceae | Nanopusillaceae archaeon | |||
| 32033101 | 32033101 | PRJNA1237347_P_NODE_420458_length_271_cov_1.555556_g413885_i0 | PRJNA1237347 | 420458 | 271 | 1.555556 | 4.21555676 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 73.6 | 7.72e-13 | NR | HJZ18565.1 | 2910166 | g413885 | i0 | 52.2 | 0.74169741697417 | 67 | 32 | 74.2 | 0 | 258 | 58 | 383 | 449 | HJZ18565.1 beta-propeller fold lactonase family protein [Candidatus Nanoarchaeia archaeon] | diamond | 201 | 73.6 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 32064871 | 32064871 | PRJNA1237347_P_NODE_97678_length_691_cov_827.786408_g91320_i0 | PRJNA1237347 | 97678 | 691 | 827.786408 | 5720.00407928 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 126 | 1.25e-33 | NR | MCA9460427.1 | 2026764 | g91320 | i0 | 86.1 | 0.342981186685962 | 79 | 11 | 34.3 | 0 | 361 | 125 | 2 | 80 | MCA9460427.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 237 | 126 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32381129 | 32381129 | PRJNA1237347_P_NODE_364639_length_295_cov_2.427928_g358066_i0 | PRJNA1237347 | 364639 | 295 | 2.427928 | 7.1623876 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 77.4 | 1.99e-14 | NR | MFC1697278.1 | 2026764 | g358066 | i0 | 54.2 | 0.732203389830508 | 72 | 31 | 71.2 | 1 | 84 | 293 | 103 | 174 | MFC1697278.1 DUF1152 domain-containing protein [Nanoarchaeota archaeon] | diamond | 216 | 77.4 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32571098 | 32571098 | PRJNA1237347_P_NODE_33819_length_1331_cov_2.710652_g30010_i0 | PRJNA1237347 | 33819 | 1331 | 2.710652 | 36.07877812 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 111 | 5.08e-22 | NR | MEK6761049.1 | 2026764 | g30010 | i0 | 24.3 | 0.797896318557476 | 354 | 220 | 78.4 | 11 | 1217 | 174 | 23 | 334 | MEK6761049.1 aminopeptidase N [Nanoarchaeota archaeon] | diamond | 1062 | 111 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota 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);;