RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA1136505" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1136505 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
1031989 1031989 PRJNA1136505_P_NODE_142881_length_246_cov_0.890173_g136021_i0 PRJNA1136505 142881 246 0.890173 2.18982558 Virgibacillus ndiopensis 2004408 Bacteria Bacteria 127 5.12e-34   NR WP_099159564.1 2004408 g136021 i0 73.2 8 82 22 100 0 1 246 169 250 WP_099159564.1 HAD family hydrolase [Virgibacillus ndiopensis] diamond 1968 127 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Virgibacillus Virgibacillus ndiopensis
7937493 7937493 PRJNA1136505_P_NODE_114187_length_270_cov_1.253807_g107327_i0 PRJNA1136505 114187 270 1.253807 3.3852789 PVC group 1783257 Bacteria Bacteria 120 3.18e-29   NR WP_212695487.1 1348613 g107327 i0 87.3 7.4 55 7 61.1 0 106 270 8 62 WP_212695487.1 thioredoxin domain-containing protein [Vallitalea pronyensis] diamond 1998 121 0.991735537190083 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Vallitaleaceae Vallitalea Vallitalea pronyensis
9212534 9212534 PRJNA1136505_P_NODE_88428_length_308_cov_2.395745_g81568_i0 PRJNA1136505 88428 308 2.395745 7.3788946 root 1 Root_unresolved Root_unresolved 179 2.75e-56   NR MCE2155652.1 1308 g81568 i0 84.2 11.6688311688312 101 16 98.4 0 303 1 1 101 MCE2155652.1 30S ribosomal protein S13 [Streptococcus thermophilus] diamond 3594 180 0.994444444444444 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus thermophilus
27006951 27006951 PRJNA1136505_P_NODE_57522_length_400_cov_2.354740_g50662_i0 PRJNA1136505 57522 400 2.35474 9.41896 Symbiobacteriaceae bacterium 2602712 Bacteria Bacteria 140 2.25e-37   NR HLO03390.1 2602712 g50662 i0 54.9 0.9975 133 55 99.8 1 399 1 66 193 HLO03390.1 histidinol-phosphate transaminase [Symbiobacteriaceae bacterium] diamond 399 140 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Symbiobacteriaceae   Symbiobacteriaceae bacterium
27355010 27355010 PRJNA1136505_P_NODE_47823_length_459_cov_1.367876_g40964_i0 PRJNA1136505 47823 459 1.367876 6.27855084 Gottschalkia purinilytica 1503 Bacteria Bacteria 43.9 0.0286   NR KNF08891.1 1503 g40964 i0 28.6 0.640522875816993 98 64 61.4 2 308 27 6 101 KNF08891.1 hypothetical protein CLPU_5c01980 [Gottschalkia purinilytica] diamond 294 43.9 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Gottschalkiaceae Gottschalkia Gottschalkia purinilytica
27438941 27438941 PRJNA1136505_P_NODE_142163_length_246_cov_0.890173_g135303_i0 PRJNA1136505 142163 246 0.890173 2.18982558 Bacteria 2 Bacteria Bacteria 167 8.64e-52   NR NLQ21260.1 1313 g135303 i0 100 1.97560975609756 81 0 98.8 0 244 2 5 85 NLQ21260.1 glycosyl transferase family 1 [Streptococcus pneumoniae] diamond 486 167 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
27912049 27912049 PRJNA1136505_P_NODE_80085_length_326_cov_2.130435_g73225_i0 PRJNA1136505 80085 326 2.130435 6.9452181 FCB group 1783270 Bacteria Bacteria 50.1 1.91e-4   NR WP_046678759.1 1642570 g73225 i0 57.9 0.984662576687117 38 16 35 0 2 115 42 79 WP_046678759.1 hypothetical protein [Paenibacillus sp. DMB20] diamond 321 50.4 0.994047619047619 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. DMB20
27943916 27943916 PRJNA1136505_P_NODE_112925_length_271_cov_2.191919_g106065_i0 PRJNA1136505 112925 271 2.191919 5.94010049 root 1 Root_unresolved Root_unresolved 51.2 7.16e-6   NR MCI2449258.1 1639 g106065 i0 85.7 2.47970479704797 28 4 31 0 1 84 78 105 MCI2449258.1 hypothetical protein [Listeria monocytogenes] diamond 672 51.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
28270308 28270308 PRJNA1136505_P_NODE_81526_length_323_cov_1.504000_g74666_i0 PRJNA1136505 81526 323 1.504 4.85792 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 45.1 0.0124   NR MCQ2407602.1 2485925 g74666 i0 39.3 0.56656346749226 61 32 53.9 2 22 195 149 207 MCQ2407602.1 phosphatidate cytidylyltransferase [Oscillospiraceae bacterium] diamond 183 45.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
28322665 28322665 PRJNA1136505_P_NODE_146866_length_244_cov_1.070175_g140006_i0 PRJNA1136505 146866 244 1.070175 2.611227 Bacteria 2 Bacteria Bacteria 48.9 1.43e-4   NR MBE3589736.1 1879010 g140006 i0 46 1.36475409836066 50 26 61.5 1 86 235 62 110 MBE3589736.1 aminoacyl-tRNA hydrolase [Bacillota bacterium] diamond 333 48.9 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
28417659 28417659 PRJNA1136505_P_NODE_104386_length_282_cov_2.325359_g97526_i0 PRJNA1136505 104386 282 2.325359 6.55751238 FCB group 1783270 Bacteria Bacteria 58.9 1.73e-8   NR WP_260424747.1 229549 g97526 i0 36.4 3.57446808510638 88 52 89.4 2 31 282 22 109 WP_260424747.1 YkvA family protein [Streptococcus minor] diamond 1008 59.3 0.993254637436762 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus minor
28606847 28606847 PRJNA1136505_P_NODE_110367_length_275_cov_1.143564_g103507_i0 PRJNA1136505 110367 275 1.143564 3.144801 root 1 Root_unresolved Root_unresolved 80.9 1.42e-15   NR WP_044022537.1 161544 g103507 i0 48.3 24.6763636363636 89 39 97.1 3 8 274 231 312 WP_044022537.1 4-hydroxyphenylpyruvate dioxygenase [Bacillus sp. SG-1] diamond 6786 81.6 0.991421568627451 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. SG-1
28870339 28870339 PRJNA1136505_P_NODE_117788_length_265_cov_2.369792_g110928_i0 PRJNA1136505 117788 265 2.369792 6.2799488 Priestia koreensis 284581 Bacteria Bacteria 123 2.2499999999999993e-31   NR WP_242175441.1 284581 g110928 i0 69.8 0.973584905660377 86 24 97.4 2 3 260 30 113 WP_242175441.1 acyl-CoA dehydrogenase family protein [Priestia koreensis] diamond 258 123 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia koreensis
29217946 29217946 PRJNA1136505_P_NODE_138489_length_248_cov_0.880000_g131629_i0 PRJNA1136505 138489 248 0.88 2.1824 Clostridium sp. Marseille-P299 1805477 Bacteria Bacteria 167 3.17e-48   NR WP_066720994.1 1805477 g131629 i0 97.6 0.991935483870968 82 2 99.2 0 247 2 286 367 WP_066720994.1 U32 family peptidase C-terminal domain-containing protein [Clostridium sp. Marseille-P299] diamond 246 167 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. Marseille-P299
29249181 29249181 PRJNA1136505_P_NODE_84009_length_318_cov_0.942857_g77149_i0 PRJNA1136505 84009 318 0.942857 2.99828526 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 47.4 0.00153   NR MDR3310048.1 2485925 g77149 i0 45.8 0.452830188679245 48 23 42.5 1 118 252 127 174 MDR3310048.1 glycerol-3-phosphate 1-O-acyltransferase PlsY [Oscillospiraceae bacterium] diamond 144 47.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
29280725 29280725 PRJNA1136505_P_NODE_133589_length_250_cov_0.870056_g126729_i0 PRJNA1136505 133589 250 0.870056 2.17514 Exiguobacterium 33986 Bacteria Bacteria 142 4.85e-39   NR WP_214763343.1 33986 g126729 i0 84.3 0.996 83 13 99.6 0 1 249 52 134 WP_214763343.1 MULTISPECIES: hypothetical protein [Exiguobacterium] diamond 249 142 1 Bacteria   Bacillati Bacillota Bacilli Bacillales   Exiguobacterium  
29553926 29553926 PRJNA1136505_P_NODE_48490_length_454_cov_1.212598_g41631_i0 PRJNA1136505 48490 454 1.212598 5.50519492 Bacteria 2 Bacteria Bacteria 79.3 1.28e-14   NR WP_015614499.1 1501 g41631 i0 51.8 5.62334801762115 83 37 54.8 1 251 3 6 85 WP_015614499.1 SDR family NAD(P)-dependent oxidoreductase [Clostridium pasteurianum] diamond 2553 79.7 0.994981179422836 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium pasteurianum
29627740 29627740 PRJNA1136505_P_NODE_142130_length_246_cov_0.890173_g135270_i0 PRJNA1136505 142130 246 0.890173 2.18982558 Staphylococcus epidermidis 1282 Bacteria Bacteria 132 1.18e-37   NR WP_305808426.1 1282 g135270 i0 100 0.841463414634146 69 0 84.1 0 208 2 1 69 WP_305808426.1 hypothetical protein, partial [Staphylococcus epidermidis] diamond 207 132 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
30122498 30122498 PRJNA1136505_P_NODE_124852_length_257_cov_1.255435_g117992_i0 PRJNA1136505 124852 257 1.255435 3.22646795 Bacteria 2 Bacteria Bacteria 86.7 7.93e-19   NR MBQ3111158.1 2044939 g117992 i0 54.9 2.77821011673152 82 36 95.7 1 8 253 116 196 MBQ3111158.1 ATP-binding protein [Clostridia bacterium] diamond 714 87.4 0.991990846681922 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30291948 30291948 PRJNA1136505_P_NODE_99772_length_288_cov_2.618605_g92912_i0 PRJNA1136505 99772 288 2.618605 7.5415824 Lysinibacillus endophyticus 1978490 Bacteria Bacteria 59.3 8.84e-8   NR WP_121213043.1 1978490 g92912 i0 38 0.822916666666667 79 49 82.3 0 19 255 100 178 WP_121213043.1 BMP family lipoprotein [Lysinibacillus endophyticus] diamond 237 59.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Ureibacillus Ureibacillus endophyticus
30607374 30607374 PRJNA1136505_P_NODE_136193_length_249_cov_0.875000_g129333_i0 PRJNA1136505 136193 249 0.875 2.17875 Metabacillus mangrovi 1491830 Bacteria Bacteria 57 3.61e-7   NR WP_155113088.1 1491830 g129333 i0 37.2 1.92771084337349 78 49 94 0 2 235 89 166 WP_155113088.1 GTPase [Metabacillus mangrovi] diamond 480 57 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Metabacillus Metabacillus mangrovi
30754581 30754581 PRJNA1136505_P_NODE_140734_length_247_cov_0.885057_g133874_i0 PRJNA1136505 140734 247 0.885057 2.18609079 root 1 Root_unresolved Root_unresolved 50.4 7.47e-5   NR WP_071457407.1 519472 g133874 i0 64.7 1.42105263157895 34 12 41.3 0 145 246 99 132 WP_071457407.1 dihydrolipoyllysine-residue acetyltransferase [Vagococcus teuberi] diamond 351 50.8 0.992125984251969 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Vagococcus Vagococcus teuberi
30892014 30892014 PRJNA1136505_P_NODE_39834_length_534_cov_2.212581_g32992_i0 PRJNA1136505 39834 534 2.212581 11.81518254 Enterococcus faecium 1352 Bacteria Bacteria 134 1.2e-37   NR PWS22095.1 1352 g32992 i0 77.6 0.47752808988764 85 17 47.8 1 4 258 1 83 PWS22095.1 hypothetical protein DKP78_20170, partial [Enterococcus faecium] diamond 255 134 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
31207333 31207333 PRJNA1136505_P_NODE_131095_length_251_cov_0.865169_g124235_i0 PRJNA1136505 131095 251 0.865169 2.17157419 Clostridia bacterium 2044939 Bacteria Bacteria 50.4 7.62e-5   NR MBR2296201.1 2044939 g124235 i0 74.1 0.645418326693227 27 7 32.3 0 232 152 34 60 MBR2296201.1 hypothetical protein [Clostridia bacterium] diamond 162 50.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31682019 31682019 PRJNA1136505_P_NODE_118277_length_265_cov_1.291667_g111417_i0 PRJNA1136505 118277 265 1.291667 3.42291755 Anaerosolibacter sp. 1872527 Bacteria Bacteria 43.1 0.00891   NR WP_300304620.1 1872527 g111417 i0 50 0.475471698113208 42 19 45.3 1 135 16 2 43 WP_300304620.1 helix-turn-helix domain-containing protein [Anaerosolibacter sp.] diamond 126 43.1 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Thermotaleaceae Anaerosolibacter Anaerosolibacter sp.
32145883 32145883 PRJNA1136505_P_NODE_82078_length_322_cov_1.236948_g75218_i0 PRJNA1136505 82078 322 1.236948 3.98297256 Bacteria 2 Bacteria Bacteria 112 2.7e-26   NR WP_073252974.1 447595 g75218 i0 61.3 7.04347826086957 93 35 86.6 1 41 319 3 94 WP_073252974.1 pyruvate kinase [Caldanaerovirga acetigignens] diamond 2268 113 0.991150442477876 Bacteria   Bacillati Bacillota Clostridia Thermosediminibacterales Thermosediminibacteraceae Caldanaerovirga Caldanaerovirga acetigignens
32283633 32283633 PRJNA1136505_P_NODE_104599_length_282_cov_1.473684_g97739_i0 PRJNA1136505 104599 282 1.473684 4.15578888 Clostridia bacterium 2044939 Bacteria Bacteria 47.4 0.00143   NR MBP3428348.1 2044939 g97739 i0 36.7 0.638297872340426 60 36 61.7 1 44 217 745 804 MBP3428348.1 Ig domain-containing protein [Clostridia bacterium] diamond 180 47.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32851440 32851440 PRJNA1136505_P_NODE_58940_length_394_cov_0.959502_g52080_i0 PRJNA1136505 58940 394 0.959502 3.78043788 Pygmaiobacter sp. 1929306 Bacteria Bacteria 69.3 1.04e-10   NR MDD2993450.1 1929306 g52080 i0 54.4 0.517766497461929 68 31 51.8 0 206 3 1330 1397 MDD2993450.1 Ig-like domain-containing protein [Pygmaiobacter sp.] diamond 204 69.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Pygmaiobacter Pygmaiobacter sp.

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