contig_metadata
4 rows where bioproject = "PRJNA760904", tax_phylum = "Nanobdellota" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26895117 | 26895117 | PRJNA760904_P_NODE_4621_length_393_cov_0.865625_g4564_i0 | PRJNA760904 | 4621 | 393 | 0.865625 | 3.40190625 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 44.3 | 0.0485 | NR | HLC56299.1 | 2910166 | g4564 | i0 | 29.7 | 0.694656488549618 | 91 | 60 | 66.4 | 1 | 1 | 261 | 219 | 309 | HLC56299.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Nanoarchaeia archaeon] | diamond | 273 | 44.3 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 27685245 | 27685245 | PRJNA760904_P_NODE_10504_length_283_cov_1.433333_g10447_i0 | PRJNA760904 | 10504 | 283 | 1.433333 | 4.05633239 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 47.8 | 9.32e-4 | NR | MBU1202049.1 | 2026764 | g10447 | i0 | 35.6 | 1.8339222614841 | 87 | 55 | 92.2 | 1 | 269 | 9 | 2 | 87 | MBU1202049.1 ADP-ribosylglycohydrolase family protein [Nanoarchaeota archaeon] | diamond | 519 | 47.8 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32139595 | 32139595 | PRJNA760904_P_NODE_5518_length_366_cov_1.273038_g5461_i0 | PRJNA760904 | 5518 | 366 | 1.273038 | 4.65931908 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 92.8 | 1.54e-20 | NR | HLD04877.1 | 2910166 | g5461 | i0 | 52.9 | 0.713114754098361 | 87 | 39 | 71.3 | 1 | 264 | 4 | 8 | 92 | HLD04877.1 molybdopterin-dependent oxidoreductase [Candidatus Nanoarchaeia archaeon] | diamond | 261 | 92.8 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia archaeon | |||||
| 32202833 | 32202833 | PRJNA760904_P_NODE_4138_length_411_cov_2.715976_g4081_i0 | PRJNA760904 | 4138 | 411 | 2.715976 | 11.16266136 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 45.1 | 0.0315 | NR | MCH8003957.1 | 2026764 | g4081 | i0 | 28.5 | 0.897810218978102 | 123 | 71 | 79.6 | 3 | 355 | 29 | 70 | 189 | MCH8003957.1 aldehyde dehydrogenase family protein [Nanoarchaeota archaeon] | diamond | 369 | 45.1 | 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);;