contig_metadata
8 rows where bioproject = "PRJEB28062", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15327595 | 15327595 | PRJEB28062_P_NODE_74533_length_395_cov_11.437888_g72171_i0 | PRJEB28062 | 74533 | 395 | 11.437888 | 45.1796576 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 87.8 | 3.55e-17 | NR | MDO8508354.1 | 2026764 | g72171 | i0 | 72.9 | 2.24050632911392 | 59 | 16 | 44.8 | 0 | 68 | 244 | 125 | 183 | MDO8508354.1 ATP-dependent helicase [Nanoarchaeota archaeon] | diamond | 885 | 87.8 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 26780107 | 26780107 | PRJEB28062_P_NODE_54401_length_479_cov_19.610837_g52048_i0 | PRJEB28062 | 54401 | 479 | 19.610837 | 93.93590923 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 105 | 1.93e-23 | NR | MEK6899278.1 | 2026764 | g52048 | i0 | 84.1 | 0.394572025052192 | 63 | 10 | 39.5 | 0 | 270 | 458 | 57 | 119 | MEK6899278.1 glycosyltransferase [Nanoarchaeota archaeon] | diamond | 189 | 105 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 27854481 | 27854481 | PRJEB28062_P_NODE_58005_length_461_cov_7.610825_g55647_i0 | PRJEB28062 | 58005 | 461 | 7.610825 | 35.08590325 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 93.2 | 1.06e-19 | NR | MEK6915668.1 | 2026764 | g55647 | i0 | 87.8 | 0.318872017353579 | 49 | 6 | 31.9 | 0 | 445 | 299 | 222 | 270 | MEK6915668.1 RNA-binding protein [Nanoarchaeota archaeon] | diamond | 147 | 93.2 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29370131 | 29370131 | PRJEB28062_P_NODE_52909_length_487_cov_26.678744_g50556_i0 | PRJEB28062 | 52909 | 487 | 26.678744 | 129.92548328 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 60.1 | 1.3e-8 | NR | MEK6829150.1 | 2026764 | g50556 | i0 | 55.2 | 0.412731006160164 | 67 | 18 | 40.7 | 3 | 231 | 34 | 1 | 56 | MEK6829150.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 201 | 60.1 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29843666 | 29843666 | PRJEB28062_P_NODE_17671_length_900_cov_3.390568_g15710_i0 | PRJEB28062 | 17671 | 900 | 3.390568 | 30.515112 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 162 | 2.5e-42 | NR | MBU0907448.1 | 2026764 | g15710 | i0 | 46 | 0.63 | 189 | 90 | 61.7 | 3 | 25 | 579 | 6 | 186 | MBU0907448.1 ATP-binding protein [Nanoarchaeota archaeon] | diamond | 567 | 162 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 30633343 | 30633343 | PRJEB28062_P_NODE_58613_length_458_cov_16.090909_g56254_i0 | PRJEB28062 | 58613 | 458 | 16.090909 | 73.69636322 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 168 | 1.3e-45 | NR | MEK6898561.1 | 2026764 | g56254 | i0 | 74.1 | 0.707423580786026 | 108 | 28 | 70.7 | 0 | 444 | 121 | 469 | 576 | MEK6898561.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 324 | 168 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 31195389 | 31195389 | PRJEB28062_P_NODE_121475_length_257_cov_1.728261_g119111_i0 | PRJEB28062 | 121475 | 257 | 1.728261 | 4.44163077 | Nanobdellati | 1783276 | Archaea | Archaea | 81.6 | 8.99e-16 | NR | MBU0459811.1 | 2026764 | g119111 | i0 | 41.9 | 10.1439688715953 | 86 | 49 | 99.2 | 1 | 257 | 3 | 277 | 362 | MBU0459811.1 DEAD/DEAH box helicase family protein [Nanoarchaeota archaeon] | diamond | 2607 | 81.6 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 31201819 | 31201819 | PRJEB28062_P_NODE_82515_length_369_cov_1.679054_g80153_i0 | PRJEB28062 | 82515 | 369 | 1.679054 | 6.19570926 | Nanobdellota archaeon | 2026764 | Archaea | Archaea | 120 | 4.98e-33 | NR | MEK6908996.1 | 2026764 | g80153 | i0 | 78.4 | 0.601626016260163 | 74 | 16 | 60.2 | 0 | 20 | 241 | 11 | 84 | MEK6908996.1 hypothetical protein [Nanoarchaeota archaeon] | diamond | 222 | 120 | 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);;