RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJEB12296" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 26 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB12296 · 26 ✖

analysis 1

  • diamond · 26 ✖
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
25636580 25636580 PRJEB12296_S_NODE_3658_length_237_cov_2.232673_g3626_i0 PRJEB12296 3658 237 2.232673 5.29143501 Flectobacillus 101 Bacteria Bacteria 151 1.5499999999999996e-43   NR WP_283326255.1 101 g3626 i0 100 1.84810126582278 73 0 92.4 0 2 220 175 247 WP_283326255.1 MULTISPECIES: (Fe-S)-binding protein [Flectobacillus] diamond 438 151 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus  
25636605 25636605 PRJEB12296_S_NODE_426_length_478_cov_268.905192_g399_i0 PRJEB12296 426 478 268.905192 1285.36681776 Pseudarcicella hirudinis 1079859 Bacteria Bacteria 71.6 4.99e-12   NR WP_092018056.1 1079859 g399 i0 100 0.50836820083682 81 0 50.8 0 402 160 1 81 WP_092018056.1 hypothetical protein [Pseudarcicella hirudinis] diamond 243 71.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Pseudarcicella Pseudarcicella hirudinis
25908940 25908940 PRJEB12296_S_NODE_372_length_497_cov_398.803030_g345_i0 PRJEB12296 372 497 398.80303 1982.0510591 Flectobacillus roseus 502259 Bacteria Bacteria 255 1.12e-77   NR WP_283346766.1 502259 g345 i0 99.3 0.82092555331992 136 1 82.1 0 463 56 476 611 WP_283346766.1 catalase/peroxidase HPI [Flectobacillus roseus] diamond 408 255 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus roseus
25908941 25908941 PRJEB12296_S_NODE_3740_length_235_cov_3.650000_g3708_i0 PRJEB12296 3740 235 3.65 8.5775 Arcicella aurantiaca 591202 Bacteria Bacteria 103 2.1e-25   NR WP_109742166.1 591202 g3708 i0 92.9 0.714893617021277 56 4 71.5 0 44 211 1 56 WP_109742166.1 30S ribosomal protein S4 [Arcicella aurantiaca] diamond 168 103 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Arcicella Arcicella aurantiaca
26045080 26045080 PRJEB12296_S_NODE_477_length_459_cov_61.054245_g449_i0 PRJEB12296 477 459 61.054245 280.23898455 Bacteroidota 976 Bacteria Bacteria 180 1.36e-54   NR WP_095160744.1 976 g449 i0 100 0.581699346405229 89 0 58.2 0 459 193 97 185 WP_095160744.1 MULTISPECIES: 50S ribosomal protein L5 [Bacteroidota] diamond 267 180 1 Bacteria FCB group Pseudomonadati Bacteroidota          
26181319 26181319 PRJEB12296_S_NODE_8446_length_180_cov_2.441379_g8414_i0 PRJEB12296 8446 180 2.441379 4.3944822 Bacteroidota 976 Bacteria Bacteria 100 1.12e-25   NR WP_095160741.1 976 g8414 i0 100 0.866666666666667 52 0 86.7 0 3 158 64 115 WP_095160741.1 MULTISPECIES: 50S ribosomal protein L18 [Bacteroidota] diamond 156 100 1 Bacteria FCB group Pseudomonadati Bacteroidota          
26423117 26423117 PRJEB12296_S_NODE_1087_length_356_cov_17187.940810_g1055_i0 PRJEB12296 1087 356 17187.94081 61189.0692836 Flectobacillaceae 3141701 Bacteria Bacteria 144 3.199999999999999e-41   NR WP_026995258.1 103 g1055 i0 86.7 1.51685393258427 90 10 75 2 314 48 1 89 WP_026995258.1 translation initiation factor IF-3 [Flectobacillus major] diamond 540 145 0.993103448275862 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus major
26453079 26453079 PRJEB12296_S_NODE_11632_length_167_cov_1.439394_g11600_i0 PRJEB12296 11632 167 1.439394 2.40378798 Cellulophaga sp. BC115SP 2683263 Bacteria Bacteria 112 2.32e-29   NR WP_166552957.1 2683263 g11600 i0 100 0.988023952095808 55 0 98.8 0 1 165 103 157 WP_166552957.1 NAD(P)H-dependent oxidoreductase [Cellulophaga sp. BC115SP] diamond 165 112 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP
26453286 26453286 PRJEB12296_S_NODE_6360_length_195_cov_6481.581250_g6328_i0 PRJEB12296 6360 195 6481.58125 12639.0834375 Arcicella rigui 797020 Bacteria Bacteria 67.8 6.51e-13   NR WP_323296949.1 797020 g6328 i0 91.9 0.569230769230769 37 3 56.9 0 73 183 1 37 WP_323296949.1 co-chaperone GroES [Arcicella rigui] diamond 111 67.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Arcicella Arcicella rigui
32925098 32925098 PRJEB12296_S_NODE_10009_length_173_cov_1.072464_g9977_i0 PRJEB12296 10009 173 1.072464 1.85536272 unclassified Arcicella 2644986 Bacteria Bacteria 103 8.250000000000001e-26   NR WP_309913441.1 2644986 g9977 i0 100 0.988439306358382 57 0 98.8 0 173 3 21 77 WP_309913441.1 MULTISPECIES: LysM peptidoglycan-binding domain-containing protein [unclassified Arcicella] diamond 171 103 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Arcicella  
32925124 32925124 PRJEB12296_S_NODE_15489_length_157_cov_2.065574_g15457_i0 PRJEB12296 15489 157 2.065574 3.24295118 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 46.6 5.12e-4   NR WP_095160422.1 1509483 g15457 i0 96.6 0.554140127388535 29 1 55.4 0 103 17 1 29 WP_095160422.1 1,4-alpha-glucan branching protein GlgB [Flectobacillus sp. BAB-3569] diamond 87 46.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569
32925174 32925174 PRJEB12296_S_NODE_505_length_450_cov_342.648193_g477_i0 PRJEB12296 505 450 342.648193 1541.9168685 Cellulophaga sp. BC115SP 2683263 Bacteria Bacteria 84.3 2.21e-17   NR WP_166552178.1 2683263 g477 i0 95.4 0.72 108 5 72 0 325 2 1 108 WP_166552178.1 hypothetical protein [Cellulophaga sp. BC115SP] diamond 324 84.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP
32942331 32942331 PRJEB12296_S_NODE_1474_length_326_cov_15.601375_g1442_i0 PRJEB12296 1474 326 15.601375 50.8604825 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 183 2.5199999999999997e-56   NR WP_095160867.1 1509483 g1442 i0 100 0.892638036809816 97 0 89.3 0 326 36 106 202 WP_095160867.1 OmpH family outer membrane protein [Flectobacillus sp. BAB-3569] diamond 291 183 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569
32976594 32976594 PRJEB12296_S_NODE_10003_length_173_cov_1.253623_g9971_i0 PRJEB12296 10003 173 1.253623 2.16876779 Cellulophaga sp. BC115SP 2683263 Bacteria Bacteria 57.4 9.56e-8   NR WP_166551595.1 2683263 g9971 i0 100 0.502890173410405 29 0 50.3 0 89 3 1 29 WP_166551595.1 efflux RND transporter periplasmic adaptor subunit [Cellulophaga sp. BC115SP] diamond 87 57.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP
32976617 32976617 PRJEB12296_S_NODE_13411_length_162_cov_2.070866_g13379_i0 PRJEB12296 13411 162 2.070866 3.35480292 Cellulophaga sp. BC115SP 2683263 Bacteria Bacteria 114 5.77e-28   NR WP_166549526.1 2683263 g13379 i0 100 1 54 0 100 0 162 1 304 357 WP_166549526.1 PAS domain-containing hybrid sensor histidine kinase/response regulator [Cellulophaga sp. BC115SP] diamond 162 114 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP
32976638 32976638 PRJEB12296_S_NODE_1891_length_300_cov_3.852830_g1859_i0 PRJEB12296 1891 300 3.85283 11.55849 Pseudarcicella hirudinis 1079859 Bacteria Bacteria 133 2.17e-37   NR WP_092018971.1 1079859 g1859 i0 100 0.99 99 0 99 0 1 297 16 114 WP_092018971.1 hypothetical protein [Pseudarcicella hirudinis] diamond 297 133 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Pseudarcicella Pseudarcicella hirudinis
32993620 32993620 PRJEB12296_S_NODE_5571_length_204_cov_1.958580_g5539_i0 PRJEB12296 5571 204 1.95858 3.9955032 Cellulophaga sp. BC115SP 2683263 Bacteria Bacteria 101 3.789999999999999e-23   NR WP_166551194.1 2683263 g5539 i0 96.4 0.808823529411765 55 2 80.9 0 204 40 299 353 WP_166551194.1 replication initiation protein [Cellulophaga sp. BC115SP] diamond 165 101 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP
32993628 32993628 PRJEB12296_S_NODE_6643_length_193_cov_2.132911_g6611_i0 PRJEB12296 6643 193 2.132911 4.11651823 Pseudarcicella hirudinis 1079859 Bacteria Bacteria 76.6 4.4e-15   NR WP_092017697.1 1079859 g6611 i0 100 0.637305699481865 41 0 63.7 0 168 46 47 87 WP_092017697.1 LysM peptidoglycan-binding domain-containing protein [Pseudarcicella hirudinis] diamond 123 76.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Pseudarcicella Pseudarcicella hirudinis
33010632 33010632 PRJEB12296_S_NODE_16372_length_155_cov_1.700000_g16340_i0 PRJEB12296 16372 155 1.7 2.635 Bacteroidota 976 Bacteria Bacteria 61.6 3.1e-10   NR WP_166550042.1 976 g16340 i0 70.6 0.987096774193548 51 15 98.7 0 2 154 75 125 WP_166550042.1 MULTISPECIES: hypothetical protein [Bacteroidota] diamond 153 61.6 1 Bacteria FCB group Pseudomonadati Bacteroidota          
33027735 33027735 PRJEB12296_S_NODE_16820_length_154_cov_1.588235_g16788_i0 PRJEB12296 16820 154 1.588235 2.4458819 Flectobacillus roseus 502259 Bacteria Bacteria 104 9.91e-27   NR WP_283345075.1 502259 g16788 i0 100 1.92857142857143 49 0 95.5 0 6 152 117 165 WP_283345075.1 hypothetical protein [Flectobacillus roseus] diamond 297 104 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus roseus
33027780 33027780 PRJEB12296_S_NODE_5580_length_204_cov_1.390533_g5548_i0 PRJEB12296 5580 204 1.390533 2.83668732 Flectobacillus longus 2984207 Bacteria Bacteria 139 5.85e-41   NR WP_283371586.1 2984207 g5548 i0 98.4 0.911764705882353 62 1 91.2 0 188 3 18 79 WP_283371586.1 hypothetical protein [Flectobacillus longus] diamond 186 139 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus longus
33041875 33041875 PRJEB12296_S_NODE_7516_length_186_cov_2.867550_g7484_i0 PRJEB12296 7516 186 2.86755 5.333643 Flectobacillus 101 Bacteria Bacteria 88.6 1.02e-18   NR WP_095161254.1 101 g7484 i0 88.5 2.01612903225806 61 7 98.4 0 2 184 323 383 WP_095161254.1 MULTISPECIES: efflux RND transporter periplasmic adaptor subunit [Flectobacillus] diamond 375 88.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus  
33044767 33044767 PRJEB12296_S_NODE_6725_length_192_cov_4.949045_g6693_i0 PRJEB12296 6725 192 4.949045 9.5021664 Pseudarcicella hirudinis 1079859 Bacteria Bacteria 90.1 2.43e-20   NR SFP43801.1 1079859 g6693 i0 98.1 0.828125 53 1 82.8 0 171 13 84 136 SFP43801.1 large subunit ribosomal protein L27 [Pseudarcicella hirudinis] diamond 159 90.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Pseudarcicella Pseudarcicella hirudinis
33112866 33112866 PRJEB12296_S_NODE_1039_length_361_cov_2.355828_g1007_i0 PRJEB12296 1039 361 2.355828 8.50453908 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 148 4.1399999999999996e-42   NR WP_095164159.1 1509483 g1007 i0 100 0.6398891966759 77 0 64 0 72 302 1 77 WP_095164159.1 LysM peptidoglycan-binding domain-containing protein [Flectobacillus sp. BAB-3569] diamond 231 148 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569
33112876 33112876 PRJEB12296_S_NODE_11647_length_167_cov_1.212121_g11615_i0 PRJEB12296 11647 167 1.212121 2.02424207 Flectobacillus longus 2984207 Bacteria Bacteria 105 1.13e-24   NR WP_283369865.1 2984207 g11615 i0 100 0.988023952095808 55 0 98.8 0 165 1 40 94 WP_283369865.1 gliding motility protein GldM [Flectobacillus longus] diamond 165 105 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus longus
33164107 33164107 PRJEB12296_S_NODE_432_length_476_cov_22.301587_g405_i0 PRJEB12296 432 476 22.301587 106.15555412 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 162 2.13e-46   NR WP_095160138.1 1509483 g405 i0 100 0.529411764705882 84 0 52.9 0 3 254 205 288 WP_095160138.1 tetratricopeptide repeat protein [Flectobacillus sp. BAB-3569] diamond 252 162 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569

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