RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA289590" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA289590 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
26789440 26789440 PRJNA289590_P_NODE_21081_length_193_cov_1.437500_g20857_i0 PRJNA289590 21081 193 1.4375 2.774375 Polyangiaceae bacterium 2268199 Bacteria Bacteria 73.6 2.55e-13   NR MFO0553643.1 2268199 g20857 i0 55.2 1.80310880829016 67 24 94.8 1 188 6 1 67 MFO0553643.1 DUF5682 family protein [Polyangiaceae bacterium] diamond 348 73.6 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
27217977 27217977 PRJNA289590_P_NODE_28522_length_166_cov_0.888889_g28298_i0 PRJNA289590 28522 166 0.888889 1.47555574 Pseudomonadati 3379134 Bacteria Bacteria 50.8 1.85e-5   NR MBJ6766071.1 2799617 g28298 i0 42.9 5.1144578313253 56 31 99.4 1 2 166 272 327 MBJ6766071.1 glycoside hydrolase family 2 protein [Myxococcaceae bacterium JPH2] diamond 849 50.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae   Myxococcaceae bacterium JPH2
27232183 27232183 PRJNA289590_P_NODE_24343_length_176_cov_1.944882_g24119_i0 PRJNA289590 24343 176 1.944882 3.42299232 Myxococcales bacterium 2026763 Bacteria Bacteria 92.4 3.33e-20   NR MBK6460194.1 2026763 g24119 i0 84.2 0.971590909090909 57 9 97.2 0 3 173 173 229 MBK6460194.1 hypothetical protein [Myxococcales bacterium] diamond 171 92.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
27295427 27295427 PRJNA289590_P_NODE_19883_length_200_cov_1.370861_g19659_i0 PRJNA289590 19883 200 1.370861 2.741722 Polyangiaceae bacterium 2268199 Bacteria Bacteria 40.8 0.0138   NR HMJ14861.1 2268199 g19659 i0 41.9 0.645 43 25 64.5 0 143 15 9 51 HMJ14861.1 hypothetical protein [Polyangiaceae bacterium] diamond 129 40.8 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
27548067 27548067 PRJNA289590_P_NODE_26684_length_168_cov_0.873950_g26460_i0 PRJNA289590 26684 168 0.87395 1.468236 Myxococcales bacterium 2026763 Bacteria Bacteria 113 2.6e-28   NR MBK6462806.1 2026763 g26460 i0 98.1 0.964285714285714 54 1 96.4 0 166 5 199 252 MBK6462806.1 DUF362 domain-containing protein [Myxococcales bacterium] diamond 162 113 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
27611394 27611394 PRJNA289590_P_NODE_9184_length_308_cov_1.498069_g8960_i0 PRJNA289590 9184 308 1.498069 4.61405252 Kofleriaceae bacterium 2212474 Bacteria Bacteria 61.2 2.61e-8   NR HEU5055814.1 2212474 g8960 i0 39.1 1.80194805194805 92 51 85.7 2 37 300 759 849 HEU5055814.1 lantibiotic dehydratase [Kofleriaceae bacterium] diamond 555 61.2 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
28527119 28527119 PRJNA289590_P_NODE_24707_length_174_cov_2.488000_g24483_i0 PRJNA289590 24707 174 2.488 4.32912 Polyangiaceae bacterium 2268199 Bacteria Bacteria 62.4 7.67e-10   NR MEZ4306422.1 2268199 g24483 i0 76.2 1.44827586206897 42 10 72.4 0 43 168 152 193 MEZ4306422.1 DUF6756 family protein [Polyangiaceae bacterium] diamond 252 62.4 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
28779342 28779342 PRJNA289590_P_NODE_10387_length_286_cov_1.793249_g10163_i0 PRJNA289590 10387 286 1.793249 5.12869214 Myxococcota bacterium 2818507 Bacteria Bacteria 51.2 2.9e-5   NR MEZ0314752.1 2818507 g10163 i0 37.3 0.870629370629371 83 49 86 2 282 37 98 178 MEZ0314752.1 hypothetical protein [Myxococcota bacterium] diamond 249 51.2 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
29252866 29252866 PRJNA289590_P_NODE_28229_length_166_cov_0.888889_g28005_i0 PRJNA289590 28229 166 0.888889 1.47555574 Polyangiaceae bacterium 2268199 Bacteria Bacteria 54.3 9.85e-7   NR MFO0553299.1 2268199 g28005 i0 50 3.25301204819277 48 24 86.7 0 159 16 239 286 MFO0553299.1 hypothetical protein [Polyangiaceae bacterium] diamond 540 54.3 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
29316231 29316231 PRJNA289590_P_NODE_13109_length_252_cov_1.024631_g12885_i0 PRJNA289590 13109 252 1.024631 2.58207012 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 42.7 0.04   NR MBI5298705.1 2026735 g12885 i0 29.9 0.916666666666667 77 50 91.7 1 12 242 170 242 MBI5298705.1 ATP-binding protein [Deltaproteobacteria bacterium] diamond 231 42.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
29789719 29789719 PRJNA289590_P_NODE_26271_length_169_cov_0.866667_g26047_i0 PRJNA289590 26271 169 0.866667 1.46466723 Myxococcales bacterium 2026763 Bacteria Bacteria 86.7 3.83e-18   NR MBL9111418.1 2026763 g26047 i0 75.9 0.958579881656805 54 13 95.9 0 3 164 166 219 MBL9111418.1 hypothetical protein [Myxococcales bacterium] diamond 162 86.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
29789728 29789728 PRJNA289590_P_NODE_31151_length_162_cov_0.920354_g30927_i0 PRJNA289590 31151 162 0.920354 1.49097348 Polyangiaceae bacterium 2268199 Bacteria Bacteria 57.8 5.93e-8   NR HRH00149.1 2268199 g30927 i0 61.5 0.962962962962963 52 15 88.9 3 160 17 51 101 HRH00149.1 hypothetical protein [Polyangiaceae bacterium] diamond 156 57.8 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
29934024 29934024 PRJNA289590_P_NODE_18851_length_206_cov_1.324841_g18627_i0 PRJNA289590 18851 206 1.324841 2.72917246 Pseudomonadati 3379134 Bacteria Bacteria 84.3 1.59e-17   NR WP_245767557.1 83460 g18627 i0 52.2 2.9126213592233 67 32 97.6 0 5 205 49 115 WP_245767557.1 M1 family aminopeptidase [Stigmatella erecta] diamond 600 85.1 0.990599294947121 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Stigmatella Stigmatella erecta
30218110 30218110 PRJNA289590_P_NODE_30512_length_163_cov_0.912281_g30288_i0 PRJNA289590 30512 163 0.912281 1.48701803 Pseudomonadati 3379134 Bacteria Bacteria 70.1 1.63e-13   NR MBN2428426.1 2026735 g30288 i0 57.4 3.97546012269939 54 23 99.4 0 163 2 60 113 MBN2428426.1 cupin domain-containing protein [Deltaproteobacteria bacterium] diamond 648 70.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
30422107 30422107 PRJNA289590_P_NODE_24553_length_175_cov_1.626984_g24329_i0 PRJNA289590 24553 175 1.626984 2.847222 Myxococcales bacterium 2026763 Bacteria Bacteria 93.2 1.9499999999999994e-23   NR MBK8218612.1 2026763 g24329 i0 92.2 0.874285714285714 51 4 87.4 0 174 22 12 62 MBK8218612.1 50S ribosomal protein L30 [Myxococcales bacterium] diamond 153 93.2 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
31622729 31622729 PRJNA289590_P_NODE_10576_length_283_cov_2.179487_g10352_i0 PRJNA289590 10576 283 2.179487 6.16794821 Sorangium cellulosum 56 Bacteria Bacteria 134 1.31e-38   NR WP_012233780.1 56 g10352 i0 73.8 1.78091872791519 84 22 89 0 252 1 1 84 WP_012233780.1 barstar family protein [Sorangium cellulosum] diamond 504 134 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum
31717683 31717683 PRJNA289590_P_NODE_27017_length_168_cov_0.873950_g26793_i0 PRJNA289590 27017 168 0.87395 1.468236 Polyangiaceae bacterium 2268199 Bacteria Bacteria 81.3 3.22e-16   NR NOU31624.1 2268199 g26793 i0 78 0.892857142857143 50 9 85.7 1 25 168 20 69 NOU31624.1 porin [Polyangiaceae bacterium] diamond 150 81.3 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
31844077 31844077 PRJNA289590_P_NODE_27417_length_167_cov_0.881356_g27193_i0 PRJNA289590 27417 167 0.881356 1.47186452 Myxococcales bacterium 2026763 Bacteria Bacteria 57.4 9.06e-8   NR MBK8219028.1 2026763 g27193 i0 50.8 2.06586826347305 61 23 97 2 2 163 1409 1469 MBK8219028.1 hypothetical protein [Myxococcales bacterium] diamond 345 57.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
32002417 32002417 PRJNA289590_P_NODE_29278_length_165_cov_0.896552_g29054_i0 PRJNA289590 29278 165 0.896552 1.4793108 Pyxidicoccus sp. MSG2 2996790 Bacteria Bacteria 77.8 5.84e-15   NR WP_267862871.1 2996790 g29054 i0 71.7 5.78181818181818 53 15 96.4 0 1 159 1412 1464 WP_267862871.1 non-ribosomal peptide synthetase [Pyxidicoccus sp. MSG2] diamond 954 77.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Pyxidicoccus Pyxidicoccus sp. MSG2
32178442 32178442 PRJNA289590_P_NODE_4878_length_451_cov_1.838308_g4656_i0 PRJNA289590 4878 451 1.838308 8.29076908 Pseudomonadati 3379134 Bacteria Bacteria 73.9 4.48e-12   NR TMB44294.1 2026735 g4656 i0 36.8 3.4390243902439 125 79 83.1 0 6 380 631 755 TMB44294.1 MAG: tetratricopeptide repeat protein [Deltaproteobacteria bacterium] diamond 1551 73.9 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
32540532 32540532 PRJNA289590_P_NODE_24779_length_174_cov_1.584000_g24555_i0 PRJNA289590 24779 174 1.584 2.75616 Pyxidicoccus sp. MSG2 2996790 Bacteria Bacteria 58.9 2.84e-8   NR WP_267862874.1 2996790 g24555 i0 52.8 0.913793103448276 53 25 91.4 0 172 14 1506 1558 WP_267862874.1 non-ribosomal peptide synthase/polyketide synthase [Pyxidicoccus sp. MSG2] diamond 159 58.9 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Pyxidicoccus Pyxidicoccus sp. MSG2

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