RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1198392" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1198392 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
6146596 6146596 PRJNA1198392_P_NODE_19865_length_244_cov_0.900585_g19724_i0 PRJNA1198392 19865 244 0.900585 2.1974274 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 178 7.46e-50   NR HEX8197776.1 2283092 g19724 i0 97.5 1.99180327868852 81 2 99.6 0 1 243 391 471 HEX8197776.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 486 178 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
12522444 12522444 PRJNA1198392_P_NODE_20590_length_242_cov_0.911243_g20449_i0 PRJNA1198392 20590 242 0.911243 2.20520806 Candidatus Sulfotelmatobacter sp. 2771375 Bacteria Bacteria 136 3.869999999999999e-37   NR HEX4783608.1 2771375 g20449 i0 85 2.96280991735537 80 12 99.2 0 241 2 202 281 HEX4783608.1 xanthine dehydrogenase family protein subunit M [Candidatus Sulfotelmatobacter sp.] diamond 717 136 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Candidatus Korobacteraceae Candidatus Sulfotelmatobacter Candidatus Sulfotelmatobacter sp.
13078170 13078170 PRJNA1198392_P_NODE_17411_length_248_cov_0.880000_g17270_i0 PRJNA1198392 17411 248 0.88 2.1824 Bacteria 2 Bacteria Bacteria 108 9.35e-26   NR HYK90489.1 1978231 g17270 i0 66.3 3.93145161290323 80 27 96.8 0 243 4 312 391 HYK90489.1 phosphoglycerate kinase [Acidobacteriota bacterium] diamond 975 109 0.990825688073395 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26787837 26787837 PRJNA1198392_P_NODE_11681_length_274_cov_1.532338_g11540_i0 PRJNA1198392 11681 274 1.532338 4.19860612 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 97.1 1.66e-21   NR MFT3743348.1 2283092 g11540 i0 59 3.64598540145985 83 34 90.9 0 25 273 1 83 MFT3743348.1 M20 family metallopeptidase [Pyrinomonadaceae bacterium] diamond 999 97.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
26914252 26914252 PRJNA1198392_P_NODE_21062_length_241_cov_1.523810_g20921_i0 PRJNA1198392 21062 241 1.52381 3.6723821 Acidobacteriota bacterium 1978231 Bacteria Bacteria 164 1.8299999999999998e-47   NR MDI9627488.1 1978231 g20921 i0 92.4 1.95435684647303 79 6 98.3 0 239 3 252 330 MDI9627488.1 sugar kinase [Acidobacteriota bacterium] diamond 471 164 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26914253 26914253 PRJNA1198392_P_NODE_7902_length_293_cov_1.722727_g7761_i0 PRJNA1198392 7902 293 1.722727 5.04759011 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 62.8 1.46e-9   NR HVE59804.1 2283092 g7761 i0 75 1.22866894197952 40 10 41 0 138 19 1 40 HVE59804.1 enoyl-CoA hydratase/isomerase family protein [Pyrinomonadaceae bacterium] diamond 360 62.8 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27009132 27009132 PRJNA1198392_P_NODE_8822_length_288_cov_1.153488_g8681_i0 PRJNA1198392 8822 288 1.153488 3.32204544 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 82 3.49e-16   NR HEX8736880.1 2283092 g8681 i0 55.2 1.34375 67 30 69.8 0 287 87 197 263 HEX8736880.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 387 82 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27672925 27672925 PRJNA1198392_P_NODE_17844_length_247_cov_1.770115_g17703_i0 PRJNA1198392 17844 247 1.770115 4.37218405 Acidobacteriota bacterium 1978231 Bacteria Bacteria 102 1.0099999999999999e-23   NR MEW6321406.1 1978231 g17703 i0 60.2 1.06882591093117 88 28 98.4 2 5 247 233 320 MEW6321406.1 serine hydrolase domain-containing protein [Acidobacteriota bacterium] diamond 264 102 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27849384 27849384 PRJNA1198392_P_NODE_17744_length_248_cov_0.880000_g17603_i0 PRJNA1198392 17744 248 0.88 2.1824 Bacteria 2 Bacteria Bacteria 92.8 2.22e-21   NR MBK8812984.1 1978231 g17603 i0 63.8 4.59677419354839 69 25 83.5 0 248 42 62 130 MBK8812984.1 PqqD family protein [Acidobacteriota bacterium] diamond 1140 92.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28070525 28070525 PRJNA1198392_P_NODE_20265_length_243_cov_0.905882_g20124_i0 PRJNA1198392 20265 243 0.905882 2.20129326 Bacteria 2 Bacteria Bacteria 98.6 2.65e-22   NR NWG14980.1 1978231 g20124 i0 60.5 3.79012345679012 76 30 93.8 0 231 4 160 235 NWG14980.1 hypothetical protein [Acidobacteriota bacterium] diamond 921 98.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28083131 28083131 PRJNA1198392_P_NODE_10465_length_280_cov_1.487923_g10324_i0 PRJNA1198392 10465 280 1.487923 4.1661844 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 98.6 1.95e-22   NR HEY0376946.1 2283092 g10324 i0 58 2.83928571428571 88 37 94.3 0 272 9 48 135 HEY0376946.1 NADP-dependent oxidoreductase [Pyrinomonadaceae bacterium] diamond 795 98.6 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29220057 29220057 PRJNA1198392_P_NODE_19009_length_245_cov_0.895349_g18868_i0 PRJNA1198392 19009 245 0.895349 2.19360505 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 106 1.17e-24   NR HEX8265742.1 2283092 g18868 i0 72.5 0.979591836734694 80 22 98 0 4 243 394 473 HEX8265742.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 240 106 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
30439196 30439196 PRJNA1198392_P_NODE_21333_length_241_cov_0.916667_g21192_i0 PRJNA1198392 21333 241 0.916667 2.20916747 Bacteria 2 Bacteria Bacteria 119 8.69e-32   NR MBW8827398.1 1978231 g21192 i0 77.2 5.88796680497925 79 18 98.3 0 239 3 17 95 MBW8827398.1 oligoribonuclease [Acidobacteriota bacterium] diamond 1419 119 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30988914 30988914 PRJNA1198392_P_NODE_8474_length_289_cov_1.425926_g8333_i0 PRJNA1198392 8474 289 1.425926 4.12092614 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 84.3 3.31e-19   NR HEX8636701.1 2283092 g8333 i0 88.6 0.456747404844291 44 5 45.7 0 156 287 1 44 HEX8636701.1 MM0924 family protein [Pyrinomonadaceae bacterium] diamond 132 84.3 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31052253 31052253 PRJNA1198392_P_NODE_16635_length_250_cov_0.870056_g16494_i0 PRJNA1198392 16635 250 0.870056 2.17514 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 83.6 1.75e-16   NR HEY0321330.1 2283092 g16494 i0 49.4 1.02 85 41 99.6 2 250 2 501 585 HEY0321330.1 ABC transporter permease [Pyrinomonadaceae bacterium] diamond 255 83.6 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31260550 31260550 PRJNA1198392_P_NODE_16555_length_250_cov_0.870056_g16414_i0 PRJNA1198392 16555 250 0.870056 2.17514 Bacteria 2 Bacteria Bacteria 159 9.55e-45   NR KXK00717.1 1617423 g16414 i0 91.6 9.96 83 7 99.6 0 2 250 161 243 KXK00717.1 MAG: excinuclease ABC subunit C [Acidobacteria bacterium OLB17] diamond 2490 159 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteria bacterium OLB17
31431326 31431326 PRJNA1198392_P_NODE_15776_length_251_cov_0.865169_g15635_i0 PRJNA1198392 15776 251 0.865169 2.17157419 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 55.8 5.47e-8   NR HYP08473.1 2212468 g15635 i0 55.6 1.64940239043825 54 24 64.5 0 89 250 1 54 HYP08473.1 hypothetical protein [Bryobacteraceae bacterium] diamond 414 55.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
31589710 31589710 PRJNA1198392_P_NODE_16556_length_250_cov_0.870056_g16415_i0 PRJNA1198392 16556 250 0.870056 2.17514 Acidobacteriota bacterium 1978231 Bacteria Bacteria 133 1.1199999999999999e-38   NR MDQ3129976.1 1978231 g16415 i0 93.8 3.12 65 4 78 0 250 56 13 77 MDQ3129976.1 sorbosone dehydrogenase family protein [Acidobacteriota bacterium] diamond 780 133 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31842394 31842394 PRJNA1198392_P_NODE_8577_length_289_cov_1.226852_g8436_i0 PRJNA1198392 8577 289 1.226852 3.54560228 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 91.3 5.25e-19   NR MCW5961948.1 2283092 g8436 i0 65.2 0.685121107266436 66 23 68.5 0 199 2 411 476 MCW5961948.1 methyltransferase regulatory domain-containing protein [Pyrinomonadaceae bacterium] diamond 198 91.3 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
32759190 32759190 PRJNA1198392_P_NODE_11680_length_274_cov_1.532338_g11539_i0 PRJNA1198392 11680 274 1.532338 4.19860612 Acidobacteriota bacterium 1978231 Bacteria Bacteria 130 5.92e-36   NR MBK6589609.1 1978231 g11539 i0 70.3 1.99270072992701 91 27 99.6 0 1 273 30 120 MBK6589609.1 BON domain-containing protein [Acidobacteriota bacterium] diamond 546 130 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota 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);;