RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA753704" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA753704 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
17779797 17779797 PRJNA753704_P_NODE_25834_length_248_cov_0.885714_g25473_i0 PRJNA753704 25834 248 0.885714 2.19657072 root 1 Root_unresolved Root_unresolved 154 1.51e-46   NR HEG7268868.1 1280 g25473 i0 96.3 155.806451612903 82 3 99.2 0 247 2 32 113 HEG7268868.1 AAA family ATPase [Staphylococcus aureus] diamond 38640 155 0.993548387096774 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
27621733 27621733 PRJNA753704_P_NODE_26924_length_245_cov_0.906977_g26563_i0 PRJNA753704 26924 245 0.906977 2.22209365 Halobacillus sp. BBL2 56800 Bacteria Bacteria 77.4 5.96e-15   NR WP_035549111.1 1543706 g26563 i0 63.6 0.673469387755102 55 20 67.3 0 80 244 53 107 WP_035549111.1 polysaccharide deacetylase family protein [Halobacillus sp. BBL2006] diamond 165 77.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Halobacillus Halobacillus sp. BBL2006
27716682 27716682 PRJNA753704_P_NODE_16424_length_297_cov_1.321429_g16063_i0 PRJNA753704 16424 297 1.321429 3.92464413 Rossellomorea vietnamensis 218284 Bacteria Bacteria 43.9 0.0271   NR WP_148955333.1 218284 g16063 i0 44.4 0.545454545454545 54 27 54.5 1 9 170 116 166 WP_148955333.1 sigma 54-interacting transcriptional regulator [Rossellomorea vietnamensis] diamond 162 43.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Rossellomorea Rossellomorea vietnamensis
27915471 27915471 PRJNA753704_P_NODE_26185_length_247_cov_0.896552_g25824_i0 PRJNA753704 26185 247 0.896552 2.21448344 Bacillati 1783272 Bacteria Bacteria 48.5 1.19e-4   NR WP_025084668.1 83526 g25824 i0 39.3 4.95546558704453 56 34 68 0 229 62 41 96 WP_025084668.1 GNAT family N-acetyltransferase [Companilactobacillus paralimentarius] diamond 1224 48.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Companilactobacillus Companilactobacillus paralimentarius
29042587 29042587 PRJNA753704_P_NODE_22468_length_258_cov_1.221622_g22107_i0 PRJNA753704 22468 258 1.221622 3.15178476 Ruminococcus sp. 41978 Bacteria Bacteria 42.7 0.0451   NR MBP3761673.1 41978 g22107 i0 37.3 0.965116279069767 83 51 96.5 1 1 249 404 485 MBP3761673.1 recombinase family protein [Ruminococcus sp.] diamond 249 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
29484206 29484206 PRJNA753704_P_NODE_29210_length_236_cov_2.049080_g28849_i0 PRJNA753704 29210 236 2.04908 4.8358288 Ornithinibacillus sp. 16A2E 3144668 Bacteria Bacteria 48.5 1.43e-4   NR WP_345823224.1 3144668 g28849 i0 56.8 1.32203389830508 37 16 47 0 224 114 41 77 WP_345823224.1 HNH endonuclease signature motif containing protein [Ornithinibacillus xuwenensis] diamond 312 48.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Ornithinibacillus Ornithinibacillus xuwenensis
30021475 30021475 PRJNA753704_P_NODE_25471_length_248_cov_1.782857_g25110_i0 PRJNA753704 25471 248 1.782857 4.42148536 Clostridia bacterium 2044939 Bacteria Bacteria 66.2 1.89e-10   NR MEI6603586.1 2044939 g25110 i0 43.2 5.55241935483871 74 38 84.7 1 28 237 298 371 MEI6603586.1 AAA family ATPase [Clostridia bacterium] diamond 1377 66.2 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31538429 31538429 PRJNA753704_P_NODE_14696_length_312_cov_2.581590_g14335_i0 PRJNA753704 14696 312 2.58159 8.0545608 Niallia sp. 2837523 Bacteria Bacteria 50.4 1.2e-4   NR HWJ76696.1 2837523 g14335 i0 47.9 0.461538461538462 48 25 46.2 0 150 293 5 52 HWJ76696.1 sulfotransferase family 2 domain-containing protein [Niallia sp.] diamond 144 50.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Niallia Niallia sp.
31664635 31664635 PRJNA753704_P_NODE_11317_length_352_cov_1.512545_g10956_i0 PRJNA753704 11317 352 1.512545 5.3241584 Cohnella abietis 2507935 Bacteria Bacteria 70.1 3.52e-11   NR WP_130605050.1 2507935 g10956 i0 44.4 0.767045454545455 90 47 75 3 280 17 204 292 WP_130605050.1 InlB B-repeat-containing protein [Cohnella abietis] diamond 270 70.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Cohnella Cohnella abietis
31769462 31769462 PRJNA753704_P_NODE_16117_length_299_cov_2.849558_g15756_i0 PRJNA753704 16117 299 2.849558 8.52017842 Bacteria 2 Bacteria Bacteria 123 1.95e-33   NR MEM5768926.1 1879010 g15756 i0 71.3 8.57859531772575 80 23 80.3 0 298 59 80 159 MEM5768926.1 phosphoribosylglycinamide formyltransferase [Bacillota bacterium] diamond 2565 124 0.991935483870968 Bacteria   Bacillati Bacillota         Bacillota bacterium
32107647 32107647 PRJNA753704_P_NODE_24278_length_251_cov_0.876404_g23917_i0 PRJNA753704 24278 251 0.876404 2.19977404 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 55.5 7.92e-7   NR MCL2633677.1 2485925 g23917 i0 38.8 1.66135458167331 67 41 80.1 0 248 48 125 191 MCL2633677.1 lipase family protein [Oscillospiraceae bacterium] diamond 417 55.5 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
32529060 32529060 PRJNA753704_P_NODE_26919_length_245_cov_0.906977_g26558_i0 PRJNA753704 26919 245 0.906977 2.22209365 Veillonella 29465 Bacteria Bacteria 159 2.87e-44   NR WP_369688078.1 671229 g26558 i0 98.8 1.98367346938776 81 1 99.2 0 3 245 79 159 WP_369688078.1 LTA synthase family protein [Veillonella sp. oral taxon 780] diamond 486 159 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella sp. oral taxon 780
32613691 32613691 PRJNA753704_P_NODE_22660_length_257_cov_1.326087_g22299_i0 PRJNA753704 22660 257 1.326087 3.40804359 Bacillota bacterium 1879010 Bacteria Bacteria 41.6 0.0425   NR HEX7715580.1 1879010 g22299 i0 39.1 0.805447470817121 69 40 78.2 1 221 21 45 113 HEX7715580.1 hypothetical protein [Bacillota bacterium] diamond 207 41.6 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
32843827 32843827 PRJNA753704_P_NODE_29760_length_231_cov_2.493671_g29399_i0 PRJNA753704 29760 231 2.493671 5.76038001 Bacillati 1783272 Bacteria Bacteria 52.4 1.12e-5   NR HEX2938139.1 2053608 g29399 i0 69.7 3.92207792207792 33 10 42.9 0 226 128 263 295 HEX2938139.1 ATP synthase F1 subunit gamma [Ruminiclostridium sp.] diamond 906 52.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminiclostridium Ruminiclostridium 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);;