RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA1103784", tax_kingdom = "Bacillati" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 20 ✖

tax_kingdom 1

  • Bacillati · 20 ✖

bioproject 1

  • PRJNA1103784 · 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
1020100 1020100 PRJNA1103784_P_NODE_5481_length_253_cov_1.711111_g5426_i0 PRJNA1103784 5481 253 1.711111 4.32911083 root 1 Root_unresolved Root_unresolved 468 1.92e-127   NTclustered gi|1796975023|gb|CP033086.1| 1280 g5426 i0 100 99.9249011857708 253 0 100 0 1 253 2463653 2463401 Staphylococcus aureus strain WH9628 chromosome blastn 25281 468 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
1020101 1020101 PRJNA1103784_P_NODE_5661_length_251_cov_0.865169_g5606_i0 PRJNA1103784 5661 251 0.865169 2.17157419 Streptococcus 1301 Bacteria Bacteria 412 9.06e-111   NTclustered gi|2804677641|gb|CP154876.1| 1313 g5606 i0 96.4 99.6135458167331 250 9 99 0 2 251 852584 852335 Streptococcus pneumoniae strain 20155336 chromosome, complete genome blastn 25003 414 0.995169082125604 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
9139742 9139742 PRJNA1103784_P_NODE_4768_length_267_cov_1.201031_g4713_i0 PRJNA1103784 4768 267 1.201031 3.20675277 Gemella haemolysans 1379 Bacteria Bacteria 488 1.5699999999999998e-133   NTclustered gi|1540173839|emb|LR134484.1| 1379 g4713 i0 99.625 472.213483146067 267 1 100 0 1 267 735304 735570 Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1 blastn 126081 488 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella Gemella haemolysans
9139757 9139757 PRJNA1103784_P_NODE_5468_length_253_cov_2.994444_g5413_i0 PRJNA1103784 5468 253 2.994444 7.57594332 Enterococcus faecium 1352 Bacteria Bacteria 54.7 0.006   NTclustered gi|2284309514|dbj|AP026579.1| 1352 g5413 i0 100 11.4743083003953 29 0 11 0 165 193 1654338 1654366 Enterococcus faecium JHP35 DNA, complete genome blastn 2903 54.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
12965956 12965956 PRJNA1103784_P_NODE_1911_length_378_cov_1.845902_g1856_i0 PRJNA1103784 1911 378 1.845902 6.97750956 Lysinibacillus fusiformis 28031 Bacteria Bacteria 56.5 0.003   NTclustered gi|2921984323|gb|CP182815.1| 28031 g1856 i0 76.923 0.349206349206349 104 21 27 2 46 146 806858 806755 Lysinibacillus fusiformis strain A15 chromosome, complete genome blastn 132 56.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Lysinibacillus Lysinibacillus fusiformis
16322674 16322674 PRJNA1103784_P_NODE_4533_length_271_cov_1.904040_g4478_i0 PRJNA1103784 4533 271 1.90404 5.1599484 Abiotrophia 46123 Bacteria Bacteria 501 2.05e-137   NTclustered gi|1848537030|gb|CP053988.1| 46125 g4478 i0 100 408.723247232472 271 0 100 0 1 271 862151 862421 Abiotrophia defectiva strain FDAARGOS_785 chromosome, complete genome blastn 110764 501 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Aerococcaceae Abiotrophia Abiotrophia defectiva
16789269 16789269 PRJNA1103784_P_NODE_4274_length_277_cov_1.117647_g4219_i0 PRJNA1103784 4274 277 1.117647 3.09588219 Streptococcus pneumoniae 1313 Bacteria Bacteria 52.8 0.025   NTclustered gi|8163683|gb|AF154031.1| 1313 g4219 i0 79.747 0.285198555956679 79 10 27 3 142 217 1663 1738 Streptococcus pneumoniae strain g48s surface protein PspC (pspC) gene, pspC-5.2 allele, complete cds blastn 79 52.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
17597867 17597867 PRJNA1103784_P_NODE_3914_length_284_cov_2.573460_g3859_i0 PRJNA1103784 3914 284 2.57346 7.3086264 Streptococcus 1301 Bacteria Bacteria 520 5.98e-143   NTclustered gi|2886512733|emb|OZ217346.1| 28037 g3859 i0 99.648 344.197183098592 284 1 100 0 1 284 18867 19150 Streptococcus mitis isolate S. mitis D22 genome assembly, chromosome: 1 blastn 97752 520 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
18871763 18871763 PRJNA1103784_P_NODE_1635_length_404_cov_2.353474_g1580_i0 PRJNA1103784 1635 404 2.353474 9.50803496 Streptococcus 1301 Bacteria Bacteria 730 0   NTclustered gi|1654236162|emb|LR594040.1| 113107 g1580 i0 99.257 375.393564356436 404 3 100 0 1 404 16814 17217 Streptococcus australis strain NCTC5338 genome assembly, chromosome: 1 blastn 151659 736 0.991847826086957 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus australis
21888896 21888896 PRJNA1103784_P_NODE_1818_length_387_cov_1.181529_g1763_i0 PRJNA1103784 1818 387 1.181529 4.57251723 Brevibacillus sp. 7WMA2 2683193 Bacteria Bacteria 211 5.76e-50   NTclustered gi|1810936193|gb|CP048799.1| 2683193 g1763 i0 78.769 112.475452196382 325 62 95 5 3 325 1419108 1419427 Brevibacillus sp. 7WMA2 chromosome, complete genome blastn 43528 211 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus sp. 7WMA2
21888941 21888941 PRJNA1103784_P_NODE_4798_length_266_cov_1.595855_g4743_i0 PRJNA1103784 4798 266 1.595855 4.2449743 Streptococcus pneumoniae 1313 Bacteria Bacteria 156 1.7899999999999995e-47   NR KAF8254224.1 1313 g4743 i0 94.3 0.992481203007519 88 5 99.2 0 264 1 15 102 KAF8254224.1 hypothetical protein BKP31_11290 [Streptococcus pneumoniae] diamond 264 156 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
25246546 25246546 PRJNA1103784_P_NODE_7660_length_242_cov_0.911243_g7605_i0 PRJNA1103784 7660 242 0.911243 2.20520806 root 1 Root_unresolved Root_unresolved 448 2.3799999999999995e-121   NTclustered gi|1893901138|gb|MT903189.1| 54005 g7605 i0 100 100 242 0 100 0 1 242 367 608 Peptoniphilus harei strain 1-DE-D40-21 16S ribosomal RNA gene, partial sequence blastn 24200 448 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus harei
26750780 26750780 PRJNA1103784_P_NODE_2161_length_362_cov_1.162630_g2106_i0 PRJNA1103784 2161 362 1.16263 4.2087206 Desulfosporosinus sp. 157907 Bacteria Bacteria 47.4 0.00311   NR MDR3540757.1 157907 g2106 i0 29.4 0.903314917127072 109 69 84.5 4 353 48 220 327 MDR3540757.1 hypothetical protein [Desulfosporosinus sp.] diamond 327 47.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfosporosinus Desulfosporosinus sp.
27762926 27762926 PRJNA1103784_P_NODE_2424_length_344_cov_4.195572_g2369_i0 PRJNA1103784 2424 344 4.195572 14.43276768 Priestia flexa 86664 Bacteria Bacteria 53.5 9.15e-6   NR WP_078990296.1 86664 g2369 i0 47.4 0.497093023255814 57 26 46.2 1 314 156 1 57 WP_078990296.1 hypothetical protein [Priestia flexa] diamond 171 53.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia flexa
28741463 28741463 PRJNA1103784_P_NODE_587_length_622_cov_1.675774_g533_i0 PRJNA1103784 587 622 1.675774 10.42331428 Paenibacillus hamazuiensis 2936508 Bacteria Bacteria 65.5 1.49e-8   NR WP_248928521.1 2936508 g533 i0 26.2 0.882636655948553 183 126 85.9 5 38 571 233 411 WP_248928521.1 hypothetical protein [Paenibacillus hamazuiensis] diamond 549 65.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus hamazuiensis
29246581 29246581 PRJNA1103784_P_NODE_6229_length_248_cov_0.880000_g6174_i0 PRJNA1103784 6229 248 0.88 2.1824 Kroppenstedtia eburnea 714067 Bacteria Bacteria 47.4 7.61e-4   NR WP_380134752.1 714067 g6174 i0 36 1.20967741935484 100 46 99.2 3 248 3 38 137 WP_380134752.1 glycerophosphodiester phosphodiesterase [Kroppenstedtia eburnea] diamond 300 47.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Kroppenstedtia Kroppenstedtia eburnea
29278045 29278045 PRJNA1103784_P_NODE_4309_length_276_cov_1.137931_g4254_i0 PRJNA1103784 4309 276 1.137931 3.14068956 Bacillus mycoides 1405 Bacteria Bacteria 52 1.28e-5   NR WP_235702224.1 1405 g4254 i0 39.7 2.3804347826087 73 41 79.3 1 16 234 95 164 WP_235702224.1 ankyrin repeat domain-containing protein [Bacillus mycoides] diamond 657 52 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus mycoides
29719984 29719984 PRJNA1103784_P_NODE_870_length_528_cov_2.496703_g815_i0 PRJNA1103784 870 528 2.496703 13.18259184 Faecalibacterium prausnitzii 853 Bacteria Bacteria 50.4 0.0011   NR MBS6135079.1 853 g815 i0 60 0.227272727272727 40 15 22.2 1 174 58 70 109 MBS6135079.1 two-component sensor histidine kinase [Faecalibacterium prausnitzii] diamond 120 50.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Faecalibacterium Faecalibacterium prausnitzii
30857489 30857489 PRJNA1103784_P_NODE_7974_length_235_cov_4.308642_g7919_i0 PRJNA1103784 7974 235 4.308642 10.1253087 Candidatus Desulfosporosinus infrequens 2043169 Bacteria Bacteria 42.4 0.00533   NR SPF49774.1 2043169 g7919 i0 60.7 0.357446808510638 28 11 35.7 0 142 225 31 58 SPF49774.1 exported hypothetical protein [Candidatus Desulfosporosinus infrequens] diamond 84 42.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfosporosinus Candidatus Desulfosporosinus infrequens
31299992 31299992 PRJNA1103784_P_NODE_7355_length_243_cov_0.905882_g7300_i0 PRJNA1103784 7355 243 0.905882 2.20129326 Lentilactobacillus buchneri 1581 Bacteria Bacteria 43.5 0.0193   NR WP_136838392.1 1581 g7300 i0 42.9 0.604938271604938 49 25 60.5 1 152 6 220 265 WP_136838392.1 McrB family protein [Lentilactobacillus buchneri] diamond 147 43.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lentilactobacillus Lentilactobacillus buchneri

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