RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJEB58983" 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

  • PRJEB58983 · 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
11603506 11603506 PRJEB58983_P_NODE_31770_length_243_cov_2.305882_g31355_i0 PRJEB58983 31770 243 2.305882 5.60329326 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 92.4 1.2e-19   NR MBI5069846.1 2026735 g31355 i0 80 2.7037037037037 55 11 67.9 0 2 166 685 739 MBI5069846.1 molybdopterin-dependent oxidoreductase [Deltaproteobacteria bacterium] diamond 657 92.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
20526019 20526019 PRJEB58983_P_NODE_32057_length_243_cov_0.917647_g31642_i0 PRJEB58983 32057 243 0.917647 2.22988221 Myxococcales bacterium 2026763 Bacteria Bacteria 137 8.35e-39   NR MBL8633872.1 2026763 g31642 i0 88.8 0.987654320987654 80 9 98.8 0 242 3 51 130 MBL8633872.1 50S ribosomal protein L6 [Myxococcales bacterium] diamond 240 137 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
26716660 26716660 PRJEB58983_P_NODE_27861_length_253_cov_1.316667_g27446_i0 PRJEB58983 27861 253 1.316667 3.33116751 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 47.8 7.15e-4   NR MDR1545405.1 2026735 g27446 i0 57.1 2.43083003952569 35 15 41.5 0 105 1 117 151 MDR1545405.1 HD domain-containing protein [Deltaproteobacteria bacterium] diamond 615 47.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
26963345 26963345 PRJEB58983_P_NODE_23682_length_271_cov_1.843434_g23267_i0 PRJEB58983 23682 271 1.843434 4.99570614 Bacteria 2 Bacteria Bacteria 100 7.56e-25   NR MBK7065129.1 2026735 g23267 i0 83.1 1.43911439114391 65 11 72 0 62 256 1 65 MBK7065129.1 50S ribosomal protein L22 [Deltaproteobacteria bacterium] diamond 390 100 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
27444737 27444737 PRJEB58983_P_NODE_33103_length_238_cov_2.078788_g32688_i0 PRJEB58983 33103 238 2.078788 4.94751544 Polyangia bacterium 3058050 Bacteria Bacteria 100 1.47e-22   NR HEY7372113.1 3058050 g32688 i0 64.6 2.18067226890756 79 28 99.6 0 1 237 357 435 HEY7372113.1 TROVE domain-containing protein [Polyangia bacterium] diamond 519 100 1 Bacteria   Pseudomonadati Myxococcota         Polyangia bacterium
27602494 27602494 PRJEB58983_P_NODE_4104_length_603_cov_2.579245_g3696_i0 PRJEB58983 4104 603 2.579245 15.55284735 Kofleriaceae bacterium 2212474 Bacteria Bacteria 135 3.0600000000000004e-36   NR MFT3692925.1 2212474 g3696 i0 69.5 0.407960199004975 82 25 40.8 0 246 1 6 87 MFT3692925.1 ATP phosphoribosyltransferase regulatory subunit [Kofleriaceae bacterium] diamond 246 135 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
28454986 28454986 PRJEB58983_P_NODE_19026_length_296_cov_1.600897_g18611_i0 PRJEB58983 19026 296 1.600897 4.73865512 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 44.7 0.0136   NR MBS1104581.1 2026735 g18611 i0 31.4 1.75337837837838 86 45 73 1 35 250 176 261 MBS1104581.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 519 44.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
28833667 28833667 PRJEB58983_P_NODE_29088_length_250_cov_0.881356_g28673_i0 PRJEB58983 29088 250 0.881356 2.20339 Kofleriaceae bacterium 2212474 Bacteria Bacteria 80.1 7.49e-17   NR MBZ0235193.1 2212474 g28673 i0 45.3 0.9 75 40 88.8 1 1 222 28 102 MBZ0235193.1 SGNH/GDSL hydrolase family protein [Kofleriaceae bacterium] diamond 225 80.1 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae   Kofleriaceae bacterium
28865226 28865226 PRJEB58983_P_NODE_28908_length_250_cov_1.593220_g28493_i0 PRJEB58983 28908 250 1.59322 3.98305 Polyangia bacterium 3058050 Bacteria Bacteria 43.1 0.0286   NR MEO6951768.1 3058050 g28493 i0 53.7 0.492 41 19 49.2 0 4 126 154 194 MEO6951768.1 enoyl-CoA hydratase/isomerase family protein [Polyangia bacterium] diamond 123 43.1 1 Bacteria   Pseudomonadati Myxococcota         Polyangia bacterium
29591085 29591085 PRJEB58983_P_NODE_10650_length_384_cov_2.379421_g10235_i0 PRJEB58983 10650 384 2.379421 9.13697664 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 132 4.93e-37   NR MRR55683.1 2026735 g10235 i0 58.9 0.8359375 107 43 83.6 1 22 342 1 106 MRR55683.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 321 132 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
29622567 29622567 PRJEB58983_P_NODE_19790_length_291_cov_1.830275_g19375_i0 PRJEB58983 19790 291 1.830275 5.32610025 Anaeromyxobacter sp. Fw1 1872521 Bacteria Bacteria 76.3 1.08e-13   NR WP_011985898.1 404589 g19375 i0 83 2.89690721649485 47 8 48.5 0 142 2 1 47 WP_011985898.1 NADP-dependent isocitrate dehydrogenase [Anaeromyxobacter sp. Fw109-5] diamond 843 76.3 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter sp. Fw109-5
30033718 30033718 PRJEB58983_P_NODE_25511_length_262_cov_3.317460_g25096_i0 PRJEB58983 25511 262 3.31746 8.6917452 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 70.1 4.16e-13   NR MBW2066955.1 2026735 g25096 i0 60.8 1.77480916030534 51 20 58.4 0 163 11 5 55 MBW2066955.1 response regulator [Deltaproteobacteria bacterium] diamond 465 70.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
30065082 30065082 PRJEB58983_P_NODE_25612_length_262_cov_1.650794_g25197_i0 PRJEB58983 25612 262 1.650794 4.32508028 Myxococcales bacterium 2026763 Bacteria Bacteria 87 1.24e-18   NR NJK90034.1 2026763 g25197 i0 67.2 1.3969465648855 61 20 69.8 0 190 8 4 64 NJK90034.1 PspA/IM30 family protein [Myxococcales bacterium] diamond 366 87 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
30318535 30318535 PRJEB58983_P_NODE_29512_length_249_cov_0.886364_g29097_i0 PRJEB58983 29512 249 0.886364 2.20704636 Polyangiales bacterium 3034171 Bacteria Bacteria 85.1 4.88e-17   NR MFO0651939.1 3034171 g29097 i0 68.5 0.650602409638554 54 17 65.1 0 163 2 972 1025 MFO0651939.1 protein kinase [Polyangiales bacterium] diamond 162 85.1 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales     Polyangiales bacterium
31195465 31195465 PRJEB58983_P_NODE_13235_length_348_cov_1.640000_g12820_i0 PRJEB58983 13235 348 1.64 5.7072 Myxococcia 32015 Bacteria Bacteria 131 8.929999999999999e-37   NR MBL8679130.1 2026763 g12820 i0 93.1 1.85344827586207 72 5 62.1 0 132 347 1 72 MBL8679130.1 50S ribosomal protein L14 [Myxococcales bacterium] diamond 645 131 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
31866701 31866701 PRJEB58983_P_NODE_30217_length_247_cov_1.362069_g29802_i0 PRJEB58983 30217 247 1.362069 3.36431043 Polyangiales bacterium 3034171 Bacteria Bacteria 81.3 2.06e-17   NR MFO0606323.1 3034171 g29802 i0 93 1.04453441295547 43 3 52.2 0 131 3 1 43 MFO0606323.1 50S ribosomal protein L11 [Polyangiales bacterium] diamond 258 81.3 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales     Polyangiales bacterium
32113306 32113306 PRJEB58983_P_NODE_8558_length_425_cov_1.548295_g8144_i0 PRJEB58983 8558 425 1.548295 6.58025375 Bacteria 2 Bacteria Bacteria 98.2 3.57e-21   NR MBI5971502.1 2026735 g8144 i0 42.4 5.59058823529412 125 71 88.2 1 375 1 163 286 MBI5971502.1 glycosyltransferase [Deltaproteobacteria bacterium] diamond 2376 99 0.991919191919192 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
32751917 32751917 PRJEB58983_P_NODE_4120_length_602_cov_2.703214_g3712_i0 PRJEB58983 4120 602 2.703214 16.27334828 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 90.9 7.57e-18   NR MBI2369604.1 2026735 g3712 i0 36.9 1.01162790697674 203 111 95.7 9 5 580 37 233 MBI2369604.1 class I SAM-dependent methyltransferase [Deltaproteobacteria bacterium] diamond 609 90.9 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);;