RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1150539" 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

  • PRJNA1150539 · 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
4128563 4128563 PRJNA1150539_S_NODE_75464_length_272_cov_1.482412_g74868_i0 PRJNA1150539 75464 272 1.482412 4.03216064 Anaeromyxobacter paludicola 2918171 Bacteria Bacteria 274 4.889999999999998e-69   NTclustered gi|2199271117|dbj|AP025592.1| 2918171 g74868 i0 87.983 200.522058823529 233 26 86 2 40 272 1384407 1384177 Anaeromyxobacter paludicola DNA, complete genome blastn 54542 274 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter paludicola
6679749 6679749 PRJNA1150539_S_NODE_99546_length_244_cov_1.263158_g98950_i0 PRJNA1150539 99546 244 1.263158 3.08210552 Pendulispora albinea 2741071 Bacteria Bacteria 224 4.4099999999999997e-54   NTclustered gi|2698035964|gb|CP089984.1| 2741071 g98950 i0 85.202 99.4426229508197 223 27 90 5 26 244 3587953 3588173 Pendulispora albinea strain MSr11954 chromosome, complete genome blastn 24264 224 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora albinea
11780237 11780237 PRJNA1150539_S_NODE_74350_length_273_cov_3.160000_g73754_i0 PRJNA1150539 74350 273 3.16 8.6268 Pendulispora rubella 2741070 Bacteria Bacteria 298 2.92e-76   NTclustered gi|2698045512|gb|CP089929.1| 2741070 g73754 i0 88.571 319.802197802198 245 28 90 0 29 273 7290015 7289771 Pendulispora rubella strain MSr11368 chromosome, complete genome blastn 87306 298 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora rubella
23989162 23989162 PRJNA1150539_S_NODE_92059_length_251_cov_1.730337_g91463_i0 PRJNA1150539 92059 251 1.730337 4.34314587 Pendulispora 3375062 Bacteria Bacteria 374 4.27e-99   NTclustered gi|2698045512|gb|CP089929.1| 2741070 g91463 i0 93.625 174.011952191235 251 15 100 1 1 251 7289236 7289485 Pendulispora rubella strain MSr11368 chromosome, complete genome blastn 43677 374 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora rubella

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