RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA596870" 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

  • PRJNA596870 · 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
19695068 19695068 PRJNA596870_P_NODE_39956_length_241_cov_0.916667_g39823_i0 PRJNA596870 39956 241 0.916667 2.20916747 Clostridium 1485 Bacteria Bacteria 166 2.68e-49   NR CDA51661.1 1262775 g39823 i0 100 2.95020746887967 79 0 98.3 0 239 3 195 273 CDA51661.1 pHP C-terminal domain protein [Clostridium sp. CAG:138] diamond 711 166 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. CAG:138
27680390 27680390 PRJNA596870_P_NODE_25744_length_268_cov_1.128205_g25611_i0 PRJNA596870 25744 268 1.128205 3.0235894 Streptococcus mitis 28037 Bacteria Bacteria 180 2.22e-50   NR WP_414361397.1 28037 g25611 i0 96.6 0.996268656716418 89 3 99.6 0 267 1 1656 1744 WP_414361397.1 amino acid adenylation domain-containing protein [Streptococcus mitis] diamond 267 180 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
27806562 27806562 PRJNA596870_P_NODE_25084_length_271_cov_1.272727_g24951_i0 PRJNA596870 25084 271 1.272727 3.44909017 Halanaerobiales bacterium 2094029 Bacteria Bacteria 134 3.4399999999999993e-34   NR MBS3812162.1 2094029 g24951 i0 68.5 0.985239852398524 89 28 98.5 0 268 2 40 128 MBS3812162.1 hypothetical protein [Halanaerobiales bacterium] diamond 267 134 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales     Halanaerobiales bacterium
27851161 27851161 PRJNA596870_P_NODE_39964_length_241_cov_0.916667_g39831_i0 PRJNA596870 39964 241 0.916667 2.20916747 Bacteria 2 Bacteria Bacteria 168 6.59e-49   NR CCY41799.1 1263002 g39831 i0 100 3.98340248962656 80 0 99.6 0 240 1 247 326 CCY41799.1 n-acetylglucosamine-6-phosphate deacetylase [Firmicutes bacterium CAG:124] diamond 960 168 1 Bacteria   Bacillati Bacillota         Firmicutes bacterium CAG:124
27869342 27869342 PRJNA596870_P_NODE_4765_length_552_cov_3.490605_g4633_i0 PRJNA596870 4765 552 3.490605 19.2681396 Romboutsia sp. 1965302 Bacteria Bacteria 157 5.25e-46   NR MCA9749906.1 1965302 g4633 i0 85.3 0.516304347826087 95 14 51.6 0 287 3 1 95 MCA9749906.1 F0F1 ATP synthase subunit A [Romboutsia sp.] diamond 285 157 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Romboutsia Romboutsia sp.
28058892 28058892 PRJNA596870_P_NODE_37505_length_243_cov_0.905882_g37372_i0 PRJNA596870 37505 243 0.905882 2.20129326 Bacilli bacterium 1903720 Bacteria Bacteria 47.8 6.02e-4   NR MBR3161236.1 1903720 g37372 i0 34.2 0.938271604938272 76 47 91.4 2 3 224 155 229 MBR3161236.1 TMEM43 family protein [Bacilli bacterium] diamond 228 47.8 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
28816443 28816443 PRJNA596870_P_NODE_24028_length_276_cov_1.517241_g23895_i0 PRJNA596870 24028 276 1.517241 4.18758516 Listeria booriae 1552123 Bacteria Bacteria 43.9 0.00926   NR WP_185534179.1 1552123 g23895 i0 35.8 1.15217391304348 53 34 57.6 0 242 84 1 53 WP_185534179.1 carbonic anhydrase family protein, partial [Listeria booriae] diamond 318 43.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria booriae
28974730 28974730 PRJNA596870_P_NODE_32508_length_248_cov_0.880000_g32375_i0 PRJNA596870 32508 248 0.88 2.1824 Clostridium sp. 1506 Bacteria Bacteria 119 3.2400000000000004e-33   NR HBF65476.1 1506 g32375 i0 96.7 1.45161290322581 60 2 72.6 0 182 3 1 60 HBF65476.1 hypothetical protein [Clostridium sp.] diamond 360 119 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
29100955 29100955 PRJNA596870_P_NODE_38968_length_242_cov_0.911243_g38835_i0 PRJNA596870 38968 242 0.911243 2.20520806 Eubacterium 1730 Bacteria Bacteria 95.9 4.469999999999999e-24   NR WP_117910491.1 1730 g38835 i0 95.7 0.570247933884298 46 2 57 0 139 2 1 46 WP_117910491.1 MULTISPECIES: helix-turn-helix domain-containing protein [Eubacterium] diamond 138 95.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium  
29258494 29258494 PRJNA596870_P_NODE_32469_length_248_cov_0.880000_g32336_i0 PRJNA596870 32469 248 0.88 2.1824 Anaerococcus sp. Marseille-P9784 2614127 Bacteria Bacteria 120 1.47e-31   NR WP_151409390.1 2614127 g32336 i0 80.5 0.991935483870968 82 16 99.2 0 248 3 19 100 WP_151409390.1 hypothetical protein [Anaerococcus sp. Marseille-P9784] diamond 246 120 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus sp. Marseille-P9784
30174544 30174544 PRJNA596870_P_NODE_32032_length_249_cov_0.875000_g31899_i0 PRJNA596870 32032 249 0.875 2.17875 Clostridiales bacterium 1898207 Bacteria Bacteria 43.1 0.0271   NR NLO83518.1 1898207 g31899 i0 31.1 0.891566265060241 74 35 89.2 1 27 248 155 212 NLO83518.1 ROK family protein [Clostridiales bacterium] diamond 222 43.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
30396217 30396217 PRJNA596870_P_NODE_32933_length_248_cov_0.880000_g32800_i0 PRJNA596870 32933 248 0.88 2.1824 Lachnospira intestinalis 3133158 Bacteria Bacteria 172 2e-51   NR WP_349161763.1 3133158 g32800 i0 100 0.991935483870968 82 0 99.2 0 2 247 98 179 WP_349161763.1 carbon-nitrogen hydrolase family protein [Lachnospira intestinalis] diamond 246 172 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Lachnospira Lachnospira intestinalis
30630172 30630172 PRJNA596870_P_NODE_33773_length_247_cov_0.885057_g33640_i0 PRJNA596870 33773 247 0.885057 2.18609079 root 1 Root_unresolved Root_unresolved 40.4 0.0252   NR PWS23192.1 1352 g33640 i0 90.9 1.53036437246964 22 2 26.7 0 122 187 19 40 PWS23192.1 thymosin beta-4 [Enterococcus faecium] diamond 378 40.8 0.990196078431373 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
30964633 30964633 PRJNA596870_P_NODE_32914_length_248_cov_0.880000_g32781_i0 PRJNA596870 32914 248 0.88 2.1824 Waltera sp. 2815806 Bacteria Bacteria 135 7.149999999999998e-35   NR MFQ9618008.1 2815806 g32781 i0 98.5 0.798387096774194 66 1 79.8 0 3 200 875 940 MFQ9618008.1 Z1 domain-containing protein [Waltera sp.] diamond 198 135 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Waltera Waltera sp.
31027859 31027859 PRJNA596870_P_NODE_27295_length_259_cov_1.655914_g27162_i0 PRJNA596870 27295 259 1.655914 4.28881726 Vagococcus sp. 1933889 Bacteria Bacteria 97.8 4.7299999999999996e-23   NR WP_332526766.1 1933889 g27162 i0 57.5 3.98455598455598 87 33 96.1 1 249 1 108 194 WP_332526766.1 helix-hairpin-helix domain-containing protein [Vagococcus sp.] diamond 1032 97.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Vagococcus Vagococcus sp.
32609049 32609049 PRJNA596870_P_NODE_25820_length_267_cov_1.737113_g25687_i0 PRJNA596870 25820 267 1.737113 4.63809171 Bacillus cereus group sp. TH230-1LC 3018048 Bacteria Bacteria 166 6.77e-50   NR MDA1587594.1 3018048 g25687 i0 98.8 1.86516853932584 83 1 93.3 0 267 19 117 199 MDA1587594.1 hypothetical protein [Bacillus cereus group sp. TH230-1LC] diamond 498 166 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus group sp. TH230-1LC
32609051 32609051 PRJNA596870_P_NODE_28280_length_254_cov_1.701657_g28147_i0 PRJNA596870 28280 254 1.701657 4.32220878 Clostridium omnivorum 1604902 Bacteria Bacteria 174 4.16e-49   NR WP_264850257.1 1604902 g28147 i0 98.8 0.992125984251969 84 1 99.2 0 252 1 93 176 WP_264850257.1 LPXTG cell wall anchor domain-containing protein [Clostridium omnivorum] diamond 252 174 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium omnivorum
32640263 32640263 PRJNA596870_P_NODE_3760_length_615_cov_1.308118_g3629_i0 PRJNA596870 3760 615 1.308118 8.0449257 Companilactobacillus baiquanensis 2486005 Bacteria Bacteria 45.1 0.0285   NR WP_125593603.1 2486005 g3629 i0 37.2 0.380487804878049 78 46 37.6 2 412 182 43 118 WP_125593603.1 D-ribose pyranase [Companilactobacillus baiquanensis] diamond 234 45.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Companilactobacillus Companilactobacillus baiquanensis

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