RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA685060" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA685060 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
29135102 29135102 PRJNA685060_P_NODE_6349_length_379_cov_1.183007_g6259_i0 PRJNA685060 6349 379 1.183007 4.48359653 Bacillota bacterium 1879010 Bacteria Bacteria 44.3 0.0383   NR NLU41568.1 1879010 g6259 i0 37.3 0.656992084432718 83 42 57.8 3 1 219 119 201 NLU41568.1 carbon-nitrogen hydrolase family protein [Bacillota bacterium] diamond 249 44.3 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
29481862 29481862 PRJNA685060_P_NODE_5970_length_393_cov_1.062500_g5880_i0 PRJNA685060 5970 393 1.0625 4.175625 Mediterraneibacter gnavus 33038 Bacteria Bacteria 44.7 0.026   NR WP_101885712.1 33038 g5880 i0 27.2 0.618320610687023 81 55 61.8 1 113 355 2 78 WP_101885712.1 helix-turn-helix domain-containing protein [Mediterraneibacter gnavus] diamond 243 44.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Mediterraneibacter Mediterraneibacter gnavus
29987454 29987454 PRJNA685060_P_NODE_13031_length_255_cov_1.269231_g12941_i0 PRJNA685060 13031 255 1.269231 3.23653905 Paraclostridium ghonii 29358 Bacteria Bacteria 73.2 5.49e-13   NR WP_307508597.1 29358 g12941 i0 45.2 2.55294117647059 73 39 85.9 1 35 253 6 77 WP_307508597.1 catalase [Paraclostridium ghonii] diamond 651 73.2 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Paraclostridium Paraclostridium ghonii
30272051 30272051 PRJNA685060_P_NODE_10492_length_291_cov_0.990826_g10402_i0 PRJNA685060 10492 291 0.990826 2.88330366 uncultured Brevibacillus sp. 169970 Bacteria Bacteria 44.7 0.0126   NR WP_289139644.1 169970 g10402 i0 28.4 0.690721649484536 67 48 69.1 0 40 240 207 273 WP_289139644.1 MerR family transcriptional regulator [uncultured Brevibacillus sp.] diamond 201 44.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus uncultured Brevibacillus sp.
30493008 30493008 PRJNA685060_P_NODE_13433_length_251_cov_0.865169_g13343_i0 PRJNA685060 13433 251 0.865169 2.17157419 Staphylococcus hominis 1290 Bacteria Bacteria 163 1.45e-44   NR WP_143129574.1 1290 g13343 i0 100 0.99203187250996006 83 0 99.2 0 249 1 683 765 WP_143129574.1 CapA family protein [Staphylococcus hominis] diamond 249 163 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus hominis
31610896 31610896 PRJNA685060_P_NODE_11596_length_274_cov_1.915423_g11506_i0 PRJNA685060 11596 274 1.915423 5.24825902 Bacillati 1783272 Bacteria Bacteria 45.4 0.00505   NR PCZ68894.1 1639 g11506 i0 51.1 4.01824817518248 47 20 48.2 1 156 25 181 227 PCZ68894.1 excinuclease ABC subunit B, partial [Listeria monocytogenes] diamond 1101 45.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
32528515 32528515 PRJNA685060_P_NODE_6479_length_375_cov_1.317881_g6389_i0 PRJNA685060 6479 375 1.317881 4.94205375 Bacteria 2 Bacteria Bacteria 80.1 7.23e-15   NR MBQ6569760.1 2044939 g6389 i0 44.1 4.568 102 55 80 1 375 76 172 273 MBQ6569760.1 UDP-glucose 4-epimerase GalE [Clostridia bacterium] diamond 1713 80.9 0.990111248454882 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium

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