RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA431371", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 17 ✖

tax_phylum 1

  • Acidobacteriota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA431371 · 17 ✖

analysis 1

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
27486568 27486568 PRJNA431371_P_NODE_10323_length_389_cov_1.148734_g10250_i0 PRJNA431371 10323 389 1.148734 4.46857526 Geothrix rubra 2927977 Bacteria Bacteria 63.2 3.91e-9   NR WP_285722077.1 2927977 g10250 i0 36 1.71979434447301 125 68 90.2 4 353 3 44 164 WP_285722077.1 CAP domain-containing protein [Geothrix rubra] diamond 669 63.2 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix rubra
28718045 28718045 PRJNA431371_P_NODE_29047_length_247_cov_1.327586_g28974_i0 PRJNA431371 29047 247 1.327586 3.27913742 Terriglobales bacterium 2282142 Bacteria Bacteria 127 8.229999999999999e-32   NR HUK86423.1 2282142 g28974 i0 76.5 2.96356275303644 81 19 98.4 0 2 244 385 465 HUK86423.1 3-hydroxyacyl-CoA dehydrogenase NAD-binding domain-containing protein [Terriglobales bacterium] diamond 732 127 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
28718049 28718049 PRJNA431371_P_NODE_36527_length_241_cov_0.916667_g36454_i0 PRJNA431371 36527 241 0.916667 2.20916747 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 48.1 4e-4   NR HET9370167.1 2910147 g36454 i0 37.7 0.759336099585062 61 37 74.7 1 181 2 11 71 HET9370167.1 glycosyltransferase [Vicinamibacterales bacterium] diamond 183 48.1 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
28939093 28939093 PRJNA431371_P_NODE_33668_length_243_cov_0.905882_g33595_i0 PRJNA431371 33668 243 0.905882 2.20129326 Candidatus Sulfotelmatobacter sp. 2771375 Bacteria Bacteria 42.7 0.0376   NR HEY1659398.1 2771375 g33595 i0 34.5 1.03703703703704 84 48 95.1 1 7 237 108 191 HEY1659398.1 hypothetical protein [Candidatus Sulfotelmatobacter sp.] diamond 252 42.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Candidatus Korobacteraceae Candidatus Sulfotelmatobacter Candidatus Sulfotelmatobacter sp.
29002570 29002570 PRJNA431371_P_NODE_7548_length_447_cov_1.756684_g7475_i0 PRJNA431371 7548 447 1.756684 7.85237748 Acidobacteriota bacterium 1978231 Bacteria Bacteria 46.6 0.0144   NR MBI4905402.1 1978231 g7475 i0 35.4 1.44295302013423 79 41 51 3 446 219 1174 1245 MBI4905402.1 choice-of-anchor D domain-containing protein [Acidobacteriota bacterium] diamond 645 46.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29223340 29223340 PRJNA431371_P_NODE_5769_length_502_cov_1.435897_g5696_i0 PRJNA431371 5769 502 1.435897 7.20820294 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 80.5 1.3e-14   NR HJW14251.1 2651171 g5696 i0 36.1 2.00796812749004 169 102 98.6 3 497 3 63 229 HJW14251.1 RluA family pseudouridine synthase [Thermoanaerobaculia bacterium] diamond 1008 80.5 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
29443908 29443908 PRJNA431371_P_NODE_22830_length_265_cov_1.291667_g22757_i0 PRJNA431371 22830 265 1.291667 3.42291755 Acidobacteriota bacterium 1978231 Bacteria Bacteria 104 6.71e-27   NR MDQ7008653.1 1978231 g22757 i0 80.9 0.769811320754717 68 13 77 0 3 206 43 110 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 204 104 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29664783 29664783 PRJNA431371_P_NODE_14870_length_331_cov_1.372093_g14797_i0 PRJNA431371 14870 331 1.372093 4.54162783 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 48.9 5.73e-4   NR HET7710489.1 2651171 g14797 i0 34.2 1.03323262839879 114 60 99.7 5 2 331 8 110 HET7710489.1 IPT/TIG domain-containing protein [Thermoanaerobaculia bacterium] diamond 342 48.9 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
29744545 29744545 PRJNA431371_P_NODE_4150_length_573_cov_3.334000_g4077_i0 PRJNA431371 4150 573 3.334 19.10382 Bacteria 2 Bacteria Bacteria 229 3.1099999999999996e-72   NR MBM3793404.1 1978231 g4077 i0 59.6 17.7277486910995 188 72 98.4 1 3 566 50 233 MBM3793404.1 hypothetical protein [Acidobacteriota bacterium] diamond 10158 231 0.991341991341991 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30644354 30644354 PRJNA431371_P_NODE_9033_length_413_cov_1.550000_g8960_i0 PRJNA431371 9033 413 1.55 6.4015 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 65.1 3.04e-9   NR MEZ5292908.1 2910147 g8960 i0 31.5 0.784503631961259 108 65 78.5 5 355 32 221 319 MEZ5292908.1 hypothetical protein [Vicinamibacterales bacterium] diamond 324 65.1 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
31023653 31023653 PRJNA431371_P_NODE_30375_length_246_cov_0.890173_g30302_i0 PRJNA431371 30375 246 0.890173 2.18982558 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 43.5 0.0101   NR HUP64291.1 2651171 g30302 i0 42.4 1.60975609756098 66 26 80.5 2 244 47 91 144 HUP64291.1 PaaI family thioesterase [Thermoanaerobaculia bacterium] diamond 396 43.5 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
31371549 31371549 PRJNA431371_P_NODE_29276_length_247_cov_0.885057_g29203_i0 PRJNA431371 29276 247 0.885057 2.18609079 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 45.1 0.00571   NR HZI85542.1 2283092 g29203 i0 39.7 1.61538461538462 58 32 70.4 1 28 201 34 88 HZI85542.1 ABC transporter substrate-binding protein [Pyrinomonadaceae bacterium] diamond 399 45.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31735606 31735606 PRJNA431371_P_NODE_13957_length_340_cov_1.441948_g13884_i0 PRJNA431371 13957 340 1.441948 4.9026232 Bacteria 2 Bacteria Bacteria 142 6.32e-39   NR MDQ3666501.1 1978231 g13884 i0 56.6 6.97941176470588 113 49 99.7 0 340 2 131 243 MDQ3666501.1 TIGR01777 family oxidoreductase [Acidobacteriota bacterium] diamond 2373 143 0.993006993006993 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31814167 31814167 PRJNA431371_P_NODE_23937_length_256_cov_2.502732_g23864_i0 PRJNA431371 23937 256 2.502732 6.40699392 Acidobacteriota bacterium 1978231 Bacteria Bacteria 100 6.64e-24   NR MEM7350164.1 1978231 g23864 i0 56.5 0.99609375 85 36 99.6 1 256 2 144 227 MEM7350164.1 phospholipase D-like domain-containing protein [Acidobacteriota bacterium] diamond 255 100 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31877275 31877275 PRJNA431371_P_NODE_18297_length_299_cov_2.044248_g18224_i0 PRJNA431371 18297 299 2.044248 6.11230152 Acidobacteriota bacterium 1978231 Bacteria Bacteria 47.8 0.00125   NR MBK8197152.1 1978231 g18224 i0 29.8 3.1304347826087 104 48 91.3 2 279 7 173 264 MBK8197152.1 hypothetical protein [Acidobacteriota bacterium] diamond 936 47.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32178882 32178882 PRJNA431371_P_NODE_20998_length_279_cov_1.072816_g20925_i0 PRJNA431371 20998 279 1.072816 2.99315664 Bacteria 2 Bacteria Bacteria 139 1.13e-38   NR MBM3792466.1 1978231 g20925 i0 77.4 40.6666666666667 93 21 100 0 279 1 78 170 MBM3792466.1 glucose 1-dehydrogenase [Acidobacteriota bacterium] diamond 11346 139 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32667877 32667877 PRJNA431371_P_NODE_4960_length_535_cov_1.173160_g4887_i0 PRJNA431371 4960 535 1.17316 6.276406 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 192 6.32e-57   NR HMF76880.1 2212468 g4887 i0 58.7 4.68785046728972 167 68 93.6 1 1 501 56 221 HMF76880.1 zinc-binding alcohol dehydrogenase family protein [Bryobacteraceae bacterium] diamond 2508 192 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae 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);;