RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA994052" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA994052 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
976875 976875 PRJNA994052_P_NODE_81501_length_199_cov_15.730159_g80244_i0 PRJNA994052 81501 199 15.730159 31.30301641 Sandaracinus amylolyticus 927083 Bacteria Bacteria 54.7 0.005   NTclustered gi|816953346|gb|CP011125.1| 927083 g80244 i0 100 0.28643216080402 29 0 15 0 131 159 4640150 4640178 Sandaracinus amylolyticus strain DSM 53668, complete genome blastn 57 54.7 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Sandaracinaceae Sandaracinus Sandaracinus amylolyticus
8926046 8926046 PRJNA994052_P_NODE_57287_length_230_cov_13.974522_g56032_i0 PRJNA994052 57287 230 13.974522 32.1414006 Myxococcales 29 Bacteria Bacteria 169 1.95e-37   NTclustered gi|337255776|gb|CP002830.1| 35 g56032 i0 81.604 67.2478260869565 212 32 91 6 11 220 4924094 4923888 Myxococcus macrosporus strain HW-1, complete genome blastn 15467 169 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus Corallococcus macrosporus
9904461 9904461 PRJNA994052_P_NODE_26948_length_290_cov_5.589862_g25708_i0 PRJNA994052 26948 290 5.589862 16.2105998 Polyangium aurulentum 2567896 Bacteria Bacteria 60.2 1.6e-4   NTclustered gi|2235996827|gb|CP079217.1| 2567896 g25708 i0 100 6.07586206896552 32 0 11 0 76 107 6813463 6813432 Polyangium aurulentum strain SDU3-1 chromosome, complete genome blastn 1762 60.2 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Polyangium Polyangium aurulentum
15004698 15004698 PRJNA994052_P_NODE_68432_length_214_cov_64.907801_g67176_i0 PRJNA994052 68432 214 64.907801 138.90269414 Labilithrix luteola 1391654 Bacteria Bacteria 231 2.2599999999999997e-56   NTclustered gi|913610804|gb|CP012333.1| 1391654 g67176 i0 86.239 137.976635514019 218 24 100 6 1 214 3941982 3941767 Labilithrix luteola strain DSM 27648, complete genome blastn 29527 231 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
18828432 18828432 PRJNA994052_P_NODE_58975_length_227_cov_106.000000_g57719_i0 PRJNA994052 58975 227 106 240.62 Pendulispora rubella 2741070 Bacteria Bacteria 267 6.63e-67   NTclustered gi|2698045512|gb|CP089929.1| 2741070 g57719 i0 88.341 334.321585903084 223 25 98 1 4 225 7289790 7290012 Pendulispora rubella strain MSr11368 chromosome, complete genome blastn 75891 267 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora rubella
22653479 22653479 PRJNA994052_P_NODE_35898_length_267_cov_38.216495_g34652_i0 PRJNA994052 35898 267 38.216495 102.03804165 Myxococcales bacterium 2026763 Bacteria Bacteria 222 1.76e-53   NTclustered gi|1958041644|gb|CP064980.1| 2026763 g34652 i0 83.133 450.003745318352 249 37 93 5 19 265 1309903 1309658 Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome blastn 120151 222 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales 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);;