contig_metadata
25 rows where bioproject = "PRJNA812715" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4643367 | 4643367 | PRJNA812715_P_NODE_9284_length_1348_cov_4.941961_g8305_i0 | PRJNA812715 | 9284 | 1348 | 4.941961 | 66.61763428 | Haloterrigena salinisoli | 3132747 | Archaea | Archaea | 56.5 | 0.011 | NTclustered | gi|2706837818|gb|CP149787.1| | 3132747 | g8305 | i0 | 100 | 0.0459940652818991 | 30 | 0 | 2 | 0 | 568 | 597 | 2037648 | 2037619 | Haloterrigena salinisoli strain KLK7 chromosome, complete genome | blastn | 62 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Haloterrigena | Haloterrigena salinisoli | |
| 5052974 | 5052974 | PRJNA812715_P_NODE_35344_length_489_cov_3.682692_g33559_i0 | PRJNA812715 | 35344 | 489 | 3.682692 | 18.00836388 | Halomicrobium | 203135 | Archaea | Archaea | 58.4 | 0.001 | NTclustered | gi|1622736797|gb|CP039375.1| | 57705 | g33559 | i0 | 91.111 | 0.466257668711656 | 45 | 0 | 9 | 4 | 249 | 292 | 2847588 | 2847547 | Halomicrobium mukohataei strain JP60 chromosome, complete genome | blastn | 228 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halomicrobium | Halomicrobium mukohataei | |
| 5915245 | 5915245 | PRJNA812715_P_NODE_108965_length_247_cov_1.770115_g107164_i0 | PRJNA812715 | 108965 | 247 | 1.770115 | 4.37218405 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 296 | 9.34e-76 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g107164 | i0 | 88.259 | 1 | 247 | 29 | 100 | 0 | 1 | 247 | 2072968 | 2073214 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 247 | 296 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 7192707 | 7192707 | PRJNA812715_P_NODE_80746_length_283_cov_1.466667_g78946_i0 | PRJNA812715 | 80746 | 283 | 1.466667 | 4.15066761 | Halomicrobium salinisoli | 2878391 | Archaea | Archaea | 156 | 1.93e-33 | NTclustered | gi|2110956525|gb|CP084463.1| | 2878391 | g78946 | i0 | 87.05 | 2.0565371024735 | 139 | 16 | 49 | 2 | 146 | 283 | 2675634 | 2675497 | Halomicrobium salinisoli strain LT50 chromosome, complete genome | blastn | 582 | 156 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halomicrobium | Halomicrobium salinisoli | |
| 9742684 | 9742684 | PRJNA812715_P_NODE_84888_length_276_cov_6.384236_g83087_i0 | PRJNA812715 | 84888 | 276 | 6.384236 | 17.62049136 | Natrinema sp. SYSU A 869 | 2871694 | Archaea | Archaea | 52.8 | 0.025 | NTclustered | gi|2089988103|gb|CP082249.1| | 2871694 | g83087 | i0 | 100 | 0.101449275362319 | 28 | 0 | 10 | 0 | 124 | 151 | 290520 | 290493 | Natrinema sp. SYSU A 869 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema sp. SYSU A 869 | |
| 11429199 | 11429199 | PRJNA812715_P_NODE_98169_length_256_cov_1.426230_g96368_i0 | PRJNA812715 | 98169 | 256 | 1.42623 | 3.6511488 | Haloferax | 2251 | Archaea | Archaea | 141 | 4.83e-29 | NTclustered | gi|4958988|gb|AF068743.1|AF068743 | 2246 | g96368 | i0 | 85.926 | 5.1953125 | 135 | 16 | 52 | 3 | 121 | 253 | 2550 | 2417 | Haloferax volcanii pyruvate decarboxylase E1 alpha subunit (pdhA) and pyruvate decarboxylase E1 beta subunit (pdhB) genes, complete cds; and lipoate acetyl-transferase E2 (pdhC) gene, partial cds | blastn | 1330 | 141 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 12290939 | 12290939 | PRJNA812715_P_NODE_101350_length_251_cov_1.730337_g99549_i0 | PRJNA812715 | 101350 | 251 | 1.730337 | 4.34314587 | Natrinema longum | 370324 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|2006040148|gb|CP071463.1| | 370324 | g99549 | i0 | 96.875 | 0.127490039840637 | 32 | 0 | 13 | 1 | 68 | 99 | 299374 | 299344 | Natrinema longum strain ABH32 chromosome, complete genome | blastn | 32 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema longum | |
| 12293624 | 12293624 | PRJNA812715_P_NODE_76410_length_290_cov_1.419355_g74610_i0 | PRJNA812715 | 76410 | 290 | 1.419355 | 4.1161295 | Halorubrum sp. PV6 | 634157 | Archaea | Archaea | 52.8 | 0.027 | NTclustered | gi|1540603140|gb|CP030064.1| | 634157 | g74610 | i0 | 100 | 0.096551724137931 | 28 | 0 | 10 | 0 | 16 | 43 | 758802 | 758829 | Halorubrum sp. PV6 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. PV6 | |
| 19938949 | 19938949 | PRJNA812715_P_NODE_125256_length_201_cov_4.906250_g123455_i0 | PRJNA812715 | 125256 | 201 | 4.90625 | 9.8615625 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 209 | 9.8e-50 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g123455 | i0 | 85.93 | 28.452736318408 | 199 | 25 | 99 | 1 | 3 | 201 | 2630426 | 2630621 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 5719 | 209 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 26642690 | 26642690 | PRJNA812715_P_NODE_90961_length_267_cov_1.350515_g89160_i0 | PRJNA812715 | 90961 | 267 | 1.350515 | 3.60587505 | Halorubrum | 56688 | Archaea | Archaea | 174 | 5.69e-51 | NR | WP_053771994.1 | 56688 | g89160 | i0 | 95.5 | 0.98876404494382 | 88 | 4 | 98.9 | 0 | 266 | 3 | 288 | 375 | WP_053771994.1 MULTISPECIES: ABC transporter ATP-binding protein [Halorubrum] | diamond | 264 | 174 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | ||
| 26778371 | 26778371 | PRJNA812715_P_NODE_122221_length_239_cov_2.861446_g120420_i0 | PRJNA812715 | 122221 | 239 | 2.861446 | 6.83885594 | Candidatus Poseidonia | 2599198 | Archaea | Archaea | 139 | 2.17e-36 | NR | RJU90963.1 | 2163009 | g120420 | i0 | 87.3 | 1.98326359832636 | 79 | 10 | 99.2 | 0 | 2 | 238 | 340 | 418 | RJU90963.1 MAG: ArsR family transcriptional regulator [Candidatus Poseidoniales archaeon] | diamond | 474 | 139 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 27884325 | 27884325 | PRJNA812715_P_NODE_108125_length_248_cov_0.880000_g106324_i0 | PRJNA812715 | 108125 | 248 | 0.88 | 2.1824 | root | 1 | Root_unresolved | Root_unresolved | 41.2 | 0.0413 | NR | WP_214041426.1 | 90427 | g106324 | i0 | 34.9 | 2.26209677419355 | 63 | 34 | 76.2 | 1 | 18 | 206 | 28 | 83 | WP_214041426.1 ferredoxin-thioredoxin reductase catalytic domain-containing protein [Methanoculleus sp.] | diamond | 561 | 41.6 | 0.990384615384615 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 27970275 | 27970275 | PRJNA812715_P_NODE_73185_length_298_cov_1.168889_g71385_i0 | PRJNA812715 | 73185 | 298 | 1.168889 | 3.48328922 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 109 | 6.42e-27 | NR | MFO8052132.1 | 2806419 | g71385 | i0 | 61.3 | 0.805369127516778 | 80 | 31 | 80.5 | 0 | 256 | 17 | 2 | 81 | MFO8052132.1 nucleoside monophosphate kinase [Thermoplasmatota archaeon] | diamond | 240 | 109 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 28444097 | 28444097 | PRJNA812715_P_NODE_90906_length_267_cov_1.515464_g89105_i0 | PRJNA812715 | 90906 | 267 | 1.515464 | 4.04628888 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 121 | 8.479999999999998e-31 | NR | MBT60717.1 | 2026739 | g89105 | i0 | 63.2 | 0.97752808988764 | 87 | 31 | 97.8 | 1 | 266 | 6 | 167 | 252 | MBT60717.1 aminotransferase [Methanobacteriota archaeon] | diamond | 261 | 121 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29233401 | 29233401 | PRJNA812715_P_NODE_57869_length_347_cov_0.843066_g56070_i0 | PRJNA812715 | 57869 | 347 | 0.843066 | 2.92543902 | Methanobacterium sp. | 2164 | Archaea | Archaea | 54.7 | 3.74e-6 | NR | MTK63112.1 | 2164 | g56070 | i0 | 51.8 | 0.93371757925072 | 56 | 27 | 48.4 | 0 | 2 | 169 | 137 | 192 | MTK63112.1 hypothetical protein [Methanobacterium sp.] | diamond | 324 | 54.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 29746956 | 29746956 | PRJNA812715_P_NODE_72890_length_299_cov_0.845133_g71090_i0 | PRJNA812715 | 72890 | 299 | 0.845133 | 2.52694767 | root | 1 | Root_unresolved | Root_unresolved | 71.2 | 6.81e-12 | NR | MDD4455694.1 | 2517205 | g71090 | i0 | 58.5 | 1.06354515050167 | 53 | 22 | 53.2 | 0 | 297 | 139 | 409 | 461 | MDD4455694.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon] | diamond | 318 | 71.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Candidatus Methanomethylophilaceae archaeon | |||
| 30244002 | 30244002 | PRJNA812715_P_NODE_102032_length_251_cov_0.865169_g100231_i0 | PRJNA812715 | 102032 | 251 | 0.865169 | 2.17157419 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 78.2 | 1.09e-14 | NR | RLF35997.1 | 1906666 | g100231 | i0 | 52.4 | 1.51792828685259 | 63 | 30 | 75.3 | 0 | 221 | 33 | 1 | 63 | RLF35997.1 MAG: ATPase, partial [Thermoplasmata archaeon] | diamond | 381 | 78.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30505486 | 30505486 | PRJNA812715_P_NODE_67773_length_312_cov_1.707113_g65973_i0 | PRJNA812715 | 67773 | 312 | 1.707113 | 5.32619256 | root | 1 | Root_unresolved | Root_unresolved | 134 | 3.85e-35 | NR | MCI4371872.1 | 1906666 | g65973 | i0 | 67 | 1.98076923076923 | 103 | 34 | 99 | 0 | 311 | 3 | 264 | 366 | MCI4371872.1 IS110 family transposase [Thermoplasmata archaeon] | diamond | 618 | 134 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31034071 | 31034071 | PRJNA812715_P_NODE_116035_length_244_cov_0.900585_g114234_i0 | PRJNA812715 | 116035 | 244 | 0.900585 | 2.1974274 | Halodesulfurarchaeum formicicum | 1873524 | Archaea | Archaea | 147 | 2.62e-41 | NR | WP_070365717.1 | 1873524 | g114234 | i0 | 90 | 0.983606557377049 | 80 | 8 | 98.4 | 0 | 242 | 3 | 18 | 97 | WP_070365717.1 bile acid:sodium symporter family protein [Halodesulfurarchaeum formicicum] | diamond | 240 | 147 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum formicicum | |
| 31105596 | 31105596 | PRJNA812715_P_NODE_92995_length_264_cov_1.204188_g91194_i0 | PRJNA812715 | 92995 | 264 | 1.204188 | 3.17905632 | root | 1 | Root_unresolved | Root_unresolved | 94.4 | 3.47e-20 | NR | MBW3582536.1 | 2026739 | g91194 | i0 | 54.5 | 7 | 88 | 40 | 100 | 0 | 264 | 1 | 566 | 653 | MBW3582536.1 AMP-binding protein [Methanobacteriota archaeon] | diamond | 1848 | 94.7 | 0.996832101372756 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31643163 | 31643163 | PRJNA812715_P_NODE_61776_length_332_cov_1.783784_g59977_i0 | PRJNA812715 | 61776 | 332 | 1.783784 | 5.92216288 | Candidatus Methanoperedens | 1392997 | Archaea | Archaea | 107 | 2.52e-24 | NR | WP_096204125.1 | 1392998 | g59977 | i0 | 51.3 | 4.9789156626506 | 113 | 45 | 98.5 | 3 | 4 | 330 | 438 | 544 | WP_096204125.1 glycine--tRNA ligase [Candidatus Methanoperedens nitroreducens] | diamond | 1653 | 108 | 0.990740740740741 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens nitratireducens | |
| 32362468 | 32362468 | PRJNA812715_P_NODE_117499_length_243_cov_0.905882_g115698_i0 | PRJNA812715 | 117499 | 243 | 0.905882 | 2.20129326 | Natronosalvus caseinilyticus | 2953747 | Archaea | Archaea | 57.4 | 1.84e-8 | NR | WP_312911353.1 | 2953747 | g115698 | i0 | 82.9 | 0.432098765432099 | 35 | 6 | 43.2 | 0 | 139 | 243 | 1 | 35 | WP_312911353.1 DUF4242 domain-containing protein [Natronosalvus caseinilyticus] | diamond | 105 | 57.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronosalvus | Natronosalvus caseinilyticus | |
| 32457309 | 32457309 | PRJNA812715_P_NODE_56319_length_353_cov_1.114286_g54520_i0 | PRJNA812715 | 56319 | 353 | 1.114286 | 3.93342958 | Methanoculleus horonobensis | 528314 | Archaea | Archaea | 43.5 | 0.0431 | NR | MDD3071884.1 | 528314 | g54520 | i0 | 31.6 | 0.484419263456091 | 57 | 37 | 46.7 | 1 | 79 | 243 | 117 | 173 | MDD3071884.1 flavodoxin family protein [Methanoculleus horonobensis] | diamond | 171 | 43.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus horonobensis | |
| 32835431 | 32835431 | PRJNA812715_P_NODE_81320_length_282_cov_1.473684_g79520_i0 | PRJNA812715 | 81320 | 282 | 1.473684 | 4.15578888 | Halococcus saccharolyticus | 62319 | Archaea | Archaea | 62 | 1.07e-9 | NR | WP_006078351.1 | 62319 | g79520 | i0 | 62 | 0.531914893617021 | 50 | 19 | 53.2 | 0 | 1 | 150 | 89 | 138 | WP_006078351.1 universal stress protein [Halococcus saccharolyticus] | diamond | 150 | 62 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus saccharolyticus | |
| 32866919 | 32866919 | PRJNA812715_P_NODE_18960_length_791_cov_2.541783_g17392_i0 | PRJNA812715 | 18960 | 791 | 2.541783 | 20.10550353 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 52.8 | 9.76e-4 | NR | MDH3365664.1 | 1906666 | g17392 | i0 | 26.3 | 0.576485461441214 | 152 | 103 | 57.3 | 4 | 686 | 234 | 987 | 1130 | MDH3365664.1 ABC transporter substrate-binding protein [Thermoplasmata archaeon] | diamond | 456 | 52.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon |
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);;