RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1199330 · 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
6703501 6703501 PRJNA1199330_P_NODE_46286_length_312_cov_2.774059_g45587_i0 PRJNA1199330 46286 312 2.774059 8.65506408 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 159 7.169999999999998e-43   NR HEX7284048.1 2910147 g45587 i0 82.1 1.01923076923077 106 16 99 1 2 310 112 217 HEX7284048.1 protein kinase [Vicinamibacterales bacterium] diamond 318 159 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
26882886 26882886 PRJNA1199330_P_NODE_84501_length_268_cov_2.400000_g83802_i0 PRJNA1199330 84501 268 2.4 6.432 Acidobacteriota bacterium 1978231 Bacteria Bacteria 53.1 1.03e-5   NR PYR37461.1 1978231 g83802 i0 45.6 1.54477611940298 68 36 75 1 57 257 62 129 PYR37461.1 MAG: hypothetical protein DMF93_17920 [Acidobacteriota bacterium] diamond 414 53.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27091499 27091499 PRJNA1199330_P_NODE_75782_length_276_cov_2.758621_g75083_i0 PRJNA1199330 75782 276 2.758621 7.61379396 Pseudomonadati 3379134 Bacteria Bacteria 129 1.89e-32   NR MBK6751104.1 1978231 g75083 i0 68.1 13.8369565217391 91 29 98.9 0 275 3 245 335 MBK6751104.1 NADP-dependent isocitrate dehydrogenase [Acidobacteriota bacterium] diamond 3819 129 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27609715 27609715 PRJNA1199330_P_NODE_42604_length_315_cov_2.735537_g41905_i0 PRJNA1199330 42604 315 2.735537 8.61694155 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 43.9 0.0324   NR MEZ5308632.1 2283092 g41905 i0 50 0.380952380952381 40 19 38.1 1 191 310 327 365 MEZ5308632.1 5'-nucleotidase C-terminal domain-containing protein [Pyrinomonadaceae bacterium] diamond 120 43.9 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27786589 27786589 PRJNA1199330_P_NODE_73284_length_279_cov_1.184466_g72585_i0 PRJNA1199330 73284 279 1.184466 3.30466014 Acidobacteriota 57723 Bacteria Bacteria 49.7 1.93e-4   NR HVR98572.1 2651171 g72585 i0 40 2.45161290322581 70 39 75.3 1 275 66 122 188 HVR98572.1 acyl-CoA desaturase [Thermoanaerobaculia bacterium] diamond 684 50.1 0.992015968063872 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
27893676 27893676 PRJNA1199330_P_NODE_113405_length_244_cov_0.912281_g112706_i0 PRJNA1199330 113405 244 0.912281 2.22596564 Acidobacteriota bacterium 1978231 Bacteria Bacteria 133 2.54e-36   NR HIN12555.1 1978231 g112706 i0 75.3 8.92622950819672 81 20 99.6 0 2 244 159 239 HIN12555.1 type I methionyl aminopeptidase [Acidobacteriota bacterium] diamond 2178 133 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27988549 27988549 PRJNA1199330_P_NODE_104185_length_250_cov_2.310734_g103486_i0 PRJNA1199330 104185 250 2.310734 5.776835 Acidobacteriota bacterium 1978231 Bacteria Bacteria 139 2.95e-39   NR MEK7722962.1 1978231 g103486 i0 79.5 0.996 83 17 99.6 0 250 2 140 222 MEK7722962.1 dienelactone hydrolase family protein [Acidobacteriota bacterium] diamond 249 139 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28051672 28051672 PRJNA1199330_P_NODE_71025_length_281_cov_1.375000_g70326_i0 PRJNA1199330 71025 281 1.375 3.86375 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 79.7 2.33e-15   NR HEY4359039.1 2052142 g70326 i0 53 0.886120996441281 83 38 88.6 1 3 251 208 289 HEY4359039.1 SDR family oxidoreductase [Acidobacteriaceae bacterium] diamond 249 79.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
28304256 28304256 PRJNA1199330_P_NODE_69586_length_282_cov_1.818182_g68887_i0 PRJNA1199330 69586 282 1.818182 5.12727324 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 43.5 0.0305   NR HEX2454260.1 2910147 g68887 i0 34.1 2.37234042553191 82 46 83 2 3 236 283 360 HEX2454260.1 PQQ-binding-like beta-propeller repeat protein [Vicinamibacterales bacterium] diamond 669 43.5 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
29175830 29175830 PRJNA1199330_P_NODE_20729_length_449_cov_2.981383_g20035_i0 PRJNA1199330 20729 449 2.981383 13.38640967 root 1 Root_unresolved Root_unresolved 53.9 7.08e-6   NR MEO1088395.1 1978231 g20035 i0 52.2 2.67928730512249 46 22 30.7 0 13 150 43 88 MEO1088395.1 ankyrin repeat domain-containing protein [Acidobacteriota bacterium] diamond 1203 53.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29724803 29724803 PRJNA1199330_P_NODE_101510_length_252_cov_1.743017_g100811_i0 PRJNA1199330 101510 252 1.743017 4.39240284 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 144 4.41e-38   NR HNY42667.1 2212468 g100811 i0 83.3 1 84 14 100 0 1 252 437 520 HNY42667.1 hypothetical protein [Bryobacteraceae bacterium] diamond 252 144 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
30230497 30230497 PRJNA1199330_P_NODE_83372_length_269_cov_2.668367_g82673_i0 PRJNA1199330 83372 269 2.668367 7.17790723 Acidobacteriota bacterium 1978231 Bacteria Bacteria 71.6 2.51e-12   NR MBI4909958.1 1978231 g82673 i0 56.7 0.669144981412639 60 26 66.9 0 241 62 1 60 MBI4909958.1 hypothetical protein [Acidobacteriota bacterium] diamond 180 71.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30262376 30262376 PRJNA1199330_P_NODE_37892_length_336_cov_1.707224_g37193_i0 PRJNA1199330 37892 336 1.707224 5.73627264 Candidatus Acidiferrales bacterium 2952895 Bacteria Bacteria 102 1.29e-22   NR HJZ52343.1 2952895 g37193 i0 47.7 4.95535714285714 111 53 99.1 1 3 335 109 214 HJZ52343.1 cation:proton antiporter [Candidatus Acidiferrales bacterium] diamond 1665 102 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales     Candidatus Acidiferrales bacterium
30957424 30957424 PRJNA1199330_P_NODE_90514_length_262_cov_4.063492_g89815_i0 PRJNA1199330 90514 262 4.063492 10.64634904 Geothrix sp. 1962974 Bacteria Bacteria 98.2 5.64e-23   NR HJW43669.1 1962974 g89815 i0 55.8 2.97709923664122 86 28 98.5 1 262 5 109 184 HJW43669.1 alkylmercury lyase family protein [Geothrix sp.] diamond 780 98.2 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp.
31039620 31039620 PRJNA1199330_P_NODE_89115_length_264_cov_1.633508_g88416_i0 PRJNA1199330 89115 264 1.633508 4.31246112 Pseudomonadati 3379134 Bacteria Bacteria 151 1.6599999999999999e-40   NR MCI0391388.1 1978231 g88416 i0 84.1 3 88 14 100 0 1 264 72 159 MCI0391388.1 ABC transporter permease [Acidobacteriota bacterium] diamond 792 151 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31494796 31494796 PRJNA1199330_P_NODE_53936_length_298_cov_2.853333_g53237_i0 PRJNA1199330 53936 298 2.853333 8.50293234 Blastocatellia bacterium 2052146 Bacteria Bacteria 54.3 6.29e-6   NR HEU4387135.1 2052146 g53237 i0 38.6 0.704697986577181 70 39 70.5 1 5 214 682 747 HEU4387135.1 protein kinase [Blastocatellia bacterium] diamond 210 54.3 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
32285866 32285866 PRJNA1199330_P_NODE_117059_length_240_cov_3.203593_g116360_i0 PRJNA1199330 117059 240 3.203593 7.6886232 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 54.3 3.08e-6   NR HWQ52805.1 2212468 g116360 i0 64.9 0.4625 37 13 46.3 0 124 234 366 402 HWQ52805.1 metallophosphoesterase [Bryobacteraceae bacterium] diamond 111 54.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
32696145 32696145 PRJNA1199330_P_NODE_103200_length_251_cov_1.370787_g102501_i0 PRJNA1199330 103200 251 1.370787 3.44067537 Granulicella cerasi 741063 Bacteria Bacteria 48.5 3.65e-4   NR WP_263370631.1 741063 g102501 i0 42.9 0.752988047808765 63 33 71.7 2 49 228 14 76 WP_263370631.1 glycoside hydrolase family 28 protein [Granulicella cerasi] diamond 189 48.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella Granulicella cerasi
32759201 32759201 PRJNA1199330_P_NODE_113780_length_244_cov_0.912281_g113081_i0 PRJNA1199330 113780 244 0.912281 2.22596564 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 42.7 0.038   NR HMD47483.1 2212468 g113081 i0 46.5 0.528688524590164 43 21 52.9 1 211 83 385 425 HMD47483.1 protein kinase [Bryobacteraceae bacterium] diamond 129 42.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
32885035 32885035 PRJNA1199330_P_NODE_64880_length_286_cov_2.107981_g64181_i0 PRJNA1199330 64880 286 2.107981 6.02882566 Acidobacteriota bacterium 1978231 Bacteria Bacteria 45.4 0.00668   NR MBK6587034.1 1978231 g64181 i0 28 0.975524475524476 93 51 97.6 2 286 8 162 238 MBK6587034.1 caspase family protein [Acidobacteriota bacterium] diamond 279 45.4 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);;