RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJEB2925" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJEB2925 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
27879630 27879630 PRJEB2925_P_NODE_11725_length_319_cov_3.419014_g10450_i0 PRJEB2925 11725 319 3.419014 10.90665466 FCB group 1783270 Bacteria Bacteria 52 2.37e-6   NR NMA33845.1 1898204 g10450 i0 81.5 2.79310344827586 27 5 25.4 0 98 178 1 27 NMA33845.1 50S ribosomal protein L35 [Clostridiaceae bacterium] diamond 891 52 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
28391287 28391287 PRJEB2925_P_NODE_4986_length_608_cov_18.417103_g3981_i0 PRJEB2925 4986 608 18.417103 111.97598624 Romboutsia sp. 1965302 Bacteria Bacteria 169 1.01e-50   NR MCA9749906.1 1965302 g3981 i0 78.4 0.547697368421053 111 24 54.8 0 351 19 1 111 MCA9749906.1 F0F1 ATP synthase subunit A [Romboutsia sp.] diamond 333 169 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Romboutsia Romboutsia sp.
29748710 29748710 PRJEB2925_P_NODE_13491_length_283_cov_7.560484_g12213_i0 PRJEB2925 13491 283 7.560484 21.39616972 Clostridium botulinum 1491 Bacteria Bacteria 45.1 0.00717   NR WP_396021533.1 1491 g12213 i0 68.1 0.996466431095406 47 13 47.7 1 18 152 72 118 WP_396021533.1 hypothetical protein, partial [Clostridium botulinum] diamond 282 45.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium botulinum
29970026 29970026 PRJEB2925_P_NODE_16191_length_245_cov_2.985714_g14913_i0 PRJEB2925 16191 245 2.985714 7.3149993 Bacillus subtilis 1423 Bacteria Bacteria 44.7 0.00328   NR WLE10830.1 1423 g14913 i0 54.3 0.563265306122449 46 20 56.3 1 49 186 56 100 WLE10830.1 hypothetical protein FPL20_GE00587 [Bacillus subtilis] diamond 138 44.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus subtilis
31265567 31265567 PRJEB2925_P_NODE_8135_length_435_cov_3.587500_g6908_i0 PRJEB2925 8135 435 3.5875 15.605625 Bacillus altitudinis 293387 Bacteria Bacteria 46.6 0.011   NR WP_061420610.1 293387 g6908 i0 26.6 0.986206896551724 143 81 87.6 5 34 414 59 193 WP_061420610.1 hypothetical protein [Bacillus altitudinis] diamond 429 46.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus altitudinis
31392243 31392243 PRJEB2925_P_NODE_10636_length_348_cov_1.546326_g9364_i0 PRJEB2925 10636 348 1.546326 5.38121448 Weissella cibaria 137591 Bacteria Bacteria 43.1 0.0332   NR WP_196777317.1 137591 g9364 i0 48.8 1.0948275862069 127 24 87.9 10 23 328 14 124 WP_196777317.1 hypothetical protein, partial [Weissella cibaria] diamond 381 43.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Weissella Weissella cibaria
31708342 31708342 PRJEB2925_P_NODE_14437_length_268_cov_5.369099_g13159_i0 PRJEB2925 14437 268 5.369099 14.38918532 Clostridia bacterium 2044939 Bacteria Bacteria 43.1 0.031   NR MBR5601676.1 2044939 g13159 i0 36 0.996268656716418 89 39 95.1 2 10 264 10 84 MBR5601676.1 VanZ family protein [Clostridia bacterium] diamond 267 43.1 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32278055 32278055 PRJEB2925_P_NODE_15279_length_258_cov_1.031390_g14001_i0 PRJEB2925 15279 258 1.03139 2.6609862 Bacillota bacterium 1879010 Bacteria Bacteria 45.4 0.0049   NR MBS5047104.1 1879010 g14001 i0 43.5 0.720930232558139 62 35 72.1 0 35 220 147 208 MBS5047104.1 carbon starvation protein A [Bacillota bacterium] diamond 186 45.4 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
32745153 32745153 PRJEB2925_P_NODE_15200_length_259_cov_1.026786_g13922_i0 PRJEB2925 15200 259 1.026786 2.65937574 Blautia 572511 Bacteria Bacteria 118 7.95e-31   NR WP_022461311.1 186803 g13922 i0 98.2 1.27413127413127 55 1 63.7 0 257 93 177 231 WP_022461311.1 MULTISPECIES: anaerobic ribonucleoside-triphosphate reductase activating protein [Lachnospiraceae] diamond 330 119 0.991596638655462 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae    

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