RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA675331" 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

  • PRJNA675331 · 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
3198596 3198596 PRJNA675331_P_NODE_10963_length_303_cov_75.169565_g10791_i0 PRJNA675331 10963 303 75.169565 227.76378195 uncultured Streptococcus sp. 83427 Bacteria Bacteria 405 1.88e-108   NTclustered gi|2695360723|gb|PP455427.1| 83427 g10791 i0 92 120.792079207921 300 6 94 11 9 293 503 799 Uncultured Streptococcus sp. clone def16 16S ribosomal RNA gene, partial sequence blastn 36600 405 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus uncultured Streptococcus sp.
5751267 5751267 PRJNA675331_P_NODE_12945_length_284_cov_1.094787_g12773_i0 PRJNA675331 12945 284 1.094787 3.10919508 Neobacillus sp. DY30 3047871 Bacteria Bacteria 147 1.17e-30   NTclustered gi|2511398412|gb|CP126093.1| 3047871 g12773 i0 82.286 16.306338028169 175 25 60 5 105 275 164379 164551 Neobacillus sp. DY30 chromosome, complete genome blastn 4631 147 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus sp. DY30
5751328 5751328 PRJNA675331_P_NODE_22805_length_243_cov_0.905882_g22633_i0 PRJNA675331 22805 243 0.905882 2.20129326 Streptococcus mitis 28037 Bacteria Bacteria 438 1.4399999999999996e-118   NTclustered gi|2886512733|emb|OZ217346.1| 28037 g22633 i0 99.177 99.0740740740741 243 2 100 0 1 243 173848 174090 Streptococcus mitis isolate S. mitis D22 genome assembly, chromosome: 1 blastn 24075 438 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
6272464 6272464 PRJNA675331_P_NODE_15185_length_270_cov_1.436548_g15013_i0 PRJNA675331 15185 270 1.436548 3.8786796 Clostridium 1485 Bacteria Bacteria 418 2.1199999999999993e-112   NTclustered gi|2425298477|gb|CP114763.1| 1492 g15013 i0 95.131 863.562962962963 267 10 99 3 3 268 11376 11640 Clostridium butyricum strain LV1 chromosome 1, complete sequence blastn 233162 418 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium butyricum
10851776 10851776 PRJNA675331_P_NODE_18689_length_250_cov_0.870056_g18517_i0 PRJNA675331 18689 250 0.870056 2.17514 Streptococcus sp. oral taxon 061 712623 Bacteria Bacteria 440 4.1399999999999976e-119   NTclustered gi|1866752300|gb|CP058258.1| 712623 g18517 i0 98.4 5.996 250 4 100 0 1 250 284137 284386 Streptococcus sp. oral taxon 061 strain F0704 chromosome, complete genome blastn 1499 440 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp. oral taxon 061
10851786 10851786 PRJNA675331_P_NODE_20569_length_247_cov_0.885057_g20397_i0 PRJNA675331 20569 247 0.885057 2.18609079 Lactobacillus crispatus 47770 Bacteria Bacteria 420 5.31e-113   NTclustered gi|2096299657|gb|CP083392.1| 47770 g20397 i0 100 27.5708502024291 227 0 92 0 1 227 250579 250353 Lactobacillus crispatus strain Lc1226 chromosome, complete genome blastn 6810 420 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus crispatus
12647843 12647843 PRJNA675331_P_NODE_18410_length_251_cov_0.865169_g18238_i0 PRJNA675331 18410 251 0.865169 2.17157419 Streptococcus 1301 Bacteria Bacteria 398 2.5399999999999994e-106   NTclustered gi|1403472623|emb|LS483417.1| 1313 g18238 i0 95.219 99.9760956175299 251 12 100 0 1 251 1155700 1155950 Streptococcus pneumoniae strain NCTC11902 genome assembly, chromosome: 1 blastn 25094 398 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
18500028 18500028 PRJNA675331_P_NODE_19595_length_248_cov_2.022857_g19423_i0 PRJNA675331 19595 248 2.022857 5.01668536 Paraclostridium bifermentans 1490 Bacteria Bacteria 449 6.81e-122   NTclustered gi|2223161236|gb|CP094933.1| 1490 g19423 i0 100 1119.5564516129 243 0 98 0 3 245 14899 14657 Paraclostridium bifermentans strain HD0315_2 chromosome, complete genome blastn 277650 449 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Paraclostridium Paraclostridium bifermentans

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