RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA613025 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
5695543 5695543 PRJNA613025_S_NODE_32505_length_163_cov_0.894737_g32351_i0 PRJNA613025 32505 163 0.894737 1.45842131 Myxococcales bacterium 2026763 Bacteria Bacteria 75.1 4.88e-14   NR MBK6693411.1 2026763 g32351 i0 64.8 0.993865030674847 54 19 99.4 0 162 1 371 424 MBK6693411.1 HAMP domain-containing histidine kinase [Myxococcales bacterium] diamond 162 75.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
29164736 29164736 PRJNA613025_S_NODE_23409_length_197_cov_1.371622_g23255_i0 PRJNA613025 23409 197 1.371622 2.70209534 Polyangiaceae bacterium 2268199 Bacteria Bacteria 46.2 8.89e-4   NR HEX7665424.1 2268199 g23255 i0 36.9 1.97969543147208 65 40 99 1 2 196 92 155 HEX7665424.1 glutathione binding-like protein [Polyangiaceae bacterium] diamond 390 46.2 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
29448400 29448400 PRJNA613025_S_NODE_30730_length_166_cov_0.871795_g30576_i0 PRJNA613025 30730 166 0.871795 1.4471797 Polyangiaceae bacterium 2268199 Bacteria Bacteria 43.1 0.00948   NR MEZ4306608.1 2268199 g30576 i0 86.4 0.397590361445783 22 3 39.8 0 99 164 358 379 MEZ4306608.1 protein kinase [Polyangiaceae bacterium] diamond 66 43.1 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
30206400 30206400 PRJNA613025_S_NODE_32352_length_163_cov_1.473684_g32198_i0 PRJNA613025 32352 163 1.473684 2.40210492 Myxococcota bacterium 2818507 Bacteria Bacteria 55.1 5.66e-7   NR MEQ1505933.1 2818507 g32198 i0 44.2 0.957055214723926 52 29 95.7 0 162 7 623 674 MEQ1505933.1 FAD-binding protein [Myxococcota bacterium] diamond 156 55.1 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
30365043 30365043 PRJNA613025_S_NODE_22632_length_202_cov_0.993464_g22478_i0 PRJNA613025 22632 202 0.993464 2.00679728 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 48.9 1.44e-4   NR MCB9737160.1 2026735 g22478 i0 37.9 0.861386138613861 58 36 86.1 0 201 28 2 59 MCB9737160.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 174 48.9 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
31091361 31091361 PRJNA613025_S_NODE_33935_length_161_cov_0.910714_g33781_i0 PRJNA613025 33935 161 0.910714 1.46624954 Polyangiaceae bacterium 2268199 Bacteria Bacteria 56.6 1.55e-7   NR MCL2779433.1 2268199 g33781 i0 58.1 0.801242236024845 43 18 80.1 0 10 138 340 382 MCL2779433.1 hypothetical protein [Polyangiaceae bacterium] diamond 129 56.6 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
31881837 31881837 PRJNA613025_S_NODE_25737_length_185_cov_1.125000_g25583_i0 PRJNA613025 25737 185 1.125 2.08125 Myxococcales bacterium 2026763 Bacteria Bacteria 80.5 8.31e-16   NR MSP61786.1 2026763 g25583 i0 63.9 0.989189189189189 61 22 98.9 0 185 3 42 102 MSP61786.1 argininosuccinate lyase [Myxococcales bacterium] diamond 183 80.5 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);;