RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1073005", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 6 ✖

tax_phylum 1

  • Myxococcota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1073005 · 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
12494843 12494843 PRJNA1073005_P_NODE_8310_length_272_cov_1.206030_g8191_i0 PRJNA1073005 8310 272 1.20603 3.2804016 Polyangium sp. 3409587 Bacteria Bacteria 61.6 9.84e-9   NR HMY18582.1 57 g8191 i0 44.2 0.849264705882353 77 40 81.6 1 51 272 1 77 HMY18582.1 sigma-54 dependent transcriptional regulator [Polyangium sp.] diamond 231 61.6 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Polyangium Polyangium sp.
15489606 15489606 PRJNA1073005_P_NODE_10473_length_228_cov_2.941935_g10354_i0 PRJNA1073005 10473 228 2.941935 6.7076118 Polyangiaceae bacterium 2268199 Bacteria Bacteria 152 6.849999999999999e-43   NR HOU91216.1 2268199 g10354 i0 93.1 0.947368421052632 72 5 94.7 0 218 3 51 122 HOU91216.1 dissimilatory-type sulfite reductase subunit alpha [Polyangiaceae bacterium] diamond 216 152 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
26846155 26846155 PRJNA1073005_P_NODE_7981_length_284_cov_1.094787_g7862_i0 PRJNA1073005 7981 284 1.094787 3.10919508 Anaeromyxobacter sp. RBG_16_69_14 1797238 Bacteria Bacteria 96.3 1.1e-22   NR OFX21971.1 1797238 g7862 i0 48.5 2.07042253521127 97 34 99.3 3 284 3 76 159 OFX21971.1 MAG: hypothetical protein A2V77_12995 [Anaeromyxobacter sp. RBG_16_69_14] diamond 588 96.3 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter sp. RBG_16_69_14
29332600 29332600 PRJNA1073005_P_NODE_9709_length_246_cov_0.890173_g9590_i0 PRJNA1073005 9709 246 0.890173 2.18982558 root 1 Root_unresolved Root_unresolved 84 2.08e-18   NR WP_332307093.1 41 g9590 i0 56.4 3.63414634146341 55 24 67.1 0 43 207 86 140 WP_332307093.1 CAP domain-containing protein [Stigmatella aurantiaca] diamond 894 84.3 0.99644128113879 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Stigmatella Stigmatella aurantiaca
29719674 29719674 PRJNA1073005_P_NODE_5770_length_382_cov_1.453074_g5651_i0 PRJNA1073005 5770 382 1.453074 5.55074268 Polyangiaceae bacterium 2268199 Bacteria Bacteria 44.7 0.0352   NR HTQ03789.1 2268199 g5651 i0 30.3 0.777486910994764 99 52 77.7 2 380 84 421 502 HTQ03789.1 hypothetical protein [Polyangiaceae bacterium] diamond 297 44.7 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
29901058 29901058 PRJNA1073005_P_NODE_7891_length_286_cov_1.924883_g7772_i0 PRJNA1073005 7891 286 1.924883 5.50516538 Pseudomonadati 3379134 Bacteria Bacteria 55.8 1.47e-6   NR WP_293275847.1 1962667 g7772 i0 48.3 1.31118881118881 60 30 62.9 1 286 107 286 344 WP_293275847.1 tectonin domain-containing protein [Nannocystis sp.] diamond 375 55.8 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae Nannocystis Nannocystis sp.

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