RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJDB12578" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJDB12578 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
1274527 1274527 PRJDB12578_S_NODE_101022_length_288_cov_1.907950_g77964_i0 PRJDB12578 101022 288 1.90795 5.494896 Bacteria 2 Bacteria Bacteria 174 6.39e-50   NR WP_010016981.1 1244 g77964 i0 82.8 13.75 93 16 96.9 0 280 2 337 429 WP_010016981.1 6-phospho-beta-glucosidase [Leuconostoc gelidum] diamond 3960 175 0.994285714285714 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Leuconostoc Leuconostoc gelidum
22954152 22954152 PRJDB12578_S_NODE_149319_length_204_cov_1.000000_g126261_i0 PRJDB12578 149319 204 1 2.04 Enterococcus faecium 1352 Bacteria Bacteria 112 2.01e-29   NR SAZ28818.1 1352 g126261 i0 77.6 5.91176470588235 67 15 98.5 0 202 2 57 123 SAZ28818.1 Integrase [Enterococcus faecium] diamond 1206 112 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
26709631 26709631 PRJDB12578_S_NODE_193781_length_169_cov_0.866667_g170723_i0 PRJDB12578 193781 169 0.866667 1.46466723 Streptococcus 1301 Bacteria Bacteria 68.2 4.27e-12   NR WP_287180993.1 1306 g170723 i0 59.3 5.75147928994083 54 22 95.9 0 162 1 1 54 WP_287180993.1 DeoR/GlpR family DNA-binding transcription regulator, partial [Streptococcus sp.] diamond 972 68.2 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp.
27538032 27538032 PRJDB12578_S_NODE_166384_length_188_cov_1.805755_g143326_i0 PRJDB12578 166384 188 1.805755 3.3948194 Anaerovoracaceae bacterium 3030912 Bacteria Bacteria 48.9 1.16e-4   NR MFA5638547.1 3030912 g143326 i0 63.3 1.00531914893617 30 11 47.9 0 96 185 8 37 MFA5638547.1 peptide-methionine (R)-S-oxide reductase MsrB [Anaerovoracaceae bacterium] diamond 189 48.9 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae   Anaerovoracaceae bacterium
27910737 27910737 PRJDB12578_S_NODE_123225_length_237_cov_2.250000_g100167_i0 PRJDB12578 123225 237 2.25 5.3325 Bacteria 2 Bacteria Bacteria 129 1.13e-33   NR WP_013976559.1 1042156 g100167 i0 70.5 2.9620253164557 78 23 98.7 0 2 235 47 124 WP_013976559.1 iron-containing alcohol dehydrogenase [Clostridium sp. SY8519] diamond 702 129 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. SY8519
27916681 27916681 PRJDB12578_S_NODE_157745_length_196_cov_1.054422_g134687_i0 PRJDB12578 157745 196 1.054422 2.06666712 Enterococcus faecium 1352 Bacteria Bacteria 40 0.0359   NR PQG87639.1 1352 g134687 i0 42.5 1.22448979591837 40 20 61.2 1 121 2 29 65 PQG87639.1 hypothetical protein CUS53_03215 [Enterococcus faecium] diamond 240 40 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
28138078 28138078 PRJDB12578_S_NODE_132665_length_223_cov_1.189655_g109607_i0 PRJDB12578 132665 223 1.189655 2.65293065 Syntrophomonas sp. 2053627 Bacteria Bacteria 45.4 0.00289   NR MEN6324598.1 2053627 g109607 i0 35.6 0.982062780269058 73 41 90.1 1 214 14 175 247 MEN6324598.1 anaerobic ribonucleoside-triphosphate reductase activating protein [Syntrophomonas sp.] diamond 219 45.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Syntrophomonadaceae Syntrophomonas Syntrophomonas sp.
28258121 28258121 PRJDB12578_S_NODE_122666_length_238_cov_2.185185_g99608_i0 PRJDB12578 122666 238 2.185185 5.2007403 Enterococcus 1350 Bacteria Bacteria 128 7.32e-33   NR WP_081157081.1 1352 g99608 i0 75.9 7.96638655462185 79 19 99.6 0 2 238 78 156 WP_081157081.1 amino acid permease [Enterococcus faecium] diamond 1896 128 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
28953179 28953179 PRJDB12578_S_NODE_98328_length_297_cov_2.080645_g75270_i0 PRJDB12578 98328 297 2.080645 6.17951565 Bacilli 91061 Bacteria Bacteria 118 6.48e-30   NR WP_298789012.1 487012 g75270 i0 79.2 13.8181818181818 72 15 72.7 0 295 80 248 319 WP_298789012.1 IS30 family transposase [uncultured Marinococcus sp.] diamond 4104 119 0.991596638655462 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Marinococcus uncultured Marinococcus sp.
29179983 29179983 PRJDB12578_S_NODE_183909_length_175_cov_1.238095_g160851_i0 PRJDB12578 183909 175 1.238095 2.16666625 Clostridium sp. SM-53 1506 Bacteria Bacteria 92.8 9.54e-21   NR WP_169104013.1 2725303 g160851 i0 78.9 6.84 57 12 97.7 0 172 2 1 57 WP_169104013.1 mannose/fructose/sorbose PTS transporter subunit IIA [Clostridium sp. SM-530-WT-3G] diamond 1197 92.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. SM-530-WT-3G
29457807 29457807 PRJDB12578_S_NODE_138690_length_215_cov_1.831325_g115632_i0 PRJDB12578 138690 215 1.831325 3.93734875 Bacteria 2 Bacteria Bacteria 122 1.51e-30   NR WP_209797535.1 39489 g115632 i0 81.4 30.2651162790698 70 13 97.7 0 5 214 16 85 WP_209797535.1 glutamate:gamma-aminobutyrate antiporter [Clostridium moniliforme] diamond 6507 123 0.991869918699187 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium moniliforme
29874505 29874505 PRJDB12578_S_NODE_129371_length_227_cov_2.612360_g106313_i0 PRJDB12578 129371 227 2.61236 5.9300572 Bacilli bacterium 1903720 Bacteria Bacteria 42.4 0.0432   NR MBR2833349.1 1903720 g106313 i0 36.8 0.753303964757709 57 33 71.4 1 40 201 2444 2500 MBR2833349.1 InlB B-repeat-containing protein [Bacilli bacterium] diamond 171 42.4 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
30126913 30126913 PRJDB12578_S_NODE_158852_length_195_cov_1.061644_g135794_i0 PRJDB12578 158852 195 1.061644 2.0702058 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 42 0.0369   NR MCR4959884.1 1898203 g135794 i0 45.8 0.738461538461539 48 20 73.8 1 23 166 219 260 MCR4959884.1 DNA mismatch repair endonuclease MutL [Lachnospiraceae bacterium] diamond 144 42 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
30695818 30695818 PRJDB12578_S_NODE_173394_length_183_cov_1.149254_g150336_i0 PRJDB12578 173394 183 1.149254 2.10313482 Apilactobacillus apisilvae 2923364 Bacteria Bacteria 44.3 0.00476   NR WP_249511526.1 2923364 g150336 i0 35.6 0.967213114754098 59 36 96.7 1 183 7 216 272 WP_249511526.1 RluA family pseudouridine synthase [Apilactobacillus apisilvae] diamond 177 44.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Apilactobacillus Apilactobacillus apisilvae
30727417 30727417 PRJDB12578_S_NODE_135774_length_219_cov_1.211765_g112716_i0 PRJDB12578 135774 219 1.211765 2.65376535 Listeria grandensis FSL F6- 1494963 Bacteria Bacteria 132 4.49e-38   NR EUJ25004.1 1265819 g112716 i0 80.8 6 73 14 100 0 1 219 30 102 EUJ25004.1 cytidine deaminase [Listeria grandensis FSL F6-0971] diamond 1314 132 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria grandensis
31227050 31227050 PRJDB12578_S_NODE_159555_length_194_cov_1.427586_g136497_i0 PRJDB12578 159555 194 1.427586 2.76951684 Bacteria 2 Bacteria Bacteria 79.3 3.23e-17   NR WP_016186185.1 1356 g136497 i0 67.2 2.69072164948454 58 19 89.7 0 176 3 1 58 WP_016186185.1 PTS cellobiose transporter subunit IIA [Enterococcus sulfureus] diamond 522 79.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus sulfureus
31264693 31264693 PRJDB12578_S_NODE_112735_length_258_cov_0.980861_g89677_i0 PRJDB12578 112735 258 0.980861 2.53062138 Enterococcus lactis 357441 Bacteria Bacteria 135 1.58e-36   NR WP_413122001.1 357441 g89677 i0 74.1 1.97674418604651 85 22 98.8 0 3 257 49 133 WP_413122001.1 IS30 family transposase [Enterococcus lactis] diamond 510 135 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus lactis
31549592 31549592 PRJDB12578_S_NODE_141716_length_212_cov_1.147239_g118658_i0 PRJDB12578 141716 212 1.147239 2.43214668 Mobilitalea sp. 1969408 Bacteria Bacteria 43.9 0.00965   NR HKL99549.1 1969408 g118658 i0 41.1 0.792452830188679 56 31 76.4 1 163 2 366 421 HKL99549.1 hypothetical protein [Mobilitalea sp.] diamond 168 43.9 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Mobilitalea Mobilitalea sp.
31707455 31707455 PRJDB12578_S_NODE_121837_length_240_cov_1.350785_g98779_i0 PRJDB12578 121837 240 1.350785 3.241884 Dehalobacter sp. DCM 2907827 Bacteria Bacteria 42.7 0.0214   NR WP_337984722.1 2907827 g98779 i0 34.3 0.875 70 42 82.5 1 207 10 36 105 WP_337984722.1 adenylate cyclase [Dehalobacter sp. DCM] diamond 210 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Dehalobacter Dehalobacter sp. DCM
32498660 32498660 PRJDB12578_S_NODE_167599_length_187_cov_1.753623_g144541_i0 PRJDB12578 167599 187 1.753623 3.27927501 Listeria aquatica 1494960 Bacteria Bacteria 99.4 2.67e-23   NR WP_036074432.1 1494960 g144541 i0 87.3 1.76470588235294 55 7 88.2 0 187 23 250 304 WP_036074432.1 PTS system mannose/fructose/sorbose family transporter subunit IID [Listeria aquatica] diamond 330 99.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria aquatica
32650064 32650064 PRJDB12578_S_NODE_161180_length_193_cov_1.055556_g138122_i0 PRJDB12578 161180 193 1.055556 2.03722308 root 1 Root_unresolved Root_unresolved 42.7 0.0156   NR MFR6965839.1 1313 g138122 i0 52.5 3.21761658031088 40 19 62.2 0 72 191 108 147 MFR6965839.1 hypothetical protein [Streptococcus pneumoniae] diamond 621 42.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
32719191 32719191 PRJDB12578_S_NODE_106160_length_273_cov_2.169643_g83102_i0 PRJDB12578 106160 273 2.169643 5.92312539 Streptococcus respiraculi 2021971 Bacteria Bacteria 43.5 0.0157   NR WP_119876833.1 2021971 g83102 i0 44.4 0.494505494505495 45 23 47.3 1 203 75 36 80 WP_119876833.1 VanZ family protein [Streptococcus respiraculi] diamond 135 43.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus respiraculi

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