contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1122875" and tax_kingdom = "Nanobdellati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28364870 | 28364870 | PRJNA1122875_P_NODE_7626_length_588_cov_1.522330_g7408_i0 | PRJNA1122875 | 7626 | 588 | 1.52233 | 8.9513004 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 84 | 7.79e-16 | NR | MBI4895878.1 | 3121606 | g7408 | i0 | 30.1 | 0.933673469387755 | 183 | 119 | 90.8 | 4 | 3 | 536 | 70 | 248 | MBI4895878.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 549 | 84 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 28459922 | 28459922 | PRJNA1122875_P_NODE_3226_length_827_cov_2.706897_g3043_i0 | PRJNA1122875 | 3226 | 827 | 2.706897 | 22.38603819 | Candidatus Afararchaeaceae archaeon | 3138761 | Archaea | Archaea | 47.4 | 0.00942 | NR | MDY7082877.1 | 3138761 | g3043 | i0 | 38.8 | 0.177750906892382 | 49 | 30 | 17.8 | 0 | 813 | 667 | 77 | 125 | MDY7082877.1 DoxX family protein [Candidatus Afararchaeaceae archaeon] | diamond | 147 | 47.4 | 1 | Archaea | Nanobdellati | Candidatus Afararchaeaceae | Candidatus Afararchaeaceae archaeon | ||||||
| 29438190 | 29438190 | PRJNA1122875_P_NODE_45730_length_249_cov_0.875000_g45506_i0 | PRJNA1122875 | 45730 | 249 | 0.875 | 2.17875 | Nanoarchaeota archaeon | 2026764 | Archaea | Archaea | 45.1 | 0.00465 | NR | RLG16828.1 | 2026764 | g45506 | i0 | 42.4 | 1.32530120481928 | 59 | 32 | 71.1 | 1 | 245 | 69 | 159 | 215 | RLG16828.1 MAG: 50S ribosomal protein L1 [Nanoarchaeota archaeon] | diamond | 330 | 45.1 | 1 | Archaea | Nanobdellati | Nanobdellota | Nanobdellota archaeon | ||||||
| 29469801 | 29469801 | PRJNA1122875_P_NODE_46190_length_248_cov_0.880000_g45966_i0 | PRJNA1122875 | 46190 | 248 | 0.88 | 2.1824 | Candidatus Iainarchaeum archaeon | 3101447 | Archaea | Archaea | 64.3 | 9.78e-10 | NR | MBT4870432.1 | 2026736 | g45966 | i0 | 52.7 | 0.665322580645161 | 55 | 26 | 66.5 | 0 | 247 | 83 | 517 | 571 | MBT4870432.1 glycosyltransferase family 25 protein [Candidatus Iainarchaeum archaeon] | diamond | 165 | 64.3 | 1 | Archaea | Nanobdellati | Candidatus Iainarchaeota | Candidatus Iainarchaeum | Candidatus Iainarchaeum archaeon | |||||
| 30923466 | 30923466 | PRJNA1122875_P_NODE_4554_length_726_cov_2.343032_g4353_i0 | PRJNA1122875 | 4554 | 726 | 2.343032 | 17.01041232 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 55.1 | 7.93e-6 | NR | NYZ74883.1 | 2250274 | g4353 | i0 | 34.6 | 0.442148760330579 | 107 | 57 | 44.2 | 4 | 378 | 58 | 13 | 106 | NYZ74883.1 hypothetical protein [Candidatus Micrarchaeota archaeon] | diamond | 321 | 55.1 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 30986551 | 30986551 | PRJNA1122875_P_NODE_23194_length_346_cov_1.490842_g22970_i0 | PRJNA1122875 | 23194 | 346 | 1.490842 | 5.15831332 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 43.1 | 0.0213 | NR | NQV08761.1 | 2026803 | g22970 | i0 | 46.2 | 0.338150289017341 | 39 | 21 | 33.8 | 0 | 122 | 6 | 71 | 109 | NQV08761.1 nascent polypeptide-associated complex protein [Candidatus Woesearchaeota archaeon] | diamond | 117 | 43.1 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 31650199 | 31650199 | PRJNA1122875_P_NODE_46697_length_248_cov_0.880000_g46473_i0 | PRJNA1122875 | 46697 | 248 | 0.88 | 2.1824 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 84.7 | 5.01e-17 | NR | NYZ73931.1 | 2250274 | g46473 | i0 | 66.7 | 2.75806451612903 | 57 | 19 | 69 | 0 | 8 | 178 | 359 | 415 | NYZ73931.1 ATPase [Candidatus Micrarchaeota archaeon] | diamond | 684 | 84.7 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 31745182 | 31745182 | PRJNA1122875_P_NODE_46957_length_247_cov_2.419540_g46733_i0 | PRJNA1122875 | 46957 | 247 | 2.41954 | 5.9762638 | Candidatus Woesearchaeota archaeon | 2026803 | Archaea | Archaea | 44.7 | 0.00778 | NR | MBS3142562.1 | 2026803 | g46733 | i0 | 44.6 | 0.680161943319838 | 56 | 24 | 66.8 | 2 | 70 | 234 | 182 | 231 | MBS3142562.1 metallophosphoesterase [Candidatus Woesearchaeota archaeon] | diamond | 168 | 44.7 | 1 | Archaea | Nanobdellati | Candidatus Woesearchaeota | Candidatus Woesearchaeota archaeon | ||||||
| 32283391 | 32283391 | PRJNA1122875_P_NODE_28659_length_307_cov_1.094017_g28435_i0 | PRJNA1122875 | 28659 | 307 | 1.094017 | 3.35863219 | Candidatus Nanoarchaeia archaeon | 2910166 | Archaea | Archaea | 50.1 | 3.86e-5 | NR | HZX45076.1 | 2910166 | g28435 | i0 | 44.4 | 1.5928338762215 | 54 | 29 | 52.8 | 1 | 3 | 164 | 60 | 112 | HZX45076.1 hypothetical protein [Candidatus Nanoarchaeia archaeon] | diamond | 489 | 50.1 | 1 | Archaea | Nanobdellati | Nanobdellota | Candidatus Nanoarchaeia | Candidatus Nanoarchaeia 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);;