RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA753151" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA753151 · 20 ✖

analysis 1

  • blastn · 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
1201828 1201828 PRJNA753151_S_NODE_151681_length_236_cov_1.398964_g149391_i0 PRJNA753151 151681 236 1.398964 3.30155504 Lactobacillus 1578 Bacteria Bacteria 436 4.999999999999999e-118   NTclustered gi|2096299657|gb|CP083392.1| 47770 g149391 i0 100 393.949152542373 236 0 100 0 1 236 89369 89604 Lactobacillus crispatus strain Lc1226 chromosome, complete genome blastn 92972 436 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus crispatus
1201884 1201884 PRJNA753151_S_NODE_269201_length_171_cov_2.109375_g266911_i0 PRJNA753151 269201 171 2.109375 3.60703125 Staphylococcus 1279 Bacteria Bacteria 316 4.6e-82   NTclustered gi|2150735284|gb|CP086659.1| 29388 g266911 i0 100 42 171 0 100 0 1 171 733816 733986 Staphylococcus capitis strain XZ03 chromosome, complete genome blastn 7182 316 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus capitis
2477242 2477242 PRJNA753151_S_NODE_160682_length_229_cov_2.844086_g158392_i0 PRJNA753151 160682 229 2.844086 6.51295694 Staphylococcus 1279 Bacteria Bacteria 424 3.76e-114   NTclustered gi|1176884116|gb|CP020463.1| 1282 g158392 i0 100 100 229 0 100 0 1 229 2239106 2239334 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 22900 424 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
2477303 2477303 PRJNA753151_S_NODE_291882_length_163_cov_1.125000_g289592_i0 PRJNA753151 291882 163 1.125 1.83375 root 1 Root_unresolved Root_unresolved 296 5.68e-76   NTclustered gi|1176884116|gb|CP020463.1| 1282 g289592 i0 99.387 100 163 1 100 0 1 163 1720506 1720668 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 16300 296 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
3753568 3753568 PRJNA753151_S_NODE_207943_length_200_cov_1.433121_g205653_i0 PRJNA753151 207943 200 1.433121 2.866242 Streptococcus 1301 Bacteria Bacteria 370 4.22e-98   NTclustered gi|1943211519|gb|CP065707.1| 1303 g205653 i0 100 340.31 200 0 100 0 1 200 424075 424274 Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome blastn 68062 370 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
3753580 3753580 PRJNA753151_S_NODE_228023_length_189_cov_2.849315_g225733_i0 PRJNA753151 228023 189 2.849315 5.38520535 Staphylococcus 1279 Bacteria Bacteria 350 5.14e-92   NTclustered gi|1928723242|gb|CP042341.1| 29388 g225733 i0 100 102.206349206349 189 0 100 0 1 189 761243 761431 Staphylococcus capitis strain BN2 chromosome, complete genome blastn 19317 350 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus capitis
3753609 3753609 PRJNA753151_S_NODE_278683_length_167_cov_35.411290_g276393_i0 PRJNA753151 278683 167 35.41129 59.1368543 root 1 Root_unresolved Root_unresolved 309 7.53e-80   NTclustered gi|1796975023|gb|CP033086.1| 1280 g276393 i0 100 99.6826347305389 167 0 100 0 1 167 2463838 2463672 Staphylococcus aureus strain WH9628 chromosome blastn 16647 309 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
5030206 5030206 PRJNA753151_S_NODE_295984_length_161_cov_2.288136_g293694_i0 PRJNA753151 295984 161 2.288136 3.68389896 Staphylococcus 1279 Bacteria Bacteria 298 1.56e-76   NTclustered gi|1899862668|gb|CP061041.1| 1292 g293694 i0 100 98.2919254658385 161 0 100 0 1 161 2284651 2284491 Staphylococcus warneri strain WS479 chromosome, complete genome blastn 15825 298 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
6305880 6305880 PRJNA753151_S_NODE_146705_length_239_cov_7.918367_g144415_i0 PRJNA753151 146705 239 7.918367 18.92489713 Staphylococcus 1279 Bacteria Bacteria 442 1.0899999999999994e-119   NTclustered gi|2688295587|gb|CP145595.1| 29388 g144415 i0 100 475.476987447699 239 0 100 0 1 239 2299167 2299405 Staphylococcus capitis strain kcgeb_sa chromosome, complete genome blastn 113639 442 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus capitis
7579824 7579824 PRJNA753151_S_NODE_176226_length_219_cov_1.272727_g173936_i0 PRJNA753151 176226 219 1.272727 2.78727213 Staphylococcus 1279 Bacteria Bacteria 405 1.29e-108   NTclustered gi|1928723242|gb|CP042341.1| 29388 g173936 i0 100 100 219 0 100 0 1 219 2247562 2247344 Staphylococcus capitis strain BN2 chromosome, complete genome blastn 21900 405 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus capitis
8854869 8854869 PRJNA753151_S_NODE_200887_length_204_cov_1.397516_g198597_i0 PRJNA753151 200887 204 1.397516 2.85093264 Bacteria 2 Bacteria Bacteria 366 5.599999999999998e-97   NTclustered gi|2179631034|gb|CP090928.1| 1282 g198597 i0 99.02 124.210784313725 204 2 100 0 1 204 442 645 Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence blastn 25339 366 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
8854908 8854908 PRJNA753151_S_NODE_268767_length_171_cov_2.765625_g266477_i0 PRJNA753151 268767 171 2.765625 4.72921875 Staphylococcus 1279 Bacteria Bacteria 311 2.14e-80   NTclustered gi|691218329|gb|CP009046.1| 1282 g266477 i0 99.415 478 171 1 100 0 1 171 638303 638473 Staphylococcus epidermidis strain SEI, complete genome blastn 81738 311 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
12681536 12681536 PRJNA753151_S_NODE_211790_length_198_cov_1.451613_g209500_i0 PRJNA753151 211790 198 1.451613 2.87419374 Staphylococcus 1279 Bacteria Bacteria 322 1.18e-83   NTclustered gi|1176884116|gb|CP020463.1| 1282 g209500 i0 100 87.8787878787879 174 0 88 0 25 198 498068 497895 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 17400 322 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
13483463 13483463 PRJNA753151_S_NODE_166311_length_225_cov_3.461538_g164021_i0 PRJNA753151 166311 225 3.461538 7.7884605 Anaerococcus prevotii 33034 Bacteria Bacteria 411 2.869999999999999e-110   NTclustered gi|256797400|gb|CP001708.1| 525919 g164021 i0 99.556 248.431111111111 225 1 100 0 1 225 239640 239416 Anaerococcus prevotii DSM 20548, complete genome blastn 55897 411 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus prevotii
14758259 14758259 PRJNA753151_S_NODE_109192_length_273_cov_1.721739_g106902_i0 PRJNA753151 109192 273 1.721739 4.70034747 Staphylococcus pasteuri 45972 Bacteria Bacteria 505 1.6e-138   NTclustered gi|1250045397|gb|CP017463.1| 45972 g106902 i0 100 99.5970695970696 273 0 100 0 1 273 2309319 2309591 Staphylococcus pasteuri strain JS7 chromosome, complete genome blastn 27190 505 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus pasteuri
16504769 16504769 PRJNA753151_S_NODE_134693_length_249_cov_3.033981_g132403_i0 PRJNA753151 134693 249 3.033981 7.55461269 Staphylococcus 1279 Bacteria Bacteria 460 3.16e-125   NTclustered gi|1848617844|gb|CP053957.1| 29388 g132403 i0 100 99.2008032128514 249 0 100 0 1 249 1788448 1788200 Staphylococcus capitis strain FDAARGOS_753 chromosome, complete genome blastn 24701 460 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus capitis
16504889 16504889 PRJNA753151_S_NODE_90533_length_294_cov_3.406375_g88243_i0 PRJNA753151 90533 294 3.406375 10.0147425 Staphylococcus 1279 Bacteria Bacteria 544 3.69e-150   NTclustered gi|1176884116|gb|CP020463.1| 1282 g88243 i0 100 100 294 0 100 0 1 294 701066 700773 Staphylococcus epidermidis strain 1457 chromosome, complete genome blastn 29400 544 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
23683358 23683358 PRJNA753151_S_NODE_294699_length_162_cov_1.134454_g292409_i0 PRJNA753151 294699 162 1.134454 1.83781548 Staphylococcus epidermidis 1282 Bacteria Bacteria 300 4.36e-77   NTclustered gi|2522199385|gb|CP127869.1| 1282 g292409 i0 100 100 162 0 100 0 1 162 1629770 1629931 Staphylococcus epidermidis strain NG02 chromosome, complete genome blastn 16200 300 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
24153545 24153545 PRJNA753151_S_NODE_253419_length_178_cov_1.000000_g251129_i0 PRJNA753151 253419 178 1 1.78 Staphylococcus 1279 Bacteria Bacteria 329 6.21e-86   NTclustered gi|2150735284|gb|CP086659.1| 29388 g251129 i0 100 42.4101123595506 178 0 100 0 1 178 1474146 1474323 Staphylococcus capitis strain XZ03 chromosome, complete genome blastn 7549 329 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus capitis
24956273 24956273 PRJNA753151_S_NODE_17960_length_524_cov_13.604990_g15920_i0 PRJNA753151 17960 524 13.60499 71.2901476 Natroniella sp. ANB-PHB2 3384444 Bacteria Bacteria 54.7 0.014   NTclustered gi|2869714905|gb|CP175562.1| 3384444 g15920 i0 100 0.0553435114503817 29 0 6 0 255 283 1966718 1966746 Natroniella sp. ANB-PHB2 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales Halobacteroidaceae Natroniella Natroniella sp. ANB-PHB2

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