RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB6584 · 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
25660506 25660506 PRJEB6584o_S_NODE_17354_length_214_cov_3.849162_g17246_i0 PRJEB6584 17354 214 3.849162 8.23720668 Clostridia bacterium 2044939 Bacteria Bacteria 72 1.23e-12   NR MBQ3486555.1 2044939 g17246 i0 60 2.52336448598131 60 24 84.1 0 214 35 535 594 MBQ3486555.1 SpoIIE family protein phosphatase [Clostridia bacterium] diamond 540 72 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
26341757 26341757 PRJEB6584o_S_NODE_79_length_1393_cov_253.885862_g69_i0 PRJEB6584 79 1393 253.885862 3536.63005766 Bacteria 2 Bacteria Bacteria 200 6.76e-57   NR WP_221843703.1 51101 g69 i0 38.3 1.95549174443647 303 173 64.8 7 1266 364 2 292 WP_221843703.1 ATP-binding protein [Brevibacillus agri] diamond 2724 202 0.99009900990099 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus agri
32923019 32923019 PRJEB6584l_S_NODE_6161_length_247_cov_2.386792_g6009_i0 PRJEB6584 6161 247 2.386792 5.89537624 Bacteria 2 Bacteria Bacteria 163 9.95e-50   NR WP_221175177.1 1280 g6009 i0 98.8 3.91093117408907 81 1 98.4 0 245 3 15 95 WP_221175177.1 hypothetical protein, partial [Staphylococcus aureus] diamond 966 164 0.99390243902439 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32964020 32964020 PRJEB6584o_S_NODE_70970_length_157_cov_2.418033_g70862_i0 PRJEB6584 70970 157 2.418033 3.79631181 Exiguobacterium aurantiacum 33987 Bacteria Bacteria 40.8 0.00861   NR WP_233005565.1 33987 g70862 i0 74.1 0.515923566878981 27 7 51.6 0 74 154 31 57 WP_233005565.1 hypothetical protein, partial [Exiguobacterium aurantiacum] diamond 81 40.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales   Exiguobacterium Exiguobacterium aurantiacum
32991616 32991616 PRJEB6584l_S_NODE_10819_length_200_cov_4.272727_g10667_i0 PRJEB6584 10819 200 4.272727 8.545454 Bacteria 2 Bacteria Bacteria 72.8 1.4e-13   NR WP_122960455.1 54910 g10667 i0 94.9 8.19 39 2 58.5 0 198 82 196 234 WP_122960455.1 toll/interleukin-1 receptor domain-containing protein [Brevibacillus centrosporus] diamond 1638 72.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus centrosporus
33014459 33014459 PRJEB6584d_S_NODE_12556_length_177_cov_2.964789_g12488_i0 PRJEB6584 12556 177 2.964789 5.24767653 Desmospora activa 500615 Bacteria Bacteria 48.1 1.01e-4   NR WP_107727705.1 500615 g12488 i0 55.1 1.52542372881356 49 20 83.1 1 164 18 125 171 WP_107727705.1 PH domain-containing protein [Desmospora activa] diamond 270 48.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Desmospora Desmospora activa
33014551 33014551 PRJEB6584l_S_NODE_23972_length_154_cov_3.983193_g23820_i0 PRJEB6584 23972 154 3.983193 6.13411722 Lawsonibacter sp. 2185275 Bacteria Bacteria 40.8 0.0498   NR MCI8423810.1 2185275 g23820 i0 45.2 0.818181818181818 42 22 81.8 1 4 129 86 126 MCI8423810.1 hypothetical protein [Lawsonibacter sp.] diamond 126 40.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Lawsonibacter Lawsonibacter sp.
33025716 33025716 PRJEB6584b_S_NODE_3532_length_197_cov_2.845679_g3514_i0 PRJEB6584 3532 197 2.845679 5.6059876300000004 Bacillus 1386 Bacteria Bacteria 65.5 3.33e-11   NR MCW1939438.1 1392 g3514 i0 50.8 7.30964467005076 61 24 92.9 1 195 13 64 118 MCW1939438.1 ATP-binding protein [Bacillus anthracis] diamond 1440 65.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus anthracis
33031603 33031603 PRJEB6584d_S_NODE_18276_length_150_cov_1.043478_g18208_i0 PRJEB6584 18276 150 1.043478 1.565217 Faecalibacillus faecis 1982628 Bacteria Bacteria 51.2 2.06e-6   NR WP_227279636.1 1982628 g18208 i0 43.8 0.96 48 27 96 0 145 2 14 61 WP_227279636.1 helix-turn-helix domain-containing protein [Faecalibacillus faecis] diamond 144 51.2 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Coprobacillaceae Faecalibacillus Faecalibacillus faecis
33031617 33031617 PRJEB6584e_S_NODE_4388_length_150_cov_1.495652_g4373_i0 PRJEB6584 4388 150 1.495652 2.243478 Streptococcus anginosus 1328 Bacteria Bacteria 73.9 8.14e-16   NR WP_264349918.1 1328 g4373 i0 100 0.92 46 0 92 0 140 3 1 46 WP_264349918.1 DUF1542 domain-containing protein, partial [Streptococcus anginosus] diamond 138 73.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus anginosus
33031674 33031674 PRJEB6584l_S_NODE_20900_length_161_cov_2.317460_g20748_i0 PRJEB6584 20900 161 2.31746 3.7311106 Streptococcus pneumoniae 1313 Bacteria Bacteria 99.8 4.83e-26   NR WP_205012622.1 1313 g20748 i0 100 0.894409937888199 48 0 89.4 0 18 161 1 48 WP_205012622.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 144 99.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
33065781 33065781 PRJEB6584o_S_NODE_13077_length_243_cov_5.245192_g12969_i0 PRJEB6584 13077 243 5.245192 12.74581656 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 56.2 2.79e-7   NR MBO4838240.1 1898203 g12969 i0 44.3 2.7283950617284 70 39 86.4 0 216 7 47 116 MBO4838240.1 sel1 repeat family protein [Lachnospiraceae bacterium] diamond 663 56.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
33099720 33099720 PRJEB6584b_S_NODE_5718_length_176_cov_2.453901_g5700_i0 PRJEB6584 5718 176 2.453901 4.3188657600000004 Bacillus velezensis 492670 Bacteria Bacteria 81.6 6.97e-18   NR NRG16064.1 492670 g5700 i0 100 1.39772727272727 41 0 69.9 0 176 54 108 148 NRG16064.1 hypothetical protein [Bacillus velezensis] diamond 246 81.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus velezensis
33099847 33099847 PRJEB6584l_S_NODE_23222_length_156_cov_1.603306_g23070_i0 PRJEB6584 23222 156 1.603306 2.50115736 Paenibacillus glucanolyticus 59843 Bacteria Bacteria 60.1 7.26e-9   NR WP_376165857.1 59843 g23070 i0 59.6 1.80769230769231 47 18 88.5 1 138 1 200 246 WP_376165857.1 ATP-binding protein [Paenibacillus glucanolyticus] diamond 282 60.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus glucanolyticus
33127980 33127980 PRJEB6584o_S_NODE_18015_length_211_cov_4.318182_g17907_i0 PRJEB6584 18015 211 4.318182 9.11136402 Bacteria 2 Bacteria Bacteria 43.1 0.015   NR WP_235821333.1 1516104 g17907 i0 64.5 4.23696682464455 31 11 44.1 0 189 97 47 77 WP_235821333.1 LysM peptidoglycan-binding domain-containing protein [Gottfriedia solisilvae] diamond 894 43.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Gottfriedia Gottfriedia solisilvae
33134596 33134596 PRJEB6584o_S_NODE_8239_length_299_cov_57.212121_g8131_i0 PRJEB6584 8239 299 57.212121 171.06424179 Clostridia bacterium 2044939 Bacteria Bacteria 72.8 1.65e-12   NR MEI6603586.1 2044939 g8131 i0 45.2 1.68561872909699 84 41 79.3 2 239 3 281 364 MEI6603586.1 AAA family ATPase [Clostridia bacterium] diamond 504 72.8 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
33145117 33145117 PRJEB6584o_S_NODE_76423_length_154_cov_6.630252_g76315_i0 PRJEB6584 76423 154 6.630252 10.21058808 Bacteria 2 Bacteria Bacteria 63.5 5.09e-10   NR WP_325008015.1 58172 g76315 i0 74 4.87012987012987 50 13 97.4 0 154 5 1358 1407 WP_325008015.1 fibronectin type III domain-containing protein [Paenibacillus sp.] diamond 750 63.9 0.993740219092332 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp.
33162013 33162013 PRJEB6584l_S_NODE_10536_length_202_cov_4.916168_g10384_i0 PRJEB6584 10536 202 4.916168 9.93065936 Bacteria 2 Bacteria Bacteria 57.4 6.29e-9   NR WP_333727354.1 1639 g10384 i0 96.9 0.95049504950495 32 1 47.5 0 107 202 1 32 WP_333727354.1 hypothetical protein, partial [Listeria monocytogenes] diamond 192 57.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes

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