RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1022139" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 19 ✖

bioproject 1

  • PRJNA1022139 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
26837364 26837364 PRJNA1022139_P_NODE_26761_length_278_cov_2.248780_g26656_i0 PRJNA1022139 26761 278 2.24878 6.2516084 root 1 Root_unresolved Root_unresolved 53.5 8.21e-6   NR HOI14343.1 90427 g26656 i0 53.3 1.94244604316547 45 21 48.6 0 135 1 53 97 HOI14343.1 GNAT family N-acetyltransferase [Methanoculleus sp.] diamond 540 53.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sp.
27098087 27098087 PRJNA1022139_P_NODE_17222_length_333_cov_1.776923_g17117_i0 PRJNA1022139 17222 333 1.776923 5.91715359 Methanoregula sp. 2052170 Archaea Archaea 45.4 0.0124   NR WP_300224501.1 2052170 g17117 i0 52 0.45045045045045 50 22 45 2 153 4 602 649 WP_300224501.1 C39 family peptidase [Methanoregula sp.] diamond 150 45.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula Methanoregula sp.
27129303 27129303 PRJNA1022139_P_NODE_24782_length_285_cov_1.933962_g24677_i0 PRJNA1022139 24782 285 1.933962 5.5117917 Methanosarcinales archaeon 2250255 Archaea Archaea 129 8.95e-33   NR RYE85578.1 2250255 g24677 i0 60.6 0.989473684210526 94 37 98.9 0 283 2 360 453 RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon] diamond 282 129 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
27351292 27351292 PRJNA1022139_P_NODE_28943_length_271_cov_1.106061_g28838_i0 PRJNA1022139 28943 271 1.106061 2.99742531 Thermoplasmata archaeon 1906666 Archaea Archaea 63.5 2.31e-9   NR NNN18203.1 1906666 g28838 i0 47.7 1.94833948339483 88 36 97.4 2 269 6 345 422 NNN18203.1 hypothetical protein [Thermoplasmata archaeon] diamond 528 63.5 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
28298209 28298209 PRJNA1022139_P_NODE_29966_length_267_cov_1.417526_g29861_i0 PRJNA1022139 29966 267 1.417526 3.78479442 Methanoculleus sp. DTU 90427 Archaea Archaea 75.9 1.13e-13   NR WP_286680964.1 1671626 g29861 i0 46.5 2.8988764044943802 86 44 96.6 1 7 264 618 701 WP_286680964.1 Orn/Lys/Arg decarboxylase N-terminal domain-containing protein [Methanoculleus sp. DTU007] diamond 774 75.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sp. DTU007
28329760 28329760 PRJNA1022139_P_NODE_30866_length_263_cov_2.389474_g30761_i0 PRJNA1022139 30866 263 2.389474 6.28431662 Methanobrevibacter sp. 66852 Archaea Archaea 49.3 2.13e-4   NR WP_407392179.1 66852 g30761 i0 61.5 0.444866920152091 39 15 44.5 0 2 118 229 267 WP_407392179.1 tetratricopeptide repeat protein [Methanobrevibacter sp.] diamond 117 49.3 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
28385144 28385144 PRJNA1022139_P_NODE_32086_length_259_cov_1.215054_g31981_i0 PRJNA1022139 32086 259 1.215054 3.14698986 root 1 Root_unresolved Root_unresolved 42.7 0.0472   NR MDH7597884.1 90426 g31981 i0 28.8 2.65250965250965 80 57 92.7 0 5 244 1230 1309 MDH7597884.1 N-6 DNA methylase [Methanothrix sp.] diamond 687 43.1 0.990719257540603 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix sp.
28479956 28479956 PRJNA1022139_P_NODE_666_length_1360_cov_2.125874_g630_i0 PRJNA1022139 666 1360 2.125874 28.9118864 Methanoculleus 45989 Archaea Archaea 51.6 0.00712   NR MFA7563037.1 90427 g630 i0 26.5 1.20220588235294 238 150 49.6 11 1154 480 45 270 MFA7563037.1 PQQ-binding-like beta-propeller repeat protein [Methanoculleus sp.] diamond 1635 51.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sp.
28645705 28645705 PRJNA1022139_P_NODE_21307_length_303_cov_2.352174_g21202_i0 PRJNA1022139 21307 303 2.352174 7.12708722 Thermoplasmatota archaeon 2806419 Archaea Archaea 94.7 2.48e-20   NR MCL4307926.1 2806419 g21202 i0 47.1 5.12871287128713 104 51 99 1 302 3 131 234 MCL4307926.1 translation elongation factor EF-1 subunit alpha [Thermoplasmatota archaeon] diamond 1554 94.7 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
29276915 29276915 PRJNA1022139_P_NODE_37449_length_248_cov_0.880000_g37344_i0 PRJNA1022139 37449 248 0.88 2.1824 Thermoplasmatota archaeon 2806419 Archaea Archaea 43.1 0.0288   NR MFA5860599.1 2806419 g37344 i0 35.7 0.846774193548387 70 44 83.5 1 17 223 336 405 MFA5860599.1 phospholipase D-like domain-containing protein [Thermoplasmatota archaeon] diamond 210 43.1 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
29623860 29623860 PRJNA1022139_P_NODE_19030_length_319_cov_2.808943_g18925_i0 PRJNA1022139 19030 319 2.808943 8.96052817 Methanobacteriota archaeon 2026739 Archaea Archaea 159 2.1200000000000001e-44   NR MBA60369.1 2026739 g18925 i0 64.4 13.6551724137931 104 36 97.8 1 1 312 323 425 MBA60369.1 fumarylacetoacetase [Methanobacteriota archaeon] diamond 4356 159 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
29718850 29718850 PRJNA1022139_P_NODE_28590_length_272_cov_1.346734_g28485_i0 PRJNA1022139 28590 272 1.346734 3.66311648 Methanobacteriota archaeon 2026739 Archaea Archaea 109 1.4e-27   NR MEK9806258.1 2026739 g28485 i0 58.4 0.981617647058823 89 35 96 2 9 269 52 140 MEK9806258.1 hypothetical protein [Methanobacteriota archaeon] diamond 267 109 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
29750415 29750415 PRJNA1022139_P_NODE_3091_length_712_cov_1.868545_g2992_i0 PRJNA1022139 3091 712 1.868545 13.3040404 Methanobacterium lacus 877455 Archaea Archaea 46.2 0.0348   NR WP_013645769.1 877455 g2992 i0 19.7 0.661516853932584 157 111 65.3 5 43 507 6 149 WP_013645769.1 hypothetical protein [Methanobacterium lacus] diamond 471 46.2 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium lacus
31046343 31046343 PRJNA1022139_P_NODE_7655_length_475_cov_1.507463_g7550_i0 PRJNA1022139 7655 475 1.507463 7.16044925 Thermoplasmatales archaeon 2268204 Archaea Archaea 122 6.36e-32   NR HEC72073.1 2268204 g7550 i0 42.6 0.890526315789474 141 79 89.1 1 44 466 1 139 HEC72073.1 hypothetical protein [Thermoplasmatales archaeon] diamond 423 122 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon
31836345 31836345 PRJNA1022139_P_NODE_10797_length_406_cov_2.174174_g10692_i0 PRJNA1022139 10797 406 2.174174 8.82714644 Methanobacteriota archaeon 2026739 Archaea Archaea 87.8 5.42e-18   NR MDQ1251776.1 2026739 g10692 i0 42.1 1.76600985221675 121 66 87.2 2 1 354 41 160 MDQ1251776.1 trans-aconitate 2-methyltransferase [Methanobacteriota archaeon] diamond 717 87.8 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
31868105 31868105 PRJNA1022139_P_NODE_4477_length_606_cov_2.791745_g4373_i0 PRJNA1022139 4477 606 2.791745 16.9179747 Haladaptatus sp. DYF46 2886041 Archaea Archaea 92.8 1.98e-19   NR WP_231186698.1 2886041 g4373 i0 28 4.74752475247525 182 126 90.1 2 580 35 9 185 WP_231186698.1 DUF4397 domain-containing protein [Haladaptatus sp. DYF46] diamond 2877 92.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haladaptataceae Haladaptatus Haladaptatus sp. DYF46
32374616 32374616 PRJNA1022139_P_NODE_32539_length_257_cov_1.456522_g32434_i0 PRJNA1022139 32539 257 1.456522 3.74326154 Methanoregulaceae archaeon 2485498 Archaea Archaea 57 4.18e-7   NR HPD75598.1 2485498 g32434 i0 37.5 1.0272373540856 88 48 96.9 3 8 256 20 105 HPD75598.1 SpoIIE family protein phosphatase [Methanoregulaceae archaeon] diamond 264 57 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae   Methanoregulaceae archaeon
32374627 32374627 PRJNA1022139_P_NODE_40839_length_243_cov_1.694118_g40734_i0 PRJNA1022139 40839 243 1.694118 4.11670674 Methanospirillum stamsii 1277351 Archaea Archaea 51.2 3.82e-5   NR WP_181391457.1 1277351 g40734 i0 34.7 0.888888888888889 72 46 88.9 1 10 225 180 250 WP_181391457.1 NosD domain-containing protein [Methanospirillum stamsii] diamond 216 51.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanospirillaceae Methanospirillum Methanospirillum stamsii
32595920 32595920 PRJNA1022139_P_NODE_25760_length_282_cov_1.373206_g25655_i0 PRJNA1022139 25760 282 1.373206 3.87244092 Methanobrevibacter sp. 66852 Archaea Archaea 49.3 3e-4   NR WP_330041221.1 66852 g25655 i0 35 3.07446808510638 80 45 79.8 2 23 247 165 242 WP_330041221.1 Ig-like domain-containing protein [Methanobrevibacter sp.] diamond 867 49.3 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;