RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1113956" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1113956 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
1496695 1496695 PRJNA1113956_P_NODE_19802_length_251_cov_0.865169_g19462_i0 PRJNA1113956 19802 251 0.865169 2.17157419 Desulfitobacterium 36853 Bacteria Bacteria 153 5.5299999999999985e-43   NR WP_323414714.1 49981 g19462 i0 90.4 2.97609561752988 83 8 99.2 0 1 249 203 285 WP_323414714.1 DNA-processing protein DprA [Desulfitobacterium sp.] diamond 747 153 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfitobacterium Desulfitobacterium sp.
2772631 2772631 PRJNA1113956_P_NODE_22803_length_241_cov_0.916667_g22463_i0 PRJNA1113956 22803 241 0.916667 2.20916747 Desulfitobacterium 36853 Bacteria Bacteria 139 3.85e-36   NR WP_325390638.1 49981 g22463 i0 98.7 4.86721991701245 77 1 95.9 0 231 1 607 683 WP_325390638.1 DNA translocase FtsK [Desulfitobacterium sp.] diamond 1173 139 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfitobacterium Desulfitobacterium sp.
23174275 23174275 PRJNA1113956_P_NODE_19959_length_250_cov_0.870056_g19619_i0 PRJNA1113956 19959 250 0.870056 2.17514 Desulfitobacterium sp. 49981 Bacteria Bacteria 159 4.58e-47   NR WP_325390308.1 49981 g19619 i0 92.8 0.996 83 6 99.6 0 2 250 143 225 WP_325390308.1 response regulator [Desulfitobacterium sp.] diamond 249 159 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfitobacterium Desulfitobacterium sp.
27225858 27225858 PRJNA1113956_P_NODE_22263_length_243_cov_0.905882_g21923_i0 PRJNA1113956 22263 243 0.905882 2.20129326 [Clostridium] innocuum 1522 Bacteria Bacteria 42.4 0.0474   NR WP_233106945.1 1522 g21923 i0 45.5 0.54320987654321 44 22 54.3 1 39 170 69 110 WP_233106945.1 isoaspartyl peptidase/L-asparaginase [[Clostridium] innocuum] diamond 132 42.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium [Clostridium] innocuum
27478761 27478761 PRJNA1113956_P_NODE_17623_length_278_cov_1.097561_g17283_i0 PRJNA1113956 17623 278 1.097561 3.05121958 Lactobacillus hominis 1203033 Bacteria Bacteria 43.5 0.0305   NR WP_008470548.1 1203033 g17283 i0 36.7 0.647482014388489 60 37 63.7 1 204 28 1 60 WP_008470548.1 ATP-dependent Clp protease ATP-binding subunit [Lactobacillus hominis] diamond 180 43.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus hominis
27763206 27763206 PRJNA1113956_P_NODE_22844_length_241_cov_0.916667_g22504_i0 PRJNA1113956 22844 241 0.916667 2.20916747 Desulfitobacterium sp. THU1 3138072 Bacteria Bacteria 137 3.12e-37   NR WP_341547374.1 3138072 g22504 i0 83.5 2.95020746887967 79 13 98.3 0 2 238 95 173 WP_341547374.1 sulfate reduction electron transfer complex DsrMKJOP subunit DsrM [Desulfitobacterium sp. THU1] diamond 711 137 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfitobacterium Desulfitobacterium sp. THU1
27920749 27920749 PRJNA1113956_P_NODE_11345_length_397_cov_3.043210_g11005_i0 PRJNA1113956 11345 397 3.04321 12.0815437 Ruminococcus sp. 41978 Bacteria Bacteria 43.9 0.034   NR MEE1317892.1 41978 g11005 i0 37 0.408060453400504 54 34 40.8 0 226 387 63 116 MEE1317892.1 hypothetical protein [Ruminococcus sp.] diamond 162 43.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
27952428 27952428 PRJNA1113956_P_NODE_1345_length_1557_cov_3.820081_g1234_i0 PRJNA1113956 1345 1557 3.820081 59.47866117 Clostridia bacterium 2044939 Bacteria Bacteria 48.9 0.0475   NR MDO5555969.1 2044939 g1234 i0 23.4 0.543352601156069 282 177 52.6 11 42 860 54 305 MDO5555969.1 DUF5711 family protein [Clostridia bacterium] diamond 846 48.9 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28710337 28710337 PRJNA1113956_P_NODE_9787_length_447_cov_4.767380_g9448_i0 PRJNA1113956 9787 447 4.76738 21.3101886 Bacilli bacterium 1903720 Bacteria Bacteria 47.4 0.0051   NR MDD2681350.1 1903720 g9448 i0 23.7 0.624161073825503 93 70 62.4 1 375 97 38 129 MDD2681350.1 tRNA (guanosine(37)-N1)-methyltransferase TrmD [Bacilli bacterium] diamond 279 47.4 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
28741741 28741741 PRJNA1113956_P_NODE_22067_length_243_cov_0.905882_g21727_i0 PRJNA1113956 22067 243 0.905882 2.20129326 Desulfosporosinus acidiphilus 885581 Bacteria Bacteria 131 1.67e-34   NR WP_014826505.1 885581 g21727 i0 80 1.97530864197531 80 16 98.8 0 242 3 315 394 WP_014826505.1 Nramp family divalent metal transporter [Desulfosporosinus acidiphilus] diamond 480 131 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfosporosinus Desulfosporosinus acidiphilus
28859018 28859018 PRJNA1113956_P_NODE_19808_length_251_cov_0.865169_g19468_i0 PRJNA1113956 19808 251 0.865169 2.17157419 Bacillaceae 186817 Bacteria Bacteria 72 2.6e-14   NR WP_090775859.1 1464122 g19468 i0 51.8 2.92828685258964 83 40 99.2 0 2 250 2 84 WP_090775859.1 30S ribosomal protein S20 [Shouchella lonarensis] diamond 735 72.4 0.994475138121547 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Shouchella Shouchella lonarensis
29531156 29531156 PRJNA1113956_P_NODE_15630_length_307_cov_1.581197_g15290_i0 PRJNA1113956 15630 307 1.581197 4.85427479 Clostridium felsineum 36839 Bacteria Bacteria 43.9 0.0244   NR WP_077833580.1 36839 g15290 i0 30.4 0.899022801302932 92 58 84 1 306 49 53 144 WP_077833580.1 hypothetical protein [Clostridium felsineum] diamond 276 43.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium felsineum
29837833 29837833 PRJNA1113956_P_NODE_22671_length_241_cov_0.916667_g22331_i0 PRJNA1113956 22671 241 0.916667 2.20916747 Veillonella 29465 Bacteria Bacteria 155 5.8e-46   NR EFL55540.1 866776 g22331 i0 98.7 3.93360995850622 79 1 98.3 0 239 3 37 115 EFL55540.1 transcriptional regulator, AraC family [Veillonella atypica ACS-049-V-Sch6] diamond 948 155 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella atypica
30067920 30067920 PRJNA1113956_P_NODE_13252_length_349_cov_1.981884_g12912_i0 PRJNA1113956 13252 349 1.981884 6.91677516 Clostridiales bacterium 1898207 Bacteria Bacteria 45.1 0.0183   NR MDD5994283.1 1898207 g12912 i0 24 0.893982808022923 104 65 79.1 3 68 343 132 233 MDD5994283.1 methyl-accepting chemotaxis protein [Clostridiales bacterium] diamond 312 45.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
30090486 30090486 PRJNA1113956_P_NODE_22432_length_242_cov_0.911243_g22092_i0 PRJNA1113956 22432 242 0.911243 2.20520806 Bacteria 2 Bacteria Bacteria 89.4 3.4300000000000004e-21   NR WP_415410990.1 985762 g22092 i0 100 1.63636363636364 44 0 54.5 0 241 110 47 90 WP_415410990.1 type II toxin-antitoxin system ParD family antitoxin, partial [Staphylococcus agnetis] diamond 396 89.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus agnetis
30541879 30541879 PRJNA1113956_P_NODE_10353_length_428_cov_1.780282_g10014_i0 PRJNA1113956 10353 428 1.780282 7.61960696 Erysipelotrichales bacterium 2478483 Bacteria Bacteria 44.7 0.0419   NR MCH5167461.1 2478483 g10014 i0 38.6 0.308411214953271 44 27 30.8 0 161 292 162 205 MCH5167461.1 hypothetical protein [Erysipelotrichales bacterium] diamond 132 44.7 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales     Erysipelotrichales bacterium
30731418 30731418 PRJNA1113956_P_NODE_11734_length_386_cov_12.539936_g11394_i0 PRJNA1113956 11734 386 12.539936 48.40415296 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 86.3 4.59e-19   NR MBQ5561215.1 1898203 g11394 i0 42.2 2.97668393782383 83 48 64.5 0 260 12 16 98 MBQ5561215.1 thioredoxin [Lachnospiraceae bacterium] diamond 1149 86.3 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
30731426 30731426 PRJNA1113956_P_NODE_21654_length_244_cov_1.801170_g21314_i0 PRJNA1113956 21654 244 1.80117 4.3948548 Veillonella tobetsuensis 1110546 Bacteria Bacteria 164 6.209999999999999e-47   NR WP_137662049.1 1110546 g21314 i0 98.8 0.995901639344262 81 1 99.6 0 2 244 52 132 WP_137662049.1 MFS transporter [Veillonella tobetsuensis] diamond 243 164 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella tobetsuensis
30889516 30889516 PRJNA1113956_P_NODE_16914_length_287_cov_1.593458_g16574_i0 PRJNA1113956 16914 287 1.593458 4.57322446 Lachnospira eligens 39485 Bacteria Bacteria 42.4 0.0469   NR WP_055214033.1 39485 g16574 i0 32 0.78397212543554 75 46 78.4 1 261 37 89 158 WP_055214033.1 hypothetical protein [Lachnospira eligens] diamond 225 42.4 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Lachnospira Lachnospira eligens
31331876 31331876 PRJNA1113956_P_NODE_22076_length_243_cov_0.905882_g21736_i0 PRJNA1113956 22076 243 0.905882 2.20129326 uncultured Oribacterium sp. 462198 Bacteria Bacteria 161 1.14e-44   NR WP_315001811.1 462198 g21736 i0 98.8 3 81 1 100 0 1 243 87 167 WP_315001811.1 lysylphosphatidylglycerol synthase domain-containing protein, partial [uncultured Oribacterium sp.] diamond 729 161 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Oribacterium uncultured Oribacterium 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);;