RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA685607", tax_kingdom = "Pseudomonadati" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 20 ✖

tax_kingdom 1

  • Pseudomonadati · 20 ✖

bioproject 1

  • PRJNA685607 · 20 ✖

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
19793423 19793423 PRJNA685607_P_NODE_90036_length_243_cov_0.905882_g89677_i0 PRJNA685607 90036 243 0.905882 2.20129326 Kofleriaceae bacterium 2212474 Bacteria Bacteria 93.2 3.6100000000000005e-21   NR HEX5060493.1 2212474 g89677 i0 97.7 1.06172839506173 43 1 53.1 0 241 113 191 233 HEX5060493.1 response regulator [Kofleriaceae bacterium] diamond 258 93.2 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
26955520 26955520 PRJNA685607_P_NODE_91002_length_243_cov_0.600000_g90643_i0 PRJNA685607 91002 243 0.6 1.458 Myxococcota bacterium 2818507 Bacteria Bacteria 45.4 0.00398   NR MEC7987112.1 2818507 g90643 i0 46.8 0.580246913580247 47 24 58 1 179 39 331 376 MEC7987112.1 hypothetical protein [Myxococcota bacterium] diamond 141 45.4 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
27335244 27335244 PRJNA685607_P_NODE_16003_length_408_cov_1.307463_g15645_i0 PRJNA685607 16003 408 1.307463 5.33444904 Polyangiaceae bacterium 2268199 Bacteria Bacteria 46.6 0.00912   NR HEX3774843.1 2268199 g15645 i0 39.7 0.573529411764706 78 44 56.6 3 167 397 376 451 HEX3774843.1 hypothetical protein [Polyangiaceae bacterium] diamond 234 46.6 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
27682806 27682806 PRJNA685607_P_NODE_49644_length_279_cov_1.155340_g49285_i0 PRJNA685607 49644 279 1.15534 3.2233986 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 46.2 0.0036   NR MBI1813839.1 2026735 g49285 i0 40.4 0.612903225806452 57 34 61.3 0 255 85 423 479 MBI1813839.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 171 46.2 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
27714450 27714450 PRJNA685607_P_NODE_88144_length_243_cov_1.547059_g87785_i0 PRJNA685607 88144 243 1.547059 3.75935337 Myxococcota bacterium 2818507 Bacteria Bacteria 42.7 0.0371   NR MEO0604080.1 2818507 g87785 i0 59.5 0.518518518518518 42 16 51.9 1 214 89 605 645 MEO0604080.1 tetratricopeptide repeat protein [Myxococcota bacterium] diamond 126 42.7 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
27840120 27840120 PRJNA685607_P_NODE_94004_length_242_cov_0.875740_g93645_i0 PRJNA685607 94004 242 0.87574 2.1192908 Polyangiaceae bacterium 2268199 Bacteria Bacteria 93.2 1.69e-20   NR HSC89367.1 2268199 g93645 i0 64.2 0.830578512396694 67 22 80.6 1 46 240 189 255 HSC89367.1 hydrogen peroxide-inducible genes activator [Polyangiaceae bacterium] diamond 201 93.2 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
28187402 28187402 PRJNA685607_P_NODE_35906_length_311_cov_1.571429_g35547_i0 PRJNA685607 35906 311 1.571429 4.88714419 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 88.2 2.57e-20   NR MBN2798920.1 2026735 g35547 i0 48.3 0.839228295819936 87 45 83.9 0 305 45 4 90 MBN2798920.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 261 88.2 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
28218980 28218980 PRJNA685607_P_NODE_77546_length_247_cov_0.885057_g77187_i0 PRJNA685607 77546 247 0.885057 2.18609079 Labilithrix sp. 1971228 Bacteria Bacteria 92 5.32e-21   NR HSO37576.1 1971228 g77187 i0 59.5 4.78542510121457 79 32 96 0 246 10 121 199 HSO37576.1 DUF3501 family protein [Labilithrix sp.] diamond 1182 92 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix sp.
28250653 28250653 PRJNA685607_P_NODE_96846_length_241_cov_0.916667_g96487_i0 PRJNA685607 96846 241 0.916667 2.20916747 Kofleriaceae bacterium 2212474 Bacteria Bacteria 41.6 0.0453   NR MBP8806634.1 2212474 g96487 i0 47.9 0.597510373443983 48 25 59.8 0 192 49 89 136 MBP8806634.1 hypothetical protein [Kofleriaceae bacterium] diamond 144 41.6 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
29450357 29450357 PRJNA685607_P_NODE_76770_length_247_cov_0.885057_g76411_i0 PRJNA685607 76770 247 0.885057 2.18609079 Polyangiaceae bacterium 2268199 Bacteria Bacteria 159 8.16e-49   NR HSC89506.1 2268199 g76411 i0 89 0.995951417004049 82 9 99.6 0 247 2 21 102 HSC89506.1 hypothetical protein [Polyangiaceae bacterium] diamond 246 159 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
29671250 29671250 PRJNA685607_P_NODE_59070_length_261_cov_1.324468_g58711_i0 PRJNA685607 59070 261 1.324468 3.45686148 Sorangium cellulosum 56 Bacteria Bacteria 73.9 4.93e-13   NR WP_020464857.1 56 g58711 i0 56.1 1.51724137931034 66 28 74.7 1 243 49 630 695 WP_020464857.1 methionine--tRNA ligase [Sorangium cellulosum] diamond 396 73.9 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum
29766204 29766204 PRJNA685607_P_NODE_67871_length_250_cov_0.870056_g67512_i0 PRJNA685607 67871 250 0.870056 2.17514 Myxococcota bacterium 2818507 Bacteria Bacteria 140 1.72e-36   NR MEM9459632.1 2818507 g67512 i0 78 2.952 82 18 98.4 0 3 248 851 932 MEM9459632.1 aminomethyl-transferring glycine dehydrogenase [Myxococcota bacterium] diamond 738 140 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
30208314 30208314 PRJNA685607_P_NODE_32992_length_320_cov_1.242915_g32633_i0 PRJNA685607 32992 320 1.242915 3.977328 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 122 1.37e-29   NR MBI1945503.1 2026735 g32633 i0 54.7 10.771875 106 47 99.4 1 1 318 609 713 MBI1945503.1 bifunctional aspartate kinase/diaminopimelate decarboxylase [Deltaproteobacteria bacterium] diamond 3447 122 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
30935405 30935405 PRJNA685607_P_NODE_54394_length_270_cov_1.106599_g54035_i0 PRJNA685607 54394 270 1.106599 2.9878173 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 44.7 0.0093   NR MCP3678314.1 2026735 g54035 i0 54.8 0.466666666666667 42 19 46.7 0 263 138 77 118 MCP3678314.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 126 44.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
31030346 31030346 PRJNA685607_P_NODE_74715_length_248_cov_0.880000_g74356_i0 PRJNA685607 74715 248 0.88 2.1824 Kofleriaceae bacterium 2212474 Bacteria Bacteria 114 3.45e-27   NR HEX3763074.1 2212474 g74356 i0 65.9 0.991935483870968 82 27 98 1 246 4 97 178 HEX3763074.1 caspase family protein [Kofleriaceae bacterium] diamond 246 114 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
31852143 31852143 PRJNA685607_P_NODE_32937_length_320_cov_1.246964_g32578_i0 PRJNA685607 32937 320 1.246964 3.9902848 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 43.5 0.0448   NR HBZ68234.1 2026735 g32578 i0 35.6 0.684375 73 47 68.4 0 73 291 151 223 HBZ68234.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 219 43.5 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
31915514 31915514 PRJNA685607_P_NODE_95197_length_241_cov_0.916667_g94838_i0 PRJNA685607 95197 241 0.916667 2.20916747 Polyangiaceae bacterium 2268199 Bacteria Bacteria 86.7 1.11e-17   NR HSC85670.1 2268199 g94838 i0 77.4 0.771784232365145 62 14 77.2 0 56 241 256 317 HSC85670.1 AgmX/PglI C-terminal domain-containing protein [Polyangiaceae bacterium] diamond 186 86.7 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
32232206 32232206 PRJNA685607_P_NODE_10998_length_474_cov_1.364090_g10642_i0 PRJNA685607 10998 474 1.36409 6.4657866 Polyangiaceae bacterium 2268199 Bacteria Bacteria 194 1.78e-59   NR HVJ14519.1 2268199 g10642 i0 67.6 2.61392405063291 136 44 86.1 0 2 409 50 185 HVJ14519.1 hypothetical protein [Polyangiaceae bacterium] diamond 1239 194 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
32433614 32433614 PRJNA685607_P_NODE_76519_length_247_cov_0.885057_g76160_i0 PRJNA685607 76519 247 0.885057 2.18609079 Labilithrix 1524217 Bacteria Bacteria 138 2.98e-36   NR MDB4937222.1 1971228 g76160 i0 76.8 2.98785425101215 82 19 99.6 0 247 2 65 146 MDB4937222.1 hypothetical protein [Labilithrix sp.] diamond 738 139 0.992805755395683 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix sp.
32453717 32453717 PRJNA685607_P_NODE_74799_length_248_cov_0.880000_g74440_i0 PRJNA685607 74799 248 0.88 2.1824 Polyangiaceae bacterium 2268199 Bacteria Bacteria 51.2 6.16e-6   NR HEY3253337.1 2268199 g74440 i0 34.6 1.71774193548387 78 46 90.7 2 225 1 1 76 HEY3253337.1 hypothetical protein [Polyangiaceae bacterium] diamond 426 51.2 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae 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);;