RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA436017" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJNA436017 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
6808437 6808437 PRJNA436017_P_NODE_19666_length_184_cov_1.857143_g19368_i0 PRJNA436017 19666 184 1.857143 3.41714312 Eubacteriales bacterium 2831996 Bacteria Bacteria 110 1.23e-27   NR MDD4377659.1 2831996 g19368 i0 78.7 0.994565217391304 61 13 99.5 0 1 183 197 257 MDD4377659.1 replication initiation protein [Eubacteriales bacterium] diamond 183 110 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
18282186 18282186 PRJNA436017_P_NODE_10175_length_270_cov_2.334764_g9877_i0 PRJNA436017 10175 270 2.334764 6.3038628 Bacteria 2 Bacteria Bacteria 99 5.18e-25   NR WP_125990424.1 972 g9877 i0 68.1 13.0888888888889 72 23 80 0 254 39 2 73 WP_125990424.1 MULTISPECIES: acyl carrier protein [Halanaerobiaceae] diamond 3534 99.4 0.995975855130785 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales Halanaerobiaceae    
27250302 27250302 PRJNA436017_P_NODE_16283_length_204_cov_2.101796_g15985_i0 PRJNA436017 16283 204 2.101796 4.28766384 Bacillati 1783272 Bacteria Bacteria 100 9.9e-25   NR WP_044824537.1 84022 g15985 i0 78.7 20.6176470588235 61 13 89.7 0 185 3 1 61 WP_044824537.1 ferritin-like domain-containing protein [Clostridium aceticum] diamond 4206 101 0.99009900990099 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium aceticum
27345334 27345334 PRJNA436017_P_NODE_19583_length_185_cov_1.027027_g19285_i0 PRJNA436017 19583 185 1.027027 1.89999995 Bacillota 1239 Bacteria Bacteria 93.6 2.0899999999999994e-23   NR WP_115793066.1 444093 g19285 i0 69 3.48648648648649 58 16 94.1 1 12 185 2 57 WP_115793066.1 hypothetical protein [Ammonifex thiophilus] diamond 645 93.6 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Ammonifex Ammonifex thiophilus
27661076 27661076 PRJNA436017_P_NODE_3564_length_495_cov_1.847162_g3282_i0 PRJNA436017 3564 495 1.847162 9.1434519 Bacteria 2 Bacteria Bacteria 188 1.22e-57   NR WP_183597216.1 274593 g3282 i0 56.5 12.7272727272727 161 69 97 1 3 482 13 173 WP_183597216.1 NAD(P)H-dependent oxidoreductase [Paenibacillus phyllosphaerae] diamond 6300 188 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus phyllosphaerae
28307621 28307621 PRJNA436017_P_NODE_6426_length_353_cov_2.208861_g6130_i0 PRJNA436017 6426 353 2.208861 7.79727933 Erysipelotrichales bacterium 2478483 Bacteria Bacteria 44.7 0.0258   NR MCH5166641.1 2478483 g6130 i0 28.4 0.807365439093484 95 64 80.7 2 19 303 410 500 MCH5166641.1 WG repeat-containing protein [Erysipelotrichales bacterium] diamond 285 44.7 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales     Erysipelotrichales bacterium
28339176 28339176 PRJNA436017_P_NODE_20526_length_180_cov_2.993007_g20228_i0 PRJNA436017 20526 180 2.993007 5.3874126 Eubacteriales bacterium 2831996 Bacteria Bacteria 82.8 5.14e-17   NR MDD4377659.1 2831996 g20228 i0 73.1 0.866666666666667 52 14 86.7 0 1 156 266 317 MDD4377659.1 replication initiation protein [Eubacteriales bacterium] diamond 156 82.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
28812410 28812410 PRJNA436017_P_NODE_16548_length_202_cov_2.600000_g16250_i0 PRJNA436017 16548 202 2.6 5.252 Anaerosporobacter sp. 1872529 Bacteria Bacteria 88.6 1.07e-18   NR WP_310602958.1 1872529 g16250 i0 62.5 3.86138613861386 64 24 95 0 8 199 100 163 WP_310602958.1 tetratricopeptide repeat protein [Anaerosporobacter sp.] diamond 780 88.6 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Anaerosporobacter Anaerosporobacter sp.
28860634 28860634 PRJNA436017_P_NODE_21748_length_175_cov_1.681159_g21450_i0 PRJNA436017 21748 175 1.681159 2.94202825 root 1 Root_unresolved Root_unresolved 91.7 1.82e-20   NR WP_073091523.1 54294 g21450 i0 77.2 56.6742857142857 57 13 97.7 0 173 3 75 131 WP_073091523.1 cysteine synthase A [Thermosyntropha lipolytica] diamond 9918 91.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Syntrophomonadaceae Thermosyntropha Thermosyntropha lipolytica
29302750 29302750 PRJNA436017_P_NODE_6149_length_361_cov_5.987654_g5853_i0 PRJNA436017 6149 361 5.987654 21.61543094 FCB group 1783270 Bacteria Bacteria 53.5 4.72e-6   NR HQP68768.1 1898207 g5853 i0 42.6 2.26869806094183 54 31 44.9 0 199 360 1 54 HQP68768.1 hotdog domain-containing protein [Clostridiales bacterium] diamond 819 53.5 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
29791357 29791357 PRJNA436017_P_NODE_6771_length_343_cov_1.522876_g6474_i0 PRJNA436017 6771 343 1.522876 5.22346468 Culicoidibacter larvae 2579976 Bacteria Bacteria 102 1.43e-24   NR WP_138191308.1 2579976 g6474 i0 70 0.612244897959184 70 21 61.2 0 343 134 24 93 WP_138191308.1 ribosome hibernation-promoting factor, HPF/YfiA family [Culicoidibacter larvae] diamond 210 102 1 Bacteria   Bacillati Bacillota Culicoidibacteria Culicoidibacterales Culicoidibacteraceae Culicoidibacter Culicoidibacter larvae
30012782 30012782 PRJNA436017_P_NODE_19851_length_183_cov_2.089041_g19553_i0 PRJNA436017 19851 183 2.089041 3.82294503 Paraclostridium bifermentans 1490 Bacteria Bacteria 69.3 3.1e-12   NR WP_373598110.1 1490 g19553 i0 54.2 4.75409836065574 59 27 96.7 0 180 4 199 257 WP_373598110.1 peroxide stress protein YaaA [Paraclostridium bifermentans] diamond 870 69.3 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Paraclostridium Paraclostridium bifermentans
30107324 30107324 PRJNA436017_P_NODE_21812_length_175_cov_1.376812_g21514_i0 PRJNA436017 21812 175 1.376812 2.409421 Staphylococcus aureus 1280 Bacteria Bacteria 122 4.739999999999999e-31   NR WP_304716840.1 1280 g21514 i0 100 0.994285714285714 58 0 99.4 0 174 1 273 330 WP_304716840.1 DUF3526 domain-containing protein, partial [Staphylococcus aureus] diamond 174 122 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30201971 30201971 PRJNA436017_P_NODE_14732_length_217_cov_0.933333_g14434_i0 PRJNA436017 14732 217 0.933333 2.02533261 Fictibacillus iocasae 2715437 Bacteria Bacteria 45.4 0.00276   NR WP_379750549.1 2715437 g14434 i0 38.8 0.67741935483871 49 30 67.7 0 214 68 101 149 WP_379750549.1 sulfotransferase family 2 domain-containing protein [Fictibacillus iocasae] diamond 147 45.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Fictibacillaceae Fictibacillus Fictibacillus iocasae
30455347 30455347 PRJNA436017_P_NODE_8853_length_293_cov_3.445312_g8555_i0 PRJNA436017 8853 293 3.445312 10.09476416 Bacillus sp. SRB_28 1969378 Bacteria Bacteria 41.6 0.0239   NR RAN86401.1 1969378 g8555 i0 49.1 0.542662116040956 53 24 54.3 1 16 174 1 50 RAN86401.1 hypothetical protein B5P41_29460 [Bacillus sp. SRB_28] diamond 159 41.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. SRB_28
30549675 30549675 PRJNA436017_P_NODE_12513_length_239_cov_1.128713_g12215_i0 PRJNA436017 12513 239 1.128713 2.69762407 Mogibacterium sp. 2049035 Bacteria Bacteria 48.5 3.1e-4   NR HHW94483.1 2049035 g12215 i0 41.9 3.05020920502092 62 36 77.8 0 187 2 199 260 HHW94483.1 HpaII family restriction endonuclease [Mogibacterium sp.] diamond 729 48.5 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae Mogibacterium Mogibacterium sp.
30739283 30739283 PRJNA436017_P_NODE_29794_length_150_cov_1.008850_g29496_i0 PRJNA436017 29794 150 1.00885 1.513275 Bacillus altitudinis 293387 Bacteria Bacteria 47.4 2.39e-4   NR WP_163116658.1 293387 g29496 i0 52.4 0.84 42 20 84 0 143 18 458 499 WP_163116658.1 Dyp-type peroxidase [Bacillus altitudinis] diamond 126 47.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus altitudinis
31244841 31244841 PRJNA436017_P_NODE_11295_length_254_cov_2.124424_g10997_i0 PRJNA436017 11295 254 2.124424 5.39603696 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 67.4 8.69e-11   NR MCR5638921.1 1898203 g10997 i0 45.8 4.86614173228346 83 43 98 1 5 253 198 278 MCR5638921.1 molecular chaperone DnaK [Lachnospiraceae bacterium] diamond 1236 67.4 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
31244843 31244843 PRJNA436017_P_NODE_13315_length_230_cov_1.404145_g13017_i0 PRJNA436017 13315 230 1.404145 3.2295335 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 41.6 0.0182   NR MBQ2937186.1 1898203 g13017 i0 32.1 0.730434782608696 56 38 73 0 169 2 15 70 MBQ2937186.1 hypothetical protein [Lachnospiraceae bacterium] diamond 168 41.6 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
31483000 31483000 PRJNA436017_P_NODE_23596_length_168_cov_1.190840_g23298_i0 PRJNA436017 23596 168 1.19084 2.0006112 Bacillota 1239 Bacteria Bacteria 68.6 1.03e-11   NR WP_034636389.1 574376 g23298 i0 65.5 5.89285714285714 55 19 98.2 0 3 167 401 455 WP_034636389.1 alanine/glycine:cation symporter family protein [Bacillus manliponensis] diamond 990 68.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus manliponensis
31830478 31830478 PRJNA436017_P_NODE_8177_length_309_cov_1.698529_g7880_i0 PRJNA436017 8177 309 1.698529 5.24845461 FCB group 1783270 Bacteria Bacteria 112 2.16e-26   NR MCM1520631.1 2028282 g7880 i0 53.8 8.04854368932039 104 47 100 1 309 1 390 493 MCM1520631.1 tetratricopeptide repeat protein [Lachnoclostridium sp.] diamond 2487 112 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Lachnoclostridium Lachnoclostridium sp.
32004154 32004154 PRJNA436017_P_NODE_7698_length_319_cov_2.336879_g7401_i0 PRJNA436017 7698 319 2.336879 7.45464401 Vallitaleaceae bacterium 2762022 Bacteria Bacteria 87.8 1.62e-19   NR MBC7960377.1 2762022 g7401 i0 61.9 0.592476489028213 63 24 59.2 0 78 266 1 63 MBC7960377.1 PspC domain-containing protein [Vallitaleaceae bacterium] diamond 189 87.8 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Vallitaleaceae   Vallitaleaceae bacterium
32067239 32067239 PRJNA436017_P_NODE_26878_length_157_cov_1.925000_g26580_i0 PRJNA436017 26878 157 1.925 3.02225 Tissierellia bacterium 2049431 Bacteria Bacteria 57.4 5.03e-9   NR HHV45653.1 2049431 g26580 i0 44.2 0.993630573248408 52 29 99.4 0 2 157 33 84 HHV45653.1 antibiotic biosynthesis monooxygenase [Tissierellia bacterium] diamond 156 57.4 1 Bacteria   Bacillati Bacillota Tissierellia       Tissierellia bacterium
32147116 32147116 PRJNA436017_P_NODE_22918_length_170_cov_2.338346_g22620_i0 PRJNA436017 22918 170 2.338346 3.9751882 FCB group 1783270 Bacteria Bacteria 81.3 9.07e-18   NR WP_257529799.1 1796619 g22620 i0 69.6 11.8411764705882 56 17 98.8 0 169 2 34 89 WP_257529799.1 Fur family transcriptional regulator [Irregularibacter muris] diamond 2013 82 0.991463414634146 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Irregularibacter Irregularibacter muris
32257552 32257552 PRJNA436017_P_NODE_15618_length_209_cov_1.813953_g15320_i0 PRJNA436017 15618 209 1.813953 3.79116177 Clostridium sp. DSM 8431 1761781 Bacteria Bacteria 99 4.8499999999999996e-23   NR WP_090011792.1 1761781 g15320 i0 64.7 2.92822966507177 68 24 97.6 0 204 1 1 68 WP_090011792.1 cysteine synthase A [Clostridium sp. DSM 8431] diamond 612 99 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. DSM 8431

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