RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1262902", tax_kingdom = "Pseudomonadati" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 4 ✖

tax_kingdom 1

  • Pseudomonadati · 4 ✖

bioproject 1

  • PRJNA1262902 · 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
7431944 7431944 PRJNA1262902_P_NODE_5666_length_270_cov_1.172589_g5624_i0 PRJNA1262902 5666 270 1.172589 3.1659903 Pseudomonadati 3379134 Bacteria Bacteria 195 3.89e-45   NTclustered gi|1338588479|gb|CP012673.1| 56 g5624 i0 84.08 73.337037037037 201 32 74 0 70 270 11758500 11758300 Sorangium cellulosum strain So ce26 chromosome, complete genome blastn 19801 195 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum
26725288 26725288 PRJNA1262902_P_NODE_11581_length_242_cov_1.426036_g11539_i0 PRJNA1262902 11581 242 1.426036 3.45100712 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 58.2 7.88e-8   NR MBI4405628.1 2026735 g11539 i0 42.7 0.929752066115702 75 43 93 0 15 239 147 221 MBI4405628.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 225 58.2 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
27105311 27105311 PRJNA1262902_P_NODE_10062_length_245_cov_1.343023_g10020_i0 PRJNA1262902 10062 245 1.343023 3.29040635 Myxococcaceae bacterium 2484252 Bacteria Bacteria 156 2.84e-43   NR HEX8702241.1 2484252 g10020 i0 91.4 0.991836734693878 81 7 99.2 0 2 244 271 351 HEX8702241.1 S41 family peptidase [Myxococcaceae bacterium] diamond 243 156 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae   Myxococcaceae bacterium
31496195 31496195 PRJNA1262902_P_NODE_9476_length_247_cov_0.885057_g9434_i0 PRJNA1262902 9476 247 0.885057 2.18609079 Myxococcaceae bacterium 2484252 Bacteria Bacteria 88.6 1.4e-19   NR HEY1333567.1 2484252 g9434 i0 82.5 0.692307692307692 57 10 69.2 0 246 76 151 207 HEY1333567.1 thiamine phosphate synthase [Myxococcaceae bacterium] diamond 171 88.6 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae   Myxococcaceae 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);;