RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB50332" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 3 ✖

tax_clade 1

bioproject 1

  • PRJEB50332 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
27001676 27001676 PRJEB50332_P_NODE_8202_length_234_cov_2.439306_g8120_i0 PRJEB50332 8202 234 2.439306 5.70797604 Halococcus 2249 Archaea Archaea 103 9.03e-26   NR WP_049909806.1 2249 g8120 i0 66.2 0.987179487179487 77 26 98.7 0 234 4 6 82 WP_049909806.1 MULTISPECIES: hypothetical protein [Halococcus] diamond 231 103 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus  
28928336 28928336 PRJEB50332_P_NODE_2808_length_343_cov_0.819149_g2726_i0 PRJEB50332 2808 343 0.819149 2.80968107 Methanobacteriota archaeon 2026739 Archaea Archaea 73.6 3.74e-13   NR RMG30150.1 2026739 g2726 i0 38.3 1.74052478134111 94 57 82.2 1 337 56 130 222 RMG30150.1 MAG: aquaporin [Methanobacteriota archaeon] diamond 597 73.6 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
29054810 29054810 PRJEB50332_P_NODE_15868_length_205_cov_1.354167_g15786_i0 PRJEB50332 15868 205 1.354167 2.77604235 Halomicrobium katesii 437163 Archaea Archaea 47.4 5.18e-4   NR WP_018257875.1 437163 g15786 i0 36.4 0.965853658536585 66 42 96.6 0 205 8 160 225 WP_018257875.1 ArsA family ATPase [Halomicrobium katesii] diamond 198 47.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halomicrobium Halomicrobium katesii

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