RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJDB3785" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJDB3785 · 19 ✖

analysis 1

  • blastn · 19 ✖

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
981159 981159 PRJDB3785_S_NODE_20521_length_176_cov_1.110236_g20368_i0 PRJDB3785 20521 176 1.110236 1.95401536 Anoxybacillaceae 3120669 Bacteria Bacteria 303 3.71e-78   NTclustered gi|1207877705|gb|CP021838.1| 33934 g20368 i0 97.74 895.357954545455 177 3 100 1 1 176 1489160 1489336 Anoxybacillus flavithermus strain 52-1A chromosome, complete genome blastn 157583 303 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Anoxybacillus Anoxybacillus flavithermus
3531805 3531805 PRJDB3785_S_NODE_16603_length_192_cov_3.482517_g16450_i0 PRJDB3785 16603 192 3.482517 6.68643264 Paraclostridium 1849822 Bacteria Bacteria 350 5.24e-92   NTclustered gi|2091226359|gb|CP079737.1| 1490 g16450 i0 99.479 907.510416666667 192 1 100 0 1 192 12822 13013 Paraclostridium bifermentans strain DSM 14991 chromosome, complete genome blastn 174242 350 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Paraclostridium Paraclostridium bifermentans
5111359 5111359 PRJDB3785_S_NODE_5425_length_325_cov_1.293478_g5272_i0 PRJDB3785 5425 325 1.293478 4.2038035 Bacillus mycoides 1405 Bacteria Bacteria 60.2 1.83e-4   NTclustered gi|2049754127|gb|CP036116.1| 1405 g5272 i0 100 1.51076923076923 32 0 10 0 119 150 74393 74362 Bacillus mycoides strain JAS481 plasmid p124 blastn 491 60.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus mycoides
7358856 7358856 PRJDB3785_S_NODE_12826_length_214_cov_1.678788_g12673_i0 PRJDB3785 12826 214 1.678788 3.59260632 Weissella 46255 Bacteria Bacteria 388 1.26e-103   NTclustered gi|498764246|gb|KC632047.1| 1629 g12673 i0 99.531 99.5327102803738 213 1 99 0 1 213 110 322 Weissella viridescens strain S49 16S ribosomal RNA gene, partial sequence blastn 21300 388 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Weissella Weissella viridescens
7661140 7661140 PRJDB3785_S_NODE_22707_length_168_cov_1.285714_g22554_i0 PRJDB3785 22707 168 1.285714 2.15999952 Weissella viridescens 1629 Bacteria Bacteria 311 2.11e-80   NTclustered gi|33590284|gb|AY342344.1| 1629 g22554 i0 100 512.910714285714 168 0 100 0 1 168 944 777 Weissella viridescens 16S ribosomal RNA gene, partial sequence; tRNA-Ala gene, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 86169 311 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Weissella Weissella viridescens
7661183 7661183 PRJDB3785_S_NODE_27927_length_155_cov_2.490566_g27774_i0 PRJDB3785 27927 155 2.490566 3.8603773 Weissella viridescens 1629 Bacteria Bacteria 287 3.21e-73   NTclustered gi|2789550285|gb|CP166868.1| 1629 g27774 i0 100 327.051612903226 155 0 100 0 1 155 18108 18262 Weissella viridescens strain XBS25 chromosome, complete genome blastn 50693 287 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Weissella Weissella viridescens
11184475 11184475 PRJDB3785_S_NODE_14129_length_206_cov_0.828025_g13976_i0 PRJDB3785 14129 206 0.828025 1.7057315 Streptococcus 1301 Bacteria Bacteria 375 9.41e-100   NTclustered gi|1851386209|gb|CP047883.1| 28037 g13976 i0 99.515 326 206 1 100 0 1 206 163294 163089 Streptococcus mitis strain S022-V3-A4 chromosome, complete genome blastn 67156 375 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
15009041 15009041 PRJDB3785_S_NODE_16932_length_191_cov_1.070423_g16779_i0 PRJDB3785 16932 191 1.070423 2.04450793 Bacteria 2 Bacteria Bacteria 342 8.699999999999999e-90   NTclustered gi|1848626851|gb|CP054017.1| 1292 g16779 i0 98.953 449.96335078534 191 2 100 0 1 191 962703 962893 Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome blastn 85943 342 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
15009055 15009055 PRJDB3785_S_NODE_6052_length_306_cov_2.019455_g5899_i0 PRJDB3785 6052 306 2.0194549999999998 6.1795323 Weissella 46255 Bacteria Bacteria 556 4.96e-154   NTclustered gi|1851774648|gb|MT585627.1| 1629 g5899 i0 99.672 106.650326797386 305 0 99 1 1 304 477 781 Weissella viridescens strain 974 16S ribosomal RNA gene, partial sequence blastn 32635 556 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Weissella Weissella viridescens
15310867 15310867 PRJDB3785_S_NODE_17573_length_188_cov_1.071942_g17420_i0 PRJDB3785 17573 188 1.071942 2.01525096 Weissella viridescens 1629 Bacteria Bacteria 342 8.539999999999999e-90   NTclustered gi|2789550285|gb|CP166868.1| 1629 g17420 i0 99.468 574.88829787234 188 1 100 0 1 188 19357 19544 Weissella viridescens strain XBS25 chromosome, complete genome blastn 108079 342 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Weissella Weissella viridescens
17559081 17559081 PRJDB3785_S_NODE_18834_length_182_cov_1.789474_g18681_i0 PRJDB3785 18834 182 1.789474 3.25684268 root 1 Root_unresolved Root_unresolved 337 3.82e-88   NTclustered gi|1214359213|gb|MF424753.1| 1613 g18681 i0 100 194 182 0 100 0 1 182 953 1134 Limosilactobacillus fermentum strain CAU6386 16S ribosomal RNA gene, partial sequence blastn 35308 337 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Limosilactobacillus Limosilactobacillus fermentum
17860572 17860572 PRJDB3785_S_NODE_14955_length_201_cov_1.006579_g14802_i0 PRJDB3785 14955 201 1.006579 2.02322379 uncultured Thermicanus sp. 1130985 Bacteria Bacteria 366 5.5e-97   NTclustered gi|998610467|emb|LT169262.1| 1130985 g14802 i0 99.502 82.0099502487562 201 1 100 0 1 201 216 16 Uncultured Thermicanus sp. partial 16S rRNA gene, clone 1911_6_843 blastn 16484 366 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus uncultured Thermicanus sp.
18832925 18832925 PRJDB3785_S_NODE_14095_length_206_cov_0.980892_g13942_i0 PRJDB3785 14095 206 0.980892 2.02063752 Streptococcus 1301 Bacteria Bacteria 375 9.41e-100   NTclustered gi|1140122741|gb|CP019562.1| 1303 g13942 i0 99.515 336.95145631068 206 1 100 0 1 206 1571479 1571274 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 69412 375 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
18832929 18832929 PRJDB3785_S_NODE_22775_length_168_cov_1.235294_g22622_i0 PRJDB3785 22775 168 1.235294 2.07529392 Bacteria 2 Bacteria Bacteria 305 9.81e-79   NTclustered gi|1042399388|gb|KU555885.1| 1292 g22622 i0 99.405 502.279761904762 168 1 100 0 1 168 462 629 Staphylococcus warneri strain SWA15219-3 16S-23S ribosomal RNA intergenic spacer gene, region blastn 84383 305 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
19134393 19134393 PRJDB3785_S_NODE_25616_length_163_cov_1.342105_g25463_i0 PRJDB3785 25616 163 1.342105 2.18763115 Lactobacillus taiwanensis 508451 Bacteria Bacteria 52.8 0.014   NTclustered gi|2023477247|gb|CP059276.1| 508451 g25463 i0 100 0.171779141104294 28 0 17 0 115 142 871005 870978 Lactobacillus taiwanensis strain CLG01 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus taiwanensis
21383340 21383340 PRJDB3785_S_NODE_18157_length_185_cov_1.308824_g18004_i0 PRJDB3785 18157 185 1.308824 2.4213244 root 1 Root_unresolved Root_unresolved 342 8.369999999999999e-90   NTclustered gi|1098890960|gb|KY078799.1| 1396 g18004 i0 100 100 185 0 100 0 1 185 314 498 Bacillus cereus strain McL6 16S ribosomal RNA gene, partial sequence blastn 18500 342 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
21383352 21383352 PRJDB3785_S_NODE_3717_length_398_cov_1.083095_g3564_i0 PRJDB3785 3717 398 1.083095 4.3107181 root 1 Root_unresolved Root_unresolved 713 0   NTclustered gi|1214359213|gb|MF424753.1| 1613 g3564 i0 98.995 193 398 4 100 0 1 398 651 254 Limosilactobacillus fermentum strain CAU6386 16S ribosomal RNA gene, partial sequence blastn 76814 719 0.991655076495132 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Limosilactobacillus Limosilactobacillus fermentum
22960684 22960684 PRJDB3785_S_NODE_15099_length_200_cov_1.298013_g14946_i0 PRJDB3785 15099 200 1.298013 2.596026 Bacillus sp. Y1 352858 Bacteria Bacteria 329 7.17e-86   NTclustered gi|1480120062|gb|CP030028.1| 352858 g14946 i0 96.5 1092.875 200 6 99 1 1 199 12369 12568 Bacillus sp. Y1 chromosome, complete genome blastn 218575 329 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. Y1
23933611 23933611 PRJDB3785_S_NODE_16239_length_194_cov_1.413793_g16086_i0 PRJDB3785 16239 194 1.413793 2.74275842 Streptococcus 1301 Bacteria Bacteria 353 4.1e-93   NTclustered gi|1140122741|gb|CP019562.1| 1303 g16086 i0 99.485 317 194 1 100 0 1 194 1570138 1570331 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 61498 353 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis

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