contig_metadata
10 rows where bioproject = "PRJEB20058" and tax_phylum = "Candidatus Aenigmatarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27949196 | 27949196 | PRJEB20058_S_NODE_4565_length_292_cov_5.441558_g4527_i0 | PRJEB20058 | 4565 | 292 | 5.441558 | 15.88934936 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 144 | 1.8e-41 | NR | MEM0332961.1 | 3121606 | g4527 | i0 | 93.8 | 0.821917808219178 | 80 | 5 | 82.2 | 0 | 241 | 2 | 1 | 80 | MEM0332961.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 240 | 144 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 28833225 | 28833225 | PRJEB20058_S_NODE_8008_length_188_cov_3.637795_g7970_i0 | PRJEB20058 | 8008 | 188 | 3.637795 | 6.8390546 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 89.7 | 6.46e-20 | NR | MCC5994609.1 | 3121606 | g7970 | i0 | 89.4 | 0.75 | 47 | 5 | 75 | 0 | 141 | 1 | 1 | 47 | MCC5994609.1 PD-(D/E)XK nuclease family protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 141 | 89.7 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 32928375 | 32928375 | PRJEB20058_P_NODE_31921_length_742_cov_13.511013_g29409_i0 | PRJEB20058 | 31921 | 742 | 13.511013 | 100.25171646 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 54.7 | 4.04e-5 | NR | MBR9682651.1 | 3121606 | g29409 | i0 | 43.5 | 0.250673854447439 | 62 | 35 | 25.1 | 0 | 98 | 283 | 21 | 82 | MBR9682651.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 186 | 54.7 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 32962693 | 32962693 | PRJEB20058_P_NODE_243146_length_208_cov_36.122449_g240321_i0 | PRJEB20058 | 243146 | 208 | 36.122449 | 75.13469392 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 74.3 | 1.39e-13 | NR | MCC5994730.1 | 3121606 | g240321 | i0 | 81 | 0.605769230769231 | 42 | 8 | 60.6 | 0 | 186 | 61 | 288 | 329 | MCC5994730.1 AAA family ATPase [Candidatus Aenigmatarchaeota archaeon] | diamond | 126 | 74.3 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 32979439 | 32979439 | PRJEB20058_P_NODE_17907_length_978_cov_49.095965_g15920_i0 | PRJEB20058 | 17907 | 978 | 49.095965 | 480.1585377 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 48.5 | 0.0105 | NR | RLJ09542.1 | 3121606 | g15920 | i0 | 40.4 | 0.174846625766871 | 57 | 33 | 17.5 | 1 | 792 | 962 | 10 | 65 | RLJ09542.1 MAG: hypothetical protein DRP15_03400, partial [Candidatus Aenigmatarchaeota archaeon] | diamond | 171 | 48.5 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 32979777 | 32979777 | PRJEB20058_P_NODE_245147_length_204_cov_11.209790_g242322_i0 | PRJEB20058 | 245147 | 204 | 11.20979 | 22.8679716 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 101 | 2.919999999999999e-23 | NR | MCC5994578.1 | 3121606 | g242322 | i0 | 88.7 | 0.779411764705882 | 53 | 6 | 77.9 | 0 | 23 | 181 | 59 | 111 | MCC5994578.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 159 | 101 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 33064317 | 33064317 | PRJEB20058_P_NODE_142069_length_325_cov_13.731061_g139248_i0 | PRJEB20058 | 142069 | 325 | 13.731061 | 44.62594825 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 81.6 | 1.22e-15 | NR | MCC5994686.1 | 3121606 | g139248 | i0 | 74.1 | 0.498461538461538 | 54 | 14 | 49.8 | 0 | 154 | 315 | 16 | 69 | MCC5994686.1 ATP-binding protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 162 | 81.6 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 33098513 | 33098513 | PRJEB20058_P_NODE_155678_length_305_cov_76.049180_g152855_i0 | PRJEB20058 | 155678 | 305 | 76.04918 | 231.949999 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 102 | 5.18e-25 | NR | MEM0332955.1 | 3121606 | g152855 | i0 | 94.5 | 0.540983606557377 | 55 | 3 | 54.1 | 0 | 303 | 139 | 86 | 140 | MEM0332955.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 165 | 102 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 33115843 | 33115843 | PRJEB20058_P_NODE_205575_length_252_cov_3.481675_g202751_i0 | PRJEB20058 | 205575 | 252 | 3.481675 | 8.773821 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 91.3 | 9e-21 | NR | MEM0332962.1 | 3121606 | g202751 | i0 | 78 | 0.702380952380952 | 59 | 13 | 70.2 | 0 | 179 | 3 | 1 | 59 | MEM0332962.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 177 | 91.3 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 33116036 | 33116036 | PRJEB20058_P_NODE_242167_length_210_cov_37.013423_g239342_i0 | PRJEB20058 | 242167 | 210 | 37.013423 | 77.7281883 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 95.5 | 2.38e-21 | NR | MCC5994730.1 | 3121606 | g239342 | i0 | 77.8 | 0.9 | 63 | 13 | 88.6 | 1 | 188 | 3 | 288 | 350 | MCC5994730.1 AAA family ATPase [Candidatus Aenigmatarchaeota archaeon] | diamond | 189 | 95.5 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota 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);;