contig_metadata
21 rows where 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1118448 | 1118448 | PRJNA541476_P_NODE_40461_length_242_cov_0.887574_g40255_i0 | PRJNA541476 | 40461 | 242 | 0.887574 | 2.14792908 | Halobacteriales | 2235 | Archaea | Archaea | 431 | 2.4e-116 | NTclustered | gi|1041620905|dbj|AP017571.1| | 29284 | g40255 | i0 | 98.76 | 10 | 242 | 3 | 100 | 0 | 1 | 242 | 18765 | 18524 | Halorubrum trapanicum plasmid pCBA1232-02 DNA, complete genome, strain: CBA1232 | blastn | 2420 | 431 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum trapanicum | |
| 1784314 | 1784314 | PRJNA541476_P_NODE_31822_length_249_cov_0.886364_g31616_i0 | PRJNA541476 | 31822 | 249 | 0.886364 | 2.20704636 | Salinirarus marinus | 3068310 | Archaea | Archaea | 169 | 2.1399999999999996e-37 | NTclustered | gi|2563036160|gb|CP132292.1| | 3068310 | g31616 | i0 | 83.799 | 2.85943775100402 | 179 | 27 | 71 | 2 | 72 | 249 | 11519 | 11696 | Haloferacaceae archaeon XH8 chromosome, complete genome | blastn | 712 | 169 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinirarus | Salinirarus marinus | |
| 1784322 | 1784322 | PRJNA541476_P_NODE_32062_length_249_cov_0.880682_g31856_i0 | PRJNA541476 | 32062 | 249 | 0.880682 | 2.19289818 | Halanaeroarchaeum sulfurireducens | 1604004 | Archaea | Archaea | 268 | 2.06e-67 | NTclustered | gi|933677909|gb|CP011564.1| | 1604004 | g31856 | i0 | 87.288 | 11.7630522088353 | 236 | 29 | 95 | 1 | 13 | 248 | 1766287 | 1766521 | Halanaeroarchaeum sulfurireducens strain M27-SA2, complete genome | blastn | 2929 | 268 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sulfurireducens | |
| 3059910 | 3059910 | PRJNA541476_P_NODE_35343_length_246_cov_0.890173_g35137_i0 | PRJNA541476 | 35343 | 246 | 0.890173 | 2.18982558 | Halospeciosus flavus | 3032283 | Archaea | Archaea | 244 | 3.42e-60 | NTclustered | gi|2490484842|gb|CP122312.1| | 3032283 | g35137 | i0 | 84.585 | 12.5528455284553 | 253 | 31 | 100 | 7 | 1 | 246 | 596811 | 596560 | Halospeciosus flavus strain XZGYJ-43 chromosome | blastn | 3088 | 244 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halospeciosus | Halospeciosus flavus | |
| 4336040 | 4336040 | PRJNA541476_P_NODE_37164_length_244_cov_0.912281_g36958_i0 | PRJNA541476 | 37164 | 244 | 0.912281 | 2.22596564 | Natronococcus occultus | 29288 | Archaea | Archaea | 228 | 3.409999999999999e-55 | NTclustered | gi|433671692|gb|CP003929.1| | 694430 | g36958 | i0 | 84.034 | 4.68032786885246 | 238 | 36 | 97 | 2 | 6 | 242 | 3621317 | 3621081 | Natronococcus occultus SP4, complete genome | blastn | 1142 | 228 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronococcus | Natronococcus occultus | |
| 4336140 | 4336140 | PRJNA541476_P_NODE_39784_length_242_cov_0.923077_g39578_i0 | PRJNA541476 | 39784 | 242 | 0.923077 | 2.23384634 | Salinibaculum marinum | 3131993 | Archaea | Archaea | 359 | 1.15e-94 | NTclustered | gi|2700494404|gb|CP147839.1| | 3131993 | g39578 | i0 | 93.388 | 2.50826446280992 | 242 | 16 | 100 | 0 | 1 | 242 | 37895 | 38136 | Salinibaculum marinum strain SYNS191 plasmid unnamed1, complete sequence | blastn | 607 | 359 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Salinibaculum | Salinibaculum marinum | |
| 8161538 | 8161538 | PRJNA541476_P_NODE_26427_length_258_cov_1.556757_g26221_i0 | PRJNA541476 | 26427 | 258 | 1.556757 | 4.01643306 | Natrinema thermotolerans | 121872 | Archaea | Archaea | 298 | 2.73e-76 | NTclustered | gi|1621090060|gb|CP031304.1| | 121872 | g26221 | i0 | 91.981 | 5.75193798449612 | 212 | 17 | 82 | 0 | 47 | 258 | 946442 | 946653 | Natrinema thermotolerans strain A29 plasmid unnamed6, complete sequence | blastn | 1484 | 298 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema thermotolerans | |
| 9437118 | 9437118 | PRJNA541476_P_NODE_30588_length_250_cov_1.033898_g30382_i0 | PRJNA541476 | 30588 | 250 | 1.033898 | 2.584745 | Halolamina sp. CBA1230 | 1853690 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|1861362334|gb|CP054587.1| | 1853690 | g30382 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 25 | 52 | 2316153 | 2316126 | Halolamina sp. CBA1230 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halolamina | Halolamina sp. CBA1230 | |
| 11987539 | 11987539 | PRJNA541476_P_NODE_28330_length_253_cov_0.866667_g28124_i0 | PRJNA541476 | 28330 | 253 | 0.866667 | 2.19266751 | Halorussus vallis | 2953749 | Archaea | Archaea | 298 | 2.6699999999999998e-76 | NTclustered | gi|2263971171|gb|CP100004.1| | 2953749 | g28124 | i0 | 97.159 | 0.695652173913043 | 176 | 5 | 70 | 0 | 2 | 177 | 76013 | 76188 | Halorussus vallis strain XZYJT10 plasmid unnamed4, complete sequence | blastn | 176 | 298 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus vallis | |
| 14537399 | 14537399 | PRJNA541476_P_NODE_22272_length_273_cov_1.080000_g22066_i0 | PRJNA541476 | 22272 | 273 | 1.08 | 2.9484 | Haloferax volcanii | 2246 | Archaea | Archaea | 412 | 9.98e-111 | NTclustered | gi|2459776771|gb|CP104742.1| | 2246 | g22066 | i0 | 94.096 | 1.9047619047619 | 271 | 16 | 99 | 0 | 1 | 271 | 275805 | 275535 | Haloferax volcanii strain SVX82 plasmid pSVX82-1, complete sequence | blastn | 520 | 412 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 15811693 | 15811693 | PRJNA541476_P_NODE_31793_length_249_cov_0.886364_g31587_i0 | PRJNA541476 | 31793 | 249 | 0.886364 | 2.20704636 | Salinirarus marinus | 3068310 | Archaea | Archaea | 363 | 9.169999999999997e-96 | NTclustered | gi|2563036160|gb|CP132292.1| | 3068310 | g31587 | i0 | 93.117 | 0.991967871485944 | 247 | 17 | 99 | 0 | 1 | 247 | 2444756 | 2444510 | Haloferacaceae archaeon XH8 chromosome, complete genome | blastn | 247 | 363 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Salinirarus | Salinirarus marinus | |
| 17085932 | 17085932 | PRJNA541476_P_NODE_14394_length_314_cov_1.290456_g14188_i0 | PRJNA541476 | 14394 | 314 | 1.290456 | 4.05203184 | Halobellus limi | 699433 | Archaea | Archaea | 69.4 | 2.92e-7 | NTclustered | gi|1621075116|gb|CP031311.1| | 699433 | g14188 | i0 | 87.302 | 5.4968152866242 | 63 | 5 | 19 | 2 | 252 | 311 | 1539057 | 1539119 | Halobellus limi strain CGMCC 1.10331 chromosome, complete genome | blastn | 1726 | 69.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus limi | |
| 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);;