RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA358009" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA358009 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
26694891 26694891 PRJNA358009_P_NODE_4761_length_327_cov_2.000000_g4698_i0 PRJNA358009 4761 327 2 6.54 Halocalculus aciditolerans 1383812 Archaea Archaea 64.3 2.57e-9   NR WP_229774124.1 1383812 g4698 i0 90.6 0.293577981651376 32 3 29.4 0 325 230 534 565 WP_229774124.1 SIR2 family protein [Halocalculus aciditolerans] diamond 96 64.3 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halocalculus Halocalculus aciditolerans
27408273 27408273 PRJNA358009_P_NODE_11503_length_174_cov_1.224000_g11434_i0 PRJNA358009 11503 174 1.224 2.12976 root 1 Root_unresolved Root_unresolved 115 3.51e-28   NR WP_068576323.1 54262 g11434 i0 96.5 18.6724137931034 57 2 98.3 0 2 172 310 366 WP_068576323.1 DNA polymerase [Thermococcus chitonophagus] diamond 3249 115 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus chitonophagus
28906268 28906268 PRJNA358009_P_NODE_6768_length_325_cov_4.065217_g6705_i0 PRJNA358009 6768 325 4.065217 13.21195525 Methanofastidiosum sp. 2666341 Archaea Archaea 113 3.4300000000000005e-27   NR HQK63031.1 2666341 g6705 i0 59.6 0.96 104 3 96 1 317 6 7 71 HQK63031.1 transposase [Methanofastidiosum sp.] diamond 312 113 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Methanofastidiosia Candidatus Methanofastidiosales Candidatus Methanofastidiosaceae Candidatus Methanofastidiosum Methanofastidiosum sp.
29442983 29442983 PRJNA358009_P_NODE_17890_length_154_cov_3.638095_g17821_i0 PRJNA358009 17890 154 3.638095 5.6026663 Candidatus Nanohaloarchaea archaeon 2594798 Archaea Archaea 72.8 2.78e-13   NR MFB6203993.1 2594798 g17821 i0 73.9 1.83116883116883 46 12 89.6 0 7 144 115 160 MFB6203993.1 alkaline phosphatase family protein [Candidatus Nanohaloarchaea archaeon] diamond 282 72.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Nanohaloarchaea       Candidatus Nanohaloarchaea archaeon
29712574 29712574 PRJNA358009_P_NODE_7750_length_224_cov_1.165714_g7681_i0 PRJNA358009 7750 224 1.165714 2.61119936 root 1 Root_unresolved Root_unresolved 156 3.64e-42   NR WP_011248956.1 311400 g7681 i0 100 2.97321428571429 74 0 99.1 0 224 3 171 244 WP_011248956.1 DNA polymerase [Thermococcus kodakarensis] diamond 666 156 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus kodakarensis
32083474 32083474 PRJNA358009_P_NODE_14958_length_163_cov_4.026316_g14889_i0 PRJNA358009 14958 163 4.026316 6.56289508 Halanaeroarchaeum 1656823 Archaea Archaea 71.2 7.71e-14   NR MFB6082319.1 1963275 g14889 i0 62.5 1.85889570552147 48 18 88.3 0 20 163 34 81 MFB6082319.1 PH domain-containing protein [Halanaeroarchaeum sp.] diamond 303 71.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halanaeroarchaeum Halanaeroarchaeum 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);;