RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJDB9741" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 6 ✖

tax_clade 1

bioproject 1

  • PRJDB9741 · 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
28043283 28043283 PRJDB9741_P_NODE_11805_length_196_cov_1.768707_g11488_i0 PRJDB9741 11805 196 1.768707 3.46666572 Methanosarcinales archaeon 2250255 Archaea Archaea 90.5 5.99e-22   NR RYE82776.1 2250255 g11488 i0 79.6 1.66836734693878 54 11 82.7 0 163 2 6 59 RYE82776.1 MAG: 30S ribosomal protein S8e, partial [Methanosarcinales archaeon] diamond 327 90.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
29148775 29148775 PRJDB9741_P_NODE_30869_length_165_cov_2.017241_g30552_i0 PRJDB9741 30869 165 2.017241 3.32844765 Methanobacteriota archaeon 2026739 Archaea Archaea 92.8 6.6500000000000005e-22   NR MCH7661435.1 2026739 g30552 i0 90.7 0.981818181818182 54 5 98.2 0 162 1 124 177 MCH7661435.1 DUF420 domain-containing protein [Methanobacteriota archaeon] diamond 162 92.8 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
30474988 30474988 PRJDB9741_P_NODE_5613_length_266_cov_1.663594_g5297_i0 PRJDB9741 5613 266 1.663594 4.42516004 Methanoregulaceae archaeon 2485498 Archaea Archaea 49.7 1.74e-4   NR RPI36929.1 2485498 g5297 i0 36.8 0.857142857142857 76 42 85.7 2 26 253 199 268 RPI36929.1 MAG: hypothetical protein EHM53_11655 [Methanoregulaceae archaeon] diamond 228 49.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae   Methanoregulaceae archaeon
31075280 31075280 PRJDB9741_P_NODE_32375_length_165_cov_0.879310_g32058_i0 PRJDB9741 32375 165 0.87931 1.4508615 Methanosarcinales archaeon 2250255 Archaea Archaea 43.1 0.00932   NR RYE85335.1 2250255 g32058 i0 64.7 0.618181818181818 34 11 60 1 164 66 124 157 RYE85335.1 MAG: hypothetical protein EOO65_00610 [Methanosarcinales archaeon] diamond 102 43.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales     Methanosarcinales archaeon
31802341 31802341 PRJDB9741_P_NODE_36137_length_163_cov_0.894737_g35820_i0 PRJDB9741 36137 163 0.894737 1.45842131 Thermoplasmatota archaeon 2806419 Archaea Archaea 54.3 1.05e-6   NR MFO7676778.1 2806419 g35820 i0 46.2 0.957055214723926 52 28 95.7 0 157 2 151 202 MFO7676778.1 M14 family zinc carboxypeptidase [Thermoplasmatota archaeon] diamond 156 54.3 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
32492810 32492810 PRJDB9741_P_NODE_33579_length_164_cov_0.886957_g33262_i0 PRJDB9741 33579 164 0.886957 1.45460948 Halalkalicoccus 332246 Archaea Archaea 89.4 4.81e-19   NR WP_336344683.1 3116651 g33262 i0 74.1 1.97560975609756 54 14 98.8 0 162 1 157 210 WP_336344683.1 hypothetical protein [Halalkalicoccus ordinarius] diamond 324 89.7 0.996655518394649 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halalkalicoccus Halalkalicoccus ordinarius

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