RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1016321", tax_clade = "FCB group" and tax_phylum = "Balneolota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Balneolota · 5 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 5 ✖

bioproject 1

  • PRJNA1016321 · 5 ✖

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
9087145 9087145 PRJNA1016321_P_NODE_35088_length_302_cov_4.000000_g34857_i0 PRJNA1016321 35088 302 4 12.08 Balneolia bacterium 2094027 Bacteria Bacteria 175 1.3899999999999998e-48   NR MCH8558094.1 2094027 g34857 i0 89.6 0.95364238410596 96 10 95.4 0 1 288 551 646 MCH8558094.1 type I DNA topoisomerase [Balneolia bacterium] diamond 288 175 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia       Balneolia bacterium
28203259 28203259 PRJNA1016321_P_NODE_36106_length_297_cov_1.973214_g35875_i0 PRJNA1016321 36106 297 1.973214 5.86044558 Balneolaceae bacterium 2053516 Bacteria Bacteria 72.8 8.99e-13   NR MCC5913415.1 2053516 g35875 i0 82.2 1.36363636363636 45 8 45.5 0 2 136 242 286 MCC5913415.1 DMT family transporter [Balneolaceae bacterium] diamond 405 72.8 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
29056116 29056116 PRJNA1016321_P_NODE_32028_length_319_cov_2.642276_g31797_i0 PRJNA1016321 32028 319 2.642276 8.42886044 Balneolia bacterium 2094027 Bacteria Bacteria 130 1.0699999999999999e-32   NR MCH8556560.1 2094027 g31797 i0 62.9 0.987460815047022 105 39 98.7 0 1 315 232 336 MCH8556560.1 PP2C family protein-serine/threonine phosphatase [Balneolia bacterium] diamond 315 130 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia       Balneolia bacterium
29782171 29782171 PRJNA1016321_P_NODE_52611_length_245_cov_1.104651_g52380_i0 PRJNA1016321 52611 245 1.104651 2.70639495 Balneolaceae bacterium 2053516 Bacteria Bacteria 130 6.609999999999999e-37   NR TVR33237.1 2053516 g52380 i0 95.5 1.61632653061224 66 3 80.8 0 48 245 1 66 TVR33237.1 MAG: S-adenosylmethionine decarboxylase proenzyme [Balneolaceae bacterium] diamond 396 130 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
32279683 32279683 PRJNA1016321_P_NODE_45799_length_257_cov_2.820652_g45568_i0 PRJNA1016321 45799 257 2.820652 7.24907564 Balneolaceae bacterium 2053516 Bacteria Bacteria 68.9 2.55e-11   NR MDZ7719469.1 2053516 g45568 i0 86.5 3.02334630350195 37 5 43.2 0 146 256 1 37 MDZ7719469.1 23S rRNA (uracil(1939)-C(5))-methyltransferase RlmD [Balneolaceae bacterium] diamond 777 68.9 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae 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);;