RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1097627", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 6 ✖

tax_phylum 1

  • Acidobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1097627 · 6 ✖

analysis 1

tax_clade 0

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
12964128 12964128 PRJNA1097627_P_NODE_83591_length_285_cov_0.952830_g83298_i0 PRJNA1097627 83591 285 0.95283 2.7155655 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 159 1.08e-43   NR HVG83116.1 2910147 g83298 i0 78.7 1.97894736842105 94 20 98.9 0 3 284 272 365 HVG83116.1 translational GTPase TypA [Vicinamibacterales bacterium] diamond 564 159 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
13773127 13773127 PRJNA1097627_P_NODE_203931_length_241_cov_0.916667_g203638_i0 PRJNA1097627 203931 241 0.916667 2.20916747 Pseudomonadati 3379134 Bacteria Bacteria 119 6.049999999999999e-32   NR HEY1499605.1 2052142 g203638 i0 72.2 9.72199170124481 79 22 98.3 0 5 241 77 155 HEY1499605.1 methylated-DNA--[protein]-cysteine S-methyltransferase [Acidobacteriaceae bacterium] diamond 2343 120 0.991666666666667 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
26972649 26972649 PRJNA1097627_P_NODE_165962_length_247_cov_0.885057_g165669_i0 PRJNA1097627 165962 247 0.885057 2.18609079 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 43.1 0.0283   NR MEJ5165943.1 2651171 g165669 i0 42.2 0.546558704453441 45 26 54.7 0 182 48 135 179 MEJ5165943.1 valine--tRNA ligase [Thermoanaerobaculia bacterium] diamond 135 43.1 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
29309684 29309684 PRJNA1097627_P_NODE_186849_length_243_cov_1.447059_g186556_i0 PRJNA1097627 186849 243 1.447059 3.51635337 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 156 9.67e-43   NR MBP7474168.1 2283092 g186556 i0 97.5 3.95061728395062 80 2 98.8 0 2 241 175 254 MBP7474168.1 DNA-directed RNA polymerase subunit beta [Pyrinomonadaceae bacterium] diamond 960 156 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29711167 29711167 PRJNA1097627_P_NODE_164890_length_247_cov_0.885057_g164597_i0 PRJNA1097627 164890 247 0.885057 2.18609079 Pseudomonadati 3379134 Bacteria Bacteria 102 2.4e-24   NR MCX6549551.1 1978231 g164597 i0 53.8 8.55060728744939 80 37 97.2 0 2 241 194 273 MCX6549551.1 SCO family protein [Acidobacteriota bacterium] diamond 2112 103 0.990291262135922 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30406865 30406865 PRJNA1097627_P_NODE_84813_length_284_cov_1.094787_g84520_i0 PRJNA1097627 84813 284 1.094787 3.10919508 Pseudomonadati 3379134 Bacteria Bacteria 184 1.26e-53   NR MEW6362591.1 1978231 g84520 i0 100 1.98591549295775 94 0 99.3 0 282 1 164 257 MEW6362591.1 DUF6798 domain-containing protein [Acidobacteriota bacterium] diamond 564 184 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota 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);;