RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB15333" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJEB15333 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
985831 985831 PRJEB15333_P_NODE_12081_length_196_cov_2.761905_g11997_i0 PRJEB15333 12081 196 2.761905 5.4133338 Streptococcus 1301 Bacteria Bacteria 355 1.15e-93   NTclustered gi|1140122741|gb|CP019562.1| 1303 g11997 i0 100 332.061224489796 192 0 98 0 1 192 1571341 1571532 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 65084 355 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
985834 985834 PRJEB15333_P_NODE_7961_length_237_cov_1.654255_g7877_i0 PRJEB15333 7961 237 1.654255 3.92058435 root 1 Root_unresolved Root_unresolved 438 1.4e-118   NTclustered gi|1861649571|gb|MT664063.1| 1306 g7877 i0 100 100 237 0 100 0 1 237 312 76 Streptococcus sp. strain KCOM 2447 (= ChDC F176) 16S ribosomal RNA gene, partial sequence blastn 23700 438 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp.
10224366 10224366 PRJEB15333_P_NODE_3669_length_332_cov_1.098940_g3585_i0 PRJEB15333 3669 332 1.09894 3.6484808 Anaerococcus nagyae 1755241 Bacteria Bacteria 553 7.029999999999998e-153   NTclustered gi|2722731751|dbj|AP031484.1| 1755241 g3585 i0 96.96 49.7409638554217 329 10 99 0 3 331 121082 121410 Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1 blastn 16514 553 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus nagyae
11499638 11499638 PRJEB15333_P_NODE_16830_length_169_cov_1.300000_g16746_i0 PRJEB15333 16830 169 1.3 2.197 Metabacillus halosaccharovorans 930124 Bacteria Bacteria 296 5.9e-76   NTclustered gi|2780438057|gb|CP162630.1| 930124 g16746 i0 98.225 804.568047337278 169 3 100 0 1 169 14208 14040 Metabacillus halosaccharovorans strain Hao 2024 chromosome, complete genome blastn 135972 296 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Metabacillus Metabacillus halosaccharovorans
15013689 15013689 PRJEB15333_P_NODE_14712_length_180_cov_1.190840_g14628_i0 PRJEB15333 14712 180 1.19084 2.143512 Exiguobacterium 33986 Bacteria Bacteria 333 4.87e-87   NTclustered gi|1735050952|gb|CP030931.1| 41170 g14628 i0 100 654.194444444444 180 0 100 0 1 180 473560 473381 Exiguobacterium acetylicum strain AMCC 101217 chromosome, complete genome blastn 117755 333 1 Bacteria   Bacillati Bacillota Bacilli Bacillales   Exiguobacterium Exiguobacterium acetylicum
15013694 15013694 PRJEB15333_P_NODE_5812_length_272_cov_3.748879_g5728_i0 PRJEB15333 5812 272 3.748879 10.19695088 Streptococcus 1301 Bacteria Bacteria 496 9.59e-136   NTclustered gi|2246565702|gb|CP097843.1| 1303 g5728 i0 99.631 330.882352941176 271 1 99 0 2 272 18076 17806 Streptococcus oralis strain HP01 chromosome, complete genome blastn 90000 496 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
15013698 15013698 PRJEB15333_P_NODE_9512_length_219_cov_1.994118_g9428_i0 PRJEB15333 9512 219 1.994118 4.36711842 Streptococcus 1301 Bacteria Bacteria 403 4.64e-108   NTclustered gi|1140122741|gb|CP019562.1| 1303 g9428 i0 100 346.438356164384 218 0 99 0 1 218 1568791 1569008 Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome blastn 75870 403 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
18837642 18837642 PRJEB15333_P_NODE_20435_length_162_cov_1.566372_g20351_i0 PRJEB15333 20435 162 1.566372 2.53752264 Bacillus 1386 Bacteria Bacteria 58.4 2.9e-4   NTclustered gi|942009880|gb|CP013000.1| 1428 g20351 i0 100 5.35802469135802 31 0 19 0 27 57 251825 251795 Bacillus thuringiensis strain XL6 chromosome, complete genome blastn 868 58.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis

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