RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB14664" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Methanobacteriati · 4 ✖

tax_clade 1

bioproject 1

  • PRJEB14664 · 4 ✖

analysis 1

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
26716082 26716082 PRJEB14664_P_NODE_15061_length_182_cov_1.897959_g14931_i0 PRJEB14664 15061 182 1.897959 3.45428538 halophilic archaeon J 29295 Archaea Archaea 48.1 2.02e-4   NR ERH09861.1 1085028 g14931 i0 49 2.55494505494505 49 23 80.8 1 173 27 185 231 ERH09861.1 MAG: hypothetical protein J07HX64_01624 [halophilic archaeon J07HX64] diamond 465 48.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales     halophilic archaeon J07HX64
28479544 28479544 PRJEB14664_P_NODE_5706_length_350_cov_1.568254_g5576_i0 PRJEB14664 5706 350 1.568254 5.488889 root 1 Root_unresolved Root_unresolved 56.6 1.43e-6   NR MCK9298840.1 90427 g5576 i0 37.8 3.19714285714286 90 36 77.1 3 345 76 172 241 MCK9298840.1 exo-alpha-sialidase [Methanoculleus sp.] diamond 1119 57 0.992982456140351 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus sp.
29212197 29212197 PRJEB14664_P_NODE_13929_length_192_cov_1.757962_g13799_i0 PRJEB14664 13929 192 1.757962 3.37528704 Haloferax sp. YSMS24 3388425 Archaea Archaea 40.4 0.0444   NR WP_411966181.1 3388425 g13799 i0 57.1 0.546875 35 7 42.2 2 46 126 62 96 WP_411966181.1 hypothetical protein [Haloferax sp. YSMS24] diamond 105 40.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Haloferax Haloferax sp. YSMS24
30064532 30064532 PRJEB14664_P_NODE_14612_length_186_cov_1.854305_g14482_i0 PRJEB14664 14612 186 1.854305 3.4490073 Methanoregulaceae archaeon 2485498 Archaea Archaea 87.4 1.81e-18   NR MDD1714532.1 2485498 g14482 i0 61 0.951612903225806 59 23 95.2 0 185 9 255 313 MDD1714532.1 PQQ-dependent sugar dehydrogenase [Methanoregulaceae archaeon] diamond 177 87.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanoregulaceae   Methanoregulaceae 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);;