RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA615175" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA615175 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
3145720 3145720 PRJNA615175_P_NODE_19063_length_319_cov_1.735772_g18895_i0 PRJNA615175 19063 319 1.735772 5.53711268 Acidobacteriota bacterium 1978231 Bacteria Bacteria 129 4.11e-36   NR MBX3295696.1 1978231 g18895 i0 100 0.630094043887147 67 0 63 0 119 319 1 67 MBX3295696.1 hypothetical protein [Acidobacteriota bacterium] diamond 201 129 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
18446883 18446883 PRJNA615175_P_NODE_2075_length_1062_cov_2.048534_g1960_i0 PRJNA615175 2075 1062 2.048534 21.75543108 Kocuria sp. cx-455 2771377 Bacteria Bacteria 448 7.789999999999997e-152   NR WP_190807958.1 2771377 g1960 i0 93.3 1.35593220338983 240 16 67.8 0 722 3 1 240 WP_190807958.1 thiamine pyrophosphate-dependent enzyme [Kocuria sp. cx-455] diamond 1440 448 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Candidatus Korobacteraceae Candidatus Sulfotelmatobacter Kocuria sp. cx-455
26649958 26649958 PRJNA615175_P_NODE_18601_length_323_cov_3.576000_g18433_i0 PRJNA615175 18601 323 3.576 11.55048 Pseudomonadati 3379134 Bacteria Bacteria 92.8 1.21e-21   NR MCU1327581.1 2026791 g18433 i0 42.5 5.03405572755418 106 58 98.5 1 1 318 23 125 MCU1327581.1 metallothiol transferase FosB [Bryobacterales bacterium] diamond 1626 93.2 0.995708154506438 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
26795532 26795532 PRJNA615175_P_NODE_6801_length_582_cov_2.214145_g6636_i0 PRJNA615175 6801 582 2.214145 12.8863239 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 195 6.190000000000001e-59   NR MCS6875194.1 2283092 g6636 i0 54.3 3.86082474226804 188 80 96.9 4 574 11 68 249 MCS6875194.1 SDR family oxidoreductase [Pyrinomonadaceae bacterium] diamond 2247 195 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27187974 27187974 PRJNA615175_P_NODE_3122_length_879_cov_5.746898_g2983_i0 PRJNA615175 3122 879 5.746898 50.51523342 Pseudomonadati 3379134 Bacteria Bacteria 107 2.5299999999999998e-24   NR PYP99988.1 1978231 g2983 i0 35.8 3.33105802047782 190 103 64.5 6 570 4 3 174 PYP99988.1 MAG: hypothetical protein DMF82_23275 [Acidobacteriota bacterium] diamond 2928 107 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27409569 27409569 PRJNA615175_P_NODE_12723_length_400_cov_4.449541_g12555_i0 PRJNA615175 12723 400 4.449541 17.798164 Bacteria 2 Bacteria Bacteria 135 7.509999999999998e-35   NR HWQ32090.1 2052146 g12555 i0 53.8 3.9 130 48 96.8 3 399 13 315 433 HWQ32090.1 erythromycin esterase family protein [Blastocatellia bacterium] diamond 1560 135 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
28027969 28027969 PRJNA615175_P_NODE_5885_length_630_cov_3.700180_g5720_i0 PRJNA615175 5885 630 3.70018 23.311134 Acidobacteriota bacterium 1978231 Bacteria Bacteria 124 2.5899999999999997e-31   NR MBS1850274.1 1978231 g5720 i0 44.1 0.647619047619048 136 71 62.4 2 89 481 77 212 MBS1850274.1 redoxin domain-containing protein [Acidobacteriota bacterium] diamond 408 124 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28154369 28154369 PRJNA615175_P_NODE_8105_length_526_cov_3.359823_g7938_i0 PRJNA615175 8105 526 3.359823 17.67266898 Acidobacteriota bacterium 1978231 Bacteria Bacteria 92.8 5.41e-20   NR MEM9293737.1 1978231 g7938 i0 59.2 0.404942965779468 71 28 40.5 1 3 215 119 188 MEM9293737.1 DUF2147 domain-containing protein [Acidobacteriota bacterium] diamond 213 92.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28438463 28438463 PRJNA615175_P_NODE_18066_length_329_cov_1.203125_g17898_i0 PRJNA615175 18066 329 1.203125 3.95828125 Acidobacteriota bacterium 1978231 Bacteria Bacteria 132 1.36e-36   NR RMG49287.1 1978231 g17898 i0 59.6 0.90273556231003 99 40 90.3 0 27 323 57 155 RMG49287.1 MAG: macro domain-containing protein [Acidobacteriota bacterium] diamond 297 132 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28438475 28438475 PRJNA615175_P_NODE_5486_length_654_cov_4.139415_g5322_i0 PRJNA615175 5486 654 4.139415 27.0717741 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 75.9 7.81e-13   NR HEY3837658.1 2212468 g5322 i0 40.3 0.591743119266055 129 64 59.2 2 3 389 100 215 HEY3837658.1 ferritin-like domain-containing protein [Bryobacteraceae bacterium] diamond 387 75.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
28691109 28691109 PRJNA615175_P_NODE_21487_length_298_cov_1.364444_g21319_i0 PRJNA615175 21487 298 1.364444 4.06604312 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 43.9 0.0153   NR MBC7929417.1 2283092 g21319 i0 43.1 0.583892617449664 58 24 51.3 2 237 85 16 71 MBC7929417.1 guanylate kinase [Pyrinomonadaceae bacterium] diamond 174 43.9 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29196248 29196248 PRJNA615175_P_NODE_23189_length_285_cov_1.075472_g23021_i0 PRJNA615175 23189 285 1.075472 3.0650952 Acidobacteriota bacterium 1978231 Bacteria Bacteria 102 3.2199999999999993e-24   NR MBM3761417.1 1978231 g23021 i0 78.2 0.578947368421053 55 12 57.9 0 121 285 1 55 MBM3761417.1 metallophosphoesterase family protein [Acidobacteriota bacterium] diamond 165 102 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30238292 30238292 PRJNA615175_P_NODE_4872_length_700_cov_3.258373_g4711_i0 PRJNA615175 4872 700 3.258373 22.808611 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 433 1.06e-149   NR HET7112237.1 2283092 g4711 i0 94 3.99428571428571 233 14 99.9 0 1 699 168 400 HET7112237.1 PEP/pyruvate-binding domain-containing protein [Pyrinomonadaceae bacterium] diamond 2796 433 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
30333530 30333530 PRJNA615175_P_NODE_13752_length_383_cov_2.483871_g13584_i0 PRJNA615175 13752 383 2.483871 9.51322593 Bryobacterales bacterium 2026791 Bacteria Bacteria 45.1 0.0263   NR MCC6862739.1 2026791 g13584 i0 57.1 0.274151436031332 35 13 27.4 1 77 181 700 732 MCC6862739.1 hypothetical protein [Bryobacterales bacterium] diamond 105 45.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
30680421 30680421 PRJNA615175_P_NODE_35153_length_241_cov_0.916667_g34985_i0 PRJNA615175 35153 241 0.916667 2.20916747 Blastocatellia bacterium 2052146 Bacteria Bacteria 42.4 0.0475   NR HZS03824.1 2052146 g34985 i0 35.9 0.796680497925311 64 32 68.5 1 45 209 14 77 HZS03824.1 ATP-binding protein [Blastocatellia bacterium] diamond 192 42.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
31976850 31976850 PRJNA615175_P_NODE_11838_length_419_cov_2.936416_g11670_i0 PRJNA615175 11838 419 2.936416 12.30358304 Acidobacteriota bacterium 1978231 Bacteria Bacteria 44.3 0.0153   NR MCI0391690.1 1978231 g11670 i0 31.1 2.7708830548926 106 65 74.5 4 356 45 5 104 MCI0391690.1 hypothetical protein [Acidobacteriota bacterium] diamond 1161 44.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32451778 32451778 PRJNA615175_P_NODE_11579_length_425_cov_1.940341_g11411_i0 PRJNA615175 11579 425 1.940341 8.24644925 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 164 1.9799999999999994e-48   NR HZH34446.1 2283092 g11411 i0 62 5.95058823529412 142 53 99.5 1 1 423 4 145 HZH34446.1 HD domain-containing protein [Pyrinomonadaceae bacterium] diamond 2529 164 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae 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);;