RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA753112" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA753112 · 13 ✖

analysis 1

  • blastn · 13 ✖

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
1201471 1201471 PRJNA753112_P_NODE_14001_length_363_cov_1.789655_g13659_i0 PRJNA753112 14001 363 1.789655 6.49644765 Streptococcus 1301 Bacteria Bacteria 604 2.1099999999999991e-168   NTclustered gi|1948677368|gb|CP066059.1| 1303 g13659 i0 96.694 332.223140495868 363 12 100 0 1 363 951289 951651 Streptococcus oralis strain FDAARGOS_1021 chromosome, complete genome blastn 120597 604 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
3753359 3753359 PRJNA753112_P_NODE_29343_length_252_cov_0.871508_g29001_i0 PRJNA753112 29343 252 0.871508 2.19620016 Lactococcus 1357 Bacteria Bacteria 466 6.89e-127   NTclustered gi|2800799246|gb|CP093959.1| 1358 g29001 i0 100 99.9960317460317 252 0 100 0 1 252 728575 728826 Lactococcus lactis strain FAM 17919 chromosome, complete genome blastn 25199 466 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Lactococcus Lactococcus lactis
6305559 6305559 PRJNA753112_P_NODE_18465_length_316_cov_1.279835_g18123_i0 PRJNA753112 18465 316 1.279835 4.0442786 Streptococcus 1301 Bacteria Bacteria 579 1.0999999999999999e-160   NTclustered gi|2890261556|gb|CP177179.1| 1304 g18123 i0 99.684 121.927215189873 316 1 100 0 1 316 14967 15282 Streptococcus salivarius strain MRD-NRLLH chromosome, complete genome blastn 38529 584 0.991438356164384 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus salivarius
7579641 7579641 PRJNA753112_P_NODE_32386_length_245_cov_0.906977_g32044_i0 PRJNA753112 32386 245 0.906977 2.22209365 Geobacillus 129337 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|2529051051|gb|CP128453.1| 1422 g32044 i0 100 29.9632653061224 245 0 100 0 1 245 3339226 3338982 Geobacillus stearothermophilus strain EF60045 chromosome, complete genome blastn 7341 453 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Geobacillus Geobacillus stearothermophilus
8382368 8382368 PRJNA753112_P_NODE_28707_length_253_cov_1.450000_g28365_i0 PRJNA753112 28707 253 1.45 3.6685 Paenibacillus sp. FSL R5-0912 1536771 Bacteria Bacteria 457 4.16e-124   NTclustered gi|2709743304|gb|CP150226.1| 1536771 g28365 i0 99.209 1123.56126482213 253 2 100 0 1 253 3493357 3493105 Paenibacillus sp. FSL R5-0912 chromosome, complete genome blastn 284261 457 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. FSL R5-0912
15230356 15230356 PRJNA753112_P_NODE_9672_length_436_cov_911.421488_g9330_i0 PRJNA753112 9672 436 911.421488 3973.79768768 FCB group 1783270 Bacteria Bacteria 65.8 5.41e-6   NTclustered gi|2504358668|gb|CP116033.1| 1517 g9330 i0 97.368 3.78669724770642 38 1 9 0 12 49 807200 807163 Thermoanaerobacterium thermosaccharolyticum strain MJ1 chromosome, complete genome blastn 1651 65.8 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Thermoanaerobacterium Thermoanaerobacterium thermosaccharolyticum
16504558 16504558 PRJNA753112_P_NODE_25593_length_269_cov_4.239796_g25251_i0 PRJNA753112 25593 269 4.239796 11.40505124 Streptococcus 1301 Bacteria Bacteria 497 2.63e-136   NTclustered gi|1948677368|gb|CP066059.1| 1303 g25251 i0 100 336 269 0 100 0 1 269 902422 902690 Streptococcus oralis strain FDAARGOS_1021 chromosome, complete genome blastn 90384 497 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
18580802 18580802 PRJNA753112_P_NODE_24935_length_273_cov_1.170000_g24593_i0 PRJNA753112 24935 273 1.17 3.1941 Gemella haemolysans 1379 Bacteria Bacteria 499 7.45e-137   NTclustered gi|1540173839|emb|LR134484.1| 1379 g24593 i0 99.634 414.769230769231 273 1 100 0 1 273 9541 9813 Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1 blastn 113232 499 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella Gemella haemolysans
19053425 19053425 PRJNA753112_P_NODE_31795_length_246_cov_0.901734_g31453_i0 PRJNA753112 31795 246 0.901734 2.21826564 Heyndrickxia 2837504 Bacteria Bacteria 455 1.4500000000000002e-123   NTclustered gi|2860284610|gb|CP174177.1| 1398 g31453 i0 100 29 246 0 100 0 1 246 1789218 1789463 Heyndrickxia coagulans strain MRD030 chromosome blastn 7134 455 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Heyndrickxia Heyndrickxia coagulans
20328148 20328148 PRJNA753112_P_NODE_30216_length_249_cov_2.528409_g29874_i0 PRJNA753112 30216 249 2.528409 6.29573841 Staphylococcus 1279 Bacteria Bacteria 460 3.16e-125   NTclustered gi|2669659999|gb|CP090011.1| 1290 g29874 i0 100 475.465863453815 249 0 100 0 1 249 762192 762440 Staphylococcus hominis strain acrlg chromosome, complete genome blastn 118391 460 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus hominis
21131333 21131333 PRJNA753112_P_NODE_12317_length_386_cov_1.884984_g11975_i0 PRJNA753112 12317 386 1.884984 7.27603824 Gemella haemolysans 1379 Bacteria Bacteria 708 0   NTclustered gi|1829987927|gb|CP050965.1| 1379 g11975 i0 99.741 481.652849740933 386 1 100 0 1 386 1542013 1541628 Gemella haemolysans strain FDAARGOS_740 chromosome blastn 185918 708 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella Gemella haemolysans
21603607 21603607 PRJNA753112_P_NODE_11977_length_392_cov_3.576803_g11635_i0 PRJNA753112 11977 392 3.576803 14.02106776 Bacillales 1385 Bacteria Bacteria 719 0   NTclustered gi|691218329|gb|CP009046.1| 1282 g11635 i0 99.745 511.02806122449 392 1 100 0 1 392 639858 640249 Staphylococcus epidermidis strain SEI, complete genome blastn 200323 719 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
24153266 24153266 PRJNA753112_P_NODE_25739_length_269_cov_1.173469_g25397_i0 PRJNA753112 25739 269 1.173469 3.15663161 Staphylococcus 1279 Bacteria Bacteria 492 1.23e-134   NTclustered gi|1176884116|gb|CP020463.1| 1282 g25397 i0 99.628 100 269 1 100 0 1 269 2092594 2092862 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 26900 492 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis

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