RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJEB75017" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 26 ✖

tax_kingdom 1

bioproject 1

  • PRJEB75017 · 26 ✖

analysis 1

  • diamond · 26 ✖

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
15437886 15437886 PRJEB75017_P_NODE_5373_length_379_cov_1.258170_g5244_i0 PRJEB75017 5373 379 1.25817 4.7684643 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 109 7.99e-25   NR MEJ2143646.1 1978231 g5244 i0 55.6 4.18733509234828 99 44 78.4 0 22 318 508 606 MEJ2143646.1 adenylate/guanylate cyclase domain-containing protein [Acidobacteriota bacterium] diamond 1587 109 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
19260968 19260968 PRJEB75017_P_NODE_3416_length_474_cov_1.486284_g3287_i0 PRJEB75017 3416 474 1.486284 7.04498616 Terriglobales bacterium 2282142 Bacteria Bacteria 218 1.2699999999999996e-68   NR HEY6182722.1 2282142 g3287 i0 66.2 9.92405063291139 157 51 99.4 1 2 472 73 227 HEY6182722.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Terriglobales bacterium] diamond 4704 218 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
19260980 19260980 PRJEB75017_P_NODE_4376_length_419_cov_1.127168_g4247_i0 PRJEB75017 4376 419 1.127168 4.72283392 Bacteria candidate phyla 1783234 Bacteria Bacteria 65.1 4.18e-9   NR MBI1760163.1 1978231 g4247 i0 40.4 4.381861575179 114 55 81.6 3 63 404 599 699 MBI1760163.1 DUF11 domain-containing protein [Acidobacteriota bacterium] diamond 1836 65.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26622540 26622540 PRJEB75017_P_NODE_13081_length_259_cov_1.053763_g12952_i0 PRJEB75017 13081 259 1.053763 2.72924617 Acidobacteriota bacterium 1978231 Bacteria Bacteria 42 0.0487   NR MDQ7008649.1 1978231 g12952 i0 36.2 0.671814671814672 58 37 67.2 0 79 252 16 73 MDQ7008649.1 hypothetical protein [Acidobacteriota bacterium] diamond 174 42 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26654017 26654017 PRJEB75017_P_NODE_11461_length_275_cov_1.108911_g11332_i0 PRJEB75017 11461 275 1.108911 3.04950525 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 83.2 3.4e-16   NR HEX4497361.1 2651171 g11332 i0 52.3 0.96 88 41 94.9 1 14 274 1291 1378 HEX4497361.1 Ig-like domain-containing protein [Thermoanaerobaculia bacterium] diamond 264 83.2 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
26876208 26876208 PRJEB75017_P_NODE_10981_length_279_cov_1.514563_g10852_i0 PRJEB75017 10981 279 1.514563 4.22563077 Acidobacteriota bacterium 1978231 Bacteria Bacteria 82.8 4.48e-16   NR MBI2827987.1 1978231 g10852 i0 71.7 0.989247311827957 46 13 49.5 0 3 140 484 529 MBI2827987.1 4-alpha-glucanotransferase [Acidobacteriota bacterium] diamond 276 82.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27381952 27381952 PRJEB75017_P_NODE_17203_length_245_cov_0.906977_g17074_i0 PRJEB75017 17203 245 0.906977 2.22209365 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 43.5 0.0213   NR HKH46212.1 2651171 g17074 i0 34.9 0.771428571428571 63 36 77.1 1 1 189 2452 2509 HKH46212.1 amino acid adenylation domain-containing protein [Thermoanaerobaculia bacterium] diamond 189 43.5 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
27445279 27445279 PRJEB75017_P_NODE_14203_length_252_cov_0.871508_g14074_i0 PRJEB75017 14203 252 0.871508 2.19620016 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 48.1 4.19e-4   NR MFN0172054.1 2212468 g14074 i0 35.3 0.80952380952381 68 44 81 0 28 231 146 213 MFN0172054.1 PEP-CTERM sorting domain-containing protein [Bryobacteraceae bacterium] diamond 204 48.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
27532482 27532482 PRJEB75017_P_NODE_14963_length_250_cov_1.322034_g14834_i0 PRJEB75017 14963 250 1.322034 3.305085 Bacteria 2 Bacteria Bacteria 43.1 0.0289   NR MSV34493.1 2026791 g14834 i0 62.1 1.392 29 11 34.8 0 249 163 351 379 MSV34493.1 hypothetical protein [Bryobacterales bacterium] diamond 348 43.5 0.990804597701149 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
28076364 28076364 PRJEB75017_P_NODE_13905_length_253_cov_0.866667_g13776_i0 PRJEB75017 13905 253 0.866667 2.19266751 Blastocatellia bacterium 2052146 Bacteria Bacteria 43.9 0.0158   NR HEX4945165.1 2052146 g13776 i0 25 1.32806324110672 112 55 98.4 2 251 3 249 360 HEX4945165.1 hypothetical protein [Blastocatellia bacterium] diamond 336 43.9 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
28392222 28392222 PRJEB75017_P_NODE_15146_length_250_cov_0.881356_g15017_i0 PRJEB75017 15146 250 0.881356 2.20339 Terriglobia bacterium 2081523 Bacteria Bacteria 45.4 0.00361   NR HYR83490.1 2081523 g15017 i0 48.1 0.624 52 27 62.4 0 2 157 153 204 HYR83490.1 DUF11 domain-containing protein [Terriglobia bacterium] diamond 156 45.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
28581814 28581814 PRJEB75017_P_NODE_15787_length_248_cov_0.891429_g15658_i0 PRJEB75017 15787 248 0.891429 2.21074392 Terracidiphilus sp. 1964191 Bacteria Bacteria 76.3 3e-14   NR HET6208579.1 1964191 g15658 i0 60.3 2.6008064516129 68 25 82.3 1 235 32 233 298 HET6208579.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Terracidiphilus sp.] diamond 645 76.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
28897304 28897304 PRJEB75017_P_NODE_4928_length_396_cov_1.448916_g4799_i0 PRJEB75017 4928 396 1.448916 5.73770736 Acidobacteriota bacterium 1978231 Bacteria Bacteria 161 9.74e-45   NR MBL8188548.1 1978231 g4799 i0 60 8.37121212121212 110 44 83.3 0 7 336 335 444 MBL8188548.1 deoxyribodipyrimidine photo-lyase [Acidobacteriota bacterium] diamond 3315 161 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28921608 28921608 PRJEB75017_P_NODE_13108_length_258_cov_2.064865_g12979_i0 PRJEB75017 13108 258 2.064865 5.3273517 Pseudomonadati 3379134 Bacteria Bacteria 76.3 2.84e-14   NR MEP7306727.1 1978231 g12979 i0 48.1 1.88372093023256 81 42 94.2 0 3 245 68 148 MEP7306727.1 arylamine N-acetyltransferase [Acidobacteriota bacterium] diamond 486 76.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28928973 28928973 PRJEB75017_P_NODE_11008_length_279_cov_1.262136_g10879_i0 PRJEB75017 11008 279 1.262136 3.52135944 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 48.5 5.11e-4   NR HEV2761950.1 2283092 g10879 i0 33.3 0.967741935483871 90 46 84.9 3 239 3 318 404 HEV2761950.1 metallophosphoesterase [Pyrinomonadaceae bacterium] diamond 270 48.5 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28928985 28928985 PRJEB75017_P_NODE_2148_length_594_cov_9.278311_g2021_i0 PRJEB75017 2148 594 9.278311 55.11316734 Acidobacteriota bacterium 1978231 Bacteria Bacteria 137 6.53e-38   NR MDQ7008653.1 1978231 g2021 i0 74.8 0.52020202020202 103 26 52 0 517 209 8 110 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 309 137 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29718042 29718042 PRJEB75017_P_NODE_16690_length_246_cov_0.901734_g16561_i0 PRJEB75017 16690 246 0.901734 2.21826564 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 103 4.68e-25   NR MFL6462934.1 2212468 g16561 i0 67.6 0.902439024390244 74 24 90.2 0 242 21 156 229 MFL6462934.1 aspartate/glutamate racemase family protein [Bryobacteraceae bacterium] diamond 222 103 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
29812929 29812929 PRJEB75017_P_NODE_14891_length_250_cov_2.220339_g14762_i0 PRJEB75017 14891 250 2.220339 5.5508475 Acidobacteriota bacterium 1978231 Bacteria Bacteria 45.4 0.0024   NR MCB1025449.1 1978231 g14762 i0 46.8 0.564 47 25 56.4 0 246 106 21 67 MCB1025449.1 hypothetical protein [Acidobacteriota bacterium] diamond 141 45.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29907968 29907968 PRJEB75017_P_NODE_4231_length_426_cov_1.847025_g4102_i0 PRJEB75017 4231 426 1.847025 7.8683265 Terriglobia bacterium 2081523 Bacteria Bacteria 50.1 6.55e-4   NR HEX2521319.1 2081523 g4102 i0 25.7 1.40845070422535 144 95 96.5 4 15 425 137 275 HEX2521319.1 PQQ-binding-like beta-propeller repeat protein [Terriglobia bacterium] diamond 600 50.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
30034282 30034282 PRJEB75017_P_NODE_14151_length_252_cov_1.301676_g14022_i0 PRJEB75017 14151 252 1.301676 3.28022352 Acidobacteriota bacterium 1978231 Bacteria Bacteria 53.5 6.74e-6   NR MBX3244177.1 1978231 g14022 i0 35.7 1.98809523809524 84 47 97.6 3 1 246 70 148 MBX3244177.1 SBBP repeat-containing protein [Acidobacteriota bacterium] diamond 501 53.5 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30982180 30982180 PRJEB75017_P_NODE_13054_length_259_cov_1.360215_g12925_i0 PRJEB75017 13054 259 1.360215 3.52295685 Blastocatellia bacterium 2052146 Bacteria Bacteria 134 1.02e-34   NR MBX7219619.1 2052146 g12925 i0 79.5 0.903474903474903 78 16 90.3 0 257 24 474 551 MBX7219619.1 alpha/beta fold hydrolase [Blastocatellia bacterium] diamond 234 134 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
31480956 31480956 PRJEB75017_P_NODE_14416_length_252_cov_0.871508_g14287_i0 PRJEB75017 14416 252 0.871508 2.19620016 Bacteria 2 Bacteria Bacteria 96.7 1.95e-21   NR MDT4965361.1 1978231 g14287 i0 65.8 3.30952380952381 79 25 94 1 238 2 26 102 MDT4965361.1 type transport system permease protein [Acidobacteriota bacterium] diamond 834 96.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31638654 31638654 PRJEB75017_P_NODE_15416_length_249_cov_0.886364_g15287_i0 PRJEB75017 15416 249 0.886364 2.20704636 root 1 Root_unresolved Root_unresolved 52 2.12e-5   NR OFW01941.1 1797187 g15287 i0 40.7 4.65060240963855 81 39 97.6 2 243 1 185 256 OFW01941.1 MAG: hypothetical protein A3G20_07555 [Acidobacteria bacterium RIFCSPLOWO2_12_FULL_59_11] diamond 1158 52.4 0.99236641221374 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteria bacterium RIFCSPLOWO2_12_FULL_59_11
31835604 31835604 PRJEB75017_P_NODE_777_length_952_cov_2.281001_g684_i0 PRJEB75017 777 952 2.281001 21.71512952 Acidobacteriota bacterium 1978231 Bacteria Bacteria 79 3.75e-12   NR MBX3294082.1 1978231 g684 i0 31.1 0.740546218487395 235 134 68.1 9 105 752 11 236 MBX3294082.1 hypothetical protein [Acidobacteriota bacterium] diamond 705 79 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32088862 32088862 PRJEB75017_P_NODE_11238_length_277_cov_1.230392_g11109_i0 PRJEB75017 11238 277 1.230392 3.40818584 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 87.4 2.53e-18   NR MEX2262404.1 2212468 g11109 i0 65.2 0.714801444043321 66 23 71.5 0 201 4 5 70 MEX2262404.1 PIG-L family deacetylase [Bryobacteraceae bacterium] diamond 198 87.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
32815391 32815391 PRJEB75017_P_NODE_16240_length_247_cov_0.896552_g16111_i0 PRJEB75017 16240 247 0.896552 2.21448344 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 45.1 0.00612   NR HYL76395.1 2212468 g16111 i0 39.8 1.0080971659919 83 46 99.6 2 1 246 102 181 HYL76395.1 ABC transporter permease [Bryobacteraceae bacterium] diamond 249 45.1 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);;