RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1240805" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1240805 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
349311 349311 PRJNA1240805_P_NODE_3921_length_233_cov_9.233696_g3872_i0 PRJNA1240805 3921 233 9.233696 21.51451168 Labilithrix luteola 1391654 Bacteria Bacteria 272 1.47e-68   NTclustered gi|913610804|gb|CP012333.1| 1391654 g3872 i0 90.047 143.244635193133 211 19 90 2 1 210 7089468 7089259 Labilithrix luteola strain DSM 27648, complete genome blastn 33376 272 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
9277730 9277730 PRJNA1240805_P_NODE_6928_length_174_cov_5.920000_g6879_i0 PRJNA1240805 6928 174 5.92 10.3008 Corallococcus macrosporus 35 Bacteria Bacteria 106 1.11e-18   NTclustered gi|1243045502|gb|CP022203.1| 1189310 g6879 i0 79.739 4.26436781609195 153 25 86 6 23 172 3150800 3150651 Corallococcus macrosporus DSM 14697 chromosome, complete genome blastn 742 106 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus Corallococcus macrosporus
13103251 13103251 PRJNA1240805_P_NODE_2891_length_277_cov_2.684211_g2842_i0 PRJNA1240805 2891 277 2.684211 7.43526447 Sandaracinus amylolyticus 927083 Bacteria Bacteria 243 1.41e-59   NTclustered gi|2183633570|gb|CP070225.1| 927083 g2842 i0 82.734 4.33574007220217 278 43 99 5 3 277 2614950 2614675 Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence blastn 1201 243 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Sandaracinaceae Sandaracinus Sandaracinus amylolyticus

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