RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA638724" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 16 ✖

bioproject 1

  • PRJNA638724 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
4437306 4437306 PRJNA638724_P_NODE_4924_length_286_cov_1.314554_g4838_i0 PRJNA638724 4924 286 1.314554 3.75962444 Acinetobacter bereziniae 106648 Bacteria Bacteria 160 1.9099999999999998e-47   NR WP_333515275.1 106648 g4838 i0 91.2 0.954545454545455 91 8 95.5 0 274 2 11 101 WP_333515275.1 AAA family ATPase [Acinetobacter bereziniae] diamond 273 160 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter bereziniae
26985990 26985990 PRJNA638724_P_NODE_6882_length_248_cov_0.880000_g6796_i0 PRJNA638724 6882 248 0.88 2.1824 Corynebacterium urealyticum 43771 Bacteria Bacteria 50.4 7.24e-5   NR WP_148813241.1 43771 g6796 i0 45.3 0.774193548387097 64 35 77.4 0 196 5 73 136 WP_148813241.1 C40 family peptidase [Corynebacterium urealyticum] diamond 192 50.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium urealyticum
27017709 27017709 PRJNA638724_P_NODE_7682_length_237_cov_2.695122_g7596_i0 PRJNA638724 7682 237 2.695122 6.38743914 Massilistercora timonensis 2086584 Bacteria Bacteria 45.4 0.00158   NR WP_106790073.1 2086584 g7596 i0 41.2 0.645569620253165 51 30 64.6 0 52 204 31 81 WP_106790073.1 DMT family transporter [Massilistercora timonensis] diamond 153 45.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Massilistercora Massilistercora timonensis
27302380 27302380 PRJNA638724_P_NODE_7083_length_246_cov_0.890173_g6997_i0 PRJNA638724 7083 246 0.890173 2.18982558 Aquabacterium sp. G14 3130164 Bacteria Bacteria 130 9.329999999999998e-37   NR WP_339582258.1 3130164 g6997 i0 100 0.75609756097561 62 0 75.6 0 186 1 1 62 WP_339582258.1 AtaL-like protein [Aquabacterium sp. G14] diamond 186 130 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales   Aquabacterium Aquabacterium sp. G14
28817575 28817575 PRJNA638724_P_NODE_2328_length_392_cov_2.253918_g2242_i0 PRJNA638724 2328 392 2.253918 8.83535856 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 46.2 0.0104   NR RLB60749.1 2026735 g2242 i0 48.9 0.344387755102041 45 23 34.4 0 368 234 175 219 RLB60749.1 MAG: hypothetical protein DRI90_12965, partial [Deltaproteobacteria bacterium] diamond 135 46.2 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
28912352 28912352 PRJNA638724_P_NODE_7528_length_241_cov_0.916667_g7442_i0 PRJNA638724 7528 241 0.916667 2.20916747 Deltaproteobacteria bacterium RBG_13_65_1 2026735 Bacteria Bacteria 43.1 0.0266   NR OGP84731.1 1797835 g7442 i0 39.7 0.908713692946058 73 42 89.6 2 235 20 157 228 OGP84731.1 MAG: 4-alpha-glucanotransferase, partial [Deltaproteobacteria bacterium RBG_13_65_10] diamond 219 43.1 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_13_65_10
29386375 29386375 PRJNA638724_P_NODE_5689_length_269_cov_1.295918_g5603_i0 PRJNA638724 5689 269 1.295918 3.48601942 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 43.1 0.0379   NR HEY4607379.1 2080302 g5603 i0 30.6 0.947955390334573 85 49 94.8 2 262 8 711 785 HEY4607379.1 DUF655 domain-containing protein [Acidimicrobiia bacterium] diamond 255 43.1 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
29480649 29480649 PRJNA638724_P_NODE_7150_length_245_cov_0.895349_g7064_i0 PRJNA638724 7150 245 0.895349 2.19360505 Simkaniaceae bacterium 2698248 Bacteria Bacteria 44.7 0.008   NR MCF7852967.1 2698248 g7064 i0 67.9 0.342857142857143 28 9 34.3 0 231 148 124 151 MCF7852967.1 ankyrin repeat domain-containing protein [Simkaniaceae bacterium] diamond 84 44.7 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae   Simkaniaceae bacterium
29670029 29670029 PRJNA638724_P_NODE_6970_length_247_cov_0.885057_g6884_i0 PRJNA638724 6970 247 0.885057 2.18609079 Cellulophaga sp. BC115SP 2683263 Bacteria Bacteria 158 3.88e-44   NR WP_166550406.1 2683263 g6884 i0 97.5 0.97165991902834 80 2 97.2 0 242 3 200 279 WP_166550406.1 SusD/RagB family nutrient-binding outer membrane lipoprotein [Cellulophaga sp. BC115SP] diamond 240 158 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Cellulophaga Cellulophaga sp. BC115SP
29828172 29828172 PRJNA638724_P_NODE_8031_length_229_cov_2.397436_g7945_i0 PRJNA638724 8031 229 2.397436 5.49012844 Bacilli 91061 Bacteria Bacteria 115 4.8799999999999996e-32   NR WP_048395409.1 91061 g7945 i0 100 0.786026200873362 60 0 78.6 0 48 227 1 60 WP_048395409.1 MULTISPECIES: hypothetical protein [Bacilli] diamond 180 115 1 Bacteria   Bacillati Bacillota Bacilli        
30523293 30523293 PRJNA638724_P_NODE_7333_length_243_cov_0.905882_g7247_i0 PRJNA638724 7333 243 0.905882 2.20129326 Fusobacterium mortiferum 850 Bacteria Bacteria 87.8 5.05e-18   NR WP_204716580.1 850 g7247 i0 58.9 0.901234567901235 73 29 88.9 1 217 2 237 309 WP_204716580.1 hypothetical protein, partial [Fusobacterium mortiferum] diamond 219 87.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium mortiferum
31756144 31756144 PRJNA638724_P_NODE_6877_length_248_cov_0.880000_g6791_i0 PRJNA638724 6877 248 0.88 2.1824 Prevotella sp. oral taxon 317 652721 Bacteria Bacteria 156 6.76e-44   NR WP_009229796.1 652721 g6791 i0 96.2 0.955645161290323 79 3 95.6 0 238 2 177 255 WP_009229796.1 imidazolonepropionase [Prevotella sp. oral taxon 317] diamond 237 156 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella Prevotella sp. oral taxon 317
31914326 31914326 PRJNA638724_P_NODE_6377_length_255_cov_2.120879_g6291_i0 PRJNA638724 6377 255 2.120879 5.40824145 Pseudonocardia sp. N23 1987376 Bacteria Bacteria 42.7 0.0449   NR WP_098957286.1 1987376 g6291 i0 33.3 0.811764705882353 69 40 81.2 2 240 34 811 873 WP_098957286.1 phosphoenolpyruvate carboxylase [Pseudonocardia sp. N23] diamond 207 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia Pseudonocardia sp. N23
32072530 32072530 PRJNA638724_P_NODE_7498_length_241_cov_1.386905_g7412_i0 PRJNA638724 7498 241 1.386905 3.34244105 Ilumatobacter sp. 1967498 Bacteria Bacteria 43.1 0.0251   NR NKB41104.1 1967498 g7412 i0 34.4 0.759336099585062 61 38 73.4 1 44 220 11 71 NKB41104.1 hypothetical protein [Ilumatobacter sp.] diamond 183 43.1 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae Ilumatobacter Ilumatobacter sp.
32230947 32230947 PRJNA638724_P_NODE_6878_length_248_cov_0.880000_g6792_i0 PRJNA638724 6878 248 0.88 2.1824 Bradyrhizobium sp. LHD-71 3072141 Bacteria Bacteria 47.4 8.96e-4   NR WP_308966524.1 3072141 g6792 i0 86.2 0.701612903225806 29 3 33.9 1 85 2 1 29 WP_308966524.1 serine hydrolase domain-containing protein [Bradyrhizobium sp. LHD-71] diamond 174 47.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. LHD-71
32830667 32830667 PRJNA638724_P_NODE_6640_length_251_cov_0.865169_g6554_i0 PRJNA638724 6640 251 0.865169 2.17157419 Streptomyces mirabilis 68239 Bacteria Bacteria 40.8 0.0423   NR WP_256259314.1 68239 g6554 i0 36.3 0.956175298804781 80 43 87.3 4 247 29 5 83 WP_256259314.1 hypothetical protein [Streptomyces mirabilis] diamond 240 40.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces mirabilis

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