RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJEB25583" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 26 ✖

tax_kingdom 1

bioproject 1

  • PRJEB25583 · 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
5125405 5125405 PRJEB25583_P_NODE_585_length_655_cov_4.343042_g424_i0 PRJEB25583 585 655 4.343042 28.4469251 Vibrio cholerae 666 Bacteria Bacteria 252 7.880000000000001e-79   NR EGR0519011.1 666 g424 i0 59.1 1.00763358778626 220 87 99.8 2 655 2 180 398 EGR0519011.1 restriction endonuclease subunit S [Vibrio cholerae] diamond 660 252 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio cholerae
21388531 21388531 PRJEB25583_P_NODE_3997_length_203_cov_1.548193_g3820_i0 PRJEB25583 3997 203 1.548193 3.14283179 Undibacterium 401469 Bacteria Bacteria 124 3.18e-33   NR WP_110253518.1 401469 g3820 i0 89.6 3.96059113300493 67 7 99 0 1 201 48 114 WP_110253518.1 MULTISPECIES: 30S ribosomal protein S2 [Undibacterium] diamond 804 124 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium  
27064739 27064739 PRJEB25583_P_NODE_2102_length_286_cov_10.389558_g1925_i0 PRJEB25583 2102 286 10.389558 29.71413588 Boseongicola sp. 1886600 Bacteria Bacteria 43.1 0.0444   NR MDE0694329.1 1886600 g1925 i0 39.3 0.587412587412587 56 30 58.7 2 113 280 299 350 MDE0694329.1 hypothetical protein [Boseongicola sp.] diamond 168 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Boseongicola Boseongicola sp.
27096326 27096326 PRJEB25583_P_NODE_2602_length_253_cov_1.773148_g2425_i0 PRJEB25583 2602 253 1.773148 4.48606444 Pseudomonadota bacterium 1977087 Bacteria Bacteria 63.5 1.94e-9   NR MES2902690.1 1977087 g2425 i0 50.7 0.794466403162055 67 32 79.4 1 15 215 94 159 MES2902690.1 hypothetical protein [Pseudomonadota bacterium] diamond 201 63.5 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27381038 27381038 PRJEB25583_P_NODE_2463_length_261_cov_1.883929_g2286_i0 PRJEB25583 2463 261 1.883929 4.91705469 Caulobacteraceae bacterium 1978230 Bacteria Bacteria 86.7 3.46e-19   NR NBW20194.1 1978230 g2286 i0 50.6 0.977011494252874 85 42 97.7 0 4 258 6 90 NBW20194.1 hypothetical protein [Caulobacteraceae bacterium] diamond 255 86.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae   Caulobacteraceae bacterium
27633572 27633572 PRJEB25583_P_NODE_3984_length_203_cov_2.060241_g3807_i0 PRJEB25583 3984 203 2.060241 4.18228923 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 45.8 0.00171   NR MEI6186906.1 1913988 g3807 i0 50 0.532019704433498 36 18 53.2 0 46 153 12 47 MEI6186906.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 108 45.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
27760062 27760062 PRJEB25583_P_NODE_2304_length_271_cov_2.585470_g2127_i0 PRJEB25583 2304 271 2.58547 7.0066237 Propionivibrio sp. 2212460 Bacteria Bacteria 170 6.219999999999999e-52   NR WP_294252398.1 2212460 g2127 i0 100 1.82656826568266 83 0 91.9 0 269 21 10 92 WP_294252398.1 phage terminase small subunit P27 family, partial [Propionivibrio sp.] diamond 495 170 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Rhodocyclales Rhodocyclaceae Propionivibrio Propionivibrio sp.
27791442 27791442 PRJEB25583_P_NODE_7124_length_159_cov_1.270492_g6947_i0 PRJEB25583 7124 159 1.270492 2.02008228 Undibacterium squillarum 1131567 Bacteria Bacteria 106 1.25e-27   NR WP_374518101.1 1131567 g6947 i0 100 0.981132075471698 52 0 98.1 0 156 1 48 99 WP_374518101.1 ubiquinone anaerobic biosynthesis accessory factor UbiT [Undibacterium squillarum] diamond 156 106 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium squillarum
28138888 28138888 PRJEB25583_P_NODE_7645_length_155_cov_1.322034_g7468_i0 PRJEB25583 7645 155 1.322034 2.0491527 uncultured Agitococcus sp. 1506599 Bacteria Bacteria 100 3.7e-23   NR WP_297922746.1 1506599 g7468 i0 92.2 0.987096774193548 51 4 98.7 0 153 1 222 272 WP_297922746.1 DUF927 domain-containing protein, partial [uncultured Agitococcus sp.] diamond 153 100 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Agitococcus uncultured Agitococcus sp.
28833228 28833228 PRJEB25583_P_NODE_4328_length_196_cov_1.729560_g4151_i0 PRJEB25583 4328 196 1.72956 3.3899376 Undibacterium luofuense 2828733 Bacteria Bacteria 129 1.65e-34   NR WP_212687793.1 2828733 g4151 i0 100 1.95918367346939 64 0 98 0 194 3 189 252 WP_212687793.1 porin [Undibacterium luofuense] diamond 384 129 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium luofuense
28864776 28864776 PRJEB25583_P_NODE_3708_length_210_cov_1.803468_g3531_i0 PRJEB25583 3708 210 1.803468 3.7872828 Azonexus sp. 1872668 Bacteria Bacteria 42 0.0304   NR HRH13163.1 1872668 g3531 i0 50 0.514285714285714 36 18 51.4 0 2 109 137 172 HRH13163.1 hypothetical protein [Azonexus sp.] diamond 108 42 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Rhodocyclales Azonexaceae Azonexus Azonexus sp.
28927967 28927967 PRJEB25583_P_NODE_4808_length_187_cov_1.406667_g4631_i0 PRJEB25583 4808 187 1.406667 2.63046729 Marinobacter sp. 50741 Bacteria Bacteria 55.1 7.56e-8   NR WP_273071914.1 50741 g4631 i0 59.1 0.705882352941177 44 18 70.6 0 54 185 51 94 WP_273071914.1 hypothetical protein [Marinobacter sp.] diamond 132 55.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Marinobacteraceae Marinobacter Marinobacter sp.
29275143 29275143 PRJEB25583_P_NODE_5309_length_179_cov_1.084507_g5132_i0 PRJEB25583 5309 179 1.084507 1.94126753 Hyphomicrobium sp. 82 Bacteria Bacteria 43.9 0.00606   NR PPC84974.1 82 g5132 i0 40.4 0.871508379888268 52 30 87.2 1 8 163 93 143 PPC84974.1 MAG: hypothetical protein CTY39_08105 [Hyphomicrobium sp.] diamond 156 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Hyphomicrobiaceae Hyphomicrobium Hyphomicrobium sp.
29338541 29338541 PRJEB25583_P_NODE_4989_length_184_cov_1.265306_g4812_i0 PRJEB25583 4989 184 1.265306 2.32816304 Legionellales bacterium 2026754 Bacteria Bacteria 57.4 3.38e-9   NR MFI4963268.1 2026754 g4812 i0 41.5 0.864130434782609 53 31 86.4 0 183 25 7 59 MFI4963268.1 hypothetical protein [Legionellales bacterium] diamond 159 57.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Legionellales     Legionellales bacterium
29685448 29685448 PRJEB25583_P_NODE_8450_length_150_cov_1.353982_g8273_i0 PRJEB25583 8450 150 1.353982 2.030973 Hydrogenophaga sp. PBC 795665 Bacteria Bacteria 73.6 7.48e-15   NR WP_009519931.1 795665 g8273 i0 91.9 2.88 37 3 74 0 112 2 1 37 WP_009519931.1 hypothetical protein [Hydrogenophaga sp. PBC] diamond 432 73.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Hydrogenophaga Hydrogenophaga sp. PBC
29780465 29780465 PRJEB25583_P_NODE_5651_length_174_cov_1.452555_g5474_i0 PRJEB25583 5651 174 1.452555 2.5274457 Pseudaquabacterium terrae 2732868 Bacteria Bacteria 41.6 0.0396   NR WP_173119635.1 2732868 g5474 i0 53.3 0.517241379310345 30 14 51.7 0 19 108 297 326 WP_173119635.1 DNA ligase D [Pseudaquabacterium terrae] diamond 90 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Pseudaquabacterium Pseudaquabacterium terrae
29938511 29938511 PRJEB25583_P_NODE_4471_length_193_cov_2.628205_g4294_i0 PRJEB25583 4471 193 2.628205 5.07243565 Rickettsia endosymbiont of Pyrocoelia pectoralis 2866165 Bacteria Bacteria 65.5 1.35e-10   NR HJD56399.1 2866165 g4294 i0 45.8 2.75129533678756 59 32 91.7 0 184 8 91 149 HJD56399.1 hypothetical protein [Rickettsia endosymbiont of Pyrocoelia pectoralis] diamond 531 65.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales Rickettsiaceae Rickettsia Rickettsia endosymbiont of Pyrocoelia pectoralis
30349689 30349689 PRJEB25583_P_NODE_4332_length_196_cov_1.610063_g4155_i0 PRJEB25583 4332 196 1.610063 3.15572348 Methyloversatilis sp. 2569862 Bacteria Bacteria 57 7.68e-9   NR WP_305611655.1 2569862 g4155 i0 86.2 3.27551020408163 29 4 44.4 0 88 2 15 43 WP_305611655.1 helix-turn-helix domain-containing protein [Methyloversatilis sp.] diamond 642 57 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Sterolibacteriaceae Methyloversatilis Methyloversatilis sp.
30381135 30381135 PRJEB25583_P_NODE_8153_length_152_cov_1.008696_g7976_i0 PRJEB25583 8153 152 1.008696 1.53321792 Castellaniella denitrificans 56119 Bacteria Bacteria 44.3 0.00307   NR WP_269359668.1 56119 g7976 i0 55.9 0.671052631578947 34 15 67.1 0 116 15 366 399 WP_269359668.1 hypothetical protein [Castellaniella denitrificans] diamond 102 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Alcaligenaceae Castellaniella Castellaniella denitrificans
30981254 30981254 PRJEB25583_P_NODE_5414_length_177_cov_1.792857_g5237_i0 PRJEB25583 5414 177 1.792857 3.17335689 Burkholderiaceae bacterium 2030806 Bacteria Bacteria 46.6 4.93e-4   NR NCX55780.1 2030806 g5237 i0 39.6 0.898305084745763 53 31 88.1 1 4 159 5 57 NCX55780.1 hypothetical protein [Burkholderiaceae bacterium] diamond 159 46.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae   Burkholderiaceae bacterium
31038107 31038107 PRJEB25583_P_NODE_4375_length_195_cov_2.031646_g4198_i0 PRJEB25583 4375 195 2.031646 3.9617097 Bacteria 2 Bacteria Bacteria 91.7 1.02e-20   NR MDH3325876.1 1913989 g4198 i0 62.9 1.90769230769231 62 23 95.4 0 3 188 156 217 MDH3325876.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 372 91.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
31290545 31290545 PRJEB25583_P_NODE_7655_length_155_cov_1.313559_g7478_i0 PRJEB25583 7655 155 1.313559 2.03601645 Gammaproteobacteria 1236 Bacteria Bacteria 96.7 5.03e-23   NR EES7561449.1 562 g7478 i0 98 2.96129032258065 51 1 98.7 0 155 3 171 221 EES7561449.1 hypothetical protein [Escherichia coli] diamond 459 96.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
31644877 31644877 PRJEB25583_P_NODE_6377_length_166_cov_1.178295_g6200_i0 PRJEB25583 6377 166 1.178295 1.9559697 Casimicrobiaceae bacterium 2906524 Bacteria Bacteria 45.8 0.00105   NR HEV8500433.1 2906524 g6200 i0 55.6 0.813253012048193 45 17 75.9 1 21 146 472 516 HEV8500433.1 tail fiber domain-containing protein [Casimicrobiaceae bacterium] diamond 135 45.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria   Casimicrobiaceae   Casimicrobiaceae bacterium
31739750 31739750 PRJEB25583_P_NODE_4877_length_186_cov_1.026846_g4700_i0 PRJEB25583 4877 186 1.026846 1.90993356 Nitrosomonas sp. 42353 Bacteria Bacteria 106 7.34e-25   NR HNJ38406.1 42353 g4700 i0 92.9 0.903225806451613 56 4 90.3 0 184 17 690 745 HNJ38406.1 hypothetical protein [Nitrosomonas sp.] diamond 168 106 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas Nitrosomonas sp.
32404420 32404420 PRJEB25583_P_NODE_2779_length_243_cov_1.689320_g2602_i0 PRJEB25583 2779 243 1.68932 4.1050476 Agitococcus sp. 1872415 Bacteria Bacteria 48.5 2.78e-5   NR HNJ86385.1 1872415 g2602 i0 85.2 0.333333333333333 27 4 33.3 0 82 2 1 27 HNJ86385.1 hypothetical protein [Agitococcus sp.] diamond 81 48.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Agitococcus Agitococcus sp.
32429610 32429610 PRJEB25583_P_NODE_3959_length_204_cov_1.167665_g3782_i0 PRJEB25583 3959 204 1.167665 2.3820366 root 1 Root_unresolved Root_unresolved 48.5 1.99e-4   NR RTK95767.1 2014784 g3782 i0 42.9 2.88235294117647 42 22 61.8 1 179 54 412 451 RTK95767.1 MAG: hypothetical protein EKK64_05790 [Neisseriaceae bacterium] diamond 588 48.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae   Neisseriaceae 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);;