RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA380660" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA380660 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
1677012 1677012 PRJNA380660_P_NODE_4582_length_375_cov_3.014451_g4185_i0 PRJNA380660 4582 375 3.014451 11.30419125 Clostridia bacterium 2044939 Bacteria Bacteria 134 6.83e-36   NR MFA7674270.1 2044939 g4185 i0 78.5 0.632 79 17 63.2 0 1 237 185 263 MFA7674270.1 type I glyceraldehyde-3-phosphate dehydrogenase [Clostridia bacterium] diamond 237 134 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
9330344 9330344 PRJNA380660_P_NODE_8628_length_233_cov_1.901961_g8228_i0 PRJNA380660 8628 233 1.901961 4.43156913 Bacillati 1783272 Bacteria Bacteria 103 9.34e-24   NR WP_294352809.1 59620 g8228 i0 86.4 117.978540772532 59 7 76 1 179 3 568 625 WP_294352809.1 ATP-dependent Clp protease ATP-binding subunit [uncultured Clostridium sp.] diamond 27489 104 0.990384615384615 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium uncultured Clostridium sp.
23354306 23354306 PRJNA380660_P_NODE_8479_length_236_cov_4.599034_g8079_i0 PRJNA380660 8479 236 4.599034 10.85372024 Streptococcus mitis 28037 Bacteria Bacteria 102 3.51e-24   NR MFS9207101.1 28037 g8079 i0 73.4 3.72457627118644 79 19 97.9 1 234 4 106 184 MFS9207101.1 hypothetical protein [Streptococcus mitis] diamond 879 102 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
27597721 27597721 PRJNA380660_P_NODE_9904_length_209_cov_1.222222_g9504_i0 PRJNA380660 9904 209 1.222222 2.55444398 Bacillaceae 186817 Bacteria Bacteria 70.1 1.66e-12   NR WP_035195791.1 1454 g9504 i0 51.5 1.95215311004785 68 20 97.6 2 2 205 111 165 WP_035195791.1 pirin family protein [Schinkia azotoformans] diamond 408 70.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Schinkia Schinkia azotoformans
30959754 30959754 PRJNA380660_P_NODE_5974_length_313_cov_2.778169_g5574_i0 PRJNA380660 5974 313 2.778169 8.69566897 Sporolactobacillus laevolacticus 33018 Bacteria Bacteria 70.9 2.17e-12   NR WP_023509635.1 33018 g5574 i0 54 2.37699680511182 63 24 60.4 2 312 124 148 205 WP_023509635.1 superoxide dismutase [Sporolactobacillus laevolacticus] diamond 744 70.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Sporolactobacillus Sporolactobacillus laevolacticus
32146893 32146893 PRJNA380660_P_NODE_5398_length_336_cov_2.508143_g4999_i0 PRJNA380660 5398 336 2.508143 8.42736048 root 1 Root_unresolved Root_unresolved 71.6 2.28e-13   NR WP_195452259.1 1624 g4999 i0 39.6 6.72321428571429 106 64 94.6 0 320 3 4 109 WP_195452259.1 30S ribosomal protein S13 [Ligilactobacillus salivarius] diamond 2259 72 0.994444444444444 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Ligilactobacillus Ligilactobacillus salivarius
32761658 32761658 PRJNA380660_P_NODE_8220_length_242_cov_3.478873_g7820_i0 PRJNA380660 8220 242 3.478873 8.41887266 Streptococcus sp. 1306 Bacteria Bacteria 89.4 1.44e-18   NR RKW00080.1 1306 g7820 i0 71.3 0.991735537190083 80 23 99.2 0 2 241 356 435 RKW00080.1 MAG: SEC10/PgrA surface exclusion domain-containing protein, partial [Streptococcus sp.] diamond 240 89.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp.
32904478 32904478 PRJNA380660_P_NODE_1460_length_702_cov_2.368499_g1156_i0 PRJNA380660 1460 702 2.368499 16.62686298 Bacillaceae 186817 Bacteria Bacteria 66.2 5.63e-9   NR WP_197140054.1 1421 g1156 i0 58.2 1.59401709401709 55 23 23.5 0 515 351 184 238 WP_197140054.1 AP2 domain-containing protein [Lysinibacillus sphaericus] diamond 1119 66.6 0.993993993993994 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Lysinibacillus Lysinibacillus sphaericus

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