RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1093380" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1093380 · 21 ✖

analysis 1

  • diamond · 21 ✖

tax_clade 0

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
199133 199133 PRJNA1093380_P_NODE_17561_length_234_cov_2.391304_g17455_i0 PRJNA1093380 17561 234 2.391304 5.59565136 Aliicoccus persicus 930138 Bacteria Bacteria 142 2.3e-37   NR WP_091475351.1 930138 g17455 i0 100 0.987179487179487 77 0 98.7 0 2 232 602 678 WP_091475351.1 heavy metal translocating P-type ATPase [Aliicoccus persicus] diamond 231 142 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Aliicoccus Aliicoccus persicus
199193 199193 PRJNA1093380_P_NODE_5941_length_285_cov_2.787736_g5835_i0 PRJNA1093380 5941 285 2.787736 7.9450476 Veillonella sp. CNR 79/14 2490954 Bacteria Bacteria 189 1.4599999999999998e-54   NR WP_126940259.1 2490954 g5835 i0 97.9 0.989473684210526 94 2 98.9 0 2 283 238 331 WP_126940259.1 glycine--tRNA ligase subunit beta [Veillonella sp. CNR 79/14] diamond 282 189 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella sp. CNR 79/14
4847274 4847274 PRJNA1093380_P_NODE_14344_length_246_cov_1.670520_g14238_i0 PRJNA1093380 14344 246 1.67052 4.1094792 Fontibacillus solani 1572857 Bacteria Bacteria 100 1.06e-22   NR WP_182535624.1 1572857 g14238 i0 56.8 3.91463414634146 81 35 98.8 0 244 2 347 427 WP_182535624.1 Nramp family divalent metal transporter [Fontibacillus solani] diamond 963 100 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Fontibacillus Fontibacillus solani
6122304 6122304 PRJNA1093380_P_NODE_14825_length_245_cov_1.738372_g14719_i0 PRJNA1093380 14825 245 1.738372 4.2590114 Veillonella sp. CHU732 2490949 Bacteria Bacteria 77.4 1.57e-15   NR WP_127166145.1 2490949 g14719 i0 100 0.428571428571429 35 0 42.9 0 140 244 1 35 WP_127166145.1 transcription termination/antitermination protein NusG [Veillonella sp. CHU732] diamond 105 77.4 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella sp. CHU732
16776230 16776230 PRJNA1093380_P_NODE_17074_length_241_cov_0.916667_g16968_i0 PRJNA1093380 17074 241 0.916667 2.20916747 Clostridia 186801 Bacteria Bacteria 157 2.83e-44   NR MDD6563988.1 1898207 g16968 i0 91.3 6.97095435684647 80 7 99.6 0 241 2 82 161 MDD6563988.1 DNA cytosine methyltransferase [Clostridiales bacterium] diamond 1680 157 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
26655849 26655849 PRJNA1093380_P_NODE_16001_length_243_cov_0.905882_g15895_i0 PRJNA1093380 16001 243 0.905882 2.20129326 Eubacterium infirmum F 56774 Bacteria Bacteria 140 3.9399999999999997e-38   NR EHO85248.1 883109 g15895 i0 97.1 0.839506172839506 68 2 84 0 243 40 41 108 EHO85248.1 hypothetical protein HMPREF0380_00973 [Eubacterium infirmum F0142] diamond 204 140 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae   [Eubacterium] infirmum
26687709 26687709 PRJNA1093380_P_NODE_12321_length_250_cov_1.418079_g12215_i0 PRJNA1093380 12321 250 1.418079 3.5451975 Candidatus Fusicatenibacter merdavium 2838600 Bacteria Bacteria 126 1.19e-32   NR HIX76836.1 2838600 g12215 i0 97.1 0.816 68 2 81.6 0 2 205 334 401 HIX76836.1 FprA family A-type flavoprotein [Candidatus Fusicatenibacter merdavium] diamond 204 126 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Fusicatenibacter Candidatus Fusicatenibacter merdavium
27193911 27193911 PRJNA1093380_P_NODE_17942_length_226_cov_2.013072_g17836_i0 PRJNA1093380 17942 226 2.013072 4.54954272 Staphylococcus epidermidis 1282 Bacteria Bacteria 44.3 0.00305   NR WP_305808990.1 1282 g17836 i0 38.7 0.823008849557522 62 37 81 1 184 2 1 62 WP_305808990.1 hypothetical protein, partial [Staphylococcus epidermidis] diamond 186 44.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
27280313 27280313 PRJNA1093380_P_NODE_9783_length_263_cov_1.773684_g9677_i0 PRJNA1093380 9783 263 1.773684 4.66478892 Clostridia 186801 Bacteria Bacteria 150 5.0299999999999985e-43   NR WP_130805969.1 1720316 g9677 i0 85.1 2.97718631178707 87 13 99.2 0 3 263 97 183 WP_130805969.1 PTS N-acetylgalactosamine transporter subunit IIC [Senegalia massiliensis] diamond 783 151 0.993377483443709 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Senegalia Senegalia massiliensis
27920357 27920357 PRJNA1093380_P_NODE_10965_length_256_cov_1.683060_g10859_i0 PRJNA1093380 10965 256 1.68306 4.3086336 Jeotgalicoccus sp. WY2 2708346 Bacteria Bacteria 147 2.05e-40   NR WP_213809839.1 2708346 g10859 i0 94.7 0.890625 76 4 89.1 0 254 27 342 417 WP_213809839.1 gephyrin-like molybdotransferase Glp [Jeotgalicoccus sp. WY2] diamond 228 147 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Jeotgalicoccus Jeotgalicoccus sp. WY2
28322225 28322225 PRJNA1093380_P_NODE_14086_length_247_cov_0.885057_g13980_i0 PRJNA1093380 14086 247 0.885057 2.18609079 Mogibacterium 86331 Bacteria Bacteria 118 4.09e-32   NR WP_288964153.1 278065 g13980 i0 83.3 1.60323886639676 66 11 80.2 0 48 245 1 66 WP_288964153.1 DUF3846 domain-containing protein [uncultured Mogibacterium sp.] diamond 396 118 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae Mogibacterium uncultured Mogibacterium sp.
28827235 28827235 PRJNA1093380_P_NODE_9428_length_265_cov_1.755208_g9322_i0 PRJNA1093380 9428 265 1.755208 4.6513012 Granulicatella 117563 Bacteria Bacteria 106 6.52e-25   NR WP_051349233.1 137732 g9322 i0 100 1.17735849056604 52 0 58.9 0 264 109 377 428 WP_051349233.1 bifunctional folylpolyglutamate synthase/dihydrofolate synthase [Granulicatella elegans] diamond 312 106 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Granulicatella Granulicatella elegans
28985611 28985611 PRJNA1093380_P_NODE_10848_length_257_cov_1.342391_g10742_i0 PRJNA1093380 10848 257 1.342391 3.44994487 Acetatifactor 1427378 Bacteria Bacteria 52 1.67e-5   NR WP_300860172.1 1671927 g10742 i0 51 3.74708171206226 51 25 59.5 0 218 66 112 162 WP_300860172.1 response regulator [uncultured Acetatifactor sp.] diamond 963 52 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Acetatifactor uncultured Acetatifactor sp.
29017235 29017235 PRJNA1093380_P_NODE_17908_length_226_cov_3.241830_g17802_i0 PRJNA1093380 17908 226 3.24183 7.3265358 Bacillati 1783272 Bacteria Bacteria 64.3 2.48e-11   NR WP_347134807.1 1280 g17802 i0 100 1.19469026548673 30 0 39.8 0 91 2 13 42 WP_347134807.1 hypothetical protein, partial [Staphylococcus aureus] diamond 270 64.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30289147 30289147 PRJNA1093380_P_NODE_14152_length_247_cov_0.885057_g14046_i0 PRJNA1093380 14152 247 0.885057 2.18609079 Jeotgalicoccus aerolatus 709510 Bacteria Bacteria 158 8.219999999999999e-47   NR WP_092598399.1 709510 g14046 i0 98.8 0.983805668016194 81 1 98.4 0 245 3 64 144 WP_092598399.1 queuosine precursor transporter [Jeotgalicoccus aerolatus] diamond 243 158 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Jeotgalicoccus Jeotgalicoccus aerolatus
30572889 30572889 PRJNA1093380_P_NODE_7513_length_276_cov_1.428571_g7407_i0 PRJNA1093380 7513 276 1.428571 3.94285596 Aedoeadaptatus 2981628 Bacteria Bacteria 181 1.63e-56   NR WP_108830648.1 2981628 g7407 i0 97.8 0.989130434782609 91 2 98.9 0 2 274 39 129 WP_108830648.1 MULTISPECIES: zinc ribbon domain-containing protein [Aedoeadaptatus] diamond 273 181 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Aedoeadaptatus  
30627505 30627505 PRJNA1093380_P_NODE_11173_length_255_cov_1.439560_g11067_i0 PRJNA1093380 11173 255 1.43956 3.670878 Anaerococcus 165779 Bacteria Bacteria 168 2.3399999999999998e-46   NR WP_245943478.1 54007 g11067 i0 100 3 85 0 100 0 255 1 122 206 WP_245943478.1 3'-5' exonuclease [Anaerococcus octavius] diamond 765 168 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus octavius
31268335 31268335 PRJNA1093380_P_NODE_16595_length_242_cov_0.911243_g16489_i0 PRJNA1093380 16595 242 0.911243 2.20520806 Marinilactibacillus sp. Marseille-P9653 2866583 Bacteria Bacteria 144 2.11e-40   NR WP_225743220.1 2866583 g16489 i0 100 0.892561983471074 72 0 89.3 0 217 2 1 72 WP_225743220.1 oligopeptide ABC transporter permease [Marinilactibacillus sp. Marseille-P9653] diamond 216 144 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Marinilactibacillus Marinilactibacillus sp. Marseille-P9653
31331501 31331501 PRJNA1093380_P_NODE_6816_length_280_cov_1.487923_g6710_i0 PRJNA1093380 6816 280 1.487923 4.1661844 Bacillota bacterium 1879010 Bacteria Bacteria 130 8.150000000000001e-33   NR MDD5863016.1 1879010 g6710 i0 91.7 0.771428571428571 72 6 77.1 0 3 218 729 800 MDD5863016.1 endopeptidase La [Bacillota bacterium] diamond 216 130 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
32375643 32375643 PRJNA1093380_P_NODE_7039_length_279_cov_1.252427_g6933_i0 PRJNA1093380 7039 279 1.252427 3.49427133 Marinilactibacillus kalidii 2820274 Bacteria Bacteria 172 9.39e-50   NR WP_208559053.1 2820274 g6933 i0 96.7 0.989247311827957 92 3 98.9 0 278 3 53 144 WP_208559053.1 PTS ascorbate transporter subunit IIC [Marinilactibacillus kalidii] diamond 276 172 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Marinilactibacillus Marinilactibacillus kalidii
32596980 32596980 PRJNA1093380_P_NODE_15460_length_244_cov_0.900585_g15354_i0 PRJNA1093380 15460 244 0.900585 2.1974274 Litchfieldia alkalitelluris 304268 Bacteria Bacteria 113 4.1800000000000005e-27   NR WP_078549303.1 304268 g15354 i0 65.4 0.959016393442623 78 27 95.9 0 10 243 161 238 WP_078549303.1 recombinase family protein [Litchfieldia alkalitelluris] diamond 234 113 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Litchfieldia Litchfieldia alkalitelluris

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