RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA1248471" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_clade 2

tax_superkingdom 1

  • Bacteria · 23 ✖

bioproject 1

  • PRJNA1248471 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
6731296 6731296 PRJNA1248471_S_NODE_12426_length_193_cov_1.062500_g12326_i0 PRJNA1248471 12426 193 1.0625 2.050625 Arthrobacter russicus 172040 Bacteria Bacteria 134 2.22e-36   NR WP_309796647.1 172040 g12326 i0 100 0.994818652849741 64 0 99.5 0 192 1 159 222 WP_309796647.1 ABC transporter substrate-binding protein [Arthrobacter russicus] diamond 192 134 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter russicus
22030365 22030365 PRJNA1248471_S_NODE_21638_length_162_cov_1.495575_g21538_i0 PRJNA1248471 21638 162 1.495575 2.4228315 Afipia sp. 1871052 Bacteria Bacteria 91.3 7.51e-20   NR HEY0235440.1 1871052 g21538 i0 86.8 0.981481481481482 53 7 98.1 0 2 160 13 65 HEY0235440.1 lytic murein transglycosylase [Afipia sp.] diamond 159 91.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Afipia Afipia sp.
26946988 26946988 PRJNA1248471_S_NODE_19862_length_165_cov_0.758621_g19762_i0 PRJNA1248471 19862 165 0.758621 1.25172465 Muribaculaceae bacterium 2498093 Bacteria Bacteria 45.4 2.26e-4   NR MEG1916030.1 2498093 g19762 i0 55.8 0.781818181818182 43 19 78.2 0 131 3 9 51 MEG1916030.1 hypothetical protein [Muribaculaceae bacterium] diamond 129 45.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Muribaculaceae   Muribaculaceae bacterium
27263361 27263361 PRJNA1248471_S_NODE_5603_length_244_cov_1.641026_g5503_i0 PRJNA1248471 5603 244 1.641026 4.00410344 Nocardia vinacea 96468 Bacteria Bacteria 42.4 0.0499   NR WP_357481875.1 96468 g5503 i0 48.7 0.479508196721311 39 19 48 1 211 95 8 45 WP_357481875.1 hypothetical protein [Nocardia vinacea] diamond 117 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia vinacea
27705825 27705825 PRJNA1248471_S_NODE_12384_length_193_cov_1.770833_g12284_i0 PRJNA1248471 12384 193 1.770833 3.41770769 Shigella sonnei 624 Bacteria Bacteria 42 0.00535   NR MDD0469303.1 624 g12284 i0 44 0.77720207253886 50 28 77.7 0 181 32 12 61 MDD0469303.1 hypothetical protein [Shigella sonnei] diamond 150 42 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
27800327 27800327 PRJNA1248471_S_NODE_18484_length_167_cov_1.296610_g18384_i0 PRJNA1248471 18484 167 1.29661 2.1653387 Blastocatellia bacterium 2052146 Bacteria Bacteria 40.4 0.0352   NR HMY75981.1 2052146 g18384 i0 45.5 0.592814371257485 33 18 59.3 0 47 145 41 73 HMY75981.1 DNA polymerase III subunit epsilon [Blastocatellia bacterium] diamond 99 40.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
28841966 28841966 PRJNA1248471_S_NODE_15128_length_179_cov_1.200000_g15028_i0 PRJNA1248471 15128 179 1.2 2.148 Candidatus Brocadiia bacterium 2517210 Bacteria Bacteria 43.1 0.0116   NR HRU06410.1 2517210 g15028 i0 42.1 0.636871508379888 38 22 63.7 0 116 3 5 42 HRU06410.1 ABC transporter ATP-binding protein [Candidatus Brocadiia bacterium] diamond 114 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia       Candidatus Brocadiia bacterium
28986716 28986716 PRJNA1248471_S_NODE_22408_length_161_cov_1.500000_g22308_i0 PRJNA1248471 22408 161 1.5 2.415 Corynebacterium 1716 Bacteria Bacteria 58.9 1.27e-8   NR WP_015453155.1 1721 g22308 i0 59.2 1.82608695652174 49 20 91.3 0 3 149 62 110 WP_015453155.1 hypothetical protein [Corynebacterium callunae] diamond 294 59.3 0.993254637436762 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium callunae
29189573 29189573 PRJNA1248471_S_NODE_18409_length_167_cov_1.677966_g18309_i0 PRJNA1248471 18409 167 1.677966 2.80220322 Microvirga antarctica 2819233 Bacteria Bacteria 89.4 2.09e-20   NR WP_210485609.1 2819233 g18309 i0 82.7 2.80239520958084 52 9 93.4 0 1 156 62 113 WP_210485609.1 NAD(P)-dependent oxidoreductase [Microvirga antarctica] diamond 468 89.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Microvirga Microvirga antarctica
29333787 29333787 PRJNA1248471_S_NODE_12889_length_190_cov_3.375887_g12789_i0 PRJNA1248471 12889 190 3.375887 6.4141853 Bacteria 2 Bacteria Bacteria 42 0.0349   NR MFP5579076.1 2080302 g12789 i0 41.7 1.56315789473684 48 28 75.8 0 160 17 99 146 MFP5579076.1 tetratricopeptide repeat protein [Acidimicrobiia bacterium] diamond 297 42.4 0.990566037735849 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
30199778 30199778 PRJNA1248471_S_NODE_12412_length_193_cov_1.395833_g12312_i0 PRJNA1248471 12412 193 1.395833 2.69395769 Treponema paraluiscuniculi 53435 Bacteria Bacteria 43.5 0.00128   NR WP_333760307.1 53435 g12312 i0 45.3 1.25906735751295 53 25 82.4 2 161 3 11 59 WP_333760307.1 hypothetical protein, partial [Treponema paraluiscuniculi] diamond 243 43.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema paraluiscuniculi
30439414 30439414 PRJNA1248471_S_NODE_21253_length_163_cov_0.719298_g21153_i0 PRJNA1248471 21253 163 0.719298 1.17245574 root 1 Root_unresolved Root_unresolved 50.1 3.26e-5   NR QHG77598.1 1280 g21153 i0 50.8 14.9447852760736 61 23 99.4 1 163 2 134 194 QHG77598.1 hypothetical protein EAX85_13915 [Staphylococcus aureus] diamond 2436 50.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30800174 30800174 PRJNA1248471_S_NODE_8254_length_213_cov_2.085366_g8154_i0 PRJNA1248471 8254 213 2.085366 4.44182958 Aquipseudomonas alcaligenes 43263 Bacteria Bacteria 45.1 0.00312   NR WP_373388768.1 43263 g8154 i0 36.5 0.732394366197183 52 33 73.2 0 175 20 124 175 WP_373388768.1 lysoplasmalogenase family protein [Aquipseudomonas alcaligenes] diamond 156 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Aquipseudomonas Aquipseudomonas alcaligenes
31274275 31274275 PRJNA1248471_S_NODE_15615_length_177_cov_1.195312_g15515_i0 PRJNA1248471 15615 177 1.195312 2.11570224 Rhodocyclaceae bacterium 1898103 Bacteria Bacteria 40 0.0317   NR HMX15607.1 1898103 g15515 i0 54.8 0.525423728813559 31 14 52.5 0 116 24 8 38 HMX15607.1 hypothetical protein [Rhodocyclaceae bacterium] diamond 93 40 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Rhodocyclales Rhodocyclaceae   Rhodocyclaceae bacterium
31369442 31369442 PRJNA1248471_S_NODE_1816_length_340_cov_16.512027_g1716_i0 PRJNA1248471 1816 340 16.512027 56.1408918 Bifidobacterium vespertilionis 2562524 Bacteria Bacteria 43.9 0.0401   NR WP_150353623.1 2562524 g1716 i0 36.7 0.529411764705882 60 33 52.9 1 156 335 203 257 WP_150353623.1 glycosyltransferase family 2 protein [Bifidobacterium vespertilionis] diamond 180 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Bifidobacterium Bifidobacterium vespertilionis
31432432 31432432 PRJNA1248471_S_NODE_11796_length_196_cov_1.217687_g11696_i0 PRJNA1248471 11796 196 1.217687 2.38666652 Afipia sp. 1871052 Bacteria Bacteria 79.7 1.85e-17   NR HEY0236965.1 1871052 g11696 i0 84.8 1.4234693877551 46 7 70.4 0 191 54 63 108 HEY0236965.1 DUF559 domain-containing protein [Afipia sp.] diamond 279 79.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Afipia Afipia sp.
32368220 32368220 PRJNA1248471_S_NODE_3079_length_300_cov_1.135458_g2979_i0 PRJNA1248471 3079 300 1.135458 3.406374 Bacteria 2 Bacteria Bacteria 44.3 0.00201   NR WP_309547482.1 1313 g2979 i0 80 0.51 25 5 25 0 163 237 37 61 WP_309547482.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 153 44.7 0.991051454138702 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
32381625 32381625 PRJNA1248471_S_NODE_7039_length_227_cov_2.005618_g6939_i0 PRJNA1248471 7039 227 2.005618 4.55275286 Clostridia bacterium 2044939 Bacteria Bacteria 87 7.57e-18   NR NCC78976.1 2044939 g6939 i0 61.7 0.79295154185022 60 23 79.3 0 191 12 526 585 NCC78976.1 hypothetical protein [Clostridia bacterium] diamond 180 87 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32589530 32589530 PRJNA1248471_S_NODE_12159_length_194_cov_2.331034_g12059_i0 PRJNA1248471 12159 194 2.331034 4.52220596 Hyphomicrobiales 356 Bacteria Bacteria 105 3.1699999999999997e-25   NR MBY0382260.1 2021379 g12059 i0 92 1.53092783505155 50 4 77.3 0 32 181 282 331 MBY0382260.1 ABC transporter substrate-binding protein [Xanthobacteraceae bacterium] diamond 297 106 0.990566037735849 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Xanthobacteraceae   Xanthobacteraceae bacterium
32728846 32728846 PRJNA1248471_S_NODE_21840_length_162_cov_0.902655_g21740_i0 PRJNA1248471 21840 162 0.902655 1.4623011 Escherichia coli 562 Bacteria Bacteria 39.7 0.024   NR WP_309049012.1 562 g21740 i0 50 0.814814814814815 44 19 81.5 1 148 17 1 41 WP_309049012.1 hypothetical protein, partial [Escherichia coli] diamond 132 39.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32809719 32809719 PRJNA1248471_S_NODE_17620_length_170_cov_0.760331_g17520_i0 PRJNA1248471 17620 170 0.760331 1.2925627 root 1 Root_unresolved Root_unresolved 59.3 5.52e-10   NR TAQ98585.1 1590 g17520 i0 73.5 1.72941176470588 34 9 60 0 54 155 1 34 TAQ98585.1 hypothetical protein BV221_15430 [Lactiplantibacillus plantarum] diamond 294 59.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
32823261 32823261 PRJNA1248471_S_NODE_21160_length_163_cov_0.885965_g21060_i0 PRJNA1248471 21160 163 0.885965 1.44412295 Escherichia coli 562 Bacteria Bacteria 49.7 3.48e-6   NR KJG94335.1 562 g21060 i0 63.6 2.94478527607362 33 12 60.7 0 162 64 35 67 KJG94335.1 hypothetical protein UC40_25285, partial [Escherichia coli] diamond 480 49.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32854657 32854657 PRJNA1248471_S_NODE_21920_length_162_cov_0.876106_g21820_i0 PRJNA1248471 21920 162 0.876106 1.41929172 Vibrio vulnificus 672 Bacteria Bacteria 71.2 8.72e-15   NR MCA0772538.1 672 g21820 i0 89.2 9.59259259259259 37 4 68.5 0 3 113 30 66 MCA0772538.1 type I glyceraldehyde-3-phosphate dehydrogenase [Vibrio vulnificus] diamond 1554 71.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio vulnificus

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