RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA263496" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 20 ✖

bioproject 1

  • PRJNA263496 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
2919732 2919732 PRJNA263496_P_NODE_13843_length_210_cov_1.273292_g13590_i0 PRJNA263496 13843 210 1.273292 2.6739132 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 106 1.36e-25   NR MBQ8928204.1 2485925 g13590 i0 70.6 3.88571428571429 68 20 97.1 0 5 208 191 258 MBQ8928204.1 aspartate--ammonia ligase [Oscillospiraceae bacterium] diamond 816 106 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
26884343 26884343 PRJNA263496_P_NODE_2581_length_567_cov_14.542471_g2338_i0 PRJNA263496 2581 567 14.542471 82.45581057 Mycobacterium tuberculosis 1773 Bacteria Bacteria 276 8.42e-93   NR WP_024754307.1 1773 g2338 i0 94.4 0.756613756613757 143 8 75.7 0 533 105 1 143 WP_024754307.1 hemoglobin alpha subunit family protein [Mycobacterium tuberculosis] diamond 429 276 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium tuberculosis
27642886 27642886 PRJNA263496_P_NODE_16844_length_190_cov_1.085106_g16591_i0 PRJNA263496 16844 190 1.085106 2.0617014 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 43.5 0.01   NR HTD57679.1 2586742 g16591 i0 59.3 0.963157894736842 27 11 42.6 0 34 114 310 336 HTD57679.1 Mu transposase C-terminal domain-containing protein [Solirubrobacteraceae bacterium] diamond 183 43.5 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
27737731 27737731 PRJNA263496_P_NODE_24684_length_162_cov_0.902655_g24431_i0 PRJNA263496 24684 162 0.902655 1.4623011 Aliterella atlantica 1827278 Bacteria Bacteria 106 2.4400000000000003e-27   NR WP_045052680.1 1827278 g24431 i0 94.3 2.94444444444444 53 3 98.1 0 160 2 42 94 WP_045052680.1 orange carotenoid protein N-terminal domain-containing protein [Aliterella atlantica] diamond 477 106 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
28558492 28558492 PRJNA263496_P_NODE_21107_length_167_cov_0.864407_g20854_i0 PRJNA263496 21107 167 0.864407 1.44355969 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 50.8 1.73e-5   NR MBP5305397.1 1898203 g20854 i0 57.4 0.844311377245509 47 17 84.4 1 3 143 248 291 MBP5305397.1 ROK family protein [Lachnospiraceae bacterium] diamond 141 50.8 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
28621609 28621609 PRJNA263496_P_NODE_17487_length_186_cov_1.481752_g17234_i0 PRJNA263496 17487 186 1.481752 2.75605872 Clostridioides difficile 1496 Bacteria Bacteria 108 1.23e-27   NR MCJ0138832.1 1496 g17234 i0 84.7 0.951612903225806 59 9 95.2 0 184 8 23 81 MCJ0138832.1 apolipoprotein A1/A4/E family protein [Clostridioides difficile] diamond 177 108 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
28621611 28621611 PRJNA263496_P_NODE_23287_length_164_cov_0.886957_g23034_i0 PRJNA263496 23287 164 0.886957 1.45460948 Corynebacterium sp. ACRPE 2918196 Bacteria Bacteria 112 1.16e-27   NR WP_239280860.1 2918196 g23034 i0 92.6 0.98780487804878 54 4 98.8 0 2 163 322 375 WP_239280860.1 RNA-guided endonuclease InsQ/TnpB family protein [Corynebacterium sp. ACRPE] diamond 162 112 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium sp. ACRPE
29302288 29302288 PRJNA263496_P_NODE_24109_length_163_cov_0.894737_g23856_i0 PRJNA263496 24109 163 0.894737 1.45842131 Bacteria 2 Bacteria Bacteria 52 2.43e-6   NR PAT01453.1 2024899 g23856 i0 67.6 2.6319018404908 34 11 62.6 0 159 58 106 139 PAT01453.1 hypothetical protein CI105_06770 [Candidatus Izimaplasma bacterium ZiA1] diamond 429 52.4 0.99236641221374 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae Candidatus Izemoplasma Candidatus Izimoplasma sp. ZiA1
29442156 29442156 PRJNA263496_P_NODE_7310_length_299_cov_0.968000_g7057_i0 PRJNA263496 7310 299 0.968 2.89432 Streptacidiphilus 228398 Bacteria Bacteria 42.4 0.00791   NR WP_165845522.1 228398 g7057 i0 36.2 0.581939799331104 58 28 58.2 1 125 298 1 49 WP_165845522.1 MULTISPECIES: hypothetical protein [Streptacidiphilus] diamond 174 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptacidiphilus  
29505443 29505443 PRJNA263496_P_NODE_20490_length_170_cov_1.090909_g20237_i0 PRJNA263496 20490 170 1.090909 1.8545453 Kitasatospora sp. NPDC 1871188 Bacteria Bacteria 43.5 0.00749   NR WP_355669325.1 3154555 g20237 i0 44.2 0.917647058823529 52 23 84.7 2 166 23 98 147 WP_355669325.1 asparagine synthase-related protein [Kitasatospora sp. NPDC004669] diamond 156 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Kitasatospora Kitasatospora sp. NPDC004669
29568632 29568632 PRJNA263496_P_NODE_19070_length_177_cov_1.593750_g18817_i0 PRJNA263496 19070 177 1.59375 2.8209375 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 81.6 1.03e-18   NR WP_229963743.1 1590 g18817 i0 83 1.52542372881356 47 8 79.7 0 177 37 4 50 WP_229963743.1 hypothetical protein [Lactiplantibacillus plantarum] diamond 270 81.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
30249979 30249979 PRJNA263496_P_NODE_18672_length_179_cov_2.646154_g18419_i0 PRJNA263496 18672 179 2.646154 4.73661566 PVC group 1783257 Bacteria Bacteria 75.9 2.79e-14   NR WP_134110546.1 171289 g18419 i0 72.9 29.0782122905028 48 13 80.4 0 12 155 344 391 WP_134110546.1 phosphoglycerate kinase [Mycoplasmopsis mustelae] diamond 5205 76.3 0.99475753604194 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis mustelae
30800600 30800600 PRJNA263496_P_NODE_15194_length_200_cov_1.933775_g14941_i0 PRJNA263496 15194 200 1.933775 3.86755 Lactiplantibacillus sp. E932 2952565 Bacteria Bacteria 40 0.0266   NR MCM8651632.1 2952565 g14941 i0 94.4 0.27 18 1 27 0 3 56 30 47 MCM8651632.1 hypothetical protein [Lactiplantibacillus sp. E932] diamond 54 40 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus sp. E932
31085106 31085106 PRJNA263496_P_NODE_14655_length_204_cov_1.309677_g14402_i0 PRJNA263496 14655 204 1.309677 2.67174108 Clostridia bacterium 2044939 Bacteria Bacteria 84.7 3.27e-17   NR MDD3613683.1 2044939 g14402 i0 61.2 2.95588235294118 67 26 98.5 0 202 2 60 126 MDD3613683.1 NADP-dependent phosphogluconate dehydrogenase [Clostridia bacterium] diamond 603 84.7 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31337897 31337897 PRJNA263496_P_NODE_9556_length_256_cov_0.908213_g9303_i0 PRJNA263496 9556 256 0.908213 2.32502528 Streptosporangium sp. NPDC 47486 Bacteria Bacteria 43.1 0.0301   NR WP_366282089.1 3155410 g9303 i0 41.7 0.703125 60 32 69.1 2 57 233 117 174 WP_366282089.1 sensor histidine kinase [Streptosporangium sp. NPDC051023] diamond 180 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Streptosporangium Streptosporangium sp. NPDC051023
32399836 32399836 PRJNA263496_P_NODE_13999_length_209_cov_1.156250_g13746_i0 PRJNA263496 13999 209 1.15625 2.4165625 Clostridia 186801 Bacteria Bacteria 63.2 3.52e-10   NR MBO5451947.1 1898203 g13746 i0 63.8 2.6555023923445 47 17 67.5 0 143 3 102 148 MBO5451947.1 DJ-1/PfpI family protein [Lachnospiraceae bacterium] diamond 555 63.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32540384 32540384 PRJNA263496_P_NODE_24939_length_162_cov_0.902655_g24686_i0 PRJNA263496 24939 162 0.902655 1.4623011 Caldanaerobacter subterraneus 911092 Bacteria Bacteria 84.3 4.71e-19   NR WP_170271202.1 911092 g24686 i0 86.4 0.814814814814815 44 6 81.5 0 136 5 1 44 WP_170271202.1 phage tail terminator family protein [Caldanaerobacter subterraneus] diamond 132 84.3 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Caldanaerobacter Caldanaerobacter subterraneus
32620863 32620863 PRJNA263496_P_NODE_11480_length_231_cov_1.675824_g11227_i0 PRJNA263496 11480 231 1.675824 3.87115344 Bacteria 2 Bacteria Bacteria 80.1 1.16e-15   NR MBR3893620.1 2044939 g11227 i0 60.9 1.66233766233766 64 25 83.1 0 194 3 23 86 MBR3893620.1 aspartate--ammonia ligase [Clostridia bacterium] diamond 384 80.1 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32666144 32666144 PRJNA263496_P_NODE_24200_length_163_cov_0.894737_g23947_i0 PRJNA263496 24200 163 0.894737 1.45842131 Clostridium tetani 1513 Bacteria Bacteria 55.8 2.82e-7   NR WP_317818676.1 1513 g23947 i0 49.1 0.975460122699387 53 27 97.5 0 161 3 205 257 WP_317818676.1 ParM/StbA family protein [Clostridium tetani] diamond 159 55.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium tetani
32823684 32823684 PRJNA263496_P_NODE_13640_length_212_cov_0.938650_g13387_i0 PRJNA263496 13640 212 0.93865 1.989938 Aliterella atlantica 1827278 Bacteria Bacteria 48.5 2.12e-5   NR WP_045055378.1 1827278 g13387 i0 100 0.35377358490566 25 0 35.4 0 2 76 53 77 WP_045055378.1 hypothetical protein [Aliterella atlantica] diamond 75 48.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica

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