contig_metadata
8 rows where bioproject = "PRJNA577580", tax_clade = "Stenosarchaea group" and tax_phylum = "Methanobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10768273 | 10768273 | PRJNA577580_P_NODE_12769_length_260_cov_1.139037_g12691_i0 | PRJNA577580 | 12769 | 260 | 1.139037 | 2.9614962 | Natronosalvus caseinilyticus | 2953747 | Archaea | Archaea | 52.8 | 0.024 | NTclustered | gi|2006550273|gb|CP071596.1| | 2953747 | g12691 | i0 | 100 | 0.107692307692308 | 28 | 0 | 11 | 0 | 204 | 231 | 302304 | 302331 | Natronosalvus caseinilyticus strain KZCA101 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronosalvus | Natronosalvus caseinilyticus | |
| 27743325 | 27743325 | PRJNA577580_P_NODE_16964_length_230_cov_3.477707_g16886_i0 | PRJNA577580 | 16964 | 230 | 3.477707 | 7.9987261 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 80.1 | 2.14e-15 | NR | HWR97478.1 | 2032688 | g16886 | i0 | 55.4 | 1.9695652173913 | 74 | 33 | 96.5 | 0 | 9 | 230 | 333 | 406 | HWR97478.1 NAD-dependent malic enzyme [Candidatus Methanoperedens sp.] | diamond | 453 | 80.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens sp. | |
| 27932503 | 27932503 | PRJNA577580_P_NODE_1725_length_691_cov_6.448220_g1651_i0 | PRJNA577580 | 1725 | 691 | 6.44822 | 44.5572002 | Haladaptatus caseinilyticus | 2993314 | Archaea | Archaea | 87.8 | 7.99e-17 | NR | WP_266075675.1 | 2993314 | g1651 | i0 | 30.1 | 1.71490593342981 | 206 | 131 | 87.3 | 6 | 665 | 63 | 40 | 237 | WP_266075675.1 DUF4397 domain-containing protein [Haladaptatus caseinilyticus] | diamond | 1185 | 87.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus caseinilyticus | |
| 29777163 | 29777163 | PRJNA577580_P_NODE_3191_length_503_cov_2.041860_g3113_i0 | PRJNA577580 | 3191 | 503 | 2.04186 | 10.2705558 | root | 1 | Root_unresolved | Root_unresolved | 209 | 1.3000000000000002e-60 | NR | WP_320160326.1 | 1005933 | g3113 | i0 | 62.3 | 17.5705765407555 | 151 | 57 | 90.1 | 0 | 1 | 453 | 539 | 689 | WP_320160326.1 S9 family peptidase [uncultured Methanoregula sp.] | diamond | 8838 | 211 | 0.990521327014218 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula sp. | |
| 29795190 | 29795190 | PRJNA577580_P_NODE_15551_length_245_cov_0.906977_g15473_i0 | PRJNA577580 | 15551 | 245 | 0.906977 | 2.22209365 | Methanomicrobiales archaeon | 2184052 | Archaea | Archaea | 63.2 | 2.37e-9 | NR | MCX6700012.1 | 2184052 | g15473 | i0 | 42.2 | 2.03265306122449 | 83 | 45 | 98 | 2 | 2 | 241 | 212 | 294 | MCX6700012.1 ATP-binding protein [Methanomicrobiales archaeon] | diamond | 498 | 63.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon | |||
| 30490472 | 30490472 | PRJNA577580_P_NODE_4193_length_440_cov_2.209809_g4115_i0 | PRJNA577580 | 4193 | 440 | 2.209809 | 9.7231596 | Natronomonas marina | 2961939 | Archaea | Archaea | 51.6 | 6.72e-5 | NR | WP_254840598.1 | 2961939 | g4115 | i0 | 41.8 | 1.95681818181818 | 67 | 36 | 43.6 | 1 | 199 | 8 | 65 | 131 | WP_254840598.1 DUF3592 domain-containing protein [Natronomonas marina] | diamond | 861 | 51.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas marina | |
| 30946385 | 30946385 | PRJNA577580_P_NODE_854_length_948_cov_6.814857_g794_i0 | PRJNA577580 | 854 | 948 | 6.814857 | 64.60484436 | root | 1 | Root_unresolved | Root_unresolved | 52.4 | 0.00125 | NR | WP_343772725.1 | 926360 | g794 | i0 | 30.5 | 1.32278481012658 | 154 | 100 | 48.4 | 5 | 1 | 459 | 78 | 225 | WP_343772725.1 DUF4397 domain-containing protein [Natronoarchaeum mannanilyticum] | diamond | 1254 | 52.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronoarchaeaceae | Natronoarchaeum | Natronoarchaeum mannanilyticum | |
| 32039579 | 32039579 | PRJNA577580_P_NODE_1958_length_649_cov_3.210069_g1881_i0 | PRJNA577580 | 1958 | 649 | 3.210069 | 20.83334781 | Halosimplex sp. | 1882270 | Archaea | Archaea | 47.8 | 0.00415 | NR | MFB6140005.1 | 1882270 | g1881 | i0 | 43.4 | 0.244992295839753 | 53 | 30 | 24.5 | 0 | 441 | 283 | 60 | 112 | MFB6140005.1 DUF3592 domain-containing protein [Halosimplex sp.] | diamond | 159 | 47.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex sp. |
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);;