contig_metadata
4 rows where bioproject = "PRJNA784298" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26841638 | 26841638 | PRJNA784298_P_NODE_6541_length_496_cov_1.456265_g6341_i0 | PRJNA784298 | 6541 | 496 | 1.456265 | 7.2230744 | root | 1 | Root_unresolved | Root_unresolved | 217 | 1.44e-63 | NR | MEK6828559.1 | 2026764 | g6341 | i0 | 61.2 | 3 | 165 | 63 | 99.2 | 1 | 1 | 492 | 466 | 630 | MEK6828559.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 1488 | 219 | 0.990867579908676 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32235308 | 32235308 | PRJNA784298_P_NODE_9098_length_418_cov_1.689855_g8897_i0 | PRJNA784298 | 9098 | 418 | 1.689855 | 7.0635939 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 194 | 2.2999999999999998e-55 | NR | MEK6828559.1 | 2026764 | g8897 | i0 | 64 | 0.997607655502392 | 139 | 49 | 99 | 1 | 416 | 3 | 435 | 573 | MEK6828559.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 417 | 194 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32520011 | 32520011 | PRJNA784298_P_NODE_7679_length_454_cov_5.695538_g7478_i0 | PRJNA784298 | 7679 | 454 | 5.695538 | 25.85774252 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 72.8 | 1.6e-12 | NR | MEK6832572.1 | 2026764 | g7478 | i0 | 68.9 | 0.297356828193833 | 45 | 14 | 29.7 | 0 | 137 | 3 | 1 | 45 | MEK6832572.1 RNA ligase family protein [Nanoarchaeota archaeon] | diamond | 135 | 72.8 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 32843991 | 32843991 | PRJNA784298_P_NODE_14020_length_333_cov_2.119231_g13819_i0 | PRJNA784298 | 14020 | 333 | 2.119231 | 7.05703923 | root | 1 | Root_unresolved | Root_unresolved | 82.8 | 7.79e-16 | NR | MEK6959777.1 | 2026764 | g13819 | i0 | 50 | 4.04504504504505 | 96 | 47 | 85.6 | 1 | 290 | 6 | 68 | 163 | MEK6959777.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 1347 | 82.8 | 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);;