RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA543299" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA543299 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
1118536 1118536 PRJNA543299_P_NODE_20361_length_167_cov_0.864407_g20204_i0 PRJNA543299 20361 167 0.864407 1.44355969 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 94.7 8.58e-22   NR MBE6618708.1 2485925 g20204 i0 83.6 0.988023952095808 55 9 98.8 0 166 2 75 129 MBE6618708.1 energy-coupling factor transporter ATPase [Oscillospiraceae bacterium] diamond 165 94.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
27046330 27046330 PRJNA543299_P_NODE_22622_length_165_cov_0.879310_g22465_i0 PRJNA543299 22622 165 0.87931 1.4508615 Streptococcus pneumoniae 1313 Bacteria Bacteria 77.8 3.62e-17   NR WP_196301265.1 1313 g22465 i0 100 0.672727272727273 37 0 67.3 0 164 54 47 83 WP_196301265.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 111 77.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
27457307 27457307 PRJNA543299_P_NODE_20483_length_167_cov_0.864407_g20326_i0 PRJNA543299 20483 167 0.864407 1.44355969 Bacilli bacterium 1903720 Bacteria Bacteria 44.3 0.00376   NR MFA5408643.1 1903720 g20326 i0 74.2 0.55688622754491 31 8 55.7 0 75 167 29 59 MFA5408643.1 hypothetical protein [Bacilli bacterium] diamond 93 44.3 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
27583312 27583312 PRJNA543299_P_NODE_25364_length_162_cov_0.893805_g25207_i0 PRJNA543299 25364 162 0.893805 1.4479641 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 112 7.67e-29   NR MBR3186902.1 1898203 g25207 i0 98.1 0.981481481481482 53 1 98.1 0 160 2 91 143 MBR3186902.1 AmmeMemoRadiSam system radical SAM enzyme [Lachnospiraceae bacterium] diamond 159 112 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
27962295 27962295 PRJNA543299_P_NODE_23065_length_164_cov_0.886957_g22908_i0 PRJNA543299 23065 164 0.886957 1.45460948 uncultured Clostridium sp. 59620 Bacteria Bacteria 82.4 1.34e-17   NR WP_298842146.1 59620 g22908 i0 68.5 0.98780487804878 54 17 98.8 0 2 163 116 169 WP_298842146.1 recombination protein NinG [uncultured Clostridium sp.] diamond 162 82.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium uncultured Clostridium sp.
28734995 28734995 PRJNA543299_P_NODE_22347_length_165_cov_0.879310_g22190_i0 PRJNA543299 22347 165 0.87931 1.4508615 FCB group 1783270 Bacteria Bacteria 59.7 2.29e-10   NR WP_167553110.1 79879 g22190 i0 65 3.56363636363636 40 14 72.7 0 6 125 8 47 WP_167553110.1 hypothetical protein [Evansella clarkii] diamond 588 59.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Evansella Evansella clarkii
28829543 28829543 PRJNA543299_P_NODE_22348_length_165_cov_0.879310_g22191_i0 PRJNA543299 22348 165 0.87931 1.4508615 Bacillati 1783272 Bacteria Bacteria 50.8 9.56e-6   NR HLG27589.1 1932001 g22191 i0 46.2 5.72727272727273 52 28 94.5 0 7 162 56 107 HLG27589.1 hypothetical protein [Paenisporosarcina sp.] diamond 945 50.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Paenisporosarcina Paenisporosarcina sp.
28972792 28972792 PRJNA543299_P_NODE_22528_length_165_cov_0.879310_g22371_i0 PRJNA543299 22528 165 0.87931 1.4508615 Dialister sp. 1955814 Bacteria Bacteria 68.9 7.29e-12   NR MDU7216148.1 1955814 g22371 i0 59.6 0.945454545454545 52 21 94.5 0 158 3 55 106 MDU7216148.1 DEAD/DEAH box helicase family protein [Dialister sp.] diamond 156 68.9 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Dialister Dialister sp.
29319923 29319923 PRJNA543299_P_NODE_22549_length_165_cov_0.879310_g22392_i0 PRJNA543299 22549 165 0.87931 1.4508615 Anaerovoracaceae bacterium 3030912 Bacteria Bacteria 73.9 1.26e-13   NR HVI41797.1 3030912 g22392 i0 59.3 0.981818181818182 54 22 98.2 0 164 3 66 119 HVI41797.1 hypothetical protein [Anaerovoracaceae bacterium] diamond 162 73.9 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae   Anaerovoracaceae bacterium
29383217 29383217 PRJNA543299_P_NODE_22589_length_165_cov_0.879310_g22432_i0 PRJNA543299 22589 165 0.87931 1.4508615 Paenibacillus dakarensis 1527293 Bacteria Bacteria 79.3 6.88e-17   NR WP_245640109.1 1527293 g22432 i0 57.4 7.8 54 23 98.2 0 164 3 11 64 WP_245640109.1 dihydrofolate reductase [Paenibacillus dakarensis] diamond 1287 79.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus dakarensis
29446107 29446107 PRJNA543299_P_NODE_23770_length_163_cov_0.894737_g23613_i0 PRJNA543299 23770 163 0.894737 1.45842131 Streptococcus pneumoniae 1313 Bacteria Bacteria 62.8 3.55e-11   NR WP_196301192.1 1313 g23613 i0 57.7 0.957055214723926 52 22 95.7 0 7 162 29 80 WP_196301192.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 156 62.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
29983135 29983135 PRJNA543299_P_NODE_23351_length_164_cov_0.886957_g23194_i0 PRJNA543299 23351 164 0.886957 1.45460948 Romboutsia ilealis 1115758 Bacteria Bacteria 43.5 0.00675   NR WP_304431170.1 1115758 g23194 i0 68.2 0.402439024390244 22 7 40.2 0 5 70 221 242 WP_304431170.1 NUMOD1 domain-containing DNA-binding protein [Romboutsia ilealis] diamond 66 43.5 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Romboutsia Romboutsia ilealis
30060986 30060986 PRJNA543299_P_NODE_22611_length_165_cov_0.879310_g22454_i0 PRJNA543299 22611 165 0.87931 1.4508615 Bacteria 2 Bacteria Bacteria 90.5 1.56e-19   NR MBC7074619.1 2093811 g22454 i0 77.8 2.94545454545455 54 12 98.2 0 164 3 137 190 MBC7074619.1 DEAD/DEAH box helicase family protein [Syntrophomonadaceae bacterium] diamond 486 90.5 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Syntrophomonadaceae   Syntrophomonadaceae bacterium
30172609 30172609 PRJNA543299_P_NODE_13592_length_203_cov_1.324675_g13435_i0 PRJNA543299 13592 203 1.324675 2.68909025 Lacticaseibacillus paracasei 1597 Bacteria Bacteria 119 9.08e-34   NR MFK5284285.1 1597 g13435 i0 100 0.842364532019704 57 0 84.2 0 3 173 9 65 MFK5284285.1 hypothetical protein [Lacticaseibacillus paracasei] diamond 171 119 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lacticaseibacillus Lacticaseibacillus paracasei
30962651 30962651 PRJNA543299_P_NODE_26114_length_161_cov_0.910714_g25957_i0 PRJNA543299 26114 161 0.910714 1.46624954 Zhenhengia sp. 2944208 Bacteria Bacteria 45.1 0.00142   NR WP_337530740.1 2944208 g25957 i0 51.1 2.72049689440994 45 22 83.9 0 141 7 14 58 WP_337530740.1 NUMOD4 motif-containing HNH endonuclease [Zhenhengia sp.] diamond 438 45.1 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Zhenhengia Zhenhengia sp.
31120228 31120228 PRJNA543299_P_NODE_17055_length_182_cov_1.150376_g16898_i0 PRJNA543299 17055 182 1.150376 2.09368432 Staphylococcus aureus 1280 Bacteria Bacteria 58.2 2.67e-9   NR WP_414058295.1 1280 g16898 i0 65 0.659340659340659 40 14 65.9 0 161 42 1 40 WP_414058295.1 hypothetical protein, partial [Staphylococcus aureus] diamond 120 58.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
31500174 31500174 PRJNA543299_P_NODE_23076_length_164_cov_0.886957_g22919_i0 PRJNA543299 23076 164 0.886957 1.45460948 Staphylococcus pseudintermedius 283734 Bacteria Bacteria 103 2.06e-27   NR WP_222114585.1 283734 g22919 i0 94.4 0.98780487804878 54 3 98.8 0 1 162 23 76 WP_222114585.1 hypothetical protein, partial [Staphylococcus pseudintermedius] diamond 162 103 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus pseudintermedius
32291331 32291331 PRJNA543299_P_NODE_23999_length_163_cov_0.894737_g23842_i0 PRJNA543299 23999 163 0.894737 1.45842131 Bacilli bacterium 1903720 Bacteria Bacteria 80.9 4.26e-16   NR HOH61224.1 1903720 g23842 i0 66.7 0.993865030674847 54 17 99.4 1 1 162 94 146 HOH61224.1 hypothetical protein [Bacilli bacterium] diamond 162 80.9 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
32385835 32385835 PRJNA543299_P_NODE_21159_length_166_cov_0.871795_g21002_i0 PRJNA543299 21159 166 0.871795 1.4471797 Clostridia bacterium 2044939 Bacteria Bacteria 106 1.1500000000000002e-27   NR NCC44200.1 2044939 g21002 i0 85.5 0.993975903614458 55 8 99.4 0 2 166 15 69 NCC44200.1 site-specific DNA-methyltransferase [Clostridia bacterium] diamond 165 106 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32449341 32449341 PRJNA543299_P_NODE_17459_length_180_cov_0.847328_g17302_i0 PRJNA543299 17459 180 0.847328 1.5251904 Selenomonas flueggei 135080 Bacteria Bacteria 42 0.0118   NR WP_302816168.1 135080 g17302 i0 46.5 0.716666666666667 43 22 70 1 37 162 23 65 WP_302816168.1 hypothetical protein [Selenomonas flueggei] diamond 129 42 1 Bacteria   Bacillati Bacillota Negativicutes Selenomonadales Selenomonadaceae Selenomonas Selenomonas flueggei
32764493 32764493 PRJNA543299_P_NODE_23420_length_164_cov_0.886957_g23263_i0 PRJNA543299 23420 164 0.886957 1.45460948 Intestinimonas sp. UBA1698 1946651 Bacteria Bacteria 51.6 9.12e-6   NR WP_286735166.1 1946651 g23263 i0 58.3 2.28658536585366 36 15 65.9 0 55 162 93 128 WP_286735166.1 DNA-methyltransferase [Intestinimonas sp. UBA1698] diamond 375 51.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Intestinimonas Intestinimonas sp. UBA1698

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