RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJEB11523", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 20 ✖

tax_phylum 1

  • Acidobacteriota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJEB11523 · 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
1288024 1288024 PRJEB11523_P_NODE_5482_length_198_cov_21.644295_g5404_i0 PRJEB11523 5482 198 21.644295 42.8557041 Paludibaculum fermentans 1473598 Bacteria Bacteria 150 5.919999999999999e-32   NTclustered gi|1929489624|gb|CP063849.1| 1473598 g5404 i0 82.486 8.91414141414141 177 25 87 4 26 198 4786264 4786090 Paludibaculum fermentans strain P105 chromosome, complete genome blastn 1765 150 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
7665994 7665994 PRJEB11523_P_NODE_6547_length_180_cov_1.557252_g6469_i0 PRJEB11523 6547 180 1.557252 2.8030536 Acidobacteriota bacterium 1978231 Bacteria Bacteria 211 2.38e-50   NTclustered gi|1958093598|gb|CP065003.1| 1978231 g6469 i0 90.625 26.8666666666667 160 14 88 1 1 159 317455 317296 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome blastn 4836 211 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
8940762 8940762 PRJEB11523_P_NODE_6928_length_174_cov_3.240000_g6850_i0 PRJEB11523 6928 174 3.24 5.6376 Acidobacteriota bacterium 1978231 Bacteria Bacteria 255 1.04e-63   NTclustered gi|1958098837|gb|CP065005.1| 1978231 g6850 i0 93.605 232.201149425287 172 10 98 1 1 171 4649474 4649303 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome blastn 40403 255 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
12767299 12767299 PRJEB11523_P_NODE_5511_length_198_cov_2.348993_g5433_i0 PRJEB11523 5511 198 2.348993 4.65100614 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 117 6e-22   NTclustered gi|2874254056|emb|OY970380.1| 2651171 g5433 i0 82.222 2.74747474747475 135 24 68 0 37 171 3528567 3528433 MAG: Thermoanaerobaculia bacterium isolate MFD05537.bin.c.2 genome assembly, chromosome: 1 blastn 544 117 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
21690359 21690359 PRJEB11523_P_NODE_318_length_1077_cov_4.126459_g269_i0 PRJEB11523 318 1077 4.126459 44.44196343 Acidobacteriota 57723 Bacteria Bacteria 339 2.6699999999999992e-107   NR MDP2876828.1 2582906 g269 i0 60.9 1.64902506963788 297 115 82.5 1 905 18 26 322 MDP2876828.1 M3 family metallopeptidase [Holophaga sp.] diamond 1776 341 0.994134897360704 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Holophaga Holophaga sp.
26652600 26652600 PRJEB11523_P_NODE_2381_length_341_cov_7.465753_g2303_i0 PRJEB11523 2381 341 7.465753 25.45821773 Acidobacteriota bacterium 1978231 Bacteria Bacteria 92 5.76e-19   NR PYS88174.1 1978231 g2303 i0 44.1 0.818181818181818 93 52 81.8 0 30 308 200 292 PYS88174.1 MAG: hypothetical protein DMF62_10520 [Acidobacteriota bacterium] diamond 279 92 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26969368 26969368 PRJEB11523_P_NODE_8842_length_158_cov_2.064220_g8764_i0 PRJEB11523 8842 158 2.06422 3.2614676 Luteitalea sp. 2004800 Bacteria Bacteria 53.1 2.46e-6   NR MPY86752.1 2004800 g8764 i0 75 0.607594936708861 32 8 60.8 0 99 4 3 34 MPY86752.1 group II intron reverse transcriptase/maturase [Luteitalea sp.] diamond 96 53.1 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae Luteitalea Luteitalea sp.
27253879 27253879 PRJEB11523_P_NODE_6083_length_187_cov_14.615942_g6005_i0 PRJEB11523 6083 187 14.615942 27.33181154 uncultured Acidobacteria bacterium HF4 171953 Bacteria Bacteria 45.1 0.00148   NR ADI18657.1 710731 g6005 i0 44.3 1.12299465240642 70 24 91.4 4 6 176 88 155 ADI18657.1 hypothetical protein [uncultured Acidobacteria bacterium HF4000_26D02] diamond 210 45.1 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteria bacterium HF4000_26D02
27443894 27443894 PRJEB11523_P_NODE_1643_length_440_cov_29.263427_g1565_i0 PRJEB11523 1643 440 29.263427 128.7590788 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 70.5 1.71e-11   NR MDQ1639270.1 2283092 g1565 i0 32.8 2.08636363636364 128 73 78.4 2 409 65 49 176 MDQ1639270.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 918 70.5 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27948795 27948795 PRJEB11523_P_NODE_405_length_945_cov_2.345982_g349_i0 PRJEB11523 405 945 2.345982 22.1695299 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 80.5 4.72e-13   NR HEX8838242.1 3069120 g349 i0 38.6 0.542857142857143 171 84 47.9 6 7 459 139 308 HEX8838242.1 hypothetical protein [Candidatus Acidiferrum sp.] diamond 513 80.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.
28043495 28043495 PRJEB11523_P_NODE_4545_length_221_cov_8.000000_g4467_i0 PRJEB11523 4545 221 8 17.68 Terriglobales bacterium 2282142 Bacteria Bacteria 106 1.66e-25   NR HEX2598115.1 2282142 g4467 i0 70.8 0.882352941176471 65 19 88.2 0 208 14 234 298 HEX2598115.1 site-specific integrase [Terriglobales bacterium] diamond 195 106 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
28106514 28106514 PRJEB11523_P_NODE_8665_length_161_cov_0.910714_g8587_i0 PRJEB11523 8665 161 0.910714 1.46624954 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 98.2 3.669999999999999e-23   NR HEY7446134.1 2910147 g8587 i0 84.9 0.987577639751553 53 8 98.8 0 3 161 191 243 HEY7446134.1 sigma-70 family RNA polymerase sigma factor [Vicinamibacterales bacterium] diamond 159 98.2 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
28327527 28327527 PRJEB11523_P_NODE_7946_length_165_cov_0.879310_g7868_i0 PRJEB11523 7946 165 0.87931 1.4508615 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 97.8 1.69e-24   NR HYJ93478.1 2910147 g7868 i0 90.7 0.981818181818182 54 5 98.2 0 163 2 75 128 HYJ93478.1 TraR/DksA C4-type zinc finger protein [Vicinamibacterales bacterium] diamond 162 97.8 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
29205839 29205839 PRJEB11523_P_NODE_5169_length_205_cov_11.519231_g5091_i0 PRJEB11523 5169 205 11.519231 23.61442355 root 1 Root_unresolved Root_unresolved 57.4 1.44e-7   NR HCC56531.1 2026791 g5091 i0 60.4 3.23414634146341 48 19 70.2 0 62 205 133 180 HCC56531.1 dTDP-glucose 4,6-dehydratase [Bryobacterales bacterium] diamond 663 57.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
29211888 29211888 PRJEB11523_P_NODE_7769_length_166_cov_0.871795_g7691_i0 PRJEB11523 7769 166 0.871795 1.4471797 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 69.3 1.94e-12   NR MET0167121.1 2910147 g7691 i0 48.1 0.939759036144578 52 27 94 0 9 164 40 91 MET0167121.1 hypothetical protein [Vicinamibacterales bacterium] diamond 156 69.3 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
30248028 30248028 PRJEB11523_P_NODE_1972_length_388_cov_25.796460_g1894_i0 PRJEB11523 1972 388 25.79646 100.0902648 Bacteria 2 Bacteria Bacteria 208 1.4600000000000004e-59   NR MBS1827722.1 1978231 g1894 i0 90.6 1.63917525773196 106 10 82 0 40 357 622 727 MBS1827722.1 GMC family oxidoreductase [Acidobacteriota bacterium] diamond 636 208 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30279806 30279806 PRJEB11523_P_NODE_792_length_678_cov_5.400636_g723_i0 PRJEB11523 792 678 5.400636 36.61631208 Bacteria 2 Bacteria Bacteria 47.8 0.0218   NR PYS90939.1 1978231 g723 i0 56.5 0.570796460176991 46 20 20.4 0 149 12 7 52 PYS90939.1 MAG: hypothetical protein DMF62_03805 [Acidobacteriota bacterium] diamond 387 48.1 0.993762993762994 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31106850 31106850 PRJEB11523_P_NODE_1335_length_499_cov_8.837778_g1257_i0 PRJEB11523 1335 499 8.837778 44.10051222 Acidobacteriota bacterium 1978231 Bacteria Bacteria 80.9 3.2e-14   NR MFQ5742001.1 1978231 g1257 i0 53.5 0.42685370741483 71 32 42.1 1 10 219 1676 1746 MFQ5742001.1 PLxRFG domain-containing protein [Acidobacteriota bacterium] diamond 213 80.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32055792 32055792 PRJEB11523_P_NODE_5638_length_195_cov_5.410959_g5560_i0 PRJEB11523 5638 195 5.410959 10.55137005 Blastocatellia bacterium 2052146 Bacteria Bacteria 82 1.5e-16   NR HQR36398.1 2052146 g5560 i0 88.9 1.38461538461538 45 5 69.2 0 173 39 300 344 HQR36398.1 ectonucleotide pyrophosphatase/phosphodiesterase [Blastocatellia bacterium] diamond 270 82 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
32334805 32334805 PRJEB11523_P_NODE_5319_length_202_cov_3.424837_g5241_i0 PRJEB11523 5319 202 3.424837 6.91817074 root 1 Root_unresolved Root_unresolved 77.8 2.17e-15   NR HUD76037.1 1964191 g5241 i0 58.7 1.93069306930693 63 26 93.6 0 2 190 129 191 HUD76037.1 hypothetical protein [Terracidiphilus sp.] diamond 390 77.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.

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);;