contig_metadata
8 rows where bioproject = "PRJNA888821" and tax_clade = "Stenosarchaea group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23815076 | 23815076 | PRJNA888821_P_NODE_33879_length_254_cov_1.607735_g33796_i0 | PRJNA888821 | 33879 | 254 | 1.607735 | 4.0836469 | Haloferax sp. S1W | 3377110 | Archaea | Archaea | 363 | 9.379999999999998e-96 | NTclustered | gi|2845113841|gb|CP172600.1| | 3377110 | g33796 | i0 | 92.8 | 1.96850393700787 | 250 | 18 | 98 | 0 | 5 | 254 | 49973 | 50222 | Haloferax sp. S1W plasmid pHFX5, complete sequence | blastn | 500 | 363 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax sp. S1W | |
| 27149872 | 27149872 | PRJNA888821_P_NODE_45582_length_219_cov_7.924658_g45499_i0 | PRJNA888821 | 45582 | 219 | 7.924658 | 17.35500102 | Halobacterium bonnevillei | 2692200 | Archaea | Archaea | 72.4 | 5.29e-13 | NR | WP_159526771.1 | 2692200 | g45499 | i0 | 85 | 1.08219178082192 | 40 | 6 | 54.8 | 0 | 2 | 121 | 262 | 301 | WP_159526771.1 ABC transporter permease [Halobacterium bonnevillei] | diamond | 237 | 72.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium bonnevillei | |
| 28097715 | 28097715 | PRJNA888821_P_NODE_49465_length_207_cov_8.037313_g49382_i0 | PRJNA888821 | 49465 | 207 | 8.037313 | 16.63723791 | Halobacteriaceae archaeon | 1931997 | Archaea | Archaea | 98.2 | 6.29e-22 | NR | MFB6255096.1 | 1931997 | g49382 | i0 | 69.6 | 2 | 69 | 21 | 100 | 0 | 1 | 207 | 111 | 179 | MFB6255096.1 uracil-xanthine permease family protein [Halobacteriaceae archaeon] | diamond | 414 | 98.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacteriaceae archaeon | ||
| 28571314 | 28571314 | PRJNA888821_P_NODE_24727_length_293_cov_3.477273_g24645_i0 | PRJNA888821 | 24727 | 293 | 3.477273 | 10.18840989 | Methanothrix sp. | 90426 | Archaea | Archaea | 61.2 | 4.67e-9 | NR | MCK9566439.1 | 90426 | g24645 | i0 | 78.1 | 0.327645051194539 | 32 | 7 | 32.8 | 0 | 122 | 27 | 1 | 32 | MCK9566439.1 HNH endonuclease [Methanothrix sp.] | diamond | 96 | 61.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 28855348 | 28855348 | PRJNA888821_P_NODE_27448_length_281_cov_7.442308_g27366_i0 | PRJNA888821 | 27448 | 281 | 7.442308 | 20.91288548 | Halolamina sp. | 1940283 | Archaea | Archaea | 66.2 | 2.28e-12 | NR | WP_014050829.1 | 1940283 | g27366 | i0 | 82.9 | 0.437722419928826 | 41 | 7 | 43.8 | 0 | 47 | 169 | 1 | 41 | WP_014050829.1 hypothetical protein [Halolamina sp.] | diamond | 123 | 66.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halolamina | Halolamina sp. | |
| 29265826 | 29265826 | PRJNA888821_P_NODE_37409_length_245_cov_4.075581_g37326_i0 | PRJNA888821 | 37409 | 245 | 4.075581 | 9.98517345 | Halolamina sp. | 1940283 | Archaea | Archaea | 67.4 | 4.51e-11 | NR | MFB6221925.1 | 1940283 | g37326 | i0 | 70 | 1.22448979591837 | 50 | 12 | 61.2 | 1 | 204 | 55 | 55 | 101 | MFB6221925.1 hypothetical protein [Halolamina sp.] | diamond | 300 | 67.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halolamina | Halolamina sp. | |
| 30348222 | 30348222 | PRJNA888821_P_NODE_38752_length_242_cov_4.254438_g38669_i0 | PRJNA888821 | 38752 | 242 | 4.254438 | 10.29573996 | Halobacteriales | 2235 | Archaea | Archaea | 120 | 2.0099999999999997e-30 | NR | WP_338914891.1 | 2162630 | g38669 | i0 | 72.4 | 1.88429752066116 | 76 | 21 | 94.2 | 0 | 242 | 15 | 184 | 259 | WP_338914891.1 MULTISPECIES: amidohydrolase family protein [Salinirubellus] | diamond | 456 | 120 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Salinirubellus | ||
| 32836583 | 32836583 | PRJNA888821_P_NODE_49380_length_207_cov_11.768657_g49297_i0 | PRJNA888821 | 49380 | 207 | 11.768657 | 24.36111999 | halophilic archaeon DL31 | 756883 | Archaea | Archaea | 62.8 | 2.78e-11 | NR | AEN07052.1 | 756883 | g49297 | i0 | 78.9 | 0.550724637681159 | 38 | 8 | 55.1 | 0 | 115 | 2 | 3 | 40 | AEN07052.1 hypothetical protein Halar_3454 [halophilic archaeon DL31] | diamond | 114 | 62.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | halophilic archaeon DL31 |
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);;