contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA599026" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3122955 | 3122955 | PRJNA599026_S_NODE_64243_length_163_cov_0.894737_g63787_i0 | PRJNA599026 | 64243 | 163 | 0.894737 | 1.45842131 | Halococcus salsus | 2162894 | Archaea | Archaea | 117 | 4.65e-29 | NR | WP_160134512.1 | 2162894 | g63787 | i0 | 100 | 0.993865030674847 | 54 | 0 | 99.4 | 0 | 1 | 162 | 524 | 577 | WP_160134512.1 (Fe-S)-binding protein [Halococcus salsus] | diamond | 162 | 117 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salsus | |
| 4399776 | 4399776 | PRJNA599026_S_NODE_71684_length_161_cov_0.910714_g71228_i0 | PRJNA599026 | 71684 | 161 | 0.910714 | 1.46624954 | Halococcus salsus | 2162894 | Archaea | Archaea | 102 | 5.87e-25 | NR | WP_160134565.1 | 2162894 | g71228 | i0 | 96.2 | 0.987577639751553 | 53 | 2 | 98.8 | 0 | 161 | 3 | 40 | 92 | WP_160134565.1 SDR family NAD(P)-dependent oxidoreductase [Halococcus salsus] | diamond | 159 | 102 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salsus | |
| 27111354 | 27111354 | PRJNA599026_S_NODE_72122_length_161_cov_0.875000_g71666_i0 | PRJNA599026 | 72122 | 161 | 0.875 | 1.40875 | Halorubrum kocurii | 478441 | Archaea | Archaea | 65.1 | 1.45e-10 | NR | WP_008849611.1 | 478441 | g71666 | i0 | 67.9 | 1.97515527950311 | 53 | 11 | 98.8 | 1 | 1 | 159 | 176 | 222 | WP_008849611.1 glycosyltransferase family 4 protein [Halorubrum kocurii] | diamond | 318 | 65.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum kocurii | |
| 27396146 | 27396146 | PRJNA599026_S_NODE_7463_length_352_cov_2.346535_g7007_i0 | PRJNA599026 | 7463 | 352 | 2.346535 | 8.2598032 | Natrarchaeobius chitinivorans | 1679083 | Archaea | Archaea | 55.1 | 7.12e-7 | NR | WP_124190132.1 | 1679083 | g7007 | i0 | 44.4 | 1.38068181818182 | 54 | 30 | 46 | 0 | 331 | 170 | 20 | 73 | WP_124190132.1 thioredoxin [Natrarchaeobius chitinivorans] | diamond | 486 | 55.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrarchaeobius | Natrarchaeobius chitinivorans | |
| 27553557 | 27553557 | PRJNA599026_S_NODE_54184_length_166_cov_0.871795_g53728_i0 | PRJNA599026 | 54184 | 166 | 0.871795 | 1.4471797 | Salinirubellus | 2162630 | Archaea | Archaea | 90.5 | 1.19e-19 | NR | WP_338914243.1 | 2162630 | g53728 | i0 | 74.5 | 0.993975903614458 | 55 | 14 | 99.4 | 0 | 1 | 165 | 292 | 346 | WP_338914243.1 MULTISPECIES: L-2-hydroxyglutarate oxidase [Salinirubellus] | diamond | 165 | 90.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Salinirubellus | ||
| 27932729 | 27932729 | PRJNA599026_S_NODE_65105_length_163_cov_0.894737_g64649_i0 | PRJNA599026 | 65105 | 163 | 0.894737 | 1.45842131 | Halanaeroarchaeum sp. | 1963275 | Archaea | Archaea | 73.2 | 1.07e-14 | NR | MFB6094612.1 | 1963275 | g64649 | i0 | 64.8 | 0.993865030674847 | 54 | 19 | 99.4 | 0 | 1 | 162 | 2 | 55 | MFB6094612.1 hypothetical protein [Halanaeroarchaeum sp.] | diamond | 162 | 73.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halanaeroarchaeum | Halanaeroarchaeum sp. | |
| 27964222 | 27964222 | PRJNA599026_S_NODE_51745_length_167_cov_0.864407_g51289_i0 | PRJNA599026 | 51745 | 167 | 0.864407 | 1.44355969 | Halapricum sp. | 1979218 | Archaea | Archaea | 92.4 | 2.72e-20 | NR | MFB6189341.1 | 1979218 | g51289 | i0 | 75.5 | 0.952095808383233 | 53 | 13 | 95.2 | 0 | 165 | 7 | 357 | 409 | MFB6189341.1 hypothetical protein [Halapricum sp.] | diamond | 159 | 92.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halapricum | Halapricum sp. | |
| 27964233 | 27964233 | PRJNA599026_S_NODE_66745_length_162_cov_0.902655_g66289_i0 | PRJNA599026 | 66745 | 162 | 0.902655 | 1.4623011 | Halococcus salsus | 2162894 | Archaea | Archaea | 92.8 | 5.670000000000001e-21 | NR | WP_160134477.1 | 2162894 | g66289 | i0 | 97.8 | 0.833333333333333 | 45 | 1 | 83.3 | 0 | 161 | 27 | 261 | 305 | WP_160134477.1 cobalamin-binding protein [Halococcus salsus] | diamond | 135 | 92.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salsus | |
| 28153950 | 28153950 | PRJNA599026_S_NODE_60045_length_164_cov_0.886957_g59589_i0 | PRJNA599026 | 60045 | 164 | 0.886957 | 1.45460948 | Halococcus sediminicola | 1264579 | Archaea | Archaea | 54.3 | 9.91e-7 | NR | WP_049997523.1 | 1264579 | g59589 | i0 | 75 | 0.585365853658537 | 32 | 8 | 58.5 | 0 | 69 | 164 | 33 | 64 | WP_049997523.1 alpha/beta hydrolase [Halococcus sediminicola] | diamond | 96 | 54.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sediminicola | |
| 28279815 | 28279815 | PRJNA599026_S_NODE_58446_length_165_cov_0.879310_g57990_i0 | PRJNA599026 | 58446 | 165 | 0.87931 | 1.4508615 | Halegenticoccus tardaugens | 2071624 | Archaea | Archaea | 57 | 9.31e-8 | NR | WP_129114102.1 | 2071624 | g57990 | i0 | 68.3 | 7.34545454545455 | 41 | 13 | 74.5 | 0 | 24 | 146 | 58 | 98 | WP_129114102.1 ABC transporter permease [Halegenticoccus tardaugens] | diamond | 1212 | 57 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halegenticoccus | Halegenticoccus tardaugens | |
| 28785032 | 28785032 | PRJNA599026_S_NODE_51367_length_167_cov_0.864407_g50911_i0 | PRJNA599026 | 51367 | 167 | 0.864407 | 1.44355969 | Halococcus hamelinensis | 332168 | Archaea | Archaea | 95.9 | 2.4300000000000003e-21 | NR | WP_007690162.1 | 332168 | g50911 | i0 | 92.7 | 0.988023952095808 | 55 | 2 | 98.8 | 1 | 167 | 3 | 430 | 482 | WP_007690162.1 ammonium transporter [Halococcus hamelinensis] | diamond | 165 | 95.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus hamelinensis | |
| 29195809 | 29195809 | PRJNA599026_S_NODE_70589_length_161_cov_0.910714_g70133_i0 | PRJNA599026 | 70589 | 161 | 0.910714 | 1.46624954 | Haloferax sp. Q22 | 1526048 | Archaea | Archaea | 96.7 | 1.24e-21 | NR | WP_172795783.1 | 1526048 | g70133 | i0 | 83 | 0.987577639751553 | 53 | 9 | 98.8 | 0 | 159 | 1 | 147 | 199 | WP_172795783.1 GmrSD restriction endonuclease domain-containing protein [Haloferax sp. Q22] | diamond | 159 | 96.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax sp. Q22 | |
| 29227477 | 29227477 | PRJNA599026_S_NODE_57489_length_165_cov_0.879310_g57033_i0 | PRJNA599026 | 57489 | 165 | 0.87931 | 1.4508615 | Halococcus sp. IIIV-5B | 2321230 | Archaea | Archaea | 81.3 | 2.15e-16 | NR | WP_120068596.1 | 2321230 | g57033 | i0 | 66 | 0.963636363636364 | 53 | 18 | 96.4 | 0 | 2 | 160 | 196 | 248 | WP_120068596.1 lysylphosphatidylglycerol synthase transmembrane domain-containing protein [Halococcus sp. IIIV-5B] | diamond | 159 | 81.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. IIIV-5B | |
| 29416540 | 29416540 | PRJNA599026_S_NODE_12429_length_281_cov_2.357759_g11973_i0 | PRJNA599026 | 12429 | 281 | 2.357759 | 6.62530279 | Natrononativus amylolyticus | 2963434 | Archaea | Archaea | 43.1 | 0.0406 | NR | WP_255170654.1 | 2963434 | g11973 | i0 | 45.3 | 0.565836298932384 | 53 | 25 | 52.3 | 1 | 18 | 164 | 266 | 318 | WP_255170654.1 M24 family metallopeptidase [Natrononativus amylolyticus] | diamond | 159 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrononativus | Natrononativus amylolyticus | |
| 29416547 | 29416547 | PRJNA599026_S_NODE_31469_length_198_cov_1.369128_g31013_i0 | PRJNA599026 | 31469 | 198 | 1.369128 | 2.71087344 | Halocatena marina | 2934937 | Archaea | Archaea | 58.2 | 5.29e-8 | NR | WP_248907501.1 | 2934937 | g31013 | i0 | 66 | 0.712121212121212 | 47 | 16 | 71.2 | 0 | 50 | 190 | 129 | 175 | WP_248907501.1 DUF4013 domain-containing protein [Halocatena marina] | diamond | 141 | 58.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halocatena | Halocatena marina | |
| 29416555 | 29416555 | PRJNA599026_S_NODE_46229_length_172_cov_3.097561_g45773_i0 | PRJNA599026 | 46229 | 172 | 3.097561 | 5.32780492 | Haloarchaeobius amylolyticus | 1198296 | Archaea | Archaea | 41.6 | 0.0357 | NR | WP_267639183.1 | 1198296 | g45773 | i0 | 51.3 | 0.680232558139535 | 39 | 19 | 68 | 0 | 15 | 131 | 340 | 378 | WP_267639183.1 DUF3179 domain-containing protein [Haloarchaeobius amylolyticus] | diamond | 117 | 41.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halorubellaceae | Haloarchaeobius | Haloarchaeobius amylolyticus | |
| 29416571 | 29416571 | PRJNA599026_S_NODE_64249_length_163_cov_0.894737_g63793_i0 | PRJNA599026 | 64249 | 163 | 0.894737 | 1.45842131 | Halorhabdus tiamatea | 430914 | Archaea | Archaea | 45.8 | 3.29e-4 | NR | WP_008525137.1 | 430914 | g63793 | i0 | 69 | 1.08588957055215 | 29 | 9 | 53.4 | 0 | 4 | 90 | 94 | 122 | WP_008525137.1 hypothetical protein [Halorhabdus tiamatea] | diamond | 177 | 45.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorhabdus | Halorhabdus tiamatea | |
| 29668908 | 29668908 | PRJNA599026_S_NODE_57690_length_165_cov_0.879310_g57234_i0 | PRJNA599026 | 57690 | 165 | 0.87931 | 1.4508615 | Haladaptatus pallidirubidus | 1008152 | Archaea | Archaea | 60.8 | 4.03e-10 | NR | WP_345409552.1 | 1008152 | g57234 | i0 | 69 | 1.52727272727273 | 42 | 13 | 76.4 | 0 | 126 | 1 | 13 | 54 | WP_345409552.1 hypothetical protein [Haladaptatus pallidirubidus] | diamond | 252 | 60.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus pallidirubidus | |
| 29700478 | 29700478 | PRJNA599026_S_NODE_57710_length_165_cov_0.879310_g57254_i0 | PRJNA599026 | 57710 | 165 | 0.87931 | 1.4508615 | Halococcus sp. IIIV-5B | 2321230 | Archaea | Archaea | 108 | 8.75e-26 | NR | WP_120071638.1 | 2321230 | g57254 | i0 | 98.2 | 1 | 55 | 1 | 100 | 0 | 1 | 165 | 732 | 786 | WP_120071638.1 plasmid replication protein RepH [Halococcus sp. IIIV-5B] | diamond | 165 | 108 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. IIIV-5B | |
| 29890511 | 29890511 | PRJNA599026_S_NODE_58271_length_165_cov_0.879310_g57815_i0 | PRJNA599026 | 58271 | 165 | 0.87931 | 1.4508615 | Halococcus sp. IIIV-5B | 2321230 | Archaea | Archaea | 95.5 | 9.56e-22 | NR | WP_120072535.1 | 2321230 | g57815 | i0 | 90.9 | 1 | 55 | 5 | 100 | 0 | 1 | 165 | 109 | 163 | WP_120072535.1 o-succinylbenzoate synthase [Halococcus sp. IIIV-5B] | diamond | 165 | 95.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. IIIV-5B | |
| 30616918 | 30616918 | PRJNA599026_S_NODE_67573_length_162_cov_0.902655_g67117_i0 | PRJNA599026 | 67573 | 162 | 0.902655 | 1.4623011 | Candidatus Nanosalina sp. J | 3101438 | Archaea | Archaea | 56.6 | 1.61e-7 | NR | EGQ44072.1 | 889948 | g67117 | i0 | 61.2 | 0.907407407407407 | 49 | 12 | 77.8 | 1 | 1 | 126 | 266 | 314 | EGQ44072.1 MAG: subtilisin-like serine protease [Candidatus Nanosalina sp. J07AB43] | diamond | 147 | 56.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Nanohaloarchaea | Candidatus Nanosalina | Candidatus Nanosalina sp. J07AB43 | |||
| 31565480 | 31565480 | PRJNA599026_S_NODE_68016_length_162_cov_0.902655_g67560_i0 | PRJNA599026 | 68016 | 162 | 0.902655 | 1.4623011 | Halococcus salsus | 2162894 | Archaea | Archaea | 113 | 1.04e-29 | NR | WP_160134238.1 | 2162894 | g67560 | i0 | 100 | 0.981481481481482 | 53 | 0 | 98.1 | 0 | 160 | 2 | 31 | 83 | WP_160134238.1 hypothetical protein [Halococcus salsus] | diamond | 159 | 113 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salsus | |
| 31691743 | 31691743 | PRJNA599026_S_NODE_55257_length_166_cov_0.871795_g54801_i0 | PRJNA599026 | 55257 | 166 | 0.871795 | 1.4471797 | Halococcus salsus | 2162894 | Archaea | Archaea | 100 | 4.38e-23 | NR | WP_160134950.1 | 2162894 | g54801 | i0 | 100 | 0.993975903614458 | 55 | 0 | 99.4 | 0 | 1 | 165 | 149 | 203 | WP_160134950.1 TrkH family potassium uptake protein [Halococcus salsus] | diamond | 165 | 100 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salsus | |
| 32261541 | 32261541 | PRJNA599026_S_NODE_63578_length_163_cov_0.894737_g63122_i0 | PRJNA599026 | 63578 | 163 | 0.894737 | 1.45842131 | Halococcus salsus | 2162894 | Archaea | Archaea | 85.1 | 2.17e-18 | NR | WP_160134293.1 | 2162894 | g63122 | i0 | 97.7 | 0.809815950920245 | 44 | 1 | 81 | 0 | 132 | 1 | 1 | 44 | WP_160134293.1 NAD(P)/FAD-dependent oxidoreductase [Halococcus salsus] | diamond | 132 | 85.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salsus | |
| 32482877 | 32482877 | PRJNA599026_S_NODE_57299_length_165_cov_0.879310_g56843_i0 | PRJNA599026 | 57299 | 165 | 0.87931 | 1.4508615 | Halococcus salsus | 2162894 | Archaea | Archaea | 112 | 1.95e-28 | NR | WP_160133845.1 | 2162894 | g56843 | i0 | 96.3 | 0.981818181818182 | 54 | 2 | 98.2 | 0 | 2 | 163 | 107 | 160 | WP_160133845.1 polysaccharide deacetylase family protein [Halococcus salsus] | diamond | 162 | 112 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salsus |
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);;