RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1158727 · 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
6682338 6682338 PRJNA1158727_P_NODE_167346_length_226_cov_2.732026_g159884_i0 PRJNA1158727 167346 226 2.732026 6.17437876 Sandaracinus amylolyticus 927083 Bacteria Bacteria 113 9.1e-21   NTclustered gi|2183633570|gb|CP070225.1| 927083 g159884 i0 76.395 2.14159292035398 233 41 100 13 1 226 3702129 3701904 Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence blastn 484 113 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Sandaracinaceae Sandaracinus Sandaracinus amylolyticus
7415434 7415434 PRJNA1158727_P_NODE_149866_length_246_cov_0.890173_g142404_i0 PRJNA1158727 149866 246 0.890173 2.18982558 Sorangium 39643 Bacteria Bacteria 115 2.79e-21   NTclustered gi|1566478966|gb|CP012672.1| 56 g142404 i0 78.351 27.4349593495935 194 31 76 8 1 188 13489900 13490088 Sorangium cellulosum strain So ce836 chromosome, complete genome blastn 6749 115 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum
11782725 11782725 PRJNA1158727_P_NODE_146730_length_247_cov_0.885057_g139268_i0 PRJNA1158727 146730 247 0.885057 2.18609079 Pendulispora rubella 2741070 Bacteria Bacteria 121 6.03e-23   NTclustered gi|2698045512|gb|CP089929.1| 2741070 g139268 i0 97.183 0.854251012145749 71 2 29 0 140 210 47660 47590 Pendulispora rubella strain MSr11368 chromosome, complete genome blastn 211 121 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora rubella
15606291 15606291 PRJNA1158727_P_NODE_119173_length_268_cov_1.579487_g111712_i0 PRJNA1158727 119173 268 1.579487 4.23302516 Labilithrix luteola 1391654 Bacteria Bacteria 213 1.06e-50   NTclustered gi|913610804|gb|CP012333.1| 1391654 g111712 i0 81.387 2.05223880597015 274 39 100 9 1 268 11540370 11540637 Labilithrix luteola strain DSM 27648, complete genome blastn 550 213 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
20704512 20704512 PRJNA1158727_P_NODE_103317_length_288_cov_1.200000_g95856_i0 PRJNA1158727 103317 288 1.2 3.456 Anaeromyxobacter sp. Fw109-5 404589 Bacteria Bacteria 54.7 0.007   NTclustered gi|152026452|gb|CP000769.1| 404589 g95856 i0 96.875 0.111111111111111 32 1 11 0 93 124 4011082 4011113 Anaeromyxobacter sp. Fw109-5, complete genome blastn 32 54.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter sp. Fw109-5
21980347 21980347 PRJNA1158727_P_NODE_120998_length_266_cov_1.595855_g113537_i0 PRJNA1158727 120998 266 1.595855 4.2449743 Corallococcus coralloides 184914 Bacteria Bacteria 287 6.130000000000001e-73   NTclustered gi|380727201|gb|CP003389.1| 1144275 g113537 i0 86.194 94.4624060150376 268 33 100 4 1 266 5755862 5756127 Corallococcus coralloides DSM 2259, complete genome blastn 25127 287 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus Corallococcus coralloides

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