RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA658591" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA658591 · 23 ✖

analysis 1

  • diamond · 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
8278742 8278742 PRJNA658591_S_NODE_587_length_492_cov_6.264108_g525_i0 PRJNA658591 587 492 6.264108 30.81941136 Pseudomonadota 1224 Bacteria Bacteria 278 6.029999999999998e-88   NR WP_325323754.1 306 g525 i0 81 134.19512195122 163 31 99.4 0 490 2 339 501 WP_325323754.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase, partial [Pseudomonas sp.] diamond 66024 280 0.992857142857143 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp.
10090021 10090021 PRJNA658591_S_NODE_4468_length_216_cov_6.065868_g4405_i0 PRJNA658591 4468 216 6.065868 13.10227488 root 1 Root_unresolved Root_unresolved 130 3.47e-33   NR WP_196229824.1 2426 g4405 i0 91.5 212.986111111111 71 6 98.6 0 215 3 512 582 WP_196229824.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase [Teredinibacter turnerae] diamond 46005 131 0.99236641221374 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Cellvibrionaceae Teredinibacter Teredinibacter turnerae
10829730 10829730 PRJNA658591_S_NODE_8209_length_173_cov_1.677419_g8146_i0 PRJNA658591 8209 173 1.677419 2.90193487 Aeromonas 642 Bacteria Bacteria 89 3.24e-19   NR MDX2126969.1 644 g8146 i0 71.4 7.7514450867052 56 16 97.1 0 5 172 102 157 MDX2126969.1 aconitate hydratase B [Aeromonas hydrophila] diamond 1341 89 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas Aeromonas hydrophila
13379590 13379590 PRJNA658591_S_NODE_4491_length_216_cov_2.149701_g4428_i0 PRJNA658591 4491 216 2.149701 4.64335416 Gammaproteobacteria 1236 Bacteria Bacteria 120 2.35e-30   NR WP_297331369.1 53249 g4428 i0 85.9 13.8055555555556 71 10 98.6 0 1 213 331 401 WP_297331369.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase, partial [Pseudoalteromonas sp.] diamond 2982 121 0.991735537190083 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Pseudoalteromonadaceae Pseudoalteromonas Pseudoalteromonas sp.
26669572 26669572 PRJNA658591_S_NODE_11501_length_152_cov_3.310680_g11438_i0 PRJNA658591 11501 152 3.31068 5.0322336 Paracoccaceae bacterium 1904441 Bacteria Bacteria 54.7 6.47e-7   NR GIS52924.1 1904441 g11438 i0 93.1 0.572368421052632 29 2 57.2 0 66 152 1 29 GIS52924.1 MAG: chaperone protein HtpG [Paracoccaceae bacterium] diamond 87 54.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae   Paracoccaceae bacterium
26872452 26872452 PRJNA658591_S_NODE_701_length_459_cov_2.007317_g639_i0 PRJNA658591 701 459 2.007317 9.21358503 root 1 Root_unresolved Root_unresolved 139 9.589999999999999e-35   NR WP_171385959.1 171383 g639 i0 72.2 15.5555555555556 97 27 63.4 0 163 453 3 99 WP_171385959.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase [Vibrio hepatarius] diamond 7140 140 0.992857142857143 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio hepatarius
27018073 27018073 PRJNA658591_S_NODE_7122_length_182_cov_1.556391_g7059_i0 PRJNA658591 7122 182 1.556391 2.83263162 Pseudomonadota bacterium 1977087 Bacteria Bacteria 57 1.53e-7   NR MCG8336191.1 1977087 g7059 i0 52.5 1.94505494505495 59 27 97.3 1 2 178 807 864 MCG8336191.1 insulinase family protein [Pseudomonadota bacterium] diamond 354 57 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27049878 27049878 PRJNA658591_S_NODE_5802_length_196_cov_8.210884_g5739_i0 PRJNA658591 5802 196 8.210884 16.09333264 Kangiella koreensis 261964 Bacteria Bacteria 86.3 9.37e-18   NR WP_012801033.1 261964 g5739 i0 73.2 3.39795918367347 56 15 85.7 0 29 196 19 74 WP_012801033.1 NADP-dependent isocitrate dehydrogenase [Kangiella koreensis] diamond 666 86.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Kangiellales Kangiellaceae Kangiella Kangiella koreensis
27144152 27144152 PRJNA658591_S_NODE_5442_length_201_cov_1.368421_g5379_i0 PRJNA658591 5442 201 1.368421 2.75052621 Thiotrichales bacterium 32-46-8 1970604 Bacteria Bacteria 61.6 4.44e-9   NR OYX03948.1 1970604 g5379 i0 67.6 1.11940298507463 37 12 55.2 0 199 89 199 235 OYX03948.1 MAG: hypothetical protein B7Z05_08990, partial [Thiotrichales bacterium 32-46-8] diamond 225 61.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales     Thiotrichales bacterium 32-46-8
27315005 27315005 PRJNA658591_S_NODE_4263_length_220_cov_1.654971_g4200_i0 PRJNA658591 4263 220 1.654971 3.6409362 Bacteria 2 Bacteria Bacteria 90.1 5.04e-19   NR WP_025240548.1 316 g4200 i0 60.6 9.7227272727272709 71 25 96.8 1 213 1 305 372 WP_025240548.1 NADP-dependent succinate-semialdehyde dehydrogenase [Stutzerimonas stutzeri] diamond 2139 90.9 0.991199119911991 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Stutzerimonas Stutzerimonas stutzeri
27492245 27492245 PRJNA658591_S_NODE_11523_length_152_cov_2.524272_g11460_i0 PRJNA658591 11523 152 2.524272 3.83689344 Nitrosomonadales bacterium 2026761 Bacteria Bacteria 45.1 0.00165   NR MEK9771194.1 2026761 g11460 i0 44.7 0.927631578947368 47 23 86.8 1 139 8 583 629 MEK9771194.1 [protein-PII] uridylyltransferase [Nitrosomonadales bacterium] diamond 141 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales     Nitrosomonadales bacterium
28597388 28597388 PRJNA658591_S_NODE_7867_length_176_cov_1.220472_g7804_i0 PRJNA658591 7867 176 1.220472 2.14803072 Vogesella urethralis 2592656 Bacteria Bacteria 114 7.1e-30   NR WP_144371639.1 2592656 g7804 i0 100 0.988636363636364 58 0 98.9 0 175 2 67 124 WP_144371639.1 TetR/AcrR family transcriptional regulator [Vogesella urethralis] diamond 174 114 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chromobacteriaceae Vogesella Vogesella urethralis
29638851 29638851 PRJNA658591_S_NODE_3570_length_235_cov_194.532258_g3507_i0 PRJNA658591 3570 235 194.532258 457.1508063 Pseudomonas fluorescens BRIP34879 1205750 Bacteria Bacteria 47.4 1.22e-4   NR ELQ05789.1 1205750 g3507 i0 69.7 0.421276595744681 33 10 42.1 0 3 101 1 33 ELQ05789.1 protocatechuate 3,4-dioxygenase subunit alpha, partial [Pseudomonas fluorescens BRIP34879] diamond 99 47.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas fluorescens
29650986 29650986 PRJNA658591_S_NODE_8210_length_173_cov_1.677419_g8147_i0 PRJNA658591 8210 173 1.677419 2.90193487 Methylomarinum 1221209 Bacteria Bacteria 83.6 5.9e-17   NR WP_031432232.1 438855 g8147 i0 74 5.30635838150289 50 13 86.7 0 165 16 291 340 WP_031432232.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase [Methylomarinum vadi] diamond 918 84.3 0.991696322657177 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Methylococcales Methylococcaceae Methylomarinum Methylomarinum vadi
30093381 30093381 PRJNA658591_S_NODE_612_length_484_cov_9.266667_g550_i0 PRJNA658591 612 484 9.266667 44.85066828 Pseudomonadati 3379134 Bacteria Bacteria 152 2.66e-39   NR HNJ38565.1 42353 g550 i0 47.7 1.93388429752066 151 79 93.6 0 481 29 800 950 HNJ38565.1 reverse transcriptase domain-containing protein [Nitrosomonas sp.] diamond 936 153 0.993464052287582 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas Nitrosomonas sp.
30303007 30303007 PRJNA658591_S_NODE_6332_length_190_cov_1.106383_g6269_i0 PRJNA658591 6332 190 1.106383 2.1021277 Curvibacter sp. 1888168 Bacteria Bacteria 120 1.1e-29   NR RUP35422.1 1888168 g6269 i0 98.4 0.994736842105263 63 1 99.5 0 190 2 1533 1595 RUP35422.1 MAG: hypothetical protein EKK45_01130, partial [Curvibacter sp.] diamond 189 120 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Curvibacter Curvibacter sp.
30713250 30713250 PRJNA658591_S_NODE_1514_length_335_cov_2.150350_g1451_i0 PRJNA658591 1514 335 2.15035 7.2036725 Thiotrichales bacterium 32-46-8 1970604 Bacteria Bacteria 163 1.53e-46   NR OYX07600.1 1970604 g1451 i0 69.5 0.940298507462687 105 32 94 0 18 332 1 105 OYX07600.1 MAG: hypothetical protein B7Z05_01050 [Thiotrichales bacterium 32-46-8] diamond 315 163 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales     Thiotrichales bacterium 32-46-8
30966220 30966220 PRJNA658591_S_NODE_5154_length_205_cov_2.089744_g5091_i0 PRJNA658591 5154 205 2.089744 4.2839752 unclassified Janthinobacterium 2610881 Bacteria Bacteria 67.4 4.47e-11   NR WP_183743267.1 2610881 g5091 i0 46.8 1.87317073170732 62 33 90.7 0 192 7 206 267 WP_183743267.1 MULTISPECIES: carboxypeptidase regulatory-like domain-containing protein [unclassified Janthinobacterium] diamond 384 67.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Janthinobacterium  
31281972 31281972 PRJNA658591_S_NODE_7315_length_180_cov_3.465649_g7252_i0 PRJNA658591 7315 180 3.465649 6.2381682 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 56.6 1.97e-7   NR MDA8524460.1 1913988 g7252 i0 44.8 0.966666666666667 58 32 96.7 0 179 6 288 345 MDA8524460.1 formyltransferase family protein [Alphaproteobacteria bacterium] diamond 174 56.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
31851267 31851267 PRJNA658591_S_NODE_5037_length_207_cov_1.069620_g4974_i0 PRJNA658591 5037 207 1.06962 2.2141134 Betaproteobacteria bacterium 1891241 Bacteria Bacteria 79.3 2.9e-15   NR MBV8030929.1 1891241 g4974 i0 64.6 2.76811594202899 65 22 92.8 1 3 194 581 645 MBV8030929.1 acetyl/propionyl/methylcrotonyl-CoA carboxylase subunit alpha [Betaproteobacteria bacterium] diamond 573 79.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria       Betaproteobacteria bacterium
31882957 31882957 PRJNA658591_S_NODE_3837_length_229_cov_1.972222_g3774_i0 PRJNA658591 3837 229 1.972222 4.51638838 Duganella sp. CF517 1881038 Bacteria Bacteria 87.4 5.62e-18   NR WP_090318457.1 1881038 g3774 i0 53.3 9.82532751091703 75 35 98.3 0 227 3 676 750 WP_090318457.1 HAD-IC family P-type ATPase [Duganella sp. CF517] diamond 2250 87.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Duganella Duganella sp. CF517
32263012 32263012 PRJNA658591_S_NODE_1858_length_307_cov_3.244186_g1795_i0 PRJNA658591 1858 307 3.244186 9.95965102 Thiotrichales bacterium 32-46-8 1970604 Bacteria Bacteria 158 6.58e-45   NR OYX07600.1 1970604 g1795 i0 67.6 0.996742671009772 102 33 99.7 0 2 307 217 318 OYX07600.1 MAG: hypothetical protein B7Z05_01050 [Thiotrichales bacterium 32-46-8] diamond 306 158 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales     Thiotrichales bacterium 32-46-8
32306906 32306906 PRJNA658591_S_NODE_9479_length_166_cov_0.863248_g9416_i0 PRJNA658591 9479 166 0.863248 1.43299168 Pseudomonadati 3379134 Bacteria Bacteria 42.4 0.0141   NR WP_308953921.1 548 g9416 i0 90.5 3.03614457831325 21 2 38 0 3 65 171 191 WP_308953921.1 zinc-binding dehydrogenase, partial [Klebsiella aerogenes] diamond 504 42.7 0.992974238875878 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella aerogenes

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