RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA274362" 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

  • PRJNA274362 · 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
26821061 26821061 PRJNA274362_S_NODE_13341_length_243_cov_2140.695876_g13221_i0 PRJNA274362 13341 243 2140.695876 5201.89097868 uncultured Schaedlerella sp. 2676055 Bacteria Bacteria 55.8 8.69e-7   NR WP_300824954.1 2676055 g13221 i0 79.3 0.358024691358025 29 6 35.8 0 30 116 1 29 WP_300824954.1 TIGR03960 family B12-binding radical SAM protein, partial [uncultured Schaedlerella sp.] diamond 87 55.8 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Schaedlerella uncultured Schaedlerella sp.
29126966 29126966 PRJNA274362_S_NODE_16269_length_224_cov_1.514286_g16149_i0 PRJNA274362 16269 224 1.514286 3.39200064 Staphylococcus aureus 1280 Bacteria Bacteria 65.9 5.47e-12   NR MCS4580470.1 1280 g16149 i0 97.7 0.589285714285714 44 1 58.9 0 221 90 1 44 MCS4580470.1 hypothetical protein [Staphylococcus aureus] diamond 132 65.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
29631600 29631600 PRJNA274362_S_NODE_32250_length_169_cov_0.866667_g32130_i0 PRJNA274362 32250 169 0.866667 1.46466723 Anoxybacillus flavithermus 33934 Bacteria Bacteria 86.3 6.37e-18   NR WP_064214309.1 33934 g32130 i0 71.4 2.98224852071006 56 16 99.4 0 2 169 272 327 WP_064214309.1 DNA gyrase subunit A [Anoxybacillus flavithermus] diamond 504 86.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Anoxybacillus Anoxybacillus flavithermus
30345085 30345085 PRJNA274362_S_NODE_20032_length_206_cov_1.305732_g19912_i0 PRJNA274362 20032 206 1.305732 2.68980792 Massilibacterium 1923871 Bacteria Bacteria 85.5 1.62e-19   NR WP_062199444.1 1632858 g19912 i0 61.8 3.94660194174757 68 26 99 0 2 205 41 108 WP_062199444.1 group I truncated hemoglobin [Massilibacterium senegalense] diamond 813 85.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Massilibacterium Massilibacterium senegalense

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