RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB41113", tax_kingdom = "Pseudomonadati" 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

  • Pseudomonadati · 6 ✖

bioproject 1

  • PRJEB41113 · 6 ✖

analysis 1

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
28195229 28195229 PRJEB41113_S_NODE_1206_length_252_cov_3.967442_g1197_i0 PRJEB41113 1206 252 3.967442 9.99795384 Bacteria 2 Bacteria Bacteria 47.4 4.23e-4   NR MBN8540054.1 2026735 g1197 i0 69 1.38095238095238 29 9 34.5 0 2 88 132 160 MBN8540054.1 glutathione peroxidase [Deltaproteobacteria bacterium] diamond 348 47.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
29079576 29079576 PRJEB41113_S_NODE_7888_length_169_cov_2.909091_g7879_i0 PRJEB41113 7888 169 2.909091 4.91636379 Bacteria 2 Bacteria Bacteria 90.1 2.7e-19   NR OJY22933.1 1895795 g7879 i0 79.6 1.91715976331361 54 11 95.9 0 3 164 476 529 OJY22933.1 MAG: hypothetical protein BGO98_33415 [Myxococcales bacterium 68-20] diamond 324 90.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium 68-20
29717315 29717315 PRJEB41113_S_NODE_1610_length_237_cov_4.795000_g1601_i0 PRJEB41113 1610 237 4.795 11.36415 Polyangiaceae bacterium 2268199 Bacteria Bacteria 141 1.66e-37   NR HTQ45418.1 2268199 g1601 i0 75.6 4.92405063291139 78 19 98.7 0 237 4 407 484 HTQ45418.1 glutamine--tRNA ligase/YqeY domain fusion protein [Polyangiaceae bacterium] diamond 1167 141 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
31038157 31038157 PRJEB41113_S_NODE_815_length_274_cov_2.337553_g806_i0 PRJEB41113 815 274 2.337553 6.40489522 Bacteria 2 Bacteria Bacteria 44.3 0.0145   NR MBI3796647.1 2026735 g806 i0 70 1.60948905109489 30 9 32.8 0 96 7 1 30 MBI3796647.1 ribose-phosphate pyrophosphokinase [Deltaproteobacteria bacterium] diamond 441 44.7 0.991051454138702 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
31613666 31613666 PRJEB41113_S_NODE_9836_length_160_cov_19.398374_g9827_i0 PRJEB41113 9836 160 19.398374 31.0373984 Corallococcus interemptor 2316720 Bacteria Bacteria 109 9.91e-30   NR WP_147468539.1 2316720 g9827 i0 97.9 0.9 48 1 90 0 4 147 9 56 WP_147468539.1 reverse transcriptase domain-containing protein, partial [Corallococcus interemptor] diamond 144 109 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus Corallococcus interemptor
32366493 32366493 PRJEB41113_S_NODE_1839_length_230_cov_7.585492_g1830_i0 PRJEB41113 1839 230 7.585492 17.4466316 Pyxidicoccus 224458 Bacteria Bacteria 56.6 3.82e-7   NR WP_171818329.1 394095 g1830 i0 36.8 3.96521739130435 76 48 99.1 0 230 3 239 314 WP_171818329.1 type IV pilus assembly protein PilM [Pyxidicoccus fallax] diamond 912 56.6 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Pyxidicoccus Pyxidicoccus fallax

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