RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA688352 · 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
12146229 12146229 PRJNA688352_P_NODE_10610_length_244_cov_0.900585_g10507_i0 PRJNA688352 10610 244 0.900585 2.1974274 Myxococcales bacterium 2026763 Bacteria Bacteria 250 7.27e-62   NTclustered gi|2108369872|gb|CP070650.1| 2026763 g10507 i0 86.784 1.17622950819672 227 27 92 3 20 244 1018903 1019128 MAG: Myxococcales bacterium isolate bin861 chromosome blastn 287 250 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
13420794 13420794 PRJNA688352_P_NODE_10191_length_245_cov_0.895349_g10088_i0 PRJNA688352 10191 245 0.895349 2.19360505 Myxococcales bacterium 2026763 Bacteria Bacteria 198 2.68e-46   NTclustered gi|2108178552|gb|CP070713.1| 2026763 g10088 i0 81.452 1.01224489795918 248 40 100 5 1 245 2207783 2207539 MAG: Myxococcales bacterium isolate bin5 chromosome blastn 248 198 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
21069280 21069280 PRJNA688352_P_NODE_11477_length_243_cov_0.876471_g11374_i0 PRJNA688352 11477 243 0.876471 2.12982453 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 444 3.09e-120   NTclustered gi|2108357597|gb|CP070652.1| 2026735 g11374 i0 99.588 1 243 1 100 0 1 243 3660781 3661023 MAG: Deltaproteobacteria bacterium isolate bin85 chromosome blastn 243 444 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
22344221 22344221 PRJNA688352_P_NODE_7318_length_251_cov_0.865169_g7215_i0 PRJNA688352 7318 251 0.865169 2.17157419 Myxococcales bacterium 2026763 Bacteria Bacteria 287 5.73e-73   NTclustered gi|2108178552|gb|CP070713.1| 2026763 g7215 i0 87.352 1.00796812749004 253 28 100 3 1 251 1659845 1659595 MAG: Myxococcales bacterium isolate bin5 chromosome blastn 253 287 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium

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