RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA557436" and tax_phylum = "Methanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA557436 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
535665 535665 PRJNA557436_S_NODE_781_length_402_cov_2.713896_g733_i0 PRJNA557436 781 402 2.713896 10.90986192 Methanobacteriota archaeon 2026739 Archaea Archaea 144 8.68e-37   NR MBK64534.1 2026739 g733 i0 50 2 134 67 100 0 1 402 484 617 MBK64534.1 hypothetical protein [Methanobacteriota archaeon] diamond 804 144 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
26794067 26794067 PRJNA557436_S_NODE_3261_length_215_cov_2.922222_g3213_i0 PRJNA557436 3261 215 2.922222 6.2827773 Methanobacteriota archaeon 2026739 Archaea Archaea 54.7 1.26e-6   NR MBG17509.1 2026739 g3213 i0 49.2 0.823255813953488 59 30 82.3 0 214 38 202 260 MBG17509.1 hypothetical protein [Methanobacteriota archaeon] diamond 177 54.7 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
26794070 26794070 PRJNA557436_S_NODE_4221_length_196_cov_1.596273_g4173_i0 PRJNA557436 4221 196 1.596273 3.12869508 Methanobacteriota archaeon 2026739 Archaea Archaea 49.7 6.01e-5   NR MEA1997743.1 2026739 g4173 i0 53.8 0.596938775510204 39 17 59.7 1 121 5 21 58 MEA1997743.1 hypothetical protein [Methanobacteriota archaeon] diamond 117 49.7 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
27489711 27489711 PRJNA557436_S_NODE_7883_length_158_cov_1.902439_g7835_i0 PRJNA557436 7883 158 1.902439 3.00585362 Methanofastidiosum sp. 2666341 Archaea Archaea 93.6 3.75e-23   NR HQF90435.1 2666341 g7835 i0 100 0.949367088607595 50 0 94.9 0 156 7 59 108 HQF90435.1 hypothetical protein [Methanofastidiosum sp.] diamond 150 93.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Methanofastidiosia Candidatus Methanofastidiosales Candidatus Methanofastidiosaceae Candidatus Methanofastidiosum Methanofastidiosum sp.
28135311 28135311 PRJNA557436_S_NODE_7365_length_162_cov_1.212598_g7317_i0 PRJNA557436 7365 162 1.212598 1.96440876 root 1 Root_unresolved Root_unresolved 67.4 1.71e-11   NR HET8686251.1 2213 g7317 i0 54.7 3.92592592592593 53 24 98.1 0 160 2 146 198 HET8686251.1 hypothetical protein [Methanosarcina sp.] diamond 636 67.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
28419512 28419512 PRJNA557436_S_NODE_2406_length_245_cov_1.428571_g2358_i0 PRJNA557436 2406 245 1.428571 3.49999895 root 1 Root_unresolved Root_unresolved 63.9 1.27e-9   NR OQC51359.1 1852875 g2358 i0 67.4 1.0530612244898 43 14 52.7 0 244 116 249 291 OQC51359.1 MAG: hypothetical protein BWX56_01014 [Euryarchaeota archaeon ADurb.Bin023] diamond 258 63.9 1 Archaea   Methanobacteriati Methanobacteriota         Euryarchaeota archaeon ADurb.Bin023
28468624 28468624 PRJNA557436_S_NODE_546_length_477_cov_4.239819_g498_i0 PRJNA557436 546 477 4.239819 20.22393663 Methanobacteriota archaeon 2026739 Archaea Archaea 78.6 7.39e-16   NR MBG17600.1 2026739 g498 i0 53.8 0.830188679245283 65 29 40.3 1 476 285 10 74 MBG17600.1 hypothetical protein [Methanobacteriota archaeon] diamond 396 78.6 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
28721102 28721102 PRJNA557436_S_NODE_7667_length_160_cov_1.184000_g7619_i0 PRJNA557436 7667 160 1.184 1.8944 Methanobacteriota archaeon 2026739 Archaea Archaea 77.8 5.32e-15   NR NDB93712.1 2026739 g7619 i0 64.2 2.98125 53 19 99.4 0 159 1 78 130 NDB93712.1 hypothetical protein [Methanobacteriota archaeon] diamond 477 77.8 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
28910142 28910142 PRJNA557436_S_NODE_4928_length_185_cov_1.633333_g4880_i0 PRJNA557436 4928 185 1.633333 3.02166605 Methanosarcina sp. 2213 Archaea Archaea 73.6 1.18e-14   NR HET8687731.1 2213 g4880 i0 68.9 0.989189189189189 61 16 98.9 2 1 183 9 66 HET8687731.1 hypothetical protein [Methanosarcina sp.] diamond 183 73.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
29289258 29289258 PRJNA557436_S_NODE_7169_length_163_cov_1.515625_g7121_i0 PRJNA557436 7169 163 1.515625 2.47046875 Methanosarcina sp. 2213 Archaea Archaea 92.8 1.17e-21   NR HET8685201.1 2213 g7121 i0 75.9 0.993865030674847 54 13 99.4 0 2 163 115 168 HET8685201.1 hypothetical protein [Methanosarcina sp.] diamond 162 92.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
29352594 29352594 PRJNA557436_S_NODE_1529_length_298_cov_2.349810_g1481_i0 PRJNA557436 1529 298 2.34981 7.0024338 Methanosarcinales archaeon 2250255 Archaea Archaea 69.7 2.45e-11   NR HUV85242.1 2250255 g1481 i0 38.6 1.14765100671141 114 54 98.7 4 1 294 260 373 HUV85242.1 hypothetical protein [Methanosarcinales archaeon] diamond 342 69.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
30332101 30332101 PRJNA557436_S_NODE_5932_length_173_cov_2.659420_g5884_i0 PRJNA557436 5932 173 2.65942 4.6007966 Methanobacteriota archaeon 2026739 Archaea Archaea 77.4 8.58e-15   NR MBG17549.1 2026739 g5884 i0 66.7 2.94797687861272 57 19 98.8 0 2 172 112 168 MBG17549.1 hypothetical protein [Methanobacteriota archaeon] diamond 510 77.4 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
30395196 30395196 PRJNA557436_S_NODE_4333_length_194_cov_1.786164_g4285_i0 PRJNA557436 4333 194 1.786164 3.46515816 Methanobacteriota archaeon 2026739 Archaea Archaea 52 1.05e-6   NR NDB93713.1 2026739 g4285 i0 41.5 1.00515463917526 65 37 99 1 194 3 24 88 NDB93713.1 hypothetical protein [Methanobacteriota archaeon] diamond 195 52 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
30710688 30710688 PRJNA557436_S_NODE_5294_length_181_cov_1.075342_g5246_i0 PRJNA557436 5294 181 1.075342 1.94636902 Methanobacteriota archaeon 2026739 Archaea Archaea 82 1.03e-17   NR MFH1835354.1 2026739 g5246 i0 63.3 0.994475138121547 60 22 99.4 0 181 2 109 168 MFH1835354.1 HNH endonuclease [Methanobacteriota archaeon] diamond 180 82 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
31469480 31469480 PRJNA557436_S_NODE_2016_length_263_cov_2.622807_g1968_i0 PRJNA557436 2016 263 2.622807 6.89798241 Methanobacteriota archaeon 2026739 Archaea Archaea 42.4 0.021   NR MBP04517.1 2026739 g1968 i0 40 0.627376425855513 55 33 62.7 0 77 241 13 67 MBP04517.1 hypothetical protein [Methanobacteriota archaeon] diamond 165 42.4 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
31564452 31564452 PRJNA557436_S_NODE_2996_length_223_cov_1.925532_g2948_i0 PRJNA557436 2996 223 1.925532 4.29393636 Methanobacteriota archaeon 2026739 Archaea Archaea 85.9 9.07e-18   NR MBG17502.1 2026739 g2948 i0 54.8 0.834080717488789 62 28 83.4 0 5 190 96 157 MBG17502.1 hypothetical protein [Methanobacteriota archaeon] diamond 186 85.9 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon

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