RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA1105232", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 13 ✖

tax_phylum 1

  • Myxococcota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1105232 · 13 ✖

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
24438499 24438499 PRJNA1105232_S_NODE_16400_length_165_cov_0.896552_g16184_i0 PRJNA1105232 16400 165 0.896552 1.4793108 Myxococcales bacterium 2026763 Bacteria Bacteria 78.6 2.98e-15   NR MCA9666679.1 2026763 g16184 i0 66 3.69090909090909 50 17 90.9 0 152 3 249 298 MCA9666679.1 glutamine synthetase III [Myxococcales bacterium] diamond 609 78.6 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
26878132 26878132 PRJNA1105232_S_NODE_3381_length_309_cov_2.576923_g3165_i0 PRJNA1105232 3381 309 2.576923 7.96269207 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 127 6.22e-33   NR MBW2270056.1 2026735 g3165 i0 61.9 1.9126213592233 97 37 94.2 0 10 300 206 302 MBW2270056.1 fructose-bisphosphate aldolase class I [Deltaproteobacteria bacterium] diamond 591 127 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
27352414 27352414 PRJNA1105232_S_NODE_4643_length_273_cov_2.227679_g4427_i0 PRJNA1105232 4643 273 2.227679 6.08156367 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 109 9.91e-26   NR MCO4770005.1 2026735 g4427 i0 61 1.71428571428571 77 30 84.6 0 272 42 389 465 MCO4770005.1 aldehyde dehydrogenase family protein [Deltaproteobacteria bacterium] diamond 468 109 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
27627853 27627853 PRJNA1105232_S_NODE_15284_length_169_cov_0.866667_g15068_i0 PRJNA1105232 15284 169 0.866667 1.46466723 Bacteria 2 Bacteria Bacteria 85.9 8.73e-18   NR MBK9071278.1 2026763 g15068 i0 75.5 7.50887573964497 53 13 94.1 0 2 160 2021 2073 MBK9071278.1 Ig-like domain-containing protein [Myxococcales bacterium] diamond 1269 85.9 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
28164472 28164472 PRJNA1105232_S_NODE_6865_length_234_cov_1.124324_g6649_i0 PRJNA1105232 6865 234 1.124324 2.63091816 Bacteria 2 Bacteria Bacteria 55.8 7.48e-7   NR MBM4395155.1 2026735 g6649 i0 32.1 1.87179487179487 81 46 92.3 2 15 230 290 370 MBM4395155.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 438 55.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
29679663 29679663 PRJNA1105232_S_NODE_7630_length_224_cov_2.885714_g7414_i0 PRJNA1105232 7630 224 2.885714 6.46399936 Archangium 47 Bacteria Bacteria 118 5.830000000000001e-29   NR WP_414640990.1 1872627 g7414 i0 76.4 13.9821428571429 72 17 96.4 0 3 218 472 543 WP_414640990.1 LysM peptidoglycan-binding domain-containing protein [Archangium sp.] diamond 3132 119 0.991596638655462 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium sp.
30193960 30193960 PRJNA1105232_S_NODE_8932_length_211_cov_1.925926_g8716_i0 PRJNA1105232 8932 211 1.925926 4.06370386 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 100 1.44e-22   NR MBU48463.1 2026735 g8716 i0 69.4 0.881516587677725 62 19 88.2 0 211 26 494 555 MBU48463.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 186 100 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
30248815 30248815 PRJNA1105232_S_NODE_7592_length_225_cov_0.886364_g7376_i0 PRJNA1105232 7592 225 0.886364 1.994319 Bacteria 2 Bacteria Bacteria 86.7 1e-17   NR MCA9591425.1 2026763 g7376 i0 46.6 2.73333333333333 73 39 97.3 0 2 220 683 755 MCA9591425.1 hypothetical protein [Myxococcales bacterium] diamond 615 86.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
30257618 30257618 PRJNA1105232_S_NODE_3132_length_318_cov_3.568773_g2916_i0 PRJNA1105232 3132 318 3.568773 11.34869814 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 127 2.33e-31   NR MBK04146.1 2026735 g2916 i0 57.8 1.92452830188679 102 43 96.2 0 314 9 856 957 MBK04146.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 612 127 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
30510002 30510002 PRJNA1105232_S_NODE_7513_length_226_cov_0.881356_g7297_i0 PRJNA1105232 7513 226 0.881356 1.99186456 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 72 1.49e-12   NR MBI4814852.1 2026735 g7297 i0 43.8 1.06194690265487 80 40 99.6 1 225 1 1940 2019 MBI4814852.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 240 72 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
31490041 31490041 PRJNA1105232_S_NODE_7656_length_224_cov_1.782857_g7440_i0 PRJNA1105232 7656 224 1.782857 3.99359968 Anaeromyxobacter sp. 1872521 Bacteria Bacteria 42.7 0.0251   NR HEX9401692.1 1872521 g7440 i0 37.7 1.37946428571429 53 33 71 0 220 62 170 222 HEX9401692.1 RNA polymerase sigma factor [Anaeromyxobacter sp.] diamond 309 42.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter sp.
31828797 31828797 PRJNA1105232_S_NODE_8277_length_217_cov_2.214286_g8061_i0 PRJNA1105232 8277 217 2.214286 4.80500062 Deltaproteobacteria 28221 Bacteria Bacteria 50.1 6.6e-5   NR HEV7557458.1 2212474 g8061 i0 36.6 1.94930875576037 71 43 96.8 2 211 2 220 289 HEV7557458.1 diacylglycerol kinase family protein [Kofleriaceae bacterium] diamond 423 50.4 0.994047619047619 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
32154161 32154161 PRJNA1105232_S_NODE_10678_length_196_cov_3.326531_g10462_i0 PRJNA1105232 10678 196 3.326531 6.52000076 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 88.6 8.46e-19   NR MBI4040480.1 2026735 g10462 i0 66.2 4.97448979591837 65 21 99.5 1 196 2 292 355 MBI4040480.1 ADP-forming succinate--CoA ligase subunit beta [Deltaproteobacteria bacterium] diamond 975 88.6 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria 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);;