RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA222400", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 23 ✖

tax_phylum 1

  • Acidobacteriota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA222400 · 23 ✖

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
7434437 7434437 PRJNA222400_P_NODE_8286_length_165_cov_1.344828_g8253_i0 PRJNA222400 8286 165 1.344828 2.2189662 Luteitalea 2004797 Bacteria Bacteria 300 4.46e-77   NTclustered gi|1016914409|gb|CP015136.1| 1855912 g8253 i0 99.394 153.884848484848 165 1 100 0 1 165 654403 654239 Luteitalea pratensis strain DSM 100886 chromosome, complete genome blastn 25391 300 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae Luteitalea Luteitalea pratensis
13120970 13120970 PRJNA222400_P_NODE_151_length_1194_cov_3.517031_g136_i0 PRJNA222400 151 1194 3.517031 41.99335014 Acidobacteriota bacterium 1978231 Bacteria Bacteria 311 2.8199999999999993e-96   NR MCB1054384.1 1978231 g136 i0 45.9 0.974874371859296 388 195 95.5 8 8 1147 67 447 MCB1054384.1 M4 family metallopeptidase [Acidobacteriota bacterium] diamond 1164 311 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
16358947 16358947 PRJNA222400_P_NODE_8573_length_164_cov_1.782609_g8540_i0 PRJNA222400 8573 164 1.782609 2.92347876 Vicinamibacteria bacterium 2793154 Bacteria Bacteria 82 9.07e-17   NR HEX6737292.1 2793154 g8540 i0 72.2 5.92682926829268 54 15 98.8 0 162 1 140 193 HEX6737292.1 isocitrate dehydrogenase (NAD(+)) [Vicinamibacteria bacterium] diamond 972 82 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria       Vicinamibacteria bacterium
18218879 18218879 PRJNA222400_P_NODE_5375_length_193_cov_1.326389_g5342_i0 PRJNA222400 5375 193 1.326389 2.55993077 Pseudomonadati 3379134 Bacteria Bacteria 127 1.04e-35   NR NLV31801.1 1978231 g5342 i0 90.5 9.79274611398964 63 6 97.9 0 3 191 73 135 NLV31801.1 peptidylprolyl isomerase [Acidobacteriota bacterium] diamond 1890 127 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
19493180 19493180 PRJNA222400_P_NODE_4976_length_200_cov_1.033113_g4943_i0 PRJNA222400 4976 200 1.033113 2.066226 Vicinamibacteria bacterium 2793154 Bacteria Bacteria 111 2.83e-20   NTclustered gi|2626216371|emb|OY821641.1| 2793154 g4943 i0 83.333 3.29 120 20 60 0 17 136 189416 189535 MAG: Vicinamibacteria bacterium isolate 8cd05730-cbc4-4aa5-8344-af9f7d824ee9 genome assembly, chromosome: 1 blastn 658 111 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria       Vicinamibacteria bacterium
22043739 22043739 PRJNA222400_P_NODE_118_length_1279_cov_1.872358_g104_i0 PRJNA222400 118 1279 1.872358 23.94745882 Acidobacteriota bacterium 1978231 Bacteria Bacteria 77.8 3.85e-11   NR PYP99840.1 1978231 g104 i0 32.3 0.910086004691165 198 110 44.6 5 1278 709 209 390 PYP99840.1 MAG: hypothetical protein DMF83_29675, partial [Acidobacteriota bacterium] diamond 1164 77.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26820985 26820985 PRJNA222400_P_NODE_421_length_771_cov_2.642659_g394_i0 PRJNA222400 421 771 2.642659 20.37490089 Acidobacteriota bacterium 1978231 Bacteria Bacteria 67.4 1.35e-8   NR MCX6594231.1 1978231 g394 i0 33.6 0.428015564202335 110 67 42.8 2 416 745 3593 3696 MCX6594231.1 putative Ig domain-containing protein [Acidobacteriota bacterium] diamond 330 67.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27597413 27597413 PRJNA222400_P_NODE_424_length_769_cov_2.405556_g397_i0 PRJNA222400 424 769 2.405556 18.49872564 Pseudomonadati 3379134 Bacteria Bacteria 322 1.58e-105   NR MBX3297142.1 1978231 g397 i0 63.2 11.9960988296489 261 86 99.9 2 2 769 135 390 MBX3297142.1 acetyl-CoA hydrolase/transferase family protein [Acidobacteriota bacterium] diamond 9225 325 0.990769230769231 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28179157 28179157 PRJNA222400_P_NODE_8626_length_164_cov_1.347826_g8593_i0 PRJNA222400 8626 164 1.347826 2.21043464 Candidatus Sulfopaludibacter sp. SbA3 2043164 Bacteria Bacteria 46.6 5.61e-4   NR SPE30972.1 2043164 g8593 i0 47.2 2.90853658536585 53 27 97 1 4 162 262 313 SPE30972.1 putative NHL repeat containing protein [Candidatus Sulfopaludibacter sp. SbA3] diamond 477 46.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Solibacteraceae Candidatus Sulfopaludibacter Candidatus Sulfopaludibacter sp. SbA3
28400435 28400435 PRJNA222400_P_NODE_3546_length_240_cov_2.293194_g3513_i0 PRJNA222400 3546 240 2.293194 5.5036656 Alloacidobacterium dinghuense 2763107 Bacteria Bacteria 43.9 0.0136   NR WP_186743498.1 2763107 g3513 i0 36.3 1 80 46 95 3 236 9 184 262 WP_186743498.1 phosphate ABC transporter substrate-binding protein PstS [Alloacidobacterium dinghuense] diamond 240 43.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Alloacidobacterium Alloacidobacterium dinghuense
28495300 28495300 PRJNA222400_P_NODE_6767_length_173_cov_1.177419_g6734_i0 PRJNA222400 6767 173 1.177419 2.03693487 Terriglobia bacterium 2081523 Bacteria Bacteria 50.1 3.82e-5   NR PWT99085.1 2081523 g6734 i0 45.5 4.61271676300578 55 30 95.4 0 173 9 221 275 PWT99085.1 MAG: hypothetical protein C5B51_27925, partial [Terriglobia bacterium] diamond 798 50.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
28779184 28779184 PRJNA222400_P_NODE_2067_length_348_cov_1.969900_g2034_i0 PRJNA222400 2067 348 1.9699 6.855252 Thermoanaerobaculaceae bacterium 2699758 Bacteria Bacteria 50.4 2.5e-4   NR NWG00545.1 2699758 g2034 i0 43.5 0.53448275862069 62 34 52.6 1 2 184 42 103 NWG00545.1 hypothetical protein [Thermoanaerobaculaceae bacterium] diamond 186 50.4 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia Thermoanaerobaculales Thermoanaerobaculaceae   Thermoanaerobaculaceae bacterium
29599987 29599987 PRJNA222400_P_NODE_7070_length_169_cov_1.733333_g7037_i0 PRJNA222400 7070 169 1.733333 2.92933277 Acidobacteriota bacterium 1978231 Bacteria Bacteria 64.7 2.15e-10   NR MCC6824751.1 1978231 g7037 i0 58.9 0.994082840236686 56 20 99.4 1 169 2 204 256 MCC6824751.1 NAD-dependent epimerase/dehydratase family protein [Acidobacteriota bacterium] diamond 168 64.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29789535 29789535 PRJNA222400_P_NODE_5731_length_187_cov_1.884058_g5698_i0 PRJNA222400 5731 187 1.884058 3.52318846 Kocuria sp. cx-455 2771377 Bacteria Bacteria 57 1.65e-7   NR WP_190806500.1 2771377 g5698 i0 54.2 0.770053475935829 48 22 77 0 144 1 342 389 WP_190806500.1 amidohydrolase [Kocuria sp. cx-455] diamond 144 57 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Candidatus Korobacteraceae Candidatus Sulfotelmatobacter Kocuria sp. cx-455
30990398 30990398 PRJNA222400_P_NODE_1534_length_413_cov_3.274725_g1501_i0 PRJNA222400 1534 413 3.274725 13.52461425 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 127 2.91e-31   NR HZH34458.1 2283092 g1501 i0 58.4 1.87409200968523 125 52 90.8 0 6 380 130 254 HZH34458.1 DUF4394 domain-containing protein [Pyrinomonadaceae bacterium] diamond 774 127 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31228970 31228970 PRJNA222400_P_NODE_1315_length_452_cov_1.486352_g1282_i0 PRJNA222400 1315 452 1.486352 6.71831104 Pseudomonadati 3379134 Bacteria Bacteria 155 2.840000000000001e-44   NR MBI4915198.1 1978231 g1282 i0 61.3 18.8893805309735 124 47 82.3 1 424 53 112 234 MBI4915198.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Acidobacteriota bacterium] diamond 8538 156 0.993589743589744 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31242969 31242969 PRJNA222400_P_NODE_1795_length_380_cov_2.105740_g1762_i0 PRJNA222400 1795 380 2.10574 8.001812 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 60.5 9.74e-8   NR HYG63891.1 2651171 g1762 i0 34.6 0.615789473684211 78 51 61.6 0 360 127 319 396 HYG63891.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 234 60.5 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
31812391 31812391 PRJNA222400_P_NODE_4477_length_210_cov_1.068323_g4444_i0 PRJNA222400 4477 210 1.068323 2.2434783 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 48.5 2.16e-4   NR HSG40566.1 2651171 g4444 i0 42.2 1.6 64 37 91.4 0 18 209 210 273 HSG40566.1 Calx-beta domain-containing protein [Thermoanaerobaculia bacterium] diamond 336 48.5 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
31938788 31938788 PRJNA222400_P_NODE_6057_length_182_cov_1.796992_g6024_i0 PRJNA222400 6057 182 1.796992 3.27052544 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 89.7 5.480000000000001e-21   NR HKB79268.1 2651171 g6024 i0 69.1 1.82967032967033 55 17 90.7 0 177 13 96 150 HKB79268.1 GNAT family N-acetyltransferase [Thermoanaerobaculia bacterium] diamond 333 89.7 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
32033889 32033889 PRJNA222400_P_NODE_7678_length_167_cov_1.322034_g7645_i0 PRJNA222400 7678 167 1.322034 2.20779678 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 58.9 1.18e-8   NR HEY7862427.1 2651171 g7645 i0 58 0.898203592814371 50 21 89.8 0 152 3 37 86 HEY7862427.1 ERAP1-like C-terminal domain-containing protein [Thermoanaerobaculia bacterium] diamond 150 58.9 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
32223785 32223785 PRJNA222400_P_NODE_2318_length_324_cov_1.945455_g2285_i0 PRJNA222400 2318 324 1.945455 6.3032742 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 53.1 1.16e-5   NR HJU55860.1 2283092 g2285 i0 43.5 3.17592592592593 62 35 57.4 0 45 230 132 193 HJU55860.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 1029 53.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
32697529 32697529 PRJNA222400_P_NODE_1620_length_401_cov_1.164773_g1587_i0 PRJNA222400 1620 401 1.164773 4.67073973 Vicinamibacteria bacterium 2793154 Bacteria Bacteria 172 2.7499999999999996e-48   NR HVO09514.1 2793154 g1587 i0 62.4 1.99002493765586 133 50 99.5 0 400 2 341 473 HVO09514.1 aldehyde dehydrogenase family protein [Vicinamibacteria bacterium] diamond 798 172 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria       Vicinamibacteria bacterium
32697535 32697535 PRJNA222400_P_NODE_4340_length_213_cov_1.402439_g4307_i0 PRJNA222400 4340 213 1.402439 2.98719507 Acidobacteriota bacterium 1978231 Bacteria Bacteria 89 1.67e-19   NR MBI4891212.1 1978231 g4307 i0 66.7 4.91549295774648 69 23 97.2 0 4 210 15 83 MBI4891212.1 glucose 1-dehydrogenase [Acidobacteriota bacterium] diamond 1047 89 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);;