RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA399133" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA399133 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
5517001 5517001 PRJNA399133_P_NODE_4385_length_242_cov_1.821256_g4297_i0 PRJNA399133 4385 242 1.821256 4.40743952 Pendulispora rubella 2741070 Bacteria Bacteria 147 9.72e-31   NTclustered gi|2698045512|gb|CP089929.1| 2741070 g4297 i0 96.591 11.2851239669421 88 3 67 0 1 88 7289172 7289259 Pendulispora rubella strain MSr11368 chromosome, complete genome blastn 2731 147 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora rubella
7458741 7458741 PRJNA399133_P_NODE_12366_length_150_cov_3.426087_g12278_i0 PRJNA399133 12366 150 3.426087 5.1391305 Pendulispora 3375062 Bacteria Bacteria 150 4.2099999999999997e-32   NTclustered gi|2698045512|gb|CP089929.1| 2741070 g12278 i0 84.667 52.1866666666667 150 23 100 0 1 150 9852998 9852849 Pendulispora rubella strain MSr11368 chromosome, complete genome blastn 7828 150 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora rubella
12559523 12559523 PRJNA399133_P_NODE_2710_length_303_cov_2.470149_g2622_i0 PRJNA399133 2710 303 2.470149 7.48455147 Myxococcia 32015 Bacteria Bacteria 381 3.169999999999999e-101   NTclustered gi|913610804|gb|CP012333.1| 1391654 g2622 i0 89.439 124.415841584158 303 31 100 1 1 303 7090163 7090464 Labilithrix luteola strain DSM 27648, complete genome blastn 37698 383 0.994778067885117 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
19539024 19539024 PRJNA399133_P_NODE_1636_length_392_cov_3.176471_g1550_i0 PRJNA399133 1636 392 3.176471 12.45176632 Pendulispora brunnea 2905690 Bacteria Bacteria 355 2.55e-93   NTclustered gi|2698055994|gb|CP089982.1| 2905690 g1550 i0 85.387 267.913265306122 349 44 88 6 46 391 7409356 7409012 Pendulispora brunnea strain MSr12523 chromosome, complete genome blastn 105022 355 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora brunnea
24032569 24032569 PRJNA399133_P_NODE_11759_length_154_cov_2.016807_g11671_i0 PRJNA399133 11759 154 2.016807 3.10588278 Myxococcia 32015 Bacteria Bacteria 224 2.5299999999999994e-54   NTclustered gi|1127377833|gb|CP016908.1| 1882918 g11671 i0 92.857 136.467532467532 154 11 100 0 1 154 1551548 1551395 Pajaroellobacter abortibovis strain BTF92-0548A/99-0131, genome blastn 21016 224 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Pajaroellobacter Pajaroellobacter abortibovis

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