contig_metadata
11 rows where bioproject = "PRJNA876641" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12332215 | 12332215 | PRJNA876641_P_NODE_14690_length_256_cov_1.295082_g14616_i0 | PRJNA876641 | 14690 | 256 | 1.295082 | 3.31540992 | Halobaculum sp. CBA1158 | 2904243 | Archaea | Archaea | 176 | 1.32e-39 | NTclustered | gi|2176093559|gb|CP090371.1| | 2904243 | g14616 | i0 | 80.435 | 8.78125 | 230 | 45 | 90 | 0 | 4 | 233 | 1585525 | 1585754 | Halobaculum sp. CBA1158 chromosome, complete genome | blastn | 2248 | 176 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum sp. CBA1158 | |
| 21255234 | 21255234 | PRJNA876641_P_NODE_19357_length_246_cov_1.335260_g19283_i0 | PRJNA876641 | 19357 | 246 | 1.33526 | 3.2847396 | Halomarina pelagica | 2961599 | Archaea | Archaea | 67.6 | 7.94e-7 | NTclustered | gi|2270305250|gb|CP100454.1| | 2961599 | g19283 | i0 | 95.238 | 1.04065040650407 | 42 | 2 | 17 | 0 | 6 | 47 | 1375388 | 1375429 | Halomarina pelagica strain BND7 chromosome, complete genome | blastn | 256 | 67.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina pelagica | |
| 28200082 | 28200082 | PRJNA876641_P_NODE_24106_length_227_cov_2.766234_g24032_i0 | PRJNA876641 | 24106 | 227 | 2.766234 | 6.27935118 | root | 1 | Root_unresolved | Root_unresolved | 50.4 | 5.42e-5 | NR | WP_115883272.1 | 2077203 | g24032 | i0 | 35.1 | 1.784140969163 | 74 | 42 | 92.5 | 3 | 7 | 216 | 228 | 299 | WP_115883272.1 oxidoreductase [Haloferax sp. Atlit-12N] | diamond | 405 | 50.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax sp. Atlit-12N | |
| 29392172 | 29392172 | PRJNA876641_P_NODE_19569_length_246_cov_0.890173_g19495_i0 | PRJNA876641 | 19569 | 246 | 0.890173 | 2.18982558 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 48.1 | 3.92e-4 | NR | MEC9120395.1 | 2806419 | g19495 | i0 | 72.4 | 0.707317073170732 | 29 | 8 | 35.4 | 0 | 246 | 160 | 207 | 235 | MEC9120395.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Thermoplasmatota archaeon] | diamond | 174 | 48.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 29675906 | 29675906 | PRJNA876641_P_NODE_13030_length_265_cov_1.333333_g12956_i0 | PRJNA876641 | 13030 | 265 | 1.333333 | 3.53333245 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 54.3 | 4.04e-6 | NR | RYE83256.1 | 2250255 | g12956 | i0 | 34.9 | 0.939622641509434 | 83 | 52 | 91.7 | 1 | 244 | 2 | 150 | 232 | RYE83256.1 MAG: hypothetical protein EOO65_04255 [Methanosarcinales archaeon] | diamond | 249 | 54.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 30348152 | 30348152 | PRJNA876641_P_NODE_14172_length_259_cov_0.876344_g14098_i0 | PRJNA876641 | 14172 | 259 | 0.876344 | 2.26973096 | root | 1 | Root_unresolved | Root_unresolved | 48.1 | 5.53e-4 | NR | WP_295594825.1 | 253161 | g14098 | i0 | 26.8 | 9.71814671814672 | 82 | 55 | 95 | 2 | 253 | 8 | 52 | 128 | WP_295594825.1 PQQ-binding-like beta-propeller repeat protein [uncultured Methanobrevibacter sp.] | diamond | 2517 | 48.5 | 0.991752577319588 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 30371629 | 30371629 | PRJNA876641_P_NODE_10232_length_281_cov_1.043269_g10158_i0 | PRJNA876641 | 10232 | 281 | 1.043269 | 2.93158589 | Candidatus Hydrothermarchaeales archaeon | 3107144 | Archaea | Archaea | 51.6 | 3.65e-5 | NR | MFQ6137201.1 | 3107144 | g10158 | i0 | 38.8 | 3.73665480427046 | 85 | 35 | 90.7 | 3 | 262 | 8 | 186 | 253 | MFQ6137201.1 prephenate dehydratase [Candidatus Hydrothermarchaeales archaeon] | diamond | 1050 | 51.6 | 1 | Archaea | Methanobacteriati | Candidatus Hydrothermarchaeota | Candidatus Hydrothermarchaeia | Candidatus Hydrothermarchaeales | Candidatus Hydrothermarchaeales archaeon | ||||
| 31287421 | 31287421 | PRJNA876641_P_NODE_23915_length_233_cov_2.456250_g23841_i0 | PRJNA876641 | 23915 | 233 | 2.45625 | 5.7230625 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 43.9 | 0.00418 | NR | MEC7713334.1 | 2806419 | g23841 | i0 | 63.9 | 0.463519313304721 | 36 | 13 | 46.4 | 0 | 125 | 18 | 10 | 45 | MEC7713334.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 108 | 43.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 31414113 | 31414113 | PRJNA876641_P_NODE_13416_length_263_cov_1.278947_g13342_i0 | PRJNA876641 | 13416 | 263 | 1.278947 | 3.36363061 | Euryarchaeota archaeon RBG_19FT_COMBO_69_17 | 1797984 | Archaea | Archaea | 94.7 | 9.9e-21 | NR | OGS62703.1 | 1797984 | g13342 | i0 | 56.7 | 3.07984790874525 | 67 | 29 | 76.4 | 0 | 263 | 63 | 307 | 373 | OGS62703.1 MAG: copper oxidase [Euryarchaeota archaeon RBG_19FT_COMBO_69_17] | diamond | 810 | 94.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Euryarchaeota archaeon RBG_19FT_COMBO_69_17 | ||||||
| 31477497 | 31477497 | PRJNA876641_P_NODE_22736_length_242_cov_0.911243_g22662_i0 | PRJNA876641 | 22736 | 242 | 0.911243 | 2.20520806 | Candidatus Methanophagales archaeon | 2056316 | Archaea | Archaea | 41.2 | 0.0209 | NR | MCR5853007.1 | 2056316 | g22662 | i0 | 44.7 | 0.582644628099174 | 47 | 20 | 58.3 | 1 | 82 | 222 | 18 | 58 | MCR5853007.1 hypothetical protein [Candidatus Methanophagales archaeon] | diamond | 141 | 41.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagales archaeon | |||
| 32899268 | 32899268 | PRJNA876641_P_NODE_7400_length_307_cov_1.974359_g7326_i0 | PRJNA876641 | 7400 | 307 | 1.974359 | 6.06128213 | Methanopyrus | 2319 | Archaea | Archaea | 45.1 | 9.26e-4 | NR | WP_011019823.1 | 2319 | g7326 | i0 | 46.7 | 0.781758957654723 | 45 | 23 | 43 | 1 | 242 | 111 | 16 | 60 | WP_011019823.1 MULTISPECIES: 30S ribosomal protein S27ae [Methanopyrus] | diamond | 240 | 45.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanopyri | Methanopyrales | Methanopyraceae | Methanopyrus |
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);;