RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA797475" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA797475 · 4 ✖

analysis 1

  • blastn · 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
7159796 7159796 PRJNA797475_P_NODE_24106_length_248_cov_0.880000_g24007_i0 PRJNA797475 24106 248 0.88 2.1824 Sandaracinus amylolyticus 927083 Bacteria Bacteria 174 4.59e-39   NTclustered gi|816953346|gb|CP011125.1| 927083 g24007 i0 82.353 1.64112903225806 204 32 81 4 47 248 3916974 3917175 Sandaracinus amylolyticus strain DSM 53668, complete genome blastn 407 174 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Sandaracinaceae Sandaracinus Sandaracinus amylolyticus
16083927 16083927 PRJNA797475_P_NODE_21433_length_251_cov_0.865169_g21334_i0 PRJNA797475 21433 251 0.865169 2.17157419 Nannocystis punicea 2995304 Bacteria Bacteria 217 7.619999999999999e-52   NTclustered gi|2415023655|gb|CP114040.1| 2995304 g21334 i0 82.4 96.4741035856574 250 42 99 2 1 249 5377540 5377292 Nannocystis poenicansa strain FL3 chromosome, complete genome blastn 24215 217 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae Nannocystis Nannocystis punicea
17359829 17359829 PRJNA797475_P_NODE_24474_length_248_cov_0.880000_g24375_i0 PRJNA797475 24474 248 0.88 2.1824 Polyangium aurulentum 2567896 Bacteria Bacteria 54.7 0.006   NTclustered gi|2235996827|gb|CP079217.1| 2567896 g24375 i0 94.286 0.141129032258065 35 2 14 0 214 248 1923284 1923250 Polyangium aurulentum strain SDU3-1 chromosome, complete genome blastn 35 54.7 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Polyangium Polyangium aurulentum
23734099 23734099 PRJNA797475_P_NODE_13959_length_289_cov_1.425926_g13860_i0 PRJNA797475 13959 289 1.425926 4.12092614 Pendulispora albinea 2741071 Bacteria Bacteria 307 5.1700000000000007e-79   NTclustered gi|2698035964|gb|CP089984.1| 2741071 g13860 i0 86.007 12.2283737024221 293 34 100 7 1 289 3589172 3589461 Pendulispora albinea strain MSr11954 chromosome, complete genome blastn 3534 307 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora albinea

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