contig_metadata
21 rows where bioproject = "PRJNA773247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5852700 | 5852700 | PRJNA773247_P_NODE_7165_length_622_cov_6.176685_g7082_i0 | PRJNA773247 | 7165 | 622 | 6.176685 | 38.4189807 | Halalkalicoccus subterraneus | 2675002 | Archaea | Archaea | 234 | 2.97e-72 | NR | WP_122088266.1 | 2675002 | g7082 | i0 | 83.3 | 0.665594855305466 | 138 | 23 | 66.6 | 0 | 434 | 21 | 1 | 138 | WP_122088266.1 DUF7289 family protein [Halalkalicoccus subterraneus] | diamond | 414 | 234 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus subterraneus | |
| 7127421 | 7127421 | PRJNA773247_P_NODE_12226_length_437_cov_3.230769_g12143_i0 | PRJNA773247 | 12226 | 437 | 3.230769 | 14.11846053 | Halalkalicoccus subterraneus | 2675002 | Archaea | Archaea | 234 | 3.08e-76 | NR | WP_122089653.1 | 2675002 | g12143 | i0 | 82.7 | 0.954233409610984 | 139 | 24 | 95.4 | 0 | 418 | 2 | 1 | 139 | WP_122089653.1 hypothetical protein [Halalkalicoccus subterraneus] | diamond | 417 | 234 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus subterraneus | |
| 10953229 | 10953229 | PRJNA773247_P_NODE_7569_length_599_cov_3.062738_g7486_i0 | PRJNA773247 | 7569 | 599 | 3.062738 | 18.34580062 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 1003 | 0 | NTclustered | gi|299126453|gb|CP002064.1| | 795797 | g7486 | i0 | 96.985 | 0.996661101836394 | 597 | 18 | 99 | 0 | 3 | 599 | 265780 | 265184 | Halalkalicoccus jeotgali B3 plasmid 2, complete sequence | blastn | 597 | 1003 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 10953258 | 10953258 | PRJNA773247_P_NODE_8929_length_536_cov_3.436285_g8846_i0 | PRJNA773247 | 8929 | 536 | 3.436285 | 18.4184876 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 405 | 3.51e-108 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g8846 | i0 | 80.561 | 2.26119402985075 | 535 | 97 | 99 | 7 | 6 | 536 | 214886 | 215417 | Halalkalicoccus jeotgali B3, complete genome | blastn | 1212 | 405 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 12686632 | 12686632 | PRJNA773247_P_NODE_25130_length_279_cov_6.519417_g25046_i0 | PRJNA773247 | 25130 | 279 | 6.519417 | 18.18917343 | Halorubrum | 56688 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|1848526000|gb|CP053941.1| | 2739057 | g25046 | i0 | 97.059 | 0.372759856630824 | 34 | 0 | 12 | 1 | 47 | 80 | 1531636 | 1531604 | Halorubrum salinarum strain RHB-C chromosome, complete genome | blastn | 104 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum salinarum | |
| 14777553 | 14777553 | PRJNA773247_P_NODE_15852_length_371_cov_2.402685_g15768_i0 | PRJNA773247 | 15852 | 371 | 2.402685 | 8.91396135 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 414 | 3.91e-111 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g15768 | i0 | 86.828 | 81.9137466307278 | 372 | 47 | 100 | 2 | 1 | 371 | 2029083 | 2029453 | Halalkalicoccus jeotgali B3, complete genome | blastn | 30390 | 414 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 16051314 | 16051314 | PRJNA773247_P_NODE_15173_length_381_cov_6.344156_g15089_i0 | PRJNA773247 | 15173 | 381 | 6.344156 | 24.17123436 | Haloterrigena salifodinae | 2675099 | Archaea | Archaea | 52.8 | 0.036 | NTclustered | gi|1988313350|gb|CP069188.1| | 2675099 | g15089 | i0 | 100 | 0.073490813648294 | 28 | 0 | 7 | 0 | 14 | 41 | 121443 | 121470 | Haloterrigena salifodinae strain BOL5-1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Haloterrigena | Haloterrigena salifodinae | |
| 21151594 | 21151594 | PRJNA773247_P_NODE_35117_length_240_cov_3.143713_g35033_i0 | PRJNA773247 | 35117 | 240 | 3.143713 | 7.5449112 | Halobellus limi | 699433 | Archaea | Archaea | 62.1 | 3.59e-5 | NTclustered | gi|1621075116|gb|CP031311.1| | 699433 | g35033 | i0 | 97.297 | 1.4 | 37 | 0 | 15 | 1 | 98 | 134 | 2957913 | 2957878 | Halobellus limi strain CGMCC 1.10331 chromosome, complete genome | blastn | 336 | 62.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus limi | |
| 22426036 | 22426036 | PRJNA773247_P_NODE_14218_length_397_cov_2.484568_g14134_i0 | PRJNA773247 | 14218 | 397 | 2.484568 | 9.86373496 | Haloprofundus salinisoli | 2876193 | Archaea | Archaea | 52.8 | 0.038 | NTclustered | gi|2099489100|gb|CP083663.1| | 2876193 | g14134 | i0 | 100 | 0.0705289672544081 | 28 | 0 | 7 | 0 | 89 | 116 | 2107044 | 2107017 | Haloprofundus salinisoli strain SQT7-1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloprofundus | Haloprofundus salinisoli | |
| 23701823 | 23701823 | PRJNA773247_P_NODE_23279_length_292_cov_4.684932_g23195_i0 | PRJNA773247 | 23279 | 292 | 4.684932 | 13.68000144 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 54.7 | 0.008 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g23195 | i0 | 100 | 0.0993150684931507 | 29 | 0 | 10 | 0 | 126 | 154 | 2143302 | 2143274 | Halalkalicoccus jeotgali B3, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 23701998 | 23701998 | PRJNA773247_P_NODE_36479_length_227_cov_3.655844_g36395_i0 | PRJNA773247 | 36479 | 227 | 3.655844 | 8.29876588 | Natronobacterium lacisalsi | 229731 | Archaea | Archaea | 54.7 | 0.006 | NTclustered | gi|1134496220|gb|CP019285.1| | 358396 | g36395 | i0 | 96.875 | 0.140969162995595 | 32 | 1 | 14 | 0 | 159 | 190 | 577095 | 577126 | Halobiforma lacisalsi AJ5, complete genome | blastn | 32 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium lacisalsi | |
| 27021728 | 27021728 | PRJNA773247_P_NODE_34142_length_242_cov_3.609467_g34058_i0 | PRJNA773247 | 34142 | 242 | 3.609467 | 8.73491014 | Methanohalobium sp. | 2837493 | Archaea | Archaea | 95.9 | 3.48e-22 | NR | WP_292487842.1 | 2837493 | g34058 | i0 | 53.8 | 0.991735537190083 | 80 | 36 | 99.2 | 1 | 2 | 241 | 140 | 218 | WP_292487842.1 DNA-methyltransferase, partial [Methanohalobium sp.] | diamond | 240 | 95.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanohalobium | Methanohalobium sp. | |
| 27116340 | 27116340 | PRJNA773247_P_NODE_32782_length_245_cov_2.802326_g32698_i0 | PRJNA773247 | 32782 | 245 | 2.802326 | 6.8656987 | Methanosarcina sp. | 2213 | Archaea | Archaea | 117 | 4.079999999999999e-32 | NR | HET8689608.1 | 2213 | g32698 | i0 | 84.1 | 0.771428571428571 | 63 | 10 | 77.1 | 0 | 2 | 190 | 54 | 116 | HET8689608.1 hypothetical protein [Methanosarcina sp.] | diamond | 189 | 117 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28199656 | 28199656 | PRJNA773247_P_NODE_18846_length_333_cov_2.430769_g18762_i0 | PRJNA773247 | 18846 | 333 | 2.430769 | 8.09446077 | root | 1 | Root_unresolved | Root_unresolved | 85.1 | 1.16e-18 | NR | HON37095.1 | 90426 | g18762 | i0 | 46.2 | 2.79279279279279 | 104 | 42 | 89.2 | 2 | 314 | 18 | 3 | 97 | HON37095.1 HNH endonuclease [Methanothrix sp.] | diamond | 930 | 85.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 28316716 | 28316716 | PRJNA773247_P_NODE_30946_length_249_cov_3.857955_g30862_i0 | PRJNA773247 | 30946 | 249 | 3.857955 | 9.60630795 | Methanomicrobiales archaeon | 2184052 | Archaea | Archaea | 53.1 | 3.28e-6 | NR | NLZ31335.1 | 2184052 | g30862 | i0 | 48.9 | 0.566265060240964 | 47 | 21 | 56.6 | 1 | 98 | 238 | 1 | 44 | NLZ31335.1 hypothetical protein [Methanomicrobiales archaeon] | diamond | 141 | 53.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiales archaeon | |||
| 28821527 | 28821527 | PRJNA773247_P_NODE_24248_length_285_cov_9.971698_g24164_i0 | PRJNA773247 | 24248 | 285 | 9.971698 | 28.4193393 | Methanoregula sp. | 2052170 | Archaea | Archaea | 57 | 5.94e-7 | NR | MCK9591864.1 | 2052170 | g24164 | i0 | 54.4 | 3.09473684210526 | 57 | 25 | 60 | 1 | 8 | 178 | 275 | 330 | MCK9591864.1 collagen-like protein [Methanoregula sp.] | diamond | 882 | 57 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 29232411 | 29232411 | PRJNA773247_P_NODE_36089_length_231_cov_2.272152_g36005_i0 | PRJNA773247 | 36089 | 231 | 2.272152 | 5.24867112 | Methanothrix sp. | 90426 | Archaea | Archaea | 58.2 | 1.76e-8 | NR | HOK59086.1 | 90426 | g36005 | i0 | 66.7 | 0.948051948051948 | 39 | 13 | 50.6 | 0 | 41 | 157 | 59 | 97 | HOK59086.1 hypothetical protein [Methanothrix sp.] | diamond | 219 | 58.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 29516276 | 29516276 | PRJNA773247_P_NODE_27730_length_264_cov_1.596859_g27646_i0 | PRJNA773247 | 27730 | 264 | 1.596859 | 4.21570776 | Halobacteria archaeon | 2670410 | Archaea | Archaea | 43.9 | 0.017 | NR | MEM2990173.1 | 2670410 | g27646 | i0 | 38.8 | 1.125 | 49 | 27 | 55.7 | 2 | 173 | 27 | 141 | 186 | MEM2990173.1 metallophosphoesterase [Halobacteria archaeon] | diamond | 297 | 43.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteria archaeon | ||||
| 30347740 | 30347740 | PRJNA773247_P_NODE_24872_length_281_cov_3.677885_g24788_i0 | PRJNA773247 | 24872 | 281 | 3.677885 | 10.33485685 | root | 1 | Root_unresolved | Root_unresolved | 60.1 | 3.56e-8 | NR | WP_006825677.1 | 160846 | g24788 | i0 | 39.1 | 2.85053380782918 | 87 | 51 | 92.9 | 1 | 21 | 281 | 97 | 181 | WP_006825677.1 DNA adenine methylase [Natrialba taiwanensis] | diamond | 801 | 60.5 | 0.993388429752066 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrialba | Natrialba taiwanensis | |
| 32654771 | 32654771 | PRJNA773247_P_NODE_35240_length_239_cov_2.355422_g35156_i0 | PRJNA773247 | 35240 | 239 | 2.355422 | 5.62945858 | root | 1 | Root_unresolved | Root_unresolved | 67.4 | 1.19e-11 | NR | WP_148858122.1 | 2055836 | g35156 | i0 | 40 | 1.9581589958159 | 80 | 47 | 99.2 | 1 | 239 | 3 | 15 | 94 | WP_148858122.1 flavodoxin domain-containing protein [Natronococcus pandeyae] | diamond | 468 | 67.8 | 0.994100294985251 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronococcus | Natronococcus pandeyae | |
| 32897317 | 32897317 | PRJNA773247_P_NODE_26180_length_273_cov_1.415000_g26096_i0 | PRJNA773247 | 26180 | 273 | 1.415 | 3.86295 | Methanoculleus sp. UBA45 | 1915512 | Archaea | Archaea | 43.9 | 0.0135 | NR | WP_343241183.1 | 1915512 | g26096 | i0 | 31.9 | 2.91208791208791 | 72 | 45 | 79.1 | 3 | 272 | 57 | 2 | 69 | WP_343241183.1 hypothetical protein [Methanoculleus sp. UBA45] | diamond | 795 | 43.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. UBA45 |
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);;