RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA312899" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 18 ✖

bioproject 1

  • PRJNA312899 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
8033616 8033616 PRJNA312899_P_NODE_90507_length_166_cov_0.871795_g90065_i0 PRJNA312899 90507 166 0.871795 1.4471797 Methanosarcina sp. MSH1 2213 Archaea Archaea 74.7 6.1e-15   NR WP_128505116.1 2507075 g90065 i0 55.6 0.975903614457831 54 24 97.6 0 5 166 24 77 WP_128505116.1 PH domain-containing protein [Methanosarcina sp. MSH10X1] diamond 162 74.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp. MSH10X1
24606355 24606355 PRJNA312899_P_NODE_8480_length_647_cov_30.023411_g8096_i0 PRJNA312899 8480 647 30.023411 194.25146917 Methanobacterium spitsbergense 2874285 Archaea Archaea 192 2.6699999999999992e-55   NR WP_223792203.1 2874285 g8096 i0 55.3 0.829984544049459 179 78 83 1 646 110 226 402 WP_223792203.1 phage integrase N-terminal SAM-like domain-containing protein [Methanobacterium spitsbergense] diamond 537 192 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium spitsbergense
27453723 27453723 PRJNA312899_P_NODE_10323_length_588_cov_38.358071_g9912_i0 PRJNA312899 10323 588 38.358071 225.54545748 Methanosarcina sp. 2213 Archaea Archaea 233 8.69e-74   NR HET8685591.1 2213 g9912 i0 56.8 0.969387755102041 190 80 95.9 2 2 565 30 219 HET8685591.1 hypothetical protein [Methanosarcina sp.] diamond 570 233 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
27944727 27944727 PRJNA312899_P_NODE_54665_length_232_cov_5.540984_g54223_i0 PRJNA312899 54665 232 5.540984 12.85508288 root 1 Root_unresolved Root_unresolved 53.9 5.54e-7   NR NMC60532.1 2099674 g54223 i0 42.9 3.84051724137931 70 39 89.2 1 215 9 44 113 NMC60532.1 hypothetical protein [Candidatus Methanofastidiosia archaeon] diamond 891 53.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Methanofastidiosia       Candidatus Methanofastidiosia archaeon
28116499 28116499 PRJNA312899_P_NODE_8705_length_639_cov_19.106780_g8318_i0 PRJNA312899 8705 639 19.10678 122.0923242 Methanogenium sp. 2196 Archaea Archaea 163 6.559999999999999e-48   NR MFA5395714.1 2196 g8318 i0 66.7 0.492957746478873 105 34 48.8 1 315 4 1 105 MFA5395714.1 hypothetical protein [Methanogenium sp.] diamond 315 163 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanogenium Methanogenium sp.
28165747 28165747 PRJNA312899_P_NODE_75585_length_185_cov_1.500000_g75143_i0 PRJNA312899 75585 185 1.5 2.775 root 1 Root_unresolved Root_unresolved 95.1 4.97e-21   NR WP_058573535.1 1544718 g75143 i0 73.8 3.95675675675676 61 16 98.9 0 2 184 388 448 WP_058573535.1 acetyl-CoA hydrolase/transferase C-terminal domain-containing protein [Haloferax profundi] diamond 732 95.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloferax Haloferax profundi
28860205 28860205 PRJNA312899_P_NODE_91228_length_165_cov_0.879310_g90786_i0 PRJNA312899 91228 165 0.87931 1.4508615 root 1 Root_unresolved Root_unresolved 68.9 2.27e-12   NR MBN2109468.1 1945595 g90786 i0 58.5 4.87272727272727 53 22 96.4 0 165 7 156 208 MBN2109468.1 alpha/beta hydrolase [Methanosarcinaceae archaeon] diamond 804 69.3 0.994227994227994 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae   Methanosarcinaceae archaeon
28986884 28986884 PRJNA312899_P_NODE_97248_length_163_cov_0.894737_g96806_i0 PRJNA312899 97248 163 0.894737 1.45842131 root 1 Root_unresolved Root_unresolved 53.1 1.31e-6   NR MEA2000245.1 2026739 g96806 i0 56 1.89570552147239 50 21 92 1 3 152 53 101 MEA2000245.1 IS607 family transposase [Methanobacteriota archaeon] diamond 309 53.1 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
29586210 29586210 PRJNA312899_P_NODE_27670_length_353_cov_12.006579_g27228_i0 PRJNA312899 27670 353 12.006579 42.38322387 Methanothrix 2222 Archaea Archaea 47 0.00368   NR WP_013718219.1 2223 g27228 i0 46.3 1.05382436260623 41 22 34.8 0 3 125 208 248 WP_013718219.1 clostripain-related cysteine peptidase [Methanothrix soehngenii] diamond 372 47 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix soehngenii
30200468 30200468 PRJNA312899_P_NODE_6692_length_718_cov_7.563528_g6339_i0 PRJNA312899 6692 718 7.563528 54.30613104 Pyrococcus kukulkanii 1609559 Archaea Archaea 70.1 5.64e-10   NR WP_068322433.1 1609559 g6339 i0 28.4 1.78412256267409 211 128 84.4 6 95 700 3 199 WP_068322433.1 ATP-binding protein [Pyrococcus kukulkanii] diamond 1281 70.1 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Pyrococcus Pyrococcus kukulkanii
30453700 30453700 PRJNA312899_P_NODE_85873_length_167_cov_0.864407_g85431_i0 PRJNA312899 85873 167 0.864407 1.44355969 Methanoregula sp. 2052170 Archaea Archaea 42 0.016   NR MDO9550824.1 2052170 g85431 i0 41.8 1.97604790419162 55 30 98.8 1 166 2 48 100 MDO9550824.1 hypothetical protein [Methanoregula sp.] diamond 330 42 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula Methanoregula sp.
30548199 30548199 PRJNA312899_P_NODE_76733_length_184_cov_1.133333_g76291_i0 PRJNA312899 76733 184 1.133333 2.08533272 Methanosphaera sp. WGK6 1561964 Archaea Archaea 64.3 3.83e-10   NR WP_084790347.1 1561964 g76291 i0 51.8 0.91304347826087 56 27 91.3 0 3 170 33 88 WP_084790347.1 metallophosphoesterase family protein [Methanosphaera sp. WGK6] diamond 168 64.3 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanosphaera Methanosphaera sp. WGK6
30895915 30895915 PRJNA312899_P_NODE_15194_length_484_cov_14.613793_g14759_i0 PRJNA312899 15194 484 14.613793 70.73075812 Natrononativus amylolyticus 2963434 Archaea Archaea 50.8 4.58e-4   NR WP_255170356.1 2963434 g14759 i0 29.7 0.793388429752066 128 81 79.3 2 65 448 138 256 WP_255170356.1 DUF63 family protein [Natrononativus amylolyticus] diamond 384 50.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natrononativus Natrononativus amylolyticus
30976644 30976644 PRJNA312899_P_NODE_21794_length_402_cov_17.600567_g21353_i0 PRJNA312899 21794 402 17.600567 70.75427934 root 1 Root_unresolved Root_unresolved 167 2.3999999999999994e-46   NR HET8689288.1 2213 g21353 i0 78.1 3.92537313432836 105 22 78.4 1 315 1 379 482 HET8689288.1 hypothetical protein [Methanosarcina sp.] diamond 1578 167 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina sp.
31148135 31148135 PRJNA312899_P_NODE_92655_length_165_cov_0.879310_g92213_i0 PRJNA312899 92655 165 0.87931 1.4508615 Methanoculleus sp. 90427 Archaea Archaea 67.4 1.61e-11   NR WP_292559546.1 90427 g92213 i0 54.7 0.963636363636364 53 22 96.4 1 161 3 22 72 WP_292559546.1 DNA adenine methylase [Methanoculleus sp.] diamond 159 67.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sp.
31780909 31780909 PRJNA312899_P_NODE_3417_length_939_cov_6.029213_g3163_i0 PRJNA312899 3417 939 6.029213 56.61431007 Natronococcus wangiae 3068275 Archaea Archaea 89 9.16e-16   NR WP_306059081.1 3068275 g3163 i0 30.6 1.68051118210863 258 127 81.8 9 112 879 85 292 WP_306059081.1 translation elongation factor EF-1 subunit alpha [Natronococcus wangiae] diamond 1578 89 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronococcus Natronococcus wangiae
31798380 31798380 PRJNA312899_P_NODE_31317_length_328_cov_16.634409_g30875_i0 PRJNA312899 31317 328 16.634409 54.56086152 root 1 Root_unresolved Root_unresolved 96.3 7.290000000000001e-22   NR MEN6290519.1 2164 g30875 i0 53 2.35060975609756 83 36 73.2 1 2 241 109 191 MEN6290519.1 hypothetical protein [Methanobacterium sp.] diamond 771 96.3 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium sp.
32463169 32463169 PRJNA312899_P_NODE_2139_length_1104_cov_8.445498_g1945_i0 PRJNA312899 2139 1104 8.445498 93.23829792 Methanosarcina 2207 Archaea Archaea 231 2.66e-71   NR WP_310574840.1 3073890 g1945 i0 58.5 2.11413043478261 193 80 52.4 0 1098 520 14 206 WP_310574840.1 NAD(P)H:quinone oxidoreductase type IV [Methanosarcina baikalica] diamond 2334 231 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina baikalica

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