RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1098727 · 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
26814597 26814597 PRJNA1098727_P_NODE_14001_length_166_cov_0.888889_g13760_i0 PRJNA1098727 14001 166 0.888889 1.47555574 Bacilli bacterium 1903720 Bacteria Bacteria 87.8 1.64e-18   NR MFR1524272.1 1903720 g13760 i0 100 0.795180722891566 44 0 79.5 0 3 134 464 507 MFR1524272.1 hypothetical protein [Bacilli bacterium] diamond 132 87.8 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
26909494 26909494 PRJNA1098727_P_NODE_10402_length_188_cov_1.482014_g10161_i0 PRJNA1098727 10402 188 1.482014 2.78618632 Roseburia sp. 2049040 Bacteria Bacteria 42.4 0.0243   NR MBD5553932.1 2049040 g10161 i0 31.7 0.957446808510638 60 38 91 1 187 17 98 157 MBD5553932.1 site-specific integrase [Roseburia sp.] diamond 180 42.4 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Roseburia Roseburia sp.
29688324 29688324 PRJNA1098727_P_NODE_7870_length_220_cov_1.216374_g7629_i0 PRJNA1098727 7870 220 1.216374 2.6760228 Bacilli bacterium 1903720 Bacteria Bacteria 44.7 0.00508   NR MEG1565409.1 1903720 g7629 i0 43.6 2.03181818181818 55 24 65.5 2 209 66 161 215 MEG1565409.1 HNH endonuclease signature motif containing protein [Bacilli bacterium] diamond 447 44.7 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
30880406 30880406 PRJNA1098727_P_NODE_14074_length_166_cov_0.888889_g13833_i0 PRJNA1098727 14074 166 0.888889 1.47555574 Clostridia 186801 Bacteria Bacteria 86.7 1.85e-18   NR MCI5504558.1 142586 g13833 i0 79.6 2.92771084337349 54 11 97.6 0 164 3 139 192 MCI5504558.1 LCP family protein [Eubacterium sp.] diamond 486 87 0.996551724137931 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium Eubacterium sp.
31426456 31426456 PRJNA1098727_P_NODE_13236_length_168_cov_0.873950_g12995_i0 PRJNA1098727 13236 168 0.87395 1.468236 Aedoeadaptatus urinae 1871017 Bacteria Bacteria 109 3.01e-26   NR WP_077074380.1 1871017 g12995 i0 94.5 1.96428571428571 55 3 98.2 0 167 3 119 173 WP_077074380.1 PucR family transcriptional regulator [Aedoeadaptatus urinae] diamond 330 109 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Aedoeadaptatus Aedoeadaptatus urinae
31900937 31900937 PRJNA1098727_P_NODE_4257_length_316_cov_3.303371_g4016_i0 PRJNA1098727 4257 316 3.303371 10.43865236 Priestia aryabhattai 412384 Bacteria Bacteria 43.1 0.018   NR WP_275211958.1 412384 g4016 i0 38.9 0.512658227848101 54 33 51.3 0 215 54 27 80 WP_275211958.1 DUF3992 domain-containing protein [Priestia aryabhattai] diamond 162 43.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Priestia Priestia aryabhattai
32185807 32185807 PRJNA1098727_P_NODE_14378_length_165_cov_0.896552_g14137_i0 PRJNA1098727 14378 165 0.896552 1.4793108 Neofamilia massiliensis 1673724 Bacteria Bacteria 57.8 6.33e-8   NR WP_054251319.1 1673724 g14137 i0 54 0.909090909090909 50 21 90.9 1 5 154 921 968 WP_054251319.1 InlB B-repeat-containing protein [Neofamilia massiliensis] diamond 150 57.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Neofamilia (nom. nud.) Neofamilia massiliensis
32848751 32848751 PRJNA1098727_P_NODE_10800_length_184_cov_1.540741_g10559_i0 PRJNA1098727 10800 184 1.540741 2.83496344 Anaerococcus provencensis 938293 Bacteria Bacteria 112 2.21e-27   NR WP_044565325.1 938293 g10559 i0 100 0.978260869565217 60 0 97.8 0 4 183 19 78 WP_044565325.1 GA module-containing protein [Anaerococcus provencensis] diamond 180 112 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus provencensis
32880237 32880237 PRJNA1098727_P_NODE_7040_length_234_cov_3.070270_g6799_i0 PRJNA1098727 7040 234 3.07027 7.1844318 Paenibacillus endoradicis 2972487 Bacteria Bacteria 43.9 0.0133   NR WP_258202998.1 2972487 g6799 i0 24.7 0.987179487179487 77 47 84.6 1 13 210 92 168 WP_258202998.1 glycoside hydrolase family 15 protein [Paenibacillus endoradicis] diamond 231 43.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus endoradicis

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