RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA577226" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA577226 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
562838 562838 PRJNA577226_S_NODE_9101_length_441_cov_2.633663_g8166_i0 PRJNA577226 9101 441 2.633663 11.61445383 Polyangia bacterium 3058050 Bacteria Bacteria 169 1e-48   NR MFO0657422.1 3058050 g8166 i0 57.2 5.87755102040816 152 56 97.3 1 439 11 138 289 MFO0657422.1 FAD-dependent thymidylate synthase [Polyangia bacterium] diamond 2592 169 1 Bacteria   Pseudomonadati Myxococcota         Polyangia bacterium
22239137 22239137 PRJNA577226_S_NODE_4478_length_680_cov_2.698289_g3600_i0 PRJNA577226 4478 680 2.698289 18.3483652 Myxococcales bacterium 2026763 Bacteria Bacteria 116 7.55e-28   NR MCA9774982.1 2026763 g3600 i0 53 0.582352941176471 132 59 57.8 2 33 425 96 225 MCA9774982.1 VWA domain-containing protein [Myxococcales bacterium] diamond 396 116 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
26794844 26794844 PRJNA577226_S_NODE_70881_length_151_cov_1.350877_g69942_i0 PRJNA577226 70881 151 1.350877 2.03982427 Cystobacter fuscus 43 Bacteria Bacteria 80.9 7.71e-17   NR WP_095991252.1 43 g69942 i0 72 9.93377483443709 50 14 99.3 0 151 2 153 202 WP_095991252.1 tRNA(His) guanylyltransferase Thg1 family protein [Cystobacter fuscus] diamond 1500 80.9 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Cystobacter Cystobacter fuscus
26858479 26858479 PRJNA577226_S_NODE_3501_length_816_cov_2.776637_g2671_i0 PRJNA577226 3501 816 2.776637 22.65735792 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 65.1 7.54e-8   NR MCP4502965.1 2026735 g2671 i0 49.3 0.742647058823529 71 34 25.4 1 609 815 135 205 MCP4502965.1 DEAD/DEAH box helicase [Deltaproteobacteria bacterium] diamond 606 65.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
28121901 28121901 PRJNA577226_S_NODE_2825_length_962_cov_2.621622_g2032_i0 PRJNA577226 2825 962 2.621622 25.22000364 Myxococcales bacterium 2026763 Bacteria Bacteria 149 4e-36   NR MCA9771962.1 2026763 g2032 i0 52.9 1.44386694386694 155 61 47.4 3 507 962 9 154 MCA9771962.1 DotA/TraY family protein [Myxococcales bacterium] diamond 1389 149 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
28279548 28279548 PRJNA577226_S_NODE_37166_length_204_cov_1.634731_g36227_i0 PRJNA577226 37166 204 1.634731 3.33485124 Polyangium fumosum 889272 Bacteria Bacteria 91.7 6.09e-20   NR WP_170228802.1 889272 g36227 i0 65.7 0.985294117647059 67 23 98.5 0 2 202 80 146 WP_170228802.1 AAA family ATPase [Polyangium fumosum] diamond 201 91.7 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Polyangium Polyangium fumosum
29605519 29605519 PRJNA577226_S_NODE_1930_length_1460_cov_3.172171_g1221_i0 PRJNA577226 1930 1460 3.172171 46.3136966 Myxococcales bacterium 2026763 Bacteria Bacteria 107 2.62e-22   NR MCA9773166.1 2026763 g1221 i0 35.3 1.77534246575342 215 139 44.2 0 1 645 38 252 MCA9773166.1 hypothetical protein [Myxococcales bacterium] diamond 2592 107 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
30047815 30047815 PRJNA577226_S_NODE_11671_length_381_cov_2.796512_g10733_i0 PRJNA577226 11671 381 2.796512 10.65471072 Myxococcales bacterium 2026763 Bacteria Bacteria 123 1.05e-31   NR MCA9772256.1 2026763 g10733 i0 52 0.968503937007874 123 56 94.5 1 3 362 142 264 MCA9772256.1 hypothetical protein [Myxococcales bacterium] diamond 369 123 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
30205702 30205702 PRJNA577226_S_NODE_13412_length_353_cov_3.037975_g12473_i0 PRJNA577226 13412 353 3.037975 10.72405175 Myxococcales bacterium 2026763 Bacteria Bacteria 60.1 1.09e-7   NR MCA9772382.1 2026763 g12473 i0 36.3 1.05382436260623 124 63 99.4 3 351 1 278 392 MCA9772382.1 strawberry notch C-terminal domain-containing protein [Myxococcales bacterium] diamond 372 60.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
30679730 30679730 PRJNA577226_S_NODE_58093_length_164_cov_2.519685_g57154_i0 PRJNA577226 58093 164 2.519685 4.1322834 Myxococcales bacterium 2026763 Bacteria Bacteria 67.4 2.53e-11   NR MCA9771629.1 2026763 g57154 i0 52.5 1.07926829268293 59 23 98.8 2 162 1 147 205 MCA9771629.1 Eco57I restriction-modification methylase domain-containing protein [Myxococcales bacterium] diamond 177 67.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
30932739 30932739 PRJNA577226_S_NODE_17094_length_310_cov_1.765568_g16155_i0 PRJNA577226 17094 310 1.765568 5.4732608 Myxococcales bacterium 2026763 Bacteria Bacteria 160 2.5299999999999992e-43   NR MCA9773584.1 2026763 g16155 i0 68.6 0.987096774193548 102 32 98.7 0 308 3 75 176 MCA9773584.1 hypothetical protein [Myxococcales bacterium] diamond 306 160 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
31167070 31167070 PRJNA577226_S_NODE_48015_length_180_cov_1.496503_g47076_i0 PRJNA577226 48015 180 1.496503 2.6937054 Pseudomonadati 3379134 Bacteria Bacteria 50.4 3.12e-5   NR MCA9773632.1 2026763 g47076 i0 49.1 3.45 57 29 95 0 7 177 198 254 MCA9773632.1 CRISPR-associated helicase Cas3' [Myxococcales bacterium] diamond 621 50.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
31912947 31912947 PRJNA577226_S_NODE_62517_length_159_cov_1.598361_g61578_i0 PRJNA577226 62517 159 1.598361 2.54139399 Myxococcales bacterium 2026763 Bacteria Bacteria 75.1 4.73e-14   NR MCA9773584.1 2026763 g61578 i0 71.2 0.981132075471698 52 15 98.1 0 159 4 264 315 MCA9773584.1 hypothetical protein [Myxococcales bacterium] diamond 156 75.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
32179743 32179743 PRJNA577226_S_NODE_46818_length_182_cov_1.724138_g45879_i0 PRJNA577226 46818 182 1.724138 3.13793116 Pseudomonadati 3379134 Bacteria Bacteria 57 1.52e-7   NR MBM4395130.1 2026735 g45879 i0 50.9 2.63736263736264 57 28 94 0 181 11 63 119 MBM4395130.1 SAM-dependent DNA methyltransferase [Deltaproteobacteria bacterium] diamond 480 57 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
32432902 32432902 PRJNA577226_S_NODE_10479_length_405_cov_2.209239_g9542_i0 PRJNA577226 10479 405 2.209239 8.94741795 Pseudomonadati 3379134 Bacteria Bacteria 70.9 9.02e-12   NR MCA9775050.1 2026763 g9542 i0 45 1.19259259259259 80 40 59.3 1 242 3 9 84 MCA9775050.1 hypothetical protein [Myxococcales bacterium] diamond 483 70.9 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
32514382 32514382 PRJNA577226_S_NODE_19639_length_287_cov_1.604000_g18700_i0 PRJNA577226 19639 287 1.604 4.60348 Chondromyces apiculatus 51 Bacteria Bacteria 64.7 7.1e-10   NR WP_231511744.1 51 g18700 i0 43.8 5.68641114982578 89 45 87.8 2 18 269 70 158 WP_231511744.1 sigma-70 family RNA polymerase sigma factor [Chondromyces apiculatus] diamond 1632 64.7 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Chondromyces Chondromyces apiculatus
32514389 32514389 PRJNA577226_S_NODE_29279_length_231_cov_1.752577_g28340_i0 PRJNA577226 29279 231 1.752577 4.04845287 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 68.9 2.33e-12   NR MCC7386607.1 2026735 g28340 i0 59.7 1.54545454545455 62 25 80.5 0 1 186 112 173 MCC7386607.1 ankyrin repeat domain-containing protein [Deltaproteobacteria bacterium] diamond 357 68.9 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
32640048 32640048 PRJNA577226_S_NODE_4160_length_714_cov_3.314623_g3288_i0 PRJNA577226 4160 714 3.314623 23.66640822 Myxococcales bacterium 2026763 Bacteria Bacteria 56.2 1.11e-5   NR MCA9772654.1 2026763 g3288 i0 42.4 0.57563025210084 66 36 26.9 1 5 196 72 137 MCA9772654.1 hypothetical protein [Myxococcales bacterium] diamond 411 56.2 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);;