RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "blastn", bioproject = "PRJNA745923" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA745923 · 23 ✖

analysis 1

  • blastn · 23 ✖

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
2000928 2000928 PRJNA745923_S_NODE_34642_length_161_cov_0.974576_g34310_i0 PRJNA745923 34642 161 0.974576 1.56906736 Lactobacillus iners 147802 Bacteria Bacteria 298 1.56e-76   NTclustered gi|1818008110|gb|CP049223.1| 147802 g34310 i0 100 11.6521739130435 161 0 100 0 1 161 1156693 1156533 Lactobacillus iners strain C0094A1 chromosome, complete genome blastn 1876 298 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
4553480 4553480 PRJNA745923_S_NODE_40564_length_150_cov_0.897196_g40232_i0 PRJNA745923 40564 150 0.897196 1.345794 Lactobacillus iners 147802 Bacteria Bacteria 272 8.609999999999998e-69   NTclustered gi|1818001851|gb|CP049231.1| 147802 g40232 i0 99.333 74.3333333333333 150 1 100 0 1 150 166451 166302 Lactobacillus iners strain C0254C1 chromosome, complete genome blastn 11150 272 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
5027118 5027118 PRJNA745923_S_NODE_24184_length_197_cov_1.558442_g23852_i0 PRJNA745923 24184 197 1.558442 3.07013074 Streptococcus 1301 Bacteria Bacteria 359 8.98e-95   NTclustered gi|2625184810|dbj|AP026968.1| 2993430 g23852 i0 99.492 100 197 1 100 0 1 197 904803 904607 Streptococcus sp. SP4011 DNA, complete genome blastn 19700 359 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus parapneumoniae
7103526 7103526 PRJNA745923_S_NODE_32726_length_166_cov_1.170732_g32394_i0 PRJNA745923 32726 166 1.170732 1.94341512 Lactobacillus iners 147802 Bacteria Bacteria 307 2.69e-79   NTclustered gi|2769739957|gb|CP160078.1| 147802 g32394 i0 100 13 166 0 100 0 1 166 1302998 1302833 Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome blastn 2158 307 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
7576740 7576740 PRJNA745923_S_NODE_13206_length_280_cov_1.759494_g12874_i0 PRJNA745923 13206 280 1.759494 4.9265832 root 1 Root_unresolved Root_unresolved 512 9.85e-141   NTclustered gi|1821622467|dbj|LC377539.1| 1280 g12874 i0 99.643 116.017857142857 280 1 100 0 1 280 12113 12392 Staphylococcus aureus plasmid pNTUH_6457 NTUH_6457 DNA, complete sequence blastn 32485 512 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
8378163 8378163 PRJNA745923_S_NODE_31587_length_169_cov_1.523810_g31255_i0 PRJNA745923 31587 169 1.52381 2.5752389 Lactobacillus iners 147802 Bacteria Bacteria 313 5.859999999999999e-81   NTclustered gi|1818004205|gb|CP049228.1| 147802 g31255 i0 100 12.603550295858 169 0 100 0 1 169 1165023 1165191 Lactobacillus iners strain C0210C1 chromosome, complete genome blastn 2130 313 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
8851876 8851876 PRJNA745923_S_NODE_23407_length_200_cov_3.057325_g23075_i0 PRJNA745923 23407 200 3.057325 6.11465 Streptococcus 1301 Bacteria Bacteria 370 4.22e-98   NTclustered gi|2886510793|emb|OZ217345.1| 28037 g23075 i0 100 312 200 0 100 0 1 200 19737 19936 Streptococcus mitis isolate S. mitis F22 genome assembly, chromosome: 1 blastn 62400 370 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
9653040 9653040 PRJNA745923_S_NODE_15908_length_252_cov_1.837321_g15576_i0 PRJNA745923 15908 252 1.837321 4.63004892 Lactobacillus iners 147802 Bacteria Bacteria 466 6.89e-127   NTclustered gi|2769739957|gb|CP160078.1| 147802 g15576 i0 100 100.345238095238 252 0 100 0 1 252 1048566 1048315 Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome blastn 25287 466 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
10928715 10928715 PRJNA745923_S_NODE_27529_length_183_cov_1.028571_g27197_i0 PRJNA745923 27529 183 1.028571 1.88228493 Lactobacillus iners 147802 Bacteria Bacteria 339 1.07e-88   NTclustered gi|2769739957|gb|CP160078.1| 147802 g27197 i0 100 13 183 0 100 0 1 183 892847 892665 Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome blastn 2379 339 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
10928851 10928851 PRJNA745923_S_NODE_36509_length_156_cov_1.274336_g36177_i0 PRJNA745923 36509 156 1.274336 1.98796416 Lactobacillus iners 147802 Bacteria Bacteria 289 9e-74   NTclustered gi|2769739957|gb|CP160078.1| 147802 g36177 i0 100 99.5897435897436 156 0 100 0 1 156 419326 419481 Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome blastn 15536 289 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
10928852 10928852 PRJNA745923_S_NODE_36709_length_155_cov_3.107143_g36377_i0 PRJNA745923 36709 155 3.107143 4.81607165 Streptococcus mitis 28037 Bacteria Bacteria 254 3.25e-63   NTclustered gi|1851386209|gb|CP047883.1| 28037 g36377 i0 97.945 31.6258064516129 146 3 94 0 1 146 1788604 1788749 Streptococcus mitis strain S022-V3-A4 chromosome, complete genome blastn 4902 254 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
10928979 10928979 PRJNA745923_S_NODE_8309_length_364_cov_2.557632_g7977_i0 PRJNA745923 8309 364 2.557632 9.30978048 Lactobacillus iners 147802 Bacteria Bacteria 671 0   NTclustered gi|2769739957|gb|CP160078.1| 147802 g7977 i0 100 84.7664835164835 363 0 99 0 2 364 357944 357582 Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome blastn 30855 671 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
12204199 12204199 PRJNA745923_S_NODE_24570_length_195_cov_2.092105_g24238_i0 PRJNA745923 24570 195 2.092105 4.07960475 Lactobacillus iners 147802 Bacteria Bacteria 350 5.34e-92   NTclustered gi|2769739957|gb|CP160078.1| 147802 g24238 i0 98.974 99.6666666666667 195 2 100 0 1 195 1008667 1008473 Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome blastn 19435 350 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
12204245 12204245 PRJNA745923_S_NODE_27510_length_183_cov_1.028571_g27178_i0 PRJNA745923 27510 183 1.028571 1.88228493 Lactobacillus iners 147802 Bacteria Bacteria 339 1.07e-88   NTclustered gi|2769739957|gb|CP160078.1| 147802 g27178 i0 100 13 183 0 100 0 1 183 358917 358735 Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome blastn 2379 339 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
14753868 14753868 PRJNA745923_S_NODE_5592_length_462_cov_3.078759_g5265_i0 PRJNA745923 5592 462 3.078759 14.22386658 Lactobacillus iners 147802 Bacteria Bacteria 848 0   NTclustered gi|2769739957|gb|CP160078.1| 147802 g5265 i0 99.784 98.7878787878788 462 1 100 0 1 462 1049692 1049231 Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome blastn 45640 848 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
15227384 15227384 PRJNA745923_S_NODE_24812_length_194_cov_1.894040_g24480_i0 PRJNA745923 24812 194 1.89404 3.6744376 root 1 Root_unresolved Root_unresolved 337 4.13e-88   NTclustered gi|2179631034|gb|CP090928.1| 1282 g24480 i0 97.938 105.345360824742 194 4 100 0 1 194 1394 1201 Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence blastn 20437 337 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus epidermidis
17776650 17776650 PRJNA745923_S_NODE_32554_length_166_cov_2.186992_g32222_i0 PRJNA745923 32554 166 2.186992 3.63040672 Paenibacillus 44249 Bacteria Bacteria 307 2.69e-79   NTclustered gi|1373996327|gb|CP028366.1| 59843 g32222 i0 100 5.51807228915663 166 0 100 0 1 166 5377113 5377278 Paenibacillus glucanolyticus strain W10507 chromosome blastn 916 307 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus glucanolyticus
18576311 18576311 PRJNA745923_S_NODE_18695_length_228_cov_2.075676_g18363_i0 PRJNA745923 18695 228 2.075676 4.73254128 Lactobacillus iners 147802 Bacteria Bacteria 422 1.34e-113   NTclustered gi|2769739957|gb|CP160078.1| 147802 g18363 i0 100 89.5745614035088 228 0 100 0 1 228 1047913 1048140 Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome blastn 20423 422 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
21127295 21127295 PRJNA745923_S_NODE_23077_length_202_cov_1.207547_g22745_i0 PRJNA745923 23077 202 1.207547 2.43924494 Lactobacillus iners 147802 Bacteria Bacteria 368 1.54e-97   NTclustered gi|2769738725|gb|CP160077.1| 147802 g22745 i0 99.505 12.0792079207921 202 1 100 0 1 202 1274740 1274539 Lactobacillus iners strain 0809_588_1_1_MRS1 chromosome, complete genome blastn 2440 368 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
23677677 23677677 PRJNA745923_S_NODE_20899_length_214_cov_1.380117_g20567_i0 PRJNA745923 20899 214 1.380117 2.95345038 Lactobacillus iners 147802 Bacteria Bacteria 396 7.559999999999996e-106   NTclustered gi|1818003035|gb|CP049230.1| 147802 g20567 i0 100 52.8738317757009 214 0 100 0 1 214 578178 578391 Lactobacillus iners strain C0322A1 chromosome, complete genome blastn 11315 396 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
24150561 24150561 PRJNA745923_S_NODE_39939_length_150_cov_4.616822_g39607_i0 PRJNA745923 39939 150 4.616822 6.925233 root 1 Root_unresolved Root_unresolved 272 8.609999999999998e-69   NTclustered gi|1796972337|gb|CP033085.1| 1280 g39607 i0 99.333 100.886666666667 150 1 100 0 1 150 2730106 2729957 Staphylococcus aureus strain WH3018 chromosome blastn 15133 272 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
24951165 24951165 PRJNA745923_S_NODE_19440_length_223_cov_1.333333_g19108_i0 PRJNA745923 19440 223 1.333333 2.97333259 Lactobacillus iners 147802 Bacteria Bacteria 412 7.88e-111   NTclustered gi|1818006880|gb|CP049225.1| 147802 g19108 i0 100 18.0313901345291 223 0 100 0 1 223 508086 508308 Lactobacillus iners strain C0059G1 chromosome, complete genome blastn 4021 412 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
24951508 24951508 PRJNA745923_S_NODE_7520_length_386_cov_1.381924_g7188_i0 PRJNA745923 7520 386 1.381924 5.33422664 Lactobacillus iners 147802 Bacteria Bacteria 708 0   NTclustered gi|1810931560|gb|CP048798.1| 147802 g7188 i0 99.742 11.979274611399 387 0 100 1 1 386 155481 155867 Lactobacillus iners strain KY chromosome, complete genome blastn 4624 708 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners

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