RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA399133" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA399133 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
413280 413280 PRJNA399133_P_NODE_8881_length_176_cov_1.687943_g8793_i0 PRJNA399133 8881 176 1.687943 2.97077968 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 88.2 5.2500000000000005e-21   NR MBS7360328.1 2485925 g8793 i0 69.6 0.954545454545455 56 17 95.5 0 170 3 1 56 MBS7360328.1 hypothetical protein [Oscillospiraceae bacterium] diamond 168 88.2 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
26758769 26758769 PRJNA399133_P_NODE_6421_length_207_cov_2.093023_g6333_i0 PRJNA399133 6421 207 2.093023 4.33255761 Bacilli bacterium 1903720 Bacteria Bacteria 44.3 0.00677   NR MBR6517658.1 1903720 g6333 i0 38.9 0.782608695652174 54 33 78.3 0 1 162 13 66 MBR6517658.1 hypothetical protein [Bacilli bacterium] diamond 162 44.3 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
28401834 28401834 PRJNA399133_P_NODE_11626_length_155_cov_1.666667_g11538_i0 PRJNA399133 11626 155 1.666667 2.58333385 Siminovitchia fortis 254758 Bacteria Bacteria 40 0.0156   NR WP_222122856.1 254758 g11538 i0 42.5 0.774193548387097 40 19 77.4 1 150 31 10 45 WP_222122856.1 hypothetical protein, partial [Siminovitchia fortis] diamond 120 40 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Siminovitchia Siminovitchia fortis
29128275 29128275 PRJNA399133_P_NODE_10849_length_160_cov_1.920000_g10761_i0 PRJNA399133 10849 160 1.92 3.072 Clostridia bacterium 2044939 Bacteria Bacteria 41.6 0.0305   NR MDD4109945.1 2044939 g10761 i0 65.4 0.4875 26 9 48.8 0 155 78 704 729 MDD4109945.1 BspA family leucine-rich repeat surface protein [Clostridia bacterium] diamond 78 41.6 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
29239550 29239550 PRJNA399133_P_NODE_5389_length_228_cov_2.404145_g5301_i0 PRJNA399133 5389 228 2.404145 5.4814506 FCB group 1783270 Bacteria Bacteria 120 1.52e-30   NR NLE25908.1 1898204 g5301 i0 73 6.77631578947368 74 20 97.4 0 224 3 114 187 NLE25908.1 terminase [Clostridiaceae bacterium] diamond 1545 120 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
29523692 29523692 PRJNA399133_P_NODE_3610_length_265_cov_2.147826_g3522_i0 PRJNA399133 3610 265 2.147826 5.6917389 PVC group 1783257 Bacteria Bacteria 51.6 3.59e-5   NR OKZ80925.1 1896992 g3522 i0 34.9 8.01509433962264 63 41 71.3 0 44 232 367 429 OKZ80925.1 MAG: chromosomal replication initiator protein DnaA [Clostridium sp. CAG:217_53_7] diamond 2124 51.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. CAG:217_53_7
29632834 29632834 PRJNA399133_P_NODE_2350_length_324_cov_1.806228_g2262_i0 PRJNA399133 2350 324 1.806228 5.85217872 Eubacteriales bacterium 2831996 Bacteria Bacteria 45.8 0.00581   NR MFA5386020.1 2831996 g2262 i0 55 0.37037037037037 40 18 37 0 191 72 72 111 MFA5386020.1 NUMOD3 domain-containing DNA-binding protein [Eubacteriales bacterium] diamond 120 45.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
29790914 29790914 PRJNA399133_P_NODE_5511_length_226_cov_0.942408_g5423_i0 PRJNA399133 5511 226 0.942408 2.12984208 Clostridia bacterium 2044939 Bacteria Bacteria 58.5 4.83e-8   NR MCK9574701.1 2044939 g5423 i0 62.5 1.04867256637168 40 14 51.8 1 119 3 1 40 MCK9574701.1 hypothetical protein [Clostridia bacterium] diamond 237 58.5 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30297058 30297058 PRJNA399133_P_NODE_1692_length_386_cov_2.131054_g1606_i0 PRJNA399133 1692 386 2.131054 8.22586844 Moorella thermoacetica 1525 Bacteria Bacteria 49.3 2.71e-4   NR WP_187422284.1 1525 g1606 i0 43.1 0.396373056994819 51 28 39.6 1 365 213 63 112 WP_187422284.1 YopX family protein [Moorella thermoacetica] diamond 153 49.3 1 Bacteria   Bacillati Bacillota Clostridia Neomoorellales Neomoorellaceae Neomoorella Neomoorella thermoacetica
30738829 30738829 PRJNA399133_P_NODE_1674_length_388_cov_2.175637_g1588_i0 PRJNA399133 1674 388 2.175637 8.44147156 Bacillota bacterium 1879010 Bacteria Bacteria 127 2.0199999999999998e-32   NR MEY3431632.1 1879010 g1588 i0 62 0.711340206185567 92 35 71.1 0 103 378 1 92 MEY3431632.1 hypothetical protein [Bacillota bacterium] diamond 276 127 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
31071723 31071723 PRJNA399133_P_NODE_4875_length_230_cov_1.435897_g4787_i0 PRJNA399133 4875 230 1.435897 3.3025631 FCB group 1783270 Bacteria Bacteria 65.9 4.15e-12   NR MFA5696499.1 1903720 g4787 i0 49.2 1.76086956521739 65 30 84.8 1 197 3 11 72 MFA5696499.1 hypothetical protein [Bacilli bacterium] diamond 405 65.9 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
31134457 31134457 PRJNA399133_P_NODE_10455_length_163_cov_1.562500_g10367_i0 PRJNA399133 10455 163 1.5625 2.546875 root 1 Root_unresolved Root_unresolved 75.9 2.65e-14   NR MEK6265978.1 1506 g10367 i0 68.5 1.98773006134969 54 17 99.4 0 162 1 98 151 MEK6265978.1 hypothetical protein [Clostridium sp.] diamond 324 75.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
31529278 31529278 PRJNA399133_P_NODE_4236_length_246_cov_1.327014_g4148_i0 PRJNA399133 4236 246 1.327014 3.26445444 Clostridia bacterium 2044939 Bacteria Bacteria 80.9 2.38e-18   NR HUV72302.1 2044939 g4148 i0 85.7 0.51219512195122 42 6 51.2 0 66 191 1 42 HUV72302.1 hypothetical protein [Clostridia bacterium] diamond 126 80.9 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31940183 31940183 PRJNA399133_P_NODE_12097_length_152_cov_1.752137_g12009_i0 PRJNA399133 12097 152 1.752137 2.66324824 Desmospora profundinema 1571184 Bacteria Bacteria 69.7 1.67e-12   NR WP_309862020.1 1571184 g12009 i0 62 0.986842105263158 50 19 98.7 0 150 1 131 180 WP_309862020.1 purine-nucleoside phosphorylase [Desmospora profundinema] diamond 150 69.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Desmospora Desmospora profundinema
32020432 32020432 PRJNA399133_P_NODE_10018_length_166_cov_1.770992_g9930_i0 PRJNA399133 10018 166 1.770992 2.93984672 root 1 Root_unresolved Root_unresolved 81.6 1.79e-18   NR MBS7360328.1 2485925 g9930 i0 75 4.35542168674699 48 12 86.7 0 2 145 49 96 MBS7360328.1 hypothetical protein [Oscillospiraceae bacterium] diamond 723 82.4 0.990291262135922 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
32035279 32035279 PRJNA399133_P_NODE_6058_length_214_cov_1.206704_g5970_i0 PRJNA399133 6058 214 1.206704 2.58234656 Cohnella thailandensis 557557 Bacteria Bacteria 78.6 3.76e-15   NR WP_245364137.1 557557 g5970 i0 43.7 0.995327102803738 71 37 99.5 1 213 1 141 208 WP_245364137.1 phage tail protein [Cohnella thailandensis] diamond 213 78.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Cohnella Cohnella thailandensis
32305448 32305448 PRJNA399133_P_NODE_9639_length_169_cov_2.626866_g9551_i0 PRJNA399133 9639 169 2.626866 4.43940354 root 1 Root_unresolved Root_unresolved 50.8 2.76e-6   NR WP_329977860.1 2049022 g9551 i0 42.9 1.98816568047337 56 31 97.6 1 166 2 30 85 WP_329977860.1 hypothetical protein [Catenibacterium sp.] diamond 336 51.2 0.9921875 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Coprobacillaceae Catenibacterium Catenibacterium sp.
32368672 32368672 PRJNA399133_P_NODE_11439_length_156_cov_2.132231_g11351_i0 PRJNA399133 11439 156 2.132231 3.32628036 FCB group 1783270 Bacteria Bacteria 78.6 9.14e-16   NR HIY80818.1 1879010 g11351 i0 69.4 22.5769230769231 49 15 94.2 0 4 150 193 241 HIY80818.1 purine-nucleoside phosphorylase [Bacillota bacterium] diamond 3522 79.3 0.991172761664565 Bacteria   Bacillati Bacillota         Bacillota bacterium

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