RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA949785", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 8 ✖

tax_phylum 1

  • Myxococcota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA949785 · 8 ✖

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
7311180 7311180 PRJNA949785_P_NODE_17146_length_246_cov_0.890173_g16949_i0 PRJNA949785 17146 246 0.890173 2.18982558 Pyxidicoccus parkwayensis 2813578 Bacteria Bacteria 156 1.65e-33   NTclustered gi|1998505907|gb|CP071090.1| 2813578 g16949 i0 86.713 13.6382113821138 143 16 58 3 102 243 693680 693820 Pyxidicoccus parkwaysis strain SCPEA02 chromosome blastn 3355 156 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Pyxidicoccus Pyxidicoccus parkwayensis
27443288 27443288 PRJNA949785_P_NODE_16783_length_247_cov_0.885057_g16586_i0 PRJNA949785 16783 247 0.885057 2.18609079 Bacteria 2 Bacteria Bacteria 114 1.44e-27   NR WP_044193879.1 394096 g16586 i0 89.1 2.33198380566802 64 7 77.7 0 247 56 45 108 WP_044193879.1 type I restriction-modification system subunit M [Hyalangium minutum] diamond 576 115 0.991304347826087 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Hyalangium Hyalangium minutum
29267439 29267439 PRJNA949785_P_NODE_14129_length_267_cov_1.350515_g13932_i0 PRJNA949785 14129 267 1.350515 3.60587505 Polyangiaceae bacterium 2268199 Bacteria Bacteria 53.9 5.27e-6   NR NUP06123.1 2268199 g13932 i0 33.3 0.808988764044944 72 48 80.9 0 49 264 91 162 NUP06123.1 PQQ-like beta-propeller repeat protein [Polyangiaceae bacterium] diamond 216 53.9 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
30183498 30183498 PRJNA949785_P_NODE_8152_length_372_cov_1.030100_g7955_i0 PRJNA949785 8152 372 1.0301 3.831972 Labilithrix sp. 1971228 Bacteria Bacteria 115 2.45e-27   NR MDF2697540.1 1971228 g7955 i0 49.6 3.14516129032258 131 56 98.4 2 3 368 413 542 MDF2697540.1 hypothetical protein [Labilithrix sp.] diamond 1170 115 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix sp.
30348631 30348631 PRJNA949785_P_NODE_18572_length_242_cov_0.911243_g18375_i0 PRJNA949785 18572 242 0.911243 2.20520806 Myxococcales 29 Bacteria Bacteria 114 1.5600000000000002e-27   NR MBL8915644.1 1872627 g18375 i0 68.8 5.91322314049587 80 24 99.2 1 2 241 83 161 MBL8915644.1 diguanylate cyclase [Archangium sp.] diamond 1431 115 0.991304347826087 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium sp.
31005028 31005028 PRJNA949785_P_NODE_12994_length_281_cov_1.336538_g12797_i0 PRJNA949785 12994 281 1.336538 3.75567178 Polyangiaceae bacterium 2268199 Bacteria Bacteria 107 1.73e-25   NR HEV3190250.1 2268199 g12797 i0 58.2 4.86832740213523 91 38 97.2 0 277 5 211 301 HEV3190250.1 peptide chain release factor 2 [Polyangiaceae bacterium] diamond 1368 107 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
31321012 31321012 PRJNA949785_P_NODE_16495_length_248_cov_0.880000_g16298_i0 PRJNA949785 16495 248 0.88 2.1824 Myxococcales bacterium 2026763 Bacteria Bacteria 46.2 8.55e-4   NR MCA9774824.1 2026763 g16298 i0 41.4 0.701612903225806 58 34 70.2 0 186 13 19 76 MCA9774824.1 hypothetical protein [Myxococcales bacterium] diamond 174 46.2 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
31826975 31826975 PRJNA949785_P_NODE_17837_length_244_cov_0.900585_g17640_i0 PRJNA949785 17837 244 0.900585 2.1974274 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 43.5 0.019   NR MBM4390646.1 2026735 g17640 i0 47.6 0.516393442622951 42 22 51.6 0 3 128 338 379 MBM4390646.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Deltaproteobacteria bacterium] diamond 126 43.5 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria 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);;