RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA596870", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 5 ✖

tax_phylum 1

  • Myxococcota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA596870 · 5 ✖

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
29732141 29732141 PRJNA596870_P_NODE_18350_length_310_cov_1.535865_g18217_i0 PRJNA596870 18350 310 1.535865 4.7611815 Polyangiaceae bacterium 2268199 Bacteria Bacteria 72 4.02e-12   NR NUQ76127.1 2268199 g18217 i0 40.2 2.07096774193548 107 58 99.7 3 2 310 288 392 NUQ76127.1 glycoside hydrolase family 18 protein [Polyangiaceae bacterium] diamond 642 72 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
30016749 30016749 PRJNA596870_P_NODE_38331_length_243_cov_0.864706_g38198_i0 PRJNA596870 38331 243 0.864706 2.10123558 Myxococcota bacterium 2818507 Bacteria Bacteria 42.7 0.0342   NR MFT4625797.1 2818507 g38198 i0 38.6 0.703703703703704 57 35 70.4 0 38 208 10 66 MFT4625797.1 hypothetical protein [Myxococcota bacterium] diamond 171 42.7 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
31072730 31072730 PRJNA596870_P_NODE_13275_length_355_cov_1.070922_g13142_i0 PRJNA596870 13275 355 1.070922 3.8017731 Bacteria 2 Bacteria Bacteria 103 4.5e-23   NR HEY8376669.1 1962667 g13142 i0 46.3 8.68732394366197 121 55 99.7 4 2 355 286 399 HEY8376669.1 molecular chaperone HtpG [Nannocystis sp.] diamond 3084 104 0.990384615384615 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae Nannocystis Nannocystis sp.
32369693 32369693 PRJNA596870_P_NODE_28539_length_253_cov_1.283333_g28406_i0 PRJNA596870 28539 253 1.283333 3.24683249 Bacteria 2 Bacteria Bacteria 133 7.5e-35   NR MDD5309684.1 2026735 g28406 i0 72.6 2.98814229249012 84 23 99.6 0 2 253 327 410 MDD5309684.1 cyclic 2,3-diphosphoglycerate synthase [Deltaproteobacteria bacterium] diamond 756 134 0.992537313432836 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
32640253 32640253 PRJNA596870_P_NODE_18420_length_310_cov_0.974684_g18287_i0 PRJNA596870 18420 310 0.974684 3.0215204 Kofleriaceae bacterium 2212474 Bacteria Bacteria 44.3 0.00795   NR HUJ60681.1 2212474 g18287 i0 58.1 0.6 31 13 30 0 308 216 46 76 HUJ60681.1 hypothetical protein [Kofleriaceae bacterium] diamond 186 44.3 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae 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);;