RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA930380 · 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
909391 909391 PRJNA930380_P_NODE_13361_length_244_cov_1.754386_g13308_i0 PRJNA930380 13361 244 1.754386 4.28070184 Lactobacillus iners 147802 Bacteria Bacteria 451 1.86e-122   NTclustered gi|2769739957|gb|CP160078.1| 147802 g13308 i0 100 13 244 0 100 0 1 244 630222 629979 Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome blastn 3172 451 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
3460233 3460233 PRJNA930380_P_NODE_13723_length_243_cov_0.905882_g13670_i0 PRJNA930380 13723 243 0.905882 2.20129326 Lactobacillus iners 147802 Bacteria Bacteria 449 6.65e-122   NTclustered gi|2769739957|gb|CP160078.1| 147802 g13670 i0 100 482.934156378601 243 0 100 0 1 243 2614 2372 Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome blastn 117353 449 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
4737728 4737728 PRJNA930380_P_NODE_14304_length_241_cov_0.916667_g14251_i0 PRJNA930380 14304 241 0.916667 2.20916747 Enterococcus faecalis 1351 Bacteria Bacteria 446 8.519999999999999e-121   NTclustered gi|2236315023|gb|CP097042.1| 1351 g14251 i0 100 100 241 0 100 0 1 241 2059909 2060149 Enterococcus faecalis strain AT34 chromosome, complete genome blastn 24100 446 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
7287552 7287552 PRJNA930380_P_NODE_6046_length_291_cov_1.412844_g5993_i0 PRJNA930380 6046 291 1.412844 4.11137604 Peptococcus niger 2741 Bacteria Bacteria 322 1.86e-83   NTclustered gi|288511|emb|X68428.1| 2741 g5993 i0 88.806 312.460481099656 268 23 91 4 25 290 1244 1506 P.niger gene for 23S rRNA blastn 90926 322 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Peptococcaceae Peptococcus Peptococcus niger
12388639 12388639 PRJNA930380_P_NODE_8350_length_281_cov_1.086538_g8297_i0 PRJNA930380 8350 281 1.086538 3.05317178 Lactobacillus iners 147802 Bacteria Bacteria 520 5.909999999999999e-143   NTclustered gi|2769739957|gb|CP160078.1| 147802 g8297 i0 100 489.224199288256 281 0 100 0 1 281 3374 3094 Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome blastn 137472 520 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
16557445 16557445 PRJNA930380_P_NODE_9613_length_273_cov_2.075000_g9560_i0 PRJNA930380 9613 273 2.075 5.66475 Streptococcus 1301 Bacteria Bacteria 52.8 0.025   NTclustered gi|1539699848|emb|LR134265.1| 1311 g9560 i0 100 6.15384615384615 28 0 10 0 125 152 1435754 1435781 Streptococcus agalactiae strain NCTC8184 genome assembly, chromosome: 1 blastn 1680 52.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus agalactiae

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