RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA642647", tax_kingdom = "Pseudomonadati" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 6 ✖

tax_kingdom 1

  • Pseudomonadati · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA642647 · 6 ✖

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
28344518 28344518 PRJNA642647_P_NODE_6446_length_151_cov_3.324561_g6396_i0 PRJNA642647 6446 151 3.324561 5.02008711 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 51.2 1.09e-5   NR MBK8246539.1 2026742 g6396 i0 44.3 1.21192052980132 61 19 91.4 1 139 2 342 402 MBK8246539.1 AAA family ATPase [Gemmatimonadota bacterium] diamond 183 51.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28470981 28470981 PRJNA642647_P_NODE_4786_length_167_cov_2.723077_g4736_i0 PRJNA642647 4786 167 2.723077 4.54753859 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 45.4 0.00147   NR MFN2384137.1 2026742 g4736 i0 87.5 0.431137724550898 24 3 43.1 0 91 162 14 37 MFN2384137.1 phage tail tube protein [Gemmatimonadota bacterium] diamond 72 45.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28988583 28988583 PRJNA642647_P_NODE_4648_length_169_cov_1.765152_g4598_i0 PRJNA642647 4648 169 1.765152 2.98310688 Bacteria 2 Bacteria Bacteria 82.8 4.84e-17   NR WP_353268876.1 1962908 g4598 i0 80.4 5.34319526627219 46 9 81.7 0 5 142 117 162 WP_353268876.1 DNA cytosine methyltransferase [Gemmatimonas sp.] diamond 903 82.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
29923408 29923408 PRJNA642647_P_NODE_2611_length_214_cov_2.141243_g2561_i0 PRJNA642647 2611 214 2.141243 4.58226002 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 60.1 1.56e-9   NR MCK5651818.1 2026742 g2561 i0 62.2 0.518691588785047 37 14 51.9 0 210 100 75 111 MCK5651818.1 hypothetical protein [Gemmatimonadota bacterium] diamond 111 60.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30618265 30618265 PRJNA642647_P_NODE_893_length_374_cov_2.896142_g843_i0 PRJNA642647 893 374 2.896142 10.83157108 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 62.8 2.62e-9   NR MBX9853930.1 2026741 g843 i0 54.7 0.425133689839572 53 24 42.5 0 162 4 9 61 MBX9853930.1 N-acetylmuramoyl-L-alanine amidase [Gemmatimonadaceae bacterium] diamond 159 62.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32893697 32893697 PRJNA642647_P_NODE_2400_length_222_cov_2.902703_g2350_i0 PRJNA642647 2400 222 2.902703 6.44400066 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 130 2.76e-33   NR MBP6775017.1 2026741 g2350 i0 76.1 0.959459459459459 71 17 95.9 0 5 217 46 116 MBP6775017.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 213 130 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium

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