RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJEB4632" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Bacteria · 30 ✖

bioproject 1

  • PRJEB4632 · 30 ✖

analysis 1

  • diamond · 30 ✖
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
9918226 9918226 PRJEB4632_P_NODE_768_length_251_cov_0.865169_g730_i0 PRJEB4632 768 251 0.865169 2.17157419 Curvibacter lanceolatus 86182 Bacteria Bacteria 166 1.64e-45   NR WP_019575978.1 86182 g730 i0 98.8 0.99203187250996006 83 1 99.2 0 251 3 526 608 WP_019575978.1 multidrug efflux RND transporter permease subunit [Curvibacter lanceolatus] diamond 249 166 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Curvibacter Curvibacter lanceolatus
11539804 11539804 PRJEB4632_P_NODE_770_length_251_cov_0.865169_g732_i0 PRJEB4632 770 251 0.865169 2.17157419 Rubrivivax albus 2499835 Bacteria Bacteria 148 9.21e-42   NR WP_199232348.1 2499835 g732 i0 84.3 2.97609561752988 83 13 99.2 0 250 2 111 193 WP_199232348.1 relaxase/mobilization nuclease domain-containing protein [Rubrivivax albus] diamond 747 148 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Rubrivivax Rubrivivax albus
11539807 11539807 PRJEB4632_P_NODE_950_length_243_cov_0.905882_g912_i0 PRJEB4632 950 243 0.905882 2.20129326 Simplicispira psychrophila 80882 Bacteria Bacteria 159 5.4e-47   NR WP_027995927.1 80882 g912 i0 96.3 0.987654320987654 80 3 98.8 0 2 241 24 103 WP_027995927.1 heavy metal response regulator transcription factor [Simplicispira psychrophila] diamond 240 159 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Simplicispira Simplicispira psychrophila
15363798 15363798 PRJEB4632_P_NODE_773_length_251_cov_0.865169_g735_i0 PRJEB4632 773 251 0.865169 2.17157419 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 156 1.5e-44   NR HUU35878.1 2910147 g735 i0 91.6 0.99203187250996006 83 7 99.2 0 250 2 66 148 HUU35878.1 PstS family phosphate ABC transporter substrate-binding protein [Vicinamibacterales bacterium] diamond 249 156 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
24287395 24287395 PRJEB4632_P_NODE_860_length_247_cov_0.885057_g822_i0 PRJEB4632 860 247 0.885057 2.18609079 Sphingobacteriia bacterium 2035813 Bacteria Bacteria 162 2.8899999999999996e-47   NR MBN8837246.1 2035813 g822 i0 100 0.995951417004049 82 0 99.6 0 1 246 79 160 MBN8837246.1 nitronate monooxygenase [Sphingobacteriia bacterium] diamond 246 162 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia       Sphingobacteriia bacterium
27033440 27033440 PRJEB4632_P_NODE_982_length_241_cov_0.916667_g944_i0 PRJEB4632 982 241 0.916667 2.20916747 Pseudomonadota bacterium 1977087 Bacteria Bacteria 160 8.98e-46   NR MBS0422071.1 1977087 g944 i0 92.4 0.983402489626556 79 6 98.3 0 1 237 244 322 MBS0422071.1 beta-lactamase family protein [Pseudomonadota bacterium] diamond 237 160 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27981121 27981121 PRJEB4632_P_NODE_905_length_244_cov_0.900585_g867_i0 PRJEB4632 905 244 0.900585 2.1974274 Candidatus Adlerbacteria bacterium 1932010 Bacteria Bacteria 64.3 2.76e-10   NR MDB5224523.1 1932010 g867 i0 63.8 0.577868852459016 47 17 57.8 0 242 102 162 208 MDB5224523.1 hypothetical protein [Candidatus Adlerbacteria bacterium] diamond 141 64.3 1 Bacteria Bacteria candidate phyla   Candidatus Adleribacteriota         Candidatus Adlerbacteria bacterium
28226711 28226711 PRJEB4632_P_NODE_786_length_250_cov_0.870056_g748_i0 PRJEB4632 786 250 0.870056 2.17514 Bacteria 2 Bacteria Bacteria 119 9.68e-33   NR MBK9285026.1 2021370 g748 i0 63.9 3.984 83 30 99.6 0 249 1 18 100 MBK9285026.1 hypothetical protein [Sphingobacteriaceae bacterium] diamond 996 120 0.991666666666667 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae   Sphingobacteriaceae bacterium
28707377 28707377 PRJEB4632_P_NODE_1047_length_227_cov_2.090909_g1009_i0 PRJEB4632 1047 227 2.090909 4.74636343 Actinacidiphila rubida 310780 Bacteria Bacteria 42.4 0.00936   NR WP_176735615.1 310780 g1009 i0 42.6 1.4273127753304 54 28 71.4 1 203 42 28 78 WP_176735615.1 NAD(P)-binding domain-containing protein, partial [Actinacidiphila rubida] diamond 324 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Actinacidiphila Actinacidiphila rubida
28770366 28770366 PRJEB4632_P_NODE_827_length_248_cov_0.880000_g789_i0 PRJEB4632 827 248 0.88 2.1824 Novosphingobium sp. BL-8A 3127639 Bacteria Bacteria 48.1 5.15e-4   NR WP_395392807.1 3127639 g789 i0 59 0.943548387096774 39 16 47.2 0 248 132 201 239 WP_395392807.1 Ig-like domain-containing protein [Novosphingobium sp. BL-8A] diamond 234 48.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Novosphingobium Novosphingobium sp. BL-8A
28801786 28801786 PRJEB4632_P_NODE_868_length_246_cov_0.890173_g830_i0 PRJEB4632 868 246 0.890173 2.18982558 Bdellovibrionales bacterium RIFOXYD1_FULL_53_11 1797403 Bacteria Bacteria 155 1.62e-43   NR OFZ79974.1 1797403 g830 i0 87.8 2 82 10 100 0 1 246 244 325 OFZ79974.1 MAG: adenylosuccinate lyase [Bdellovibrionales bacterium RIFOXYD1_FULL_53_11] diamond 492 155 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium RIFOXYD1_FULL_53_11
28896589 28896589 PRJEB4632_P_NODE_948_length_243_cov_0.905882_g910_i0 PRJEB4632 948 243 0.905882 2.20129326 Curvibacter gracilis 230310 Bacteria Bacteria 155 3.3299999999999996e-45   NR WP_027476396.1 230310 g910 i0 98.8 1 81 1 100 0 243 1 130 210 WP_027476396.1 flagellar basal-body rod protein FlgF [Curvibacter gracilis] diamond 243 155 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Curvibacter Curvibacter gracilis
28960103 28960103 PRJEB4632_P_NODE_988_length_241_cov_0.916667_g950_i0 PRJEB4632 988 241 0.916667 2.20916747 unclassified Sphingomonas 196159 Bacteria Bacteria 172 3.23e-53   NR WP_033965179.1 196159 g950 i0 100 0.983402489626556 79 0 98.3 0 3 239 49 127 WP_033965179.1 MULTISPECIES: rod shape-determining protein MreD [unclassified Sphingomonas] diamond 237 172 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas  
29212649 29212649 PRJEB4632_P_NODE_789_length_250_cov_0.870056_g751_i0 PRJEB4632 789 250 0.870056 2.17514 Bacteroidota bacterium 1898104 Bacteria Bacteria 98.6 3.96e-24   NR MBS1650605.1 1898104 g751 i0 83.1 0.708 59 10 70.8 0 178 2 1 59 MBS1650605.1 DoxX family protein [Bacteroidota bacterium] diamond 177 98.6 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
29275458 29275458 PRJEB4632_P_NODE_829_length_248_cov_0.880000_g791_i0 PRJEB4632 829 248 0.88 2.1824 Ferruginibacter sp. 1940288 Bacteria Bacteria 62.8 7.01e-10   NR HRD43728.1 1940288 g791 i0 38.3 1.93548387096774 81 47 98 1 244 2 88 165 HRD43728.1 hypothetical protein [Ferruginibacter sp.] diamond 480 62.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Ferruginibacter Ferruginibacter sp.
29338857 29338857 PRJEB4632_P_NODE_949_length_243_cov_0.905882_g911_i0 PRJEB4632 949 243 0.905882 2.20129326 Cellulomonas humilata 144055 Bacteria Bacteria 105 3.03e-24   NR WP_175347822.1 144055 g911 i0 95.2 0.765432098765432 62 3 76.5 0 2 187 689 750 WP_175347822.1 glycogen debranching protein GlgX [Cellulomonas humilata] diamond 186 105 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Cellulomonadaceae Cellulomonas Cellulomonas humilata
29843940 29843940 PRJEB4632_P_NODE_791_length_250_cov_0.870056_g753_i0 PRJEB4632 791 250 0.870056 2.17514 uncultured Quadrisphaera sp. 904978 Bacteria Bacteria 43.1 0.0299   NR CAA9422658.1 904978 g753 i0 45.6 0.948 79 35 87.6 4 238 20 247 323 CAA9422658.1 MAG: 2-isopropylmalate synthase, partial [uncultured Quadrisphaera sp.] diamond 237 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kineosporiales Kineosporiaceae Quadrisphaera uncultured Quadrisphaera sp.
29970280 29970280 PRJEB4632_P_NODE_891_length_245_cov_0.895349_g853_i0 PRJEB4632 891 245 0.895349 2.19360505 Lentisphaerae bacterium GWF2_44_16 1798571 Bacteria Bacteria 48.5 1.44e-4   NR OGV49611.1 1798571 g853 i0 43.4 0.648979591836735 53 30 64.9 0 2 160 103 155 OGV49611.1 MAG: hypothetical protein A2017_16305 [Lentisphaerae bacterium GWF2_44_16] diamond 159 48.5 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerae bacterium GWF2_44_16
30002041 30002041 PRJEB4632_P_NODE_931_length_243_cov_0.905882_g893_i0 PRJEB4632 931 243 0.905882 2.20129326 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 115 1.2099999999999999e-27   NR MET0634462.1 1869212 g893 i0 76.8 1.01234567901235 82 18 100 1 1 243 215 296 MET0634462.1 hypothetical protein [Chitinophagaceae bacterium] diamond 246 115 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
30033601 30033601 PRJEB4632_P_NODE_951_length_243_cov_0.905882_g913_i0 PRJEB4632 951 243 0.905882 2.20129326 Polyangiaceae bacterium 2268199 Bacteria Bacteria 58.2 1.31e-7   NR NOU34320.1 2268199 g913 i0 56.3 0.592592592592593 48 21 59.3 0 80 223 361 408 NOU34320.1 hypothetical protein [Polyangiaceae bacterium] diamond 144 58.2 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
30127987 30127987 PRJEB4632_P_NODE_812_length_249_cov_0.875000_g774_i0 PRJEB4632 812 249 0.875 2.17875 Caldisericia bacterium 2758719 Bacteria Bacteria 58.9 7.28e-8   NR HQJ57415.1 2758719 g774 i0 51 0.590361445783133 49 24 59 0 101 247 137 185 HQJ57415.1 toprim domain-containing protein [Caldisericia bacterium] diamond 147 58.9 1 Bacteria Caldisericota/Cryosericota group Pseudomonadati Caldisericota Caldisericia       Caldisericia bacterium
30286682 30286682 PRJEB4632_P_NODE_972_length_242_cov_0.911243_g934_i0 PRJEB4632 972 242 0.911243 2.20520806 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 143 2.71e-42   NR HEX4888938.1 1913988 g934 i0 82.3 2.93801652892562 79 14 97.9 0 237 1 10 88 HEX4888938.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 711 143 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
31076256 31076256 PRJEB4632_P_NODE_935_length_243_cov_0.905882_g897_i0 PRJEB4632 935 243 0.905882 2.20129326 Lentisphaerota bacterium 1932692 Bacteria Bacteria 147 6.3e-41   NR MBN1556907.1 1932692 g897 i0 82.7 6 81 14 100 0 243 1 25 105 MBN1556907.1 sugar kinase [Lentisphaerota bacterium] diamond 1458 147 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
31417254 31417254 PRJEB4632_P_NODE_896_length_245_cov_0.895349_g858_i0 PRJEB4632 896 245 0.895349 2.19360505 Pseudomonadati 3379134 Bacteria Bacteria 125 4.2499999999999996e-32   NR HBA09945.1 359408 g858 i0 73.8 4.9469387755102 80 20 98 1 244 5 118 196 HBA09945.1 PBSX family phage terminase large subunit [Methylotenera mobilis] diamond 1212 125 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylotenera Methylotenera mobilis
31701913 31701913 PRJEB4632_P_NODE_937_length_243_cov_0.905882_g899_i0 PRJEB4632 937 243 0.905882 2.20129326 Bacteria 2 Bacteria Bacteria 82.8 1.33e-16   NR MSU67472.1 2006848 g899 i0 92.9 1.03703703703704 42 3 51.9 0 3 128 290 331 MSU67472.1 MBL fold metallo-hydrolase [Opitutaceae bacterium] diamond 252 82.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
31866560 31866560 PRJEB4632_P_NODE_797_length_250_cov_0.870056_g759_i0 PRJEB4632 797 250 0.870056 2.17514 Bacteroidota bacterium 1898104 Bacteria Bacteria 87.8 4.78e-19   NR MEI6489353.1 1898104 g759 i0 61.8 0.816 68 25 80.4 1 5 205 89 156 MEI6489353.1 hypothetical protein [Bacteroidota bacterium] diamond 204 87.8 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31923289 31923289 PRJEB4632_P_NODE_817_length_249_cov_0.875000_g779_i0 PRJEB4632 817 249 0.875 2.17875 Bacteria 2 Bacteria Bacteria 139 2.18e-38   NR PIU40455.1 1974742 g779 i0 88 2 83 10 100 0 1 249 190 272 PIU40455.1 MAG: amino acid transporter, partial [Candidatus Omnitrophica bacterium CG07_land_8_20_14_0_80_50_8] diamond 498 139 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophica bacterium CG07_land_8_20_14_0_80_50_8
31961585 31961585 PRJEB4632_P_NODE_838_length_248_cov_0.880000_g800_i0 PRJEB4632 838 248 0.88 2.1824 Elusimicrobiaceae bacterium 2735568 Bacteria Bacteria 99.8 2.0600000000000001e-22   NR MBR2392244.1 2735568 g800 i0 55.7 0.955645161290323 79 35 95.6 0 239 3 40 118 MBR2392244.1 ParB N-terminal domain-containing protein [Elusimicrobiaceae bacterium] diamond 237 99.8 1 Bacteria   Pseudomonadati Elusimicrobiota Elusimicrobia Elusimicrobiales Elusimicrobiaceae   Elusimicrobiaceae bacterium
32563095 32563095 PRJEB4632_P_NODE_759_length_251_cov_0.865169_g721_i0 PRJEB4632 759 251 0.865169 2.17157419 Bacteroidota bacterium 1898104 Bacteria Bacteria 144 1.02e-39   NR MBS1637978.1 1898104 g721 i0 77.1 0.99203187250996006 83 19 99.2 0 251 3 198 280 MBS1637978.1 acyl-CoA reductase [Bacteroidota bacterium] diamond 249 144 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
32846168 32846168 PRJEB4632_P_NODE_940_length_243_cov_0.905882_g902_i0 PRJEB4632 940 243 0.905882 2.20129326 Sphingobacteriaceae bacterium 2021370 Bacteria Bacteria 157 2.78e-47   NR RYZ92345.1 2021370 g902 i0 100 0.950617283950617 77 0 95.1 0 7 237 61 137 RYZ92345.1 MAG: hypothetical protein EOP47_30425, partial [Sphingobacteriaceae bacterium] diamond 231 157 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae   Sphingobacteriaceae 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);;