contig_metadata
25 rows where bioproject = "PRJNA849172" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4665743 | 4665743 | PRJNA849172_P_NODE_75664_length_264_cov_1.408377_g75304_i0 | PRJNA849172 | 75664 | 264 | 1.408377 | 3.71811528 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 333 | 7.689999999999999e-87 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g75304 | i0 | 89.961 | 3.89772727272727 | 259 | 24 | 98 | 2 | 1 | 258 | 1828025 | 1828282 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 1029 | 333 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 5937480 | 5937480 | PRJNA849172_P_NODE_108725_length_242_cov_0.923077_g108365_i0 | PRJNA849172 | 108725 | 242 | 0.923077 | 2.23384634 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 268 | 1.99e-67 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g108365 | i0 | 86.831 | 1.83057851239669 | 243 | 29 | 100 | 3 | 1 | 242 | 2664898 | 2665138 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 443 | 268 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 6336673 | 6336673 | PRJNA849172_P_NODE_49085_length_299_cov_1.685841_g48725_i0 | PRJNA849172 | 49085 | 299 | 1.685841 | 5.0406645899999996 | Halococcus | 2249 | Archaea | Archaea | 436 | 6.57e-118 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g48725 | i0 | 92.977 | 10.4916387959866 | 299 | 21 | 100 | 0 | 1 | 299 | 396318 | 396616 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 3137 | 436 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 7215512 | 7215512 | PRJNA849172_P_NODE_78826_length_261_cov_1.388298_g78466_i0 | PRJNA849172 | 78826 | 261 | 1.388298 | 3.62345778 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 305 | 1.65e-78 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g78466 | i0 | 87.984 | 1.94252873563218 | 258 | 31 | 99 | 0 | 1 | 258 | 548752 | 549009 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 507 | 305 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 8490672 | 8490672 | PRJNA849172_P_NODE_94447_length_249_cov_1.994318_g94087_i0 | PRJNA849172 | 94447 | 249 | 1.994318 | 4.96585182 | Salinibaculum rarum | 3058903 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|2548167091|gb|CP129992.1| | 3058903 | g94087 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 94 | 121 | 2867748 | 2867721 | Salinibaculum rarum strain KK48 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Salinibaculum | Salinibaculum rarum | |
| 10161241 | 10161241 | PRJNA849172_P_NODE_56708_length_285_cov_2.943396_g56348_i0 | PRJNA849172 | 56708 | 285 | 2.943396 | 8.3886786 | Halococcus | 2249 | Archaea | Archaea | 350 | 8.34e-92 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g56348 | i0 | 88.772 | 96.8140350877193 | 285 | 32 | 100 | 0 | 1 | 285 | 1116060 | 1115776 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 27592 | 350 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 14862230 | 14862230 | PRJNA849172_P_NODE_108592_length_242_cov_0.923077_g108232_i0 | PRJNA849172 | 108592 | 242 | 0.923077 | 2.23384634 | Halomarina pelagica | 2961599 | Archaea | Archaea | 274 | 4.27e-69 | NTclustered | gi|2270305251|gb|CP100455.1| | 2961599 | g108232 | i0 | 87.712 | 5.78099173553719 | 236 | 27 | 97 | 2 | 1 | 235 | 261276 | 261510 | Halomarina pelagica strain BND7 plasmid unnamed1, complete sequence | blastn | 1399 | 274 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina pelagica | |
| 14864560 | 14864560 | PRJNA849172_P_NODE_52292_length_291_cov_3.733945_g51932_i0 | PRJNA849172 | 52292 | 291 | 3.733945 | 10.86577995 | Halorussus vallis | 2953749 | Archaea | Archaea | 52.8 | 0.027 | NTclustered | gi|2263966384|gb|CP100000.1| | 2953749 | g51932 | i0 | 100 | 0.0962199312714777 | 28 | 0 | 10 | 0 | 227 | 254 | 3508578 | 3508605 | Halorussus vallis strain XZYJT10 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus vallis | |
| 14865523 | 14865523 | PRJNA849172_P_NODE_83532_length_256_cov_4.956284_g83172_i0 | PRJNA849172 | 83532 | 256 | 4.956284 | 12.68808704 | Haloarcula sp. CBA1115 | 1592728 | Archaea | Archaea | 451 | 1.96e-122 | NTclustered | gi|749699433|gb|CP010529.1| | 1592728 | g83172 | i0 | 98.438 | 110.87890625 | 256 | 4 | 100 | 0 | 1 | 256 | 1463 | 1208 | Haloarcula sp. CBA1115, complete genome | blastn | 28385 | 451 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula sp. CBA1115 | |
| 18685750 | 18685750 | PRJNA849172_P_NODE_113775_length_237_cov_3.804878_g113415_i0 | PRJNA849172 | 113775 | 237 | 3.804878 | 9.01756086 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 383 | 6.64e-102 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g113415 | i0 | 95.781 | 1.9915611814346 | 237 | 10 | 100 | 0 | 1 | 237 | 282091 | 282327 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 472 | 383 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 18686314 | 18686314 | PRJNA849172_P_NODE_134875_length_214_cov_5.085106_g134515_i0 | PRJNA849172 | 134875 | 214 | 5.085106 | 10.88212684 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 56.5 | 0.001 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g134515 | i0 | 100 | 0.14018691588785 | 30 | 0 | 14 | 0 | 14 | 43 | 79064 | 79035 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 18688431 | 18688431 | PRJNA849172_P_NODE_70955_length_268_cov_5.497436_g70595_i0 | PRJNA849172 | 70955 | 268 | 5.497436 | 14.73312848 | root | 1 | Root_unresolved | Root_unresolved | 66.2 | 2.74e-10 | NR | WP_052279112.1 | 2214 | g70595 | i0 | 47.7 | 2.95522388059702 | 88 | 44 | 98.5 | 1 | 268 | 5 | 239 | 324 | WP_052279112.1 PAS domain S-box protein [Methanosarcina acetivorans] | diamond | 792 | 66.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina acetivorans | |
| 19961813 | 19961813 | PRJNA849172_P_NODE_146076_length_201_cov_4.500000_g145716_i0 | PRJNA849172 | 146076 | 201 | 4.5 | 9.045 | Halococcus sediminicola | 1264579 | Archaea | Archaea | 115 | 5.430000000000001e-29 | NR | WP_154019981.1 | 1264579 | g145716 | i0 | 90.2 | 0.91044776119403 | 61 | 6 | 91 | 0 | 200 | 18 | 111 | 171 | WP_154019981.1 IS630 family transposase [Halococcus sediminicola] | diamond | 183 | 115 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sediminicola | |
| 19963957 | 19963957 | PRJNA849172_P_NODE_82576_length_257_cov_3.603261_g82216_i0 | PRJNA849172 | 82576 | 257 | 3.603261 | 9.26038077 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 387 | 5.64e-103 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g82216 | i0 | 93.774 | 47.6614785992218 | 257 | 16 | 100 | 0 | 1 | 257 | 1737460 | 1737204 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 12249 | 387 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 22511510 | 22511510 | PRJNA849172_P_NODE_122458_length_230_cov_2.528662_g122098_i0 | PRJNA849172 | 122458 | 230 | 2.528662 | 5.8159226 | Halomarina litorea | 2961595 | Archaea | Archaea | 198 | 2.49e-46 | NTclustered | gi|2270268912|gb|CP100448.1| | 2961595 | g122098 | i0 | 83.105 | 4.91739130434783 | 219 | 35 | 95 | 2 | 13 | 230 | 3008566 | 3008349 | Halomarina litorea strain BCD28 chromosome, complete genome | blastn | 1131 | 198 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina litorea | |
| 23786510 | 23786510 | PRJNA849172_P_NODE_104519_length_244_cov_0.912281_g104159_i0 | PRJNA849172 | 104519 | 244 | 0.912281 | 2.22596564 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 303 | 5.5e-78 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g104159 | i0 | 89.831 | 0.967213114754098 | 236 | 24 | 97 | 0 | 1 | 236 | 2703563 | 2703798 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 236 | 303 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 26905090 | 26905090 | PRJNA849172_P_NODE_82941_length_257_cov_2.255435_g82581_i0 | PRJNA849172 | 82941 | 257 | 2.255435 | 5.79646795 | root | 1 | Root_unresolved | Root_unresolved | 66.6 | 1.71e-10 | NR | MCX8207589.1 | 90426 | g82581 | i0 | 36.5 | 5.96498054474708 | 85 | 54 | 99.2 | 0 | 257 | 3 | 293 | 377 | MCX8207589.1 PAS domain S-box protein [Methanothrix sp.] | diamond | 1533 | 66.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 27023242 | 27023242 | PRJNA849172_P_NODE_89562_length_252_cov_1.083799_g89202_i0 | PRJNA849172 | 89562 | 252 | 1.083799 | 2.73117348 | Halococcus salifodinae | 36738 | Archaea | Archaea | 51.6 | 3.25e-5 | NR | WP_241430264.1 | 36738 | g89202 | i0 | 60 | 0.833333333333333 | 35 | 14 | 41.7 | 0 | 252 | 148 | 954 | 988 | WP_241430264.1 VWA domain-containing protein [Halococcus salifodinae] | diamond | 210 | 51.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salifodinae | |
| 27781522 | 27781522 | PRJNA849172_P_NODE_59264_length_282_cov_1.712919_g58904_i0 | PRJNA849172 | 59264 | 282 | 1.712919 | 4.83043158 | Halococcus thailandensis | 335952 | Archaea | Archaea | 161 | 5.15e-44 | NR | WP_241431201.1 | 335952 | g58904 | i0 | 86.5 | 1.8936170212766 | 89 | 12 | 94.7 | 0 | 269 | 3 | 34 | 122 | WP_241431201.1 carboxypeptidase-like regulatory domain-containing protein [Halococcus thailandensis] | diamond | 534 | 161 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus thailandensis | |
| 27947631 | 27947631 | PRJNA849172_P_NODE_114505_length_236_cov_6.453988_g114145_i0 | PRJNA849172 | 114505 | 236 | 6.453988 | 15.23141168 | Halococcus | 2249 | Archaea | Archaea | 54.7 | 6.69e-7 | NR | PSQ64376.1 | 1919209 | g114145 | i0 | 73.2 | 4.71610169491525 | 41 | 11 | 52.1 | 0 | 8 | 130 | 129 | 169 | PSQ64376.1 MAG: TspO protein [Halobacteriales archaeon SW_9_67_24] | diamond | 1113 | 55.1 | 0.992740471869329 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon SW_9_67_24 | |||
| 29589093 | 29589093 | PRJNA849172_P_NODE_101370_length_245_cov_3.953488_g101010_i0 | PRJNA849172 | 101370 | 245 | 3.953488 | 9.6860456 | root | 1 | Root_unresolved | Root_unresolved | 56.6 | 5.04e-7 | NR | WP_292345499.1 | 1811680 | g101010 | i0 | 70 | 3.64897959183673 | 50 | 14 | 61.2 | 1 | 231 | 82 | 215 | 263 | WP_292345499.1 PKD domain-containing protein [Methanoregula sp. PtaB.Bin085] | diamond | 894 | 56.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. PtaB.Bin085 | |
| 30497302 | 30497302 | PRJNA849172_P_NODE_55553_length_287_cov_1.448598_g55193_i0 | PRJNA849172 | 55553 | 287 | 1.448598 | 4.15747626 | Methanosarcina sp. | 2213 | Archaea | Archaea | 141 | 1.96e-40 | NR | HET8689243.1 | 2213 | g55193 | i0 | 71.3 | 0.982578397212544 | 94 | 27 | 98.3 | 0 | 287 | 6 | 68 | 161 | HET8689243.1 hypothetical protein [Methanosarcina sp.] | diamond | 282 | 141 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 31517087 | 31517087 | PRJNA849172_P_NODE_82996_length_257_cov_2.108696_g82636_i0 | PRJNA849172 | 82996 | 257 | 2.108696 | 5.41934872 | Halococcus | 2249 | Archaea | Archaea | 120 | 2.78e-29 | NR | WP_256686162.1 | 224402 | g82636 | i0 | 69.4 | 1.98443579766537 | 85 | 26 | 99.2 | 0 | 256 | 2 | 653 | 737 | WP_256686162.1 ABC transporter permease [Halococcus qingdaonensis] | diamond | 510 | 120 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 32077888 | 32077888 | PRJNA849172_P_NODE_101838_length_245_cov_2.575581_g101478_i0 | PRJNA849172 | 101838 | 245 | 2.575581 | 6.31017345 | Methanosarcina sp. | 2213 | Archaea | Archaea | 73.6 | 3.28e-14 | NR | HET8688272.1 | 2213 | g101478 | i0 | 64 | 0.612244897959184 | 50 | 18 | 61.2 | 0 | 95 | 244 | 3 | 52 | HET8688272.1 protein-tyrosine phosphatase family protein [Methanosarcina sp.] | diamond | 150 | 73.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 32772977 | 32772977 | PRJNA849172_P_NODE_62540_length_278_cov_1.795122_g62180_i0 | PRJNA849172 | 62540 | 278 | 1.795122 | 4.99043916 | Halococcus sp. PRR34 | 3020830 | Archaea | Archaea | 141 | 2.17e-39 | NR | WP_273838618.1 | 3020830 | g62180 | i0 | 94.6 | 0.798561151079137 | 74 | 4 | 79.9 | 0 | 55 | 276 | 7 | 80 | WP_273838618.1 hypothetical protein [Halococcus sp. PRR34] | diamond | 222 | 141 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. PRR34 |
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);;