RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJEB3181" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJEB3181 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
21732889 21732889 PRJEB3181_S_NODE_6338_length_245_cov_351.323810_g6045_i0 PRJEB3181 6338 245 351.32381 860.7433345 Bacteria 2 Bacteria Bacteria 90.5 2.22e-21   NR MCA9749906.1 1965302 g6045 i0 83.1 1.44489795918367 59 10 72.2 0 244 68 53 111 MCA9749906.1 F0F1 ATP synthase subunit A [Romboutsia sp.] diamond 354 90.5 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Romboutsia Romboutsia sp.
26747967 26747967 PRJEB3181_P_NODE_11881_length_246_cov_6.111628_g11617_i0 PRJEB3181 11881 246 6.111628 15.03460488 Bacillus aquiflavi 2672567 Bacteria Bacteria 42.4 0.0487   NR WP_163240025.1 2672567 g11617 i0 37.8 0.902439024390244 74 36 78 3 54 245 171 244 WP_163240025.1 putative RNA methyltransferase [Bacillus aquiflavi] diamond 222 42.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus aquiflavi
27222742 27222742 PRJEB3181_P_NODE_13823_length_227_cov_2.959184_g13559_i0 PRJEB3181 13823 227 2.959184 6.71734768 Streptococcus dysgalactiae 1334 Bacteria Bacteria 43.1 0.00261   NR TYL02226.1 1334 g13559 i0 63 0.356828193832599 27 10 35.7 0 211 131 38 64 TYL02226.1 hypothetical protein E0F72_03840 [Streptococcus dysgalactiae] diamond 81 43.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
27381143 27381143 PRJEB3181_P_NODE_15823_length_211_cov_1.488889_g15559_i0 PRJEB3181 15823 211 1.488889 3.14155579 Bacillota bacterium 1879010 Bacteria Bacteria 42.4 0.0344   NR MCE1246567.1 1879010 g15559 i0 52.5 0.568720379146919 40 19 56.9 0 13 132 608 647 MCE1246567.1 protein kinase [Bacillota bacterium] diamond 120 42.4 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
27475695 27475695 PRJEB3181_P_NODE_12483_length_240_cov_1.736842_g12219_i0 PRJEB3181 12483 240 1.736842 4.1684208 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 59.7 3.56e-8   NR MCR5374976.1 1898203 g12219 i0 53.7 1.3625 54 25 67.5 0 236 75 339 392 MCR5374976.1 SH3 domain-containing protein [Lachnospiraceae bacterium] diamond 327 59.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
27563619 27563619 PRJEB3181_S_NODE_17064_length_157_cov_2.573770_g16771_i0 PRJEB3181 17064 157 2.57377 4.0408189 Bacteria 2 Bacteria Bacteria 60.8 2.31e-9   NR MBB1522924.1 1898207 g16771 i0 73.8 3.82165605095541 42 11 80.3 0 156 31 185 226 MBB1522924.1 tRNA (guanosine(37)-N1)-methyltransferase TrmD [Clostridiales bacterium] diamond 600 61.2 0.993464052287582 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
27879637 27879637 PRJEB3181_P_NODE_6325_length_329_cov_2.389262_g6067_i0 PRJEB3181 6325 329 2.389262 7.86067198 Bacteria 2 Bacteria Bacteria 58.5 2.42e-7   NR WP_025731458.1 363870 g6067 i0 41.7 1.77811550151976 96 42 76.6 2 326 75 228 321 WP_025731458.1 UDP-N-acetylglucosamine 4,6-dehydratase (inverting) [Heyndrickxia ginsengihumi] diamond 585 58.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Heyndrickxia Heyndrickxia ginsengihumi
28107087 28107087 PRJEB3181_S_NODE_15825_length_163_cov_2.187500_g15532_i0 PRJEB3181 15825 163 2.1875 3.565625 Tepidibacillus fermentans 1281767 Bacteria Bacteria 38.5 0.0494   NR TCS77684.1 1281767 g15532 i0 84.2 0.349693251533742 19 3 35 0 152 96 5 23 TCS77684.1 hypothetical protein EDD72_1353, partial [Tepidibacillus fermentans] diamond 57 38.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Tepidibacillus Tepidibacillus fermentans
28479615 28479615 PRJEB3181_P_NODE_14686_length_220_cov_2.402116_g14422_i0 PRJEB3181 14686 220 2.402116 5.2846552 Bacteria 2 Bacteria Bacteria 70.1 4.67e-12   NR NMD44744.1 1898207 g14422 i0 77.3 1.86818181818182 44 10 60 0 18 149 273 316 NMD44744.1 type I glyceraldehyde-3-phosphate dehydrogenase [Clostridiales bacterium] diamond 411 70.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
28549434 28549434 PRJEB3181_P_NODE_26327_length_156_cov_2.552000_g26062_i0 PRJEB3181 26327 156 2.552 3.98112 Acutalibacteraceae bacterium 3077420 Bacteria Bacteria 45.1 0.0018   NR MEE0858530.1 3077420 g26062 i0 59 3 39 15 75 1 156 40 638 675 MEE0858530.1 Ig-like domain-containing protein [Acutalibacteraceae bacterium] diamond 468 45.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Acutalibacteraceae   Acutalibacteraceae bacterium
29016628 29016628 PRJEB3181_S_NODE_9128_length_209_cov_238.000000_g8835_i0 PRJEB3181 9128 209 238 497.42 root 1 Root_unresolved Root_unresolved 41.6 0.0324   NR WP_289704086.1 1531 g8835 i0 90 1.11961722488038 20 2 28.7 0 209 150 1 20 WP_289704086.1 IS66 family transposase, partial [Enterocloster clostridioformis] diamond 234 42 0.990476190476191 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Enterocloster Enterocloster clostridioformis
30444175 30444175 PRJEB3181_P_NODE_19013_length_189_cov_3.677215_g18749_i0 PRJEB3181 19013 189 3.677215 6.94993635 Blautia sp. NSJ-175 2931396 Bacteria Bacteria 48.5 2.43e-5   NR WP_244806873.1 2931396 g18749 i0 47.7 3.15873015873016 44 23 69.8 0 170 39 5 48 WP_244806873.1 helix-turn-helix domain-containing protein [Blautia sp. NSJ-175] diamond 597 48.5 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia Blautia sp. NSJ-175
30444188 30444188 PRJEB3181_S_NODE_16933_length_158_cov_1.300813_g16640_i0 PRJEB3181 16933 158 1.300813 2.05528454 Clostridia bacterium 2044939 Bacteria Bacteria 66.6 4.34e-11   NR MCX8075370.1 2044939 g16640 i0 55.8 0.987341772151899 52 23 98.7 0 157 2 356 407 MCX8075370.1 formate--tetrahydrofolate ligase [Clostridia bacterium] diamond 156 66.6 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30563567 30563567 PRJEB3181_P_NODE_13793_length_227_cov_4.806122_g13529_i0 PRJEB3181 13793 227 4.806122 10.90989694 Bacillati 1783272 Bacteria Bacteria 55.8 7.55e-8   NR MBD9143676.1 1547 g13529 i0 52 12.0528634361233 50 24 66.1 0 224 75 62 111 MBD9143676.1 NlpC/P60 family protein [Thomasclavelia ramosa] diamond 2736 55.8 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Coprobacillaceae Thomasclavelia Thomasclavelia ramosa
31392317 31392317 PRJEB3181_S_NODE_15096_length_167_cov_2.704545_g14803_i0 PRJEB3181 15096 167 2.704545 4.51659015 Sulfobacillus acidophilus 53633 Bacteria Bacteria 54.3 1.1e-6   NR MBN4077474.1 53633 g14803 i0 52 0.898203592814371 50 23 89.8 1 162 13 214 262 MBN4077474.1 transposase [Sulfobacillus acidophilus] diamond 150 54.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiales Family XVII. Incertae Sedis Sulfobacillus Sulfobacillus acidophilus
31670181 31670181 PRJEB3181_P_NODE_20977_length_178_cov_5.605442_g20713_i0 PRJEB3181 20977 178 5.605442 9.97768676 Bacillota 1239 Bacteria Bacteria 47.4 3.49e-4   NR MCW6664511.1 2954217 g20713 i0 45 4.1123595505618 40 22 67.4 0 12 131 344 383 MCW6664511.1 NlpC/P60 family protein [Aerococcaceae bacterium NML191219] diamond 732 47.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Aerococcaceae   Aerococcaceae bacterium NML191219
31701870 31701870 PRJEB3181_S_NODE_18617_length_151_cov_1.241379_g18324_i0 PRJEB3181 18617 151 1.241379 1.87448229 Paenibacillus 44249 Bacteria Bacteria 57 8.67e-8   NR WP_268569832.1 1464 g18324 i0 65.8 1.50993377483444 38 13 75.5 0 114 1 201 238 WP_268569832.1 ATP-binding protein [Paenibacillus larvae] diamond 228 57 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus larvae
32214682 32214682 PRJEB3181_P_NODE_22878_length_170_cov_1.712230_g22613_i0 PRJEB3181 22878 170 1.71223 2.910791 Clostridia bacterium 2044939 Bacteria Bacteria 102 6.9e-27   NR MEG1344943.1 2044939 g22613 i0 90.6 0.935294117647059 53 5 93.5 0 169 11 16 68 MEG1344943.1 hypothetical protein [Clostridia bacterium] diamond 159 102 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32499619 32499619 PRJEB3181_P_NODE_14999_length_217_cov_4.752688_g14735_i0 PRJEB3181 14999 217 4.752688 10.31333296 Lactiplantibacillus plantarum WJL 1350466 Bacteria Bacteria 55.8 1.44e-8   NR ERO39489.1 1350466 g14735 i0 70.3 1.92165898617512 37 11 51.2 0 106 216 1 37 ERO39489.1 hypothetical protein LPLWJ_34090 [Lactiplantibacillus plantarum WJL] diamond 417 55.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
32650316 32650316 PRJEB3181_P_NODE_1460_length_533_cov_3.213147_g1301_i0 PRJEB3181 1460 533 3.213147 17.12607351 Bacteria 2 Bacteria Bacteria 147 3.8399999999999997e-38   NR WP_379787048.1 29374 g1301 i0 55.5 15.7429643527205 146 63 82.2 2 530 93 44 187 WP_379787048.1 F0F1 ATP synthase subunit alpha [Filifactor villosus] diamond 8391 148 0.993243243243243 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Filifactoraceae Filifactor Filifactor villosus

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