RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1160211", tax_clade = "Stenosarchaea group" and tax_phylum = "Methanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 5 ✖

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 5 ✖

bioproject 1

  • PRJNA1160211 · 5 ✖
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
6686916 6686916 PRJNA1160211_S_NODE_109166_length_440_cov_3.708447_g107938_i0 PRJNA1160211 109166 440 3.708447 16.3171668 uncultured Methanoregula sp. 1005933 Archaea Archaea 196 1.86e-45   NTclustered gi|2621785414|emb|OY781872.1| 1005933 g107938 i0 82.511 4.32954545454545 223 39 51 0 189 411 3121383 3121605 MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1 blastn 1905 196 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae Methanoregula uncultured Methanoregula sp.
9966185 9966185 PRJNA1160211_S_NODE_100848_length_455_cov_16.837696_g99622_i0 PRJNA1160211 100848 455 16.837696 76.6115168 Halococcus 2249 Archaea Archaea 608 2.0899999999999995e-169   NTclustered gi|2221489803|gb|CP095005.1| 179637 g99622 i0 92.111 142.863736263736 431 34 95 0 24 454 212451 212021 Halococcus dombrowskii strain H4 chromosome, complete genome blastn 65003 608 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
20165431 20165431 PRJNA1160211_S_NODE_90356_length_476_cov_10.434243_g89133_i0 PRJNA1160211 90356 476 10.434243 49.66699668 Halalkalicoccus 332246 Archaea Archaea 846 0   NTclustered gi|507148368|ref|NR_103171.1| 413810 g89133 i0 98.739 165.321428571429 476 6 100 0 1 476 1307 832 Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence blastn 78693 846 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus jeotgali
27861576 27861576 PRJNA1160211_S_NODE_274605_length_245_cov_1.924419_g273372_i0 PRJNA1160211 274605 245 1.924419 4.71482655 Halospeciosus flavus 3032283 Archaea Archaea 152 1.0299999999999998e-43   NR WP_382267974.1 3032283 g273372 i0 88.6 0.96734693877551 79 9 96.7 0 8 244 38 116 WP_382267974.1 replication initiation factor domain-containing protein [Halospeciosus flavus] diamond 237 152 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halospeciosus Halospeciosus flavus
30451402 30451402 PRJNA1160211_S_NODE_18893_length_717_cov_15.989130_g17911_i0 PRJNA1160211 18893 717 15.98913 114.6420621 Halosimplex aquaticum 3026162 Archaea Archaea 121 1.83e-27   NR WP_274325319.1 3026162 g17911 i0 30 0.97489539748954 233 152 94.6 2 7 684 259 487 WP_274325319.1 PAS domain-containing sensor histidine kinase [Halosimplex aquaticum] diamond 699 121 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halosimplex Halosimplex aquaticum

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