RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA1103784" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1103784 · 11 ✖

analysis 1

  • blastn · 11 ✖

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

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