RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA688736" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA688736 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
6281086 6281086 PRJNA688736_P_NODE_14885_length_396_cov_3.362229_g14600_i0 PRJNA688736 14885 396 3.362229 13.31442684 root 1 Root_unresolved Root_unresolved 192 1.58e-60   NR MRC56835.1 1428 g14600 i0 91.2 7.00757575757576 102 9 77.3 0 396 91 20 121 MRC56835.1 50S ribosomal protein L30e [Bacillus thuringiensis] diamond 2775 192 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis
27998419 27998419 PRJNA688736_P_NODE_44845_length_248_cov_0.891429_g44560_i0 PRJNA688736 44845 248 0.891429 2.21074392 Lapidilactobacillus concavus 287844 Bacteria Bacteria 157 2.24e-47   NR WP_057823203.1 287844 g44560 i0 97.6 0.991935483870968 82 2 99.2 0 248 3 77 158 WP_057823203.1 hypothetical protein [Lapidilactobacillus concavus] diamond 246 157 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lapidilactobacillus Lapidilactobacillus concavus
31187785 31187785 PRJNA688736_P_NODE_50875_length_242_cov_0.923077_g50590_i0 PRJNA688736 50875 242 0.923077 2.23384634 uncultured Lachnoanaerobaculum sp. 1662275 Bacteria Bacteria 112 1.79e-27   NR WP_314505175.1 1662275 g50590 i0 66.7 0.966942148760331 78 26 96.7 0 1 234 114 191 WP_314505175.1 LacI family DNA-binding transcriptional regulator [uncultured Lachnoanaerobaculum sp.] diamond 234 112 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Lachnoanaerobaculum uncultured Lachnoanaerobaculum sp.
31757406 31757406 PRJNA688736_P_NODE_43497_length_249_cov_1.329545_g43212_i0 PRJNA688736 43497 249 1.329545 3.31056705 Thermaerobacter sp. 1937527 Bacteria Bacteria 43.1 0.0292   NR HEY8488732.1 1937527 g43212 i0 39.1 0.771084337349398 64 34 72.3 2 16 195 332 394 HEY8488732.1 HD domain-containing phosphohydrolase [Thermaerobacter sp.] diamond 192 43.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiales Family XVII. Incertae Sedis Thermaerobacter Thermaerobacter sp.

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