RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJEB8827" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 31 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB8827 · 31 ✖

analysis 1

  • diamond · 31 ✖
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
25529646 25529646 PRJEB8827e_S_NODE_3033_length_248_cov_526.253521_g3005_i0 PRJEB8827 3033 248 526.253521 1305.10873208 Flectobacillus roseus 502259 Bacteria Bacteria 77 4.26e-16   NR WP_283372260.1 502259 g3005 i0 97.6 0.508064516129032 42 1 50.8 0 235 110 18 59 WP_283372260.1 DUF3106 domain-containing protein [Flectobacillus roseus] diamond 126 77 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus roseus
25665700 25665700 PRJEB8827e_S_NODE_42818_length_152_cov_1.367521_g42790_i0 PRJEB8827 42818 152 1.367521 2.07863192 Pseudomonadati 3379134 Bacteria Bacteria 104 1.13e-24   NR WP_026899067.1 1122943 g42790 i0 100 15.7894736842105 50 0 98.7 0 1 150 14 63 WP_026899067.1 MFS transporter [Daejeonella oryzae] diamond 2400 104 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Daejeonella Daejeonella oryzae
25666347 25666347 PRJEB8827i_S_NODE_1538_length_199_cov_1605.176829_g1533_i0 PRJEB8827 1538 199 1605.176829 3194.30188971 Arcicella aurantiaca 591202 Bacteria Bacteria 87.8 2.68e-18   NR WP_109743479.1 591202 g1533 i0 88.7 0.798994974874372 53 6 79.9 0 167 9 476 528 WP_109743479.1 molecular chaperone DnaK [Arcicella aurantiaca] diamond 159 87.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Arcicella Arcicella aurantiaca
25753833 25753833 PRJEB8827e_S_NODE_1450_length_330_cov_1120.454237_g1422_i0 PRJEB8827 1450 330 1120.454237 3697.4989821 Bacteroidota 976 Bacteria Bacteria 90.9 3.17e-20   NR WP_095160744.1 976 g1422 i0 100 0.409090909090909 45 0 40.9 0 330 196 141 185 WP_095160744.1 MULTISPECIES: 50S ribosomal protein L5 [Bacteroidota] diamond 135 90.9 1 Bacteria FCB group Pseudomonadati Bacteroidota          
25801887 25801887 PRJEB8827e_S_NODE_7843_length_199_cov_1.969512_g7815_i0 PRJEB8827 7843 199 1.969512 3.91932888 Bacteroidota bacterium 1898104 Bacteria Bacteria 109 7.420000000000001e-26   NR MEM9981998.1 1898104 g7815 i0 86.4 9.94974874371859 66 9 99.5 0 2 199 269 334 MEM9981998.1 ATP-dependent Clp protease ATP-binding subunit [Bacteroidota bacterium] diamond 1980 109 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
25938640 25938640 PRJEB8827g_S_NODE_6380_length_170_cov_3.585185_g6359_i0 PRJEB8827 6380 170 3.585185 6.0948145 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 103 6.39e-26   NR WP_095160867.1 1509483 g6359 i0 98.2 0.988235294117647 56 1 98.8 0 169 2 149 204 WP_095160867.1 OmpH family outer membrane protein [Flectobacillus sp. BAB-3569] diamond 168 103 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569
26073792 26073792 PRJEB8827b_S_NODE_4037_length_214_cov_2.391061_g3985_i0 PRJEB8827 4037 214 2.391061 5.11687054 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 140 2.68e-40   NR WP_095160867.1 1509483 g3985 i0 100 0.995327102803738 71 0 99.5 0 213 1 107 177 WP_095160867.1 OmpH family outer membrane protein [Flectobacillus sp. BAB-3569] diamond 213 140 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569
26162067 26162067 PRJEB8827e_S_NODE_5021_length_217_cov_2.763736_g4993_i0 PRJEB8827 5021 217 2.763736 5.99730712 Cytophagales 768507 Bacteria Bacteria 90.9 1.25e-20   NR MEK0441899.1 1898104 g4993 i0 77.6 17.294930875576 58 13 80.2 0 216 43 132 189 MEK0441899.1 hypothetical protein [Bacteroidota bacterium] diamond 3753 91.7 0.991275899672846 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
26483030 26483030 PRJEB8827i_S_NODE_2552_length_185_cov_4.133333_g2547_i0 PRJEB8827 2552 185 4.133333 7.64666605 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 115 1.68e-30   NR WP_095160867.1 1509483 g2547 i0 100 0.989189189189189 61 0 98.9 0 1 183 140 200 WP_095160867.1 OmpH family outer membrane protein [Flectobacillus sp. BAB-3569] diamond 183 115 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569
32940507 32940507 PRJEB8827e_S_NODE_37425_length_161_cov_1.269841_g37397_i0 PRJEB8827 37425 161 1.269841 2.04444401 Bacteria 2 Bacteria Bacteria 100 2.5899999999999994e-23   NR MEO1653703.1 1898104 g37397 i0 88.7 5.92546583850932 53 6 98.8 0 161 3 156 208 MEO1653703.1 gliding motility lipoprotein GldJ [Bacteroidota bacterium] diamond 954 101 0.99009900990099 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
32948409 32948409 PRJEB8827f_S_NODE_1898_length_298_cov_3.011407_g1878_i0 PRJEB8827 1898 298 3.011407 8.97399286 Bacteroidota 976 Bacteria Bacteria 91.3 1.43e-20   NR WP_095160744.1 976 g1878 i0 100 0.453020134228188 45 0 45.3 0 296 162 141 185 WP_095160744.1 MULTISPECIES: 50S ribosomal protein L5 [Bacteroidota] diamond 135 91.3 1 Bacteria FCB group Pseudomonadati Bacteroidota          
32948546 32948546 PRJEB8827i_S_NODE_10866_length_152_cov_1.367521_g10861_i0 PRJEB8827 10866 152 1.367521 2.07863192 Flectobacillus roseus 502259 Bacteria Bacteria 56.6 4.77e-9   NR WP_283373042.1 502259 g10861 i0 93.8 0.631578947368421 32 2 63.2 0 112 17 1 32 WP_283373042.1 YtxH domain-containing protein [Flectobacillus roseus] diamond 96 56.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus roseus
32982627 32982627 PRJEB8827e_S_NODE_859_length_401_cov_4.953552_g831_i0 PRJEB8827 859 401 4.953552 19.86374352 Cellulophaga sp. BC115SP 2683263 Bacteria Bacteria 78.6 2.29e-15   NR WP_166552178.1 2683263 g831 i0 96.2 0.778054862842893 104 4 77.8 0 90 401 1 104 WP_166552178.1 hypothetical protein [Cellulophaga sp. BC115SP] diamond 312 78.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP
32982784 32982784 PRJEB8827h_S_NODE_40227_length_165_cov_7.376923_g40208_i0 PRJEB8827 40227 165 7.376923 12.17192295 Alistipes onderdonkii 328813 Bacteria Bacteria 41.2 0.0462   NR MEI3539360.1 328813 g40208 i0 47.4 0.690909090909091 38 20 69.1 0 10 123 245 282 MEI3539360.1 metallophosphoesterase N-terminal domain-containing protein [Alistipes onderdonkii] diamond 114 41.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Rikenellaceae Alistipes Alistipes onderdonkii
32982793 32982793 PRJEB8827i_S_NODE_3019_length_181_cov_1.664384_g3014_i0 PRJEB8827 3019 181 1.664384 3.01253504 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 95.1 5.57e-21   NR WP_095164255.1 1509483 g3014 i0 100 0.812154696132597 49 0 81.2 0 148 2 1 49 WP_095164255.1 sensor histidine kinase [Flectobacillus sp. BAB-3569] diamond 147 95.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569
32982794 32982794 PRJEB8827i_S_NODE_643_length_242_cov_11.347826_g638_i0 PRJEB8827 643 242 11.347826 27.46173892 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 43.1 0.025   NR WP_095160138.1 1509483 g638 i0 100 0.260330578512397 21 0 26 0 3 65 268 288 WP_095160138.1 tetratricopeptide repeat protein [Flectobacillus sp. BAB-3569] diamond 63 43.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569
32999336 32999336 PRJEB8827b_S_NODE_2643_length_228_cov_2.989637_g2591_i0 PRJEB8827 2643 228 2.989637 6.81637236 Bacteroidota 976 Bacteria Bacteria 84.7 5.21e-19   NR WP_166551422.1 976 g2591 i0 100 0.618421052631579 47 0 61.8 0 197 57 1 47 WP_166551422.1 MULTISPECIES: hypothetical protein [Bacteroidota] diamond 141 84.7 1 Bacteria FCB group Pseudomonadati Bacteroidota          
32999625 32999625 PRJEB8827f_S_NODE_9027_length_184_cov_3.342282_g9007_i0 PRJEB8827 9027 184 3.342282 6.14979888 Alistipes onderdonkii 328813 Bacteria Bacteria 44.3 0.00454   NR MEI3539360.1 328813 g9007 i0 46.5 0.701086956521739 43 23 70.1 0 176 48 240 282 MEI3539360.1 metallophosphoesterase N-terminal domain-containing protein [Alistipes onderdonkii] diamond 129 44.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Rikenellaceae Alistipes Alistipes onderdonkii
33016547 33016547 PRJEB8827e_S_NODE_37436_length_161_cov_0.952381_g37408_i0 PRJEB8827 37436 161 0.952381 1.53333341 Saprospirales bacterium 2026790 Bacteria Bacteria 59.7 1.06e-8   NR MAT56025.1 2026790 g37408 i0 77.1 1.30434782608696 35 8 65.2 0 159 55 215 249 MAT56025.1 hypothetical protein [Saprospirales bacterium] diamond 210 59.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales     Saprospirales bacterium
33033505 33033505 PRJEB8827b_S_NODE_1604_length_254_cov_15.091324_g1552_i0 PRJEB8827 1604 254 15.091324 38.33196296 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 52.4 1.49e-5   NR WP_095160138.1 1509483 g1552 i0 100 0.318897637795276 27 0 31.9 0 252 172 262 288 WP_095160138.1 tetratricopeptide repeat protein [Flectobacillus sp. BAB-3569] diamond 81 52.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569
33033617 33033617 PRJEB8827e_S_NODE_39356_length_158_cov_1.300813_g39328_i0 PRJEB8827 39356 158 1.300813 2.05528454 unclassified Arcicella 2644986 Bacteria Bacteria 63.2 7.65e-11   NR WP_309912918.1 2644986 g39328 i0 100 0.531645569620253 28 0 53.2 0 156 73 113 140 WP_309912918.1 MULTISPECIES: hypothetical protein [unclassified Arcicella] diamond 84 63.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Arcicella  
33067651 33067651 PRJEB8827e_S_NODE_3693_length_233_cov_4.792929_g3665_i0 PRJEB8827 3693 233 4.792929 11.16752457 Microscillaceae bacterium 2053581 Bacteria Bacteria 62 9.48e-10   NR MCU0446465.1 2053581 g3665 i0 45.8 0.927038626609442 72 36 88.8 1 231 25 52 123 MCU0446465.1 DUF4890 domain-containing protein [Microscillaceae bacterium] diamond 216 62 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Microscillaceae   Microscillaceae bacterium
33084793 33084793 PRJEB8827e_S_NODE_39886_length_157_cov_2.008197_g39858_i0 PRJEB8827 39886 157 2.008197 3.15286929 Crocinitomix sp. 2039232 Bacteria Bacteria 54.3 9.04e-7   NR MFT5822449.1 2039232 g39858 i0 51 1.94904458598726 51 24 97.5 1 3 155 1 50 MFT5822449.1 tetraacyldisaccharide 4'-kinase [Crocinitomix sp.] diamond 306 54.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Crocinitomicaceae Crocinitomix Crocinitomix sp.
33128239 33128239 PRJEB8827g_S_NODE_871_length_306_cov_8.402214_g850_i0 PRJEB8827 871 306 8.402214 25.71077484 Bacteroidota 976 Bacteria Bacteria 66.6 3.27e-11   NR WP_166552178.1 2683263 g850 i0 98 1.32352941176471 51 1 50 0 41 193 1 51 WP_166552178.1 hypothetical protein [Cellulophaga sp. BC115SP] diamond 405 66.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP
33135876 33135876 PRJEB8827e_S_NODE_2127_length_283_cov_3.205645_g2099_i0 PRJEB8827 2127 283 3.205645 9.07197535 Bacteroidota bacterium 1898104 Bacteria Bacteria 64.7 9.66e-11   NR TAE76024.1 1898104 g2099 i0 53.5 0.752650176678445 71 32 75.3 1 6 218 1 70 TAE76024.1 MAG: BON domain-containing protein [Bacteroidota bacterium] diamond 213 64.7 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
33135906 33135906 PRJEB8827e_S_NODE_2903_length_252_cov_4.543779_g2875_i0 PRJEB8827 2903 252 4.543779 11.45032308 Cytophagia bacterium 2026730 Bacteria Bacteria 65.9 9.12e-11   NR TAF99205.1 2026730 g2875 i0 62.5 1.14285714285714 48 18 57.1 0 238 95 147 194 TAF99205.1 MAG: translation initiation factor IF-3 [Cytophagia bacterium] diamond 288 65.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia       Cytophagia bacterium
33145344 33145344 PRJEB8827i_S_NODE_1039_length_213_cov_2.544944_g1034_i0 PRJEB8827 1039 213 2.544944 5.42073072 Bacteroidota 976 Bacteria Bacteria 65.5 3.02e-11   NR WP_166552178.1 2683263 g1034 i0 100 1.35211267605634 32 0 45.1 0 156 61 1 32 WP_166552178.1 hypothetical protein [Cellulophaga sp. BC115SP] diamond 288 65.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP
33152898 33152898 PRJEB8827b_S_NODE_40624_length_156_cov_1.462810_g40572_i0 PRJEB8827 40624 156 1.46281 2.2819836 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 101 1.67e-24   NR WP_095160138.1 1509483 g40572 i0 100 0.980769230769231 51 0 98.1 0 3 155 219 269 WP_095160138.1 tetratricopeptide repeat protein [Flectobacillus sp. BAB-3569] diamond 153 101 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569
33153052 33153052 PRJEB8827e_S_NODE_5480_length_213_cov_2.674157_g5452_i0 PRJEB8827 5480 213 2.674157 5.69595441 Microscillaceae bacterium 2053581 Bacteria Bacteria 80.5 1.74e-17   NR MCU0445920.1 2053581 g5452 i0 63.8 0.971830985915493 69 24 95.8 1 209 6 30 98 MCU0445920.1 hypothetical protein [Microscillaceae bacterium] diamond 207 80.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Microscillaceae   Microscillaceae bacterium
33170235 33170235 PRJEB8827f_S_NODE_34368_length_153_cov_1.762712_g34348_i0 PRJEB8827 34368 153 1.762712 2.69694936 Flectobacillus sp. BAB-3569 1509483 Bacteria Bacteria 95.1 1.9e-22   NR WP_095164159.1 1509483 g34348 i0 100 0.980392156862745 50 0 98 0 2 151 30 79 WP_095164159.1 LysM peptidoglycan-binding domain-containing protein [Flectobacillus sp. BAB-3569] diamond 150 95.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Flectobacillus Flectobacillus sp. BAB-3569
33170345 33170345 PRJEB8827i_S_NODE_584_length_249_cov_2.649533_g579_i0 PRJEB8827 584 249 2.649533 6.59733717 Bacteroidota 976 Bacteria Bacteria 79 1.28e-16   NR WP_166551422.1 976 g579 i0 100 0.518072289156627 43 0 51.8 0 233 105 1 43 WP_166551422.1 MULTISPECIES: hypothetical protein [Bacteroidota] diamond 129 79 1 Bacteria FCB group Pseudomonadati Bacteroidota          

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