RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA399133" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA399133 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
27534527 27534527 PRJNA399133_P_NODE_5243_length_229_cov_1.773196_g5155_i0 PRJNA399133 5243 229 1.773196 4.06061884 Bacteria 2 Bacteria Bacteria 52 1.7e-5   NR MCA9503384.1 2026763 g5155 i0 95.8 1.25764192139738 24 1 31.4 0 73 2 357 380 MCA9503384.1 NAD(P)/FAD-dependent oxidoreductase [Myxococcales bacterium] diamond 288 52 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
28717693 28717693 PRJNA399133_P_NODE_7087_length_197_cov_1.666667_g6999_i0 PRJNA399133 7087 197 1.666667 3.28333399 Myxococcales bacterium 2026763 Bacteria Bacteria 67.8 1.5e-11   NR MDO9016594.1 2026763 g6999 i0 79.5 1.79695431472081 39 8 59.4 0 192 76 167 205 MDO9016594.1 hypothetical protein [Myxococcales bacterium] diamond 354 67.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
31040268 31040268 PRJNA399133_P_NODE_8455_length_180_cov_2.193103_g8367_i0 PRJNA399133 8455 180 2.193103 3.9475854 Pseudomonadati 3379134 Bacteria Bacteria 45.4 0.00187   NR MFT3707833.1 1872627 g8367 i0 55.6 2.46666666666667 54 22 90 1 162 1 847 898 MFT3707833.1 putative Ig domain-containing protein [Archangium sp.] diamond 444 45.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium sp.
32510159 32510159 PRJNA399133_P_NODE_2699_length_304_cov_1.732342_g2611_i0 PRJNA399133 2699 304 1.732342 5.26631968 Myxococcota bacterium 2818507 Bacteria Bacteria 88.6 5.98e-18   NR MDQ2644660.1 2818507 g2611 i0 58.8 0.671052631578947 68 28 67.1 0 12 215 709 776 MDQ2644660.1 S8 family peptidase [Myxococcota bacterium] diamond 204 88.6 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota 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);;