RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA896973" 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

  • PRJNA896973 · 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
8896889 8896889 PRJNA896973_P_NODE_23047_length_249_cov_0.875000_g22953_i0 PRJNA896973 23047 249 0.875 2.17875 Natronomonas sp. LN261 2750669 Archaea Archaea 165 2.89e-48   NR WP_181692690.1 2750669 g22953 i0 97.6 1 83 2 100 0 249 1 149 231 WP_181692690.1 AAA family ATPase [Natronomonas sp. LN261] diamond 249 165 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas sp. LN261
9801035 9801035 PRJNA896973_P_NODE_22768_length_249_cov_1.375000_g22674_i0 PRJNA896973 22768 249 1.375 3.42375 Natronomonas sp. LN261 2750669 Archaea Archaea 165 2.2099999999999997e-47   NR WP_181692260.1 2750669 g22674 i0 95.1 0.987951807228916 82 4 98.8 0 247 2 6 87 WP_181692260.1 tRNA pseudouridine(54/55) synthase Pus10 [Natronomonas sp. LN261] diamond 246 165 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas sp. LN261
18724756 18724756 PRJNA896973_P_NODE_27275_length_242_cov_0.911243_g27181_i0 PRJNA896973 27275 242 0.911243 2.20520806 Halonotius aquaticus 2216978 Archaea Archaea 155 6.5799999999999985e-43   NR WP_120103427.1 2216978 g27181 i0 88.8 1.98347107438017 80 9 99.2 0 240 1 381 460 WP_120103427.1 lipase maturation factor family protein [Halonotius aquaticus] diamond 480 155 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halonotius Halonotius aquaticus
29116205 29116205 PRJNA896973_P_NODE_22548_length_250_cov_0.870056_g22454_i0 PRJNA896973 22548 250 0.870056 2.17514 Halobacteriales 2235 Archaea Archaea 148 4.59e-40   NR WP_256401039.1 755306 g22454 i0 90.4 7.968 83 8 99.6 0 250 2 16 98 WP_256401039.1 ATP-binding protein [Haloarchaeobius litoreus] diamond 1992 148 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halorubellaceae Haloarchaeobius Haloarchaeobius litoreus
29550219 29550219 PRJNA896973_P_NODE_25650_length_245_cov_0.895349_g25556_i0 PRJNA896973 25650 245 0.895349 2.19360505 Halovenus carboxidivorans 2692199 Archaea Archaea 110 4.04e-26   NR WP_159763028.1 2692199 g25556 i0 69.1 0.991836734693878 81 25 99.2 0 243 1 230 310 WP_159763028.1 PAS domain-containing protein [Halovenus carboxidivorans] diamond 243 110 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halovenus Halovenus carboxidivorans
29676360 29676360 PRJNA896973_P_NODE_25450_length_245_cov_0.895349_g25356_i0 PRJNA896973 25450 245 0.895349 2.19360505 Natronomonas sp. LN261 2750669 Archaea Archaea 140 3.4699999999999995e-37   NR WP_181691709.1 2750669 g25356 i0 95.6 0.83265306122449 68 3 83.3 0 205 2 1 68 WP_181691709.1 acyl-CoA mutase large subunit family protein [Natronomonas sp. LN261] diamond 204 140 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Natronomonas Natronomonas sp. LN261

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