contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA541476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26729278 | 26729278 | PRJNA541476_P_NODE_31701_length_249_cov_0.886364_g31495_i0 | PRJNA541476 | 31701 | 249 | 0.886364 | 2.20704636 | Halonotius terrestris | 2487750 | Archaea | Archaea | 99.8 | 1.25e-24 | NR | WP_142978534.1 | 2487750 | g31495 | i0 | 84.6 | 0.626506024096386 | 52 | 8 | 62.7 | 0 | 246 | 91 | 90 | 141 | WP_142978534.1 VOC family protein [Halonotius terrestris] | diamond | 156 | 99.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halonotius | Halonotius terrestris | |
| 27187399 | 27187399 | PRJNA541476_P_NODE_5042_length_507_cov_3.423963_g4841_i0 | PRJNA541476 | 5042 | 507 | 3.423963 | 17.35949241 | Methanomicrobiales | 2191 | Archaea | Archaea | 65.1 | 9.27e-9 | NR | HOI13930.1 | 90427 | g4841 | i0 | 33.1 | 2.70414201183432 | 154 | 83 | 89.3 | 6 | 3 | 455 | 123 | 259 | HOI13930.1 kelch repeat-containing protein [Methanoculleus sp.] | diamond | 1371 | 65.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 27440687 | 27440687 | PRJNA541476_P_NODE_36343_length_245_cov_0.901163_g36137_i0 | PRJNA541476 | 36343 | 245 | 0.901163 | 2.20784935 | Halobacteriales | 2235 | Archaea | Archaea | 148 | 2.67e-40 | NR | WP_103992728.1 | 699433 | g36137 | i0 | 88.9 | 16.8 | 81 | 9 | 99.2 | 0 | 3 | 245 | 135 | 215 | WP_103992728.1 orc1/cdc6 family replication initiation protein [Halobellus limi] | diamond | 4116 | 148 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus limi | |
| 27472063 | 27472063 | PRJNA541476_P_NODE_24863_length_263_cov_2.378947_g24657_i0 | PRJNA541476 | 24863 | 263 | 2.378947 | 6.25663061 | root | 1 | Root_unresolved | Root_unresolved | 46.2 | 0.00288 | NR | MDD1700180.1 | 2052170 | g24657 | i0 | 39.3 | 6.58174904942966 | 84 | 37 | 94.7 | 4 | 250 | 2 | 331 | 401 | MDD1700180.1 PKD domain-containing protein [Methanoregula sp.] | diamond | 1731 | 46.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 27598430 | 27598430 | PRJNA541476_P_NODE_24844_length_263_cov_2.731579_g24638_i0 | PRJNA541476 | 24844 | 263 | 2.731579 | 7.18405277 | root | 1 | Root_unresolved | Root_unresolved | 77.8 | 2.18e-14 | NR | WP_011322054.1 | 2257 | g24638 | i0 | 44 | 6.66159695817491 | 75 | 39 | 82.1 | 1 | 216 | 1 | 154 | 228 | WP_011322054.1 bacterio-opsin activator domain-containing protein [Natronomonas pharaonis] | diamond | 1752 | 77.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas pharaonis | |
| 28088463 | 28088463 | PRJNA541476_P_NODE_40845_length_238_cov_2.357576_g40639_i0 | PRJNA541476 | 40845 | 238 | 2.357576 | 5.61103088 | Methanoregula sp. | 2052170 | Archaea | Archaea | 45.8 | 0.00284 | NR | MDO9324427.1 | 2052170 | g40639 | i0 | 55 | 0.504201680672269 | 40 | 17 | 50.4 | 1 | 155 | 36 | 85 | 123 | MDO9324427.1 TIGR03768 family metallophosphoesterase [Methanoregula sp.] | diamond | 120 | 45.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 28435980 | 28435980 | PRJNA541476_P_NODE_29106_length_252_cov_0.865922_g28900_i0 | PRJNA541476 | 29106 | 252 | 0.865922 | 2.18212344 | Haloferax denitrificans | 35745 | Archaea | Archaea | 127 | 2.1599999999999998e-32 | NR | WP_152421726.1 | 35745 | g28900 | i0 | 75 | 1 | 84 | 21 | 100 | 0 | 1 | 252 | 15 | 98 | WP_152421726.1 EVE domain-containing protein [Haloferax denitrificans] | diamond | 252 | 127 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax denitrificans | |
| 32701432 | 32701432 | PRJNA541476_P_NODE_37740_length_244_cov_0.900585_g37534_i0 | PRJNA541476 | 37740 | 244 | 0.900585 | 2.1974274 | Halococcoides sp. | 2907509 | Archaea | Archaea | 44.7 | 0.00629 | NR | MFB6163416.1 | 2907509 | g37534 | i0 | 40.4 | 0.639344262295082 | 52 | 30 | 62.7 | 1 | 162 | 10 | 146 | 197 | MFB6163416.1 AAA family ATPase [Halococcoides sp.] | diamond | 156 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halococcoides | Halococcoides sp. | |
| 32858952 | 32858952 | PRJNA541476_P_NODE_38600_length_243_cov_0.917647_g38394_i0 | PRJNA541476 | 38600 | 243 | 0.917647 | 2.22988221 | Halonotius aquaticus | 2216978 | Archaea | Archaea | 142 | 1.36e-39 | NR | WP_120102868.1 | 2216978 | g38394 | i0 | 85 | 1.97530864197531 | 80 | 12 | 98.8 | 0 | 242 | 3 | 154 | 233 | WP_120102868.1 ParB/RepB/Spo0J family partition protein [Halonotius aquaticus] | diamond | 480 | 142 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halonotius | Halonotius aquaticus |
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);;