contig_metadata
10 rows where bioproject = "PRJNA1123436" and tax_phylum = "Candidatus Micrarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13032748 | 13032748 | PRJNA1123436_P_NODE_120551_length_243_cov_0.905882_g119337_i0 | PRJNA1123436 | 120551 | 243 | 0.905882 | 2.20129326 | Nanobdellati | 1783276 | Archaea | Archaea | 160 | 3.46e-45 | NR | MBI5228105.1 | 2250274 | g119337 | i0 | 96.3 | 6.91358024691358 | 80 | 3 | 98.8 | 0 | 241 | 2 | 212 | 291 | MBI5228105.1 V-type ATP synthase subunit B [Candidatus Micrarchaeota archaeon] | diamond | 1680 | 161 | 0.993788819875776 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 27228170 | 27228170 | PRJNA1123436_P_NODE_32083_length_452_cov_0.973615_g30871_i0 | PRJNA1123436 | 32083 | 452 | 0.973615 | 4.4007398 | Candidatus Bilamarchaeaceae archaeon | 2886391 | Archaea | Archaea | 52.4 | 4.65e-5 | NR | MEM4360115.1 | 2886391 | g30871 | i0 | 37.3 | 0.922566371681416 | 102 | 51 | 67 | 4 | 6 | 308 | 86 | 175 | MEM4360115.1 hypothetical protein [Candidatus Bilamarchaeaceae archaeon] | diamond | 417 | 52.4 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Anstonellales | Candidatus Bilamarchaeaceae | Candidatus Bilamarchaeaceae archaeon | |||
| 27259951 | 27259951 | PRJNA1123436_P_NODE_124863_length_242_cov_0.911243_g123649_i0 | PRJNA1123436 | 124863 | 242 | 0.911243 | 2.20520806 | Candidatus Micrarchaeia archaeon | 3018267 | Archaea | Archaea | 96.3 | 3.34e-21 | NR | MFA5246506.1 | 3018267 | g123649 | i0 | 62.7 | 1.8595041322314 | 75 | 28 | 93 | 0 | 3 | 227 | 127 | 201 | MFA5246506.1 histidine--tRNA ligase [Candidatus Micrarchaeia archaeon] | diamond | 450 | 96.3 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Micrarchaeia archaeon | |||||
| 27418138 | 27418138 | PRJNA1123436_P_NODE_45063_length_374_cov_1.279070_g43849_i0 | PRJNA1123436 | 45063 | 374 | 1.27907 | 4.7837218 | Candidatus Bilamarchaeaceae archaeon | 2886391 | Archaea | Archaea | 47.4 | 2.4e-4 | NR | MEM4360119.1 | 2886391 | g43849 | i0 | 35.2 | 0.56951871657754 | 71 | 38 | 57 | 1 | 112 | 324 | 2 | 64 | MEM4360119.1 hypothetical protein [Candidatus Bilamarchaeaceae archaeon] | diamond | 213 | 47.4 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Anstonellales | Candidatus Bilamarchaeaceae | Candidatus Bilamarchaeaceae archaeon | |||
| 29785827 | 29785827 | PRJNA1123436_P_NODE_126431_length_241_cov_0.916667_g125217_i0 | PRJNA1123436 | 126431 | 241 | 0.916667 | 2.20916747 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 57.4 | 4.8e-8 | NR | MDE1834859.1 | 2250274 | g125217 | i0 | 51.4 | 0.460580912863071 | 37 | 18 | 46.1 | 0 | 119 | 9 | 111 | 147 | MDE1834859.1 hypothetical protein [Candidatus Micrarchaeota archaeon] | diamond | 111 | 57.4 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 31418185 | 31418185 | PRJNA1123436_P_NODE_100556_length_249_cov_1.556818_g99342_i0 | PRJNA1123436 | 100556 | 249 | 1.556818 | 3.87647682 | Archaea | 2157 | Archaea | Archaea | 115 | 2.67e-29 | NR | OIO22578.1 | 1805249 | g99342 | i0 | 66.7 | 1.95180722891566 | 81 | 27 | 97.6 | 0 | 244 | 2 | 142 | 222 | OIO22578.1 MAG: hypothetical protein AUJ65_05850 [Candidatus Micrarchaeota archaeon CG1_02_51_15] | diamond | 486 | 115 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon CG1_02_51_15 | ||||||
| 31713751 | 31713751 | PRJNA1123436_P_NODE_6937_length_1138_cov_4.217840_g6048_i0 | PRJNA1123436 | 6937 | 1138 | 4.21784 | 47.9990192 | Candidatus Bilamarchaeaceae archaeon | 2886391 | Archaea | Archaea | 100 | 9.85e-22 | NR | MEM4360122.1 | 2886391 | g6048 | i0 | 45.8 | 0.28207381370826 | 107 | 57 | 27.9 | 1 | 731 | 414 | 1 | 107 | MEM4360122.1 hypothetical protein [Candidatus Bilamarchaeaceae archaeon] | diamond | 321 | 100 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Anstonellales | Candidatus Bilamarchaeaceae | Candidatus Bilamarchaeaceae archaeon | |||
| 31840078 | 31840078 | PRJNA1123436_P_NODE_108297_length_247_cov_0.885057_g107083_i0 | PRJNA1123436 | 108297 | 247 | 0.885057 | 2.18609079 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 130 | 2.9e-36 | NR | MEW6748504.1 | 2250274 | g107083 | i0 | 82.5 | 0.97165991902834 | 80 | 14 | 97.2 | 0 | 6 | 245 | 79 | 158 | MEW6748504.1 hypothetical protein [Candidatus Micrarchaeota archaeon] | diamond | 240 | 130 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 32367471 | 32367471 | PRJNA1123436_P_NODE_101459_length_249_cov_0.875000_g100245_i0 | PRJNA1123436 | 101459 | 249 | 0.875 | 2.17875 | Nanobdellati | 1783276 | Archaea | Archaea | 63.2 | 4.57e-10 | NR | NYZ73714.1 | 2250274 | g100245 | i0 | 75 | 0.963855421686747 | 40 | 10 | 48.2 | 0 | 121 | 2 | 1 | 40 | NYZ73714.1 nitroreductase family protein [Candidatus Micrarchaeota archaeon] | diamond | 240 | 63.2 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 32409882 | 32409882 | PRJNA1123436_P_NODE_64219_length_311_cov_1.617647_g63005_i0 | PRJNA1123436 | 64219 | 311 | 1.617647 | 5.03088217 | Candidatus Bilamarchaeaceae archaeon | 2886391 | Archaea | Archaea | 90.1 | 3.76e-20 | NR | MEM4360120.1 | 2886391 | g63005 | i0 | 68.3 | 0.607717041800643 | 63 | 20 | 60.8 | 0 | 191 | 3 | 1 | 63 | MEM4360120.1 transglycosylase SLT domain-containing protein [Candidatus Bilamarchaeaceae archaeon] | diamond | 189 | 90.1 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Anstonellales | Candidatus Bilamarchaeaceae | Candidatus Bilamarchaeaceae 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);;