RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA414225" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA414225 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
27549400 27549400 PRJNA414225_P_NODE_13104_length_198_cov_1.020134_g13017_i0 PRJNA414225 13104 198 1.020134 2.01986532 Methanoculleus sp. 90427 Archaea Archaea 93.2 3.07e-20   NR WP_292559315.1 90427 g13017 i0 72.7 0.833333333333333 55 15 83.3 0 198 34 354 408 WP_292559315.1 hypothetical protein [Methanoculleus sp.] diamond 165 93.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sp.
27896704 27896704 PRJNA414225_P_NODE_42085_length_170_cov_1.685950_g41998_i0 PRJNA414225 42085 170 1.68595 2.866115 Methanothrix sp. 90426 Archaea Archaea 76.3 1.33e-14   NR HOO54542.1 90426 g41998 i0 71.4 0.988235294117647 56 15 98.8 1 3 170 47 101 HOO54542.1 endonuclease/exonuclease/phosphatase family protein [Methanothrix sp.] diamond 168 76.3 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanotrichales Methanotrichaceae Methanothrix Methanothrix sp.
28465285 28465285 PRJNA414225_P_NODE_8326_length_219_cov_1.200000_g8239_i0 PRJNA414225 8326 219 1.2 2.628 Candidatus Poseidoniales archaeon 2163009 Archaea Archaea 51.2 2.64e-5   NR MEK9694273.1 2163009 g8239 i0 35.3 1.80821917808219 68 43 93.2 1 218 15 264 330 MEK9694273.1 hypothetical protein [Candidatus Poseidoniales archaeon] diamond 396 51.2 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
31434331 31434331 PRJNA414225_P_NODE_63116_length_165_cov_0.879310_g63029_i0 PRJNA414225 63116 165 0.87931 1.4508615 archaeon 1906665 Archaea Archaea 79.7 5.65e-16   NR NCQ50339.1 1906665 g63029 i0 70 0.909090909090909 50 14 89.1 1 148 2 216 265 NCQ50339.1 hypothetical protein [archaeon] diamond 150 79.7 1 Archaea               archaeon
31972102 31972102 PRJNA414225_P_NODE_65078_length_165_cov_0.879310_g64991_i0 PRJNA414225 65078 165 0.87931 1.4508615 Methanofastidiosum sp. 2666341 Archaea Archaea 123 3.0000000000000003e-31   NR MBP6933165.1 2666341 g64991 i0 100 1 55 0 100 0 165 1 352 406 MBP6933165.1 RagB/SusD family nutrient uptake outer membrane protein [Methanofastidiosum sp.] diamond 165 123 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Candidatus Methanofastidiosia Candidatus Methanofastidiosales Candidatus Methanofastidiosaceae Candidatus Methanofastidiosum Methanofastidiosum sp.
32162154 32162154 PRJNA414225_P_NODE_59598_length_166_cov_0.871795_g59511_i0 PRJNA414225 59598 166 0.871795 1.4471797 Candidatus Bathyarchaeia archaeon 3045160 Archaea Archaea 41.6 0.0345   NR HKM78892.1 3045160 g59511 i0 33.3 0.921686746987952 51 34 92.2 0 157 5 119 169 HKM78892.1 CBS domain-containing protein [Candidatus Bathyarchaeia archaeon] diamond 153 41.6 1 Archaea   Thermoproteati Candidatus Bathyarchaeota Candidatus Bathyarchaeia       Candidatus Bathyarchaeia archaeon
32162156 32162156 PRJNA414225_P_NODE_83518_length_162_cov_1.805310_g83431_i0 PRJNA414225 83518 162 1.80531 2.9246022 archaeon 1906665 Archaea Archaea 80.1 1.65e-16   NR RYG52446.1 1906665 g83431 i0 66 0.981481481481482 53 18 98.1 0 160 2 36 88 RYG52446.1 MAG: hypothetical protein EON66_09740, partial [archaeon] diamond 159 80.1 1 Archaea               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);;