RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1144090" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1144090 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
26901415 26901415 PRJNA1144090_P_NODE_92621_length_260_cov_2.614973_g92086_i0 PRJNA1144090 92621 260 2.614973 6.7989298 Pseudomonadati 3379134 Bacteria Bacteria 52.8 1.26e-5   NR WP_300827129.1 209 g92086 i0 53.8 6.04615384615385 65 22 72.7 2 6 194 155 213 WP_300827129.1 MULTISPECIES: hypothetical protein [Helicobacter] diamond 1572 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter  
27070460 27070460 PRJNA1144090_P_NODE_5022_length_1272_cov_2.276063_g4738_i0 PRJNA1144090 5022 1272 2.276063 28.95152136 Campylobacterota bacterium 2026809 Bacteria Bacteria 52 0.00215   NR MEA2027678.1 2026809 g4738 i0 31.5 0.474056603773585 111 68 24.5 3 959 1270 18 127 MEA2027678.1 caspase family protein [Campylobacterota bacterium] diamond 603 52 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
28144605 28144605 PRJNA1144090_P_NODE_91085_length_263_cov_1.505263_g90550_i0 PRJNA1144090 91085 263 1.505263 3.95884169 Campylobacterota bacterium 2026809 Bacteria Bacteria 62.4 5.79e-9   NR MCB9492830.1 2026809 g90550 i0 44.9 0.889733840304182 78 31 89 2 236 3 813 878 MCB9492830.1 hypothetical protein [Campylobacterota bacterium] diamond 234 62.4 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
28365194 28365194 PRJNA1144090_P_NODE_6446_length_1126_cov_8.470085_g6116_i0 PRJNA1144090 6446 1126 8.470085 95.3731571 Campylobacterota bacterium 2026809 Bacteria Bacteria 161 1.9199999999999998e-42   NR MEA3353466.1 2026809 g6116 i0 33.9 0.967140319715808 363 176 93.5 16 1057 5 3 313 MEA3353466.1 DUF2235 domain-containing protein [Campylobacterota bacterium] diamond 1089 161 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
29627889 29627889 PRJNA1144090_P_NODE_71150_length_300_cov_1.321586_g70615_i0 PRJNA1144090 71150 300 1.321586 3.964758 Campylobacterota bacterium 2026809 Bacteria Bacteria 42.4 0.041   NR MDQ1339672.1 2026809 g70615 i0 42.1 0.57 57 30 57 1 182 12 16 69 MDQ1339672.1 hypothetical protein [Campylobacterota bacterium] diamond 171 42.4 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
30355369 30355369 PRJNA1144090_P_NODE_51312_length_356_cov_1.632509_g50777_i0 PRJNA1144090 51312 356 1.632509 5.81173204 Campylobacter coli 195 Bacteria Bacteria 130 1.01e-36   NR WP_402370336.1 195 g50777 i0 100 0.530898876404494 63 0 53.1 0 355 167 37 99 WP_402370336.1 hypothetical protein [Campylobacter coli] diamond 189 130 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
31144246 31144246 PRJNA1144090_P_NODE_108815_length_245_cov_1.581395_g108280_i0 PRJNA1144090 108815 245 1.581395 3.87441775 Campylobacter coli 195 Bacteria Bacteria 77.8 1.05e-16   NR WP_402370331.1 195 g108280 i0 100 0.46530612244898 38 0 46.5 0 131 244 1 38 WP_402370331.1 hypothetical protein [Campylobacter coli] diamond 114 77.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
31492782 31492782 PRJNA1144090_P_NODE_58556_length_332_cov_1.212355_g58021_i0 PRJNA1144090 58556 332 1.212355 4.0250186 Nitratifractor sp. 2268144 Bacteria Bacteria 44.3 0.00896   NR HGZ70199.1 2268144 g58021 i0 33.7 0.75 83 39 64.2 3 308 96 35 113 HGZ70199.1 hypothetical protein [Nitratifractor sp.] diamond 249 44.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Nitratifractor Nitratifractor sp.
31714042 31714042 PRJNA1144090_P_NODE_75157_length_291_cov_2.119266_g74622_i0 PRJNA1144090 75157 291 2.119266 6.16706406 Campylobacter coli 195 Bacteria Bacteria 197 3.99e-59   NR WP_402370334.1 195 g74622 i0 100 1 97 0 100 0 291 1 259 355 WP_402370334.1 protein rep [Campylobacter coli] diamond 291 197 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
31797624 31797624 PRJNA1144090_P_NODE_81517_length_279_cov_1.495146_g80982_i0 PRJNA1144090 81517 279 1.495146 4.17145734 Bacteria 2 Bacteria Bacteria 51.2 2.71e-6   NR GAA9125269.1 210 g80982 i0 69 2.53763440860215 29 9 31.2 0 271 185 4 32 GAA9125269.1 hypothetical protein Kyoto190A_0810 [Helicobacter pylori] diamond 708 51.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32882945 32882945 PRJNA1144090_P_NODE_53440_length_348_cov_2.240000_g52905_i0 PRJNA1144090 53440 348 2.24 7.7952 Helicobacter marmotae 152490 Bacteria Bacteria 48.5 0.00116   NR WP_104699558.1 152490 g52905 i0 31.6 0.681034482758621 79 52 68.1 1 2 238 192 268 WP_104699558.1 DNA polymerase I [Helicobacter marmotae] diamond 237 48.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter marmotae

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