RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA554794" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA554794 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
27678796 27678796 PRJNA554794_P_NODE_23904_length_163_cov_0.894737_g19975_i0 PRJNA554794 23904 163 0.894737 1.45842131 Dialister sp. 1955814 Bacteria Bacteria 107 8.37e-28   NR MDU5281830.1 1955814 g19975 i0 98.1 1.95092024539877 53 1 97.5 0 161 3 67 119 MDU5281830.1 MobA/MobL family protein [Dialister sp.] diamond 318 107 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Dialister Dialister sp.
30236210 30236210 PRJNA554794_P_NODE_22392_length_169_cov_0.775000_g18463_i0 PRJNA554794 22392 169 0.775 1.30975 Bacillus thuringiensis 1428 Bacteria Bacteria 73.6 9.17e-16   NR MRC01722.1 1428 g18463 i0 91.7 0.85207100591716 48 4 85.2 0 26 169 1 48 MRC01722.1 hypothetical protein [Bacillus thuringiensis] diamond 144 73.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis
31058078 31058078 PRJNA554794_P_NODE_11075_length_333_cov_2.672535_g7150_i0 PRJNA554794 11075 333 2.672535 8.89954155 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 47.8 0.00163   NR MBQ8238023.1 2485925 g7150 i0 47.6 0.378378378378378 42 22 37.8 0 130 255 135 176 MBQ8238023.1 glycosyltransferase family 2 protein [Oscillospiraceae bacterium] diamond 126 47.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
31690043 31690043 PRJNA554794_P_NODE_21857_length_175_cov_1.603175_g17928_i0 PRJNA554794 21857 175 1.603175 2.80555625 Alteribacillus persepolensis 568899 Bacteria Bacteria 74.7 2.3e-14   NR WP_091270958.1 568899 g17928 i0 68.6 5.53714285714286 51 16 87.4 0 173 21 199 249 WP_091270958.1 metallophosphoesterase [Alteribacillus persepolensis] diamond 969 74.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Alteribacillus Alteribacillus persepolensis
32323192 32323192 PRJNA554794_P_NODE_11419_length_316_cov_1.161049_g7492_i0 PRJNA554794 11419 316 1.161049 3.66891484 Thermoflavimicrobium daqui 2137476 Bacteria Bacteria 57.4 6.41e-8   NR WP_113658786.1 2137476 g7492 i0 44.2 0.493670886075949 52 29 49.4 0 289 134 24 75 WP_113658786.1 peptidase inhibitor family I36 protein [Thermoflavimicrobium daqui] diamond 156 57.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Thermoflavimicrobium Thermoflavimicrobium daqui

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