RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA796753" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 6 ✖

bioproject 1

  • PRJNA796753 · 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
28569694 28569694 PRJNA796753_P_NODE_37067_length_256_cov_1.683060_g36755_i0 PRJNA796753 37067 256 1.68306 4.3086336 Halarchaeum acidiphilum 489138 Archaea Archaea 43.9 0.007   NR WP_020222420.1 489138 g36755 i0 40.9 0.7734375 66 36 73.8 1 191 3 8 73 WP_020222420.1 DUF4129 domain-containing protein [Halarchaeum acidiphilum] diamond 198 43.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halarchaeum Halarchaeum acidiphilum
28853751 28853751 PRJNA796753_P_NODE_54948_length_235_cov_3.135802_g54636_i0 PRJNA796753 54948 235 3.135802 7.3691347 Haloplanus sp. CK5-1 2949994 Archaea Archaea 42 0.0176   NR WP_338740382.1 2949994 g54636 i0 48.9 0.574468085106383 45 19 52.3 1 74 196 11 55 WP_338740382.1 hypothetical protein [Haloplanus sp. CK5-1] diamond 135 42 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloplanus Haloplanus salilacus
29201357 29201357 PRJNA796753_P_NODE_11589_length_410_cov_0.964392_g11277_i0 PRJNA796753 11589 410 0.964392 3.9540072 Methanoregulaceae archaeon 2485498 Archaea Archaea 44.7 0.0248   NR HRY75955.1 2485498 g11277 i0 47.1 0.248780487804878 34 18 24.9 0 216 115 53 86 HRY75955.1 isoprenylcysteine carboxylmethyltransferase family protein [Methanoregulaceae archaeon] diamond 102 44.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae   Methanoregulaceae archaeon
29368288 29368288 PRJNA796753_P_NODE_53949_length_241_cov_0.916667_g53637_i0 PRJNA796753 53949 241 0.916667 2.20916747 root 1 Root_unresolved Root_unresolved 82 5.19e-16   NR WP_321508096.1 1005933 g53637 i0 55 3.95850622406639 80 27 99.6 2 2 241 144 214 WP_321508096.1 carboxylesterase/lipase family protein [uncultured Methanoregula sp.] diamond 954 82.8 0.990338164251208 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula uncultured Methanoregula sp.
30148458 30148458 PRJNA796753_P_NODE_41932_length_249_cov_0.875000_g41620_i0 PRJNA796753 41932 249 0.875 2.17875 Saliphagus infecundisoli 1849069 Archaea Archaea 66.6 1.06e-10   NR WP_224829651.1 1849069 g41620 i0 46.3 0.987951807228916 82 43 97.6 1 3 245 146 227 WP_224829651.1 methyltransferase domain-containing protein [Saliphagus infecundisoli] diamond 246 66.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Saliphagus Saliphagus infecundisoli
32866465 32866465 PRJNA796753_P_NODE_26660_length_291_cov_1.811927_g26348_i0 PRJNA796753 26660 291 1.811927 5.27270757 Methanocellales archaeon 2666334 Archaea Archaea 58.9 2.24e-8   NR MEM2934473.1 2666334 g26348 i0 62.7 0.525773195876289 51 19 52.6 0 247 95 4 54 MEM2934473.1 50S ribosomal protein L19e [Methanocellales archaeon] diamond 153 58.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanocellales     Methanocellales 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);;