RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA811237" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA811237 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
3775435 3775435 PRJNA811237_S_NODE_33823_length_162_cov_0.902655_g33583_i0 PRJNA811237 33823 162 0.902655 1.4623011 Enterococcus 1350 Bacteria Bacteria 294 2.03e-75   NTclustered gi|939198273|gb|CP010060.1| 44008 g33583 i0 99.383 195.950617283951 162 1 100 0 1 162 138297 138136 Enterococcus cecorum strain SA1 genome blastn 31744 294 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus cecorum
4637262 4637262 PRJNA811237_S_NODE_25444_length_172_cov_1.512195_g25204_i0 PRJNA811237 25444 172 1.512195 2.6009754 Liquorilactobacillus hordei 468911 Bacteria Bacteria 52.8 0.014   NTclustered gi|1318759364|gb|CP018176.1| 468911 g25204 i0 100 0.162790697674419 28 0 16 0 40 67 892914 892941 Liquorilactobacillus hordei strain TMW 1.1822 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Liquorilactobacillus Liquorilactobacillus hordei
5051619 5051619 PRJNA811237_S_NODE_30704_length_165_cov_0.879310_g30464_i0 PRJNA811237 30704 165 0.87931 1.4508615 root 1 Root_unresolved Root_unresolved 54.7 0.004   NTclustered gi|2511329391|gb|CP126079.1| 1406 g30464 i0 100 8.00606060606061 29 0 18 0 1 29 2043096 2043068 Paenibacillus polymyxa strain ACCC03434 chromosome, complete genome blastn 1321 54.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus polymyxa
7187093 7187093 PRJNA811237_S_NODE_4086_length_359_cov_2.538710_g3846_i0 PRJNA811237 4086 359 2.53871 9.1139689 Clostridium botulinum 1491 Bacteria Bacteria 54.7 0.009   NTclustered gi|743960172|dbj|AP014696.1| 1491 g3846 i0 96.875 0.0891364902506964 32 1 9 0 305 336 2319365 2319396 Clostridium botulinum DNA, complete genome, strain: 111 blastn 32 54.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium botulinum
11012661 11012661 PRJNA811237_S_NODE_11529_length_230_cov_1.751381_g11289_i0 PRJNA811237 11529 230 1.751381 4.0281763 Solibacillus sp. FSL W8-0372 2921713 Bacteria Bacteria 52.8 0.021   NTclustered gi|2709615959|gb|CP150204.1| 2921713 g11289 i0 100 0.121739130434783 28 0 12 0 196 223 873214 873187 Solibacillus sp. FSL W8-0372 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Solibacillus Solibacillus sp. FSL W8-0372
24175220 24175220 PRJNA811237_S_NODE_21239_length_185_cov_1.147059_g20999_i0 PRJNA811237 21239 185 1.147059 2.12205915 Bacillaceae 186817 Bacteria Bacteria 337 3.89e-88   NTclustered gi|1387294402|gb|CP023704.1| 35841 g20999 i0 99.459 915.140540540541 185 1 100 0 1 185 16688 16504 Caldibacillus thermoamylovorans strain SSBM chromosome, complete genome blastn 169301 337 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Caldibacillus Caldibacillus thermoamylovorans

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