RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA488043 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
450070 450070 PRJNA488043_P_NODE_7621_length_434_cov_2.123457_g5459_i0 PRJNA488043 7621 434 2.123457 9.21580338 Campylobacterota bacterium 2026809 Bacteria Bacteria 196 4.65e-60   NR MDQ1245098.1 2026809 g5459 i0 100 0.67741935483871 98 0 67.7 0 294 1 1 98 MDQ1245098.1 3(or 17)beta-hydroxysteroid dehydrogenase [Campylobacterota bacterium] diamond 294 196 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
26855074 26855074 PRJNA488043_P_NODE_21101_length_161_cov_4.000000_g18859_i0 PRJNA488043 21101 161 4 6.44 Helicobacter pylori 210 Bacteria Bacteria 42.4 0.0028   NR GAA9243766.1 210 g18859 i0 72 0.46583850931677 25 7 46.6 0 81 155 2 26 GAA9243766.1 hypothetical protein Kyoto198A_5880 [Helicobacter pylori] diamond 75 42.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26997310 26997310 PRJNA488043_P_NODE_19882_length_173_cov_1.715278_g17640_i0 PRJNA488043 19882 173 1.715278 2.96743094 Pseudomonadati 3379134 Bacteria Bacteria 115 1.12e-31   NR MCH3755945.1 195 g17640 i0 100 2.96531791907514 57 0 98.8 0 1 171 16 72 MCH3755945.1 CYTH domain-containing protein [Campylobacter coli] diamond 513 115 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
27392543 27392543 PRJNA488043_P_NODE_16623_length_206_cov_181.581921_g14381_i0 PRJNA488043 16623 206 181.581921 374.05875726 Helicobacter pylori 210 Bacteria Bacteria 40.8 0.0204   NR GAA6820949.1 210 g14381 i0 56.4 0.567961165048544 39 12 49.5 1 68 169 2 40 GAA6820949.1 hypothetical protein Kyoto200A_3790 [Helicobacter pylori] diamond 117 40.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27424214 27424214 PRJNA488043_P_NODE_19683_length_175_cov_1.931507_g17441_i0 PRJNA488043 19683 175 1.931507 3.38013725 Campylobacterota bacterium 2026809 Bacteria Bacteria 118 4e-29   NR MDQ1245100.1 2026809 g17441 i0 98.2 0.977142857142857 57 1 97.7 0 3 173 543 599 MDQ1245100.1 hypothetical protein [Campylobacterota bacterium] diamond 171 118 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
27550157 27550157 PRJNA488043_P_NODE_15564_length_219_cov_213.936842_g13322_i0 PRJNA488043 15564 219 213.936842 468.52168398 Helicobacter pylori 210 Bacteria Bacteria 70.5 2.7e-14   NR GAA9176259.1 210 g13322 i0 68.2 0.602739726027397 44 13 58.9 1 219 91 6 49 GAA9176259.1 hypothetical protein Kyoto193A_0410 [Helicobacter pylori] diamond 132 70.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28150335 28150335 PRJNA488043_P_NODE_16725_length_205_cov_75.028409_g14483_i0 PRJNA488043 16725 205 75.028409 153.80823845 Helicobacter pylori 210 Bacteria Bacteria 46.2 1.9e-4   NR GAA9030935.1 210 g14483 i0 100 0.278048780487805 19 0 27.8 0 186 130 1 19 GAA9030935.1 hypothetical protein Kyoto181A_8700 [Helicobacter pylori] diamond 57 46.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28276342 28276342 PRJNA488043_P_NODE_3626_length_753_cov_2.671271_g1993_i1 PRJNA488043 3626 753 2.671271 20.11467063 Helicobacter pylori 210 Bacteria Bacteria 156 2.62e-45   NR WP_316479292.1 210 g1993 i1 97.4 0.310756972111554 78 2 31.1 0 700 467 1 78 WP_316479292.1 hypothetical protein, partial [Helicobacter pylori] diamond 234 156 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28623990 28623990 PRJNA488043_P_NODE_13967_length_243_cov_369.757009_g11725_i0 PRJNA488043 13967 243 369.757009 898.50953187 Helicobacter pylori 210 Bacteria Bacteria 88.6 3.34e-21   NR GAA6899098.1 210 g11725 i0 93.5 0.765432098765432 62 4 76.5 0 242 57 1 62 GAA6899098.1 hypothetical protein Kyoto207A_0760 [Helicobacter pylori] diamond 186 88.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28655443 28655443 PRJNA488043_P_NODE_10907_length_311_cov_5.053191_g8666_i0 PRJNA488043 10907 311 5.053191 15.71542401 Helicobacter pylori 210 Bacteria Bacteria 48.1 4.63e-5   NR GAA8766134.1 210 g8666 i0 95.2 0.202572347266881 21 1 20.3 0 168 106 1 21 GAA8766134.1 hypothetical protein Kyoto147A_4290 [Helicobacter pylori] diamond 63 48.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28718587 28718587 PRJNA488043_P_NODE_12387_length_275_cov_1.430894_g10146_i0 PRJNA488043 12387 275 1.430894 3.9349585 Campylobacterota bacterium 2026809 Bacteria Bacteria 104 5.09e-25   NR MDQ1245098.1 2026809 g10146 i0 100 0.534545454545455 49 0 53.5 0 1 147 192 240 MDQ1245098.1 3(or 17)beta-hydroxysteroid dehydrogenase [Campylobacterota bacterium] diamond 147 104 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
28750115 28750115 PRJNA488043_P_NODE_15387_length_222_cov_2.207254_g13145_i0 PRJNA488043 15387 222 2.207254 4.90010388 Desulfurellales bacterium 2482794 Bacteria Bacteria 44.7 0.00312   NR TXH42837.1 2482794 g13145 i0 51.3 0.527027027027027 39 18 52.7 1 99 215 1 38 TXH42837.1 MAG: hypothetical protein E6Q97_35100 [Desulfurellales bacterium] diamond 117 44.7 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
29129216 29129216 PRJNA488043_P_NODE_7149_length_457_cov_2.343458_g5019_i0 PRJNA488043 7149 457 2.343458 10.70960306 Helicobacter pylori 210 Bacteria Bacteria 70.5 5.4e-13   NR WP_316458330.1 210 g5019 i0 77.6 0.38074398249453 58 1 38.1 1 407 234 1 46 WP_316458330.1 hypothetical protein, partial [Helicobacter pylori] diamond 174 70.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29665373 29665373 PRJNA488043_P_NODE_9710_length_350_cov_1.897196_g7474_i0 PRJNA488043 9710 350 1.897196 6.640186 Desulfurellales bacterium 2482794 Bacteria Bacteria 83.2 2e-16   NR TXH55603.1 2482794 g7474 i0 64.1 0.548571428571429 64 22 54.9 1 2 193 136 198 TXH55603.1 MAG: hypothetical protein E6Q97_08520 [Desulfurellales bacterium] diamond 192 83.2 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
29760302 29760302 PRJNA488043_P_NODE_1051_length_1724_cov_2.938053_g375_i0 PRJNA488043 1051 1724 2.938053 50.65203372 Helicobacter pylori 210 Bacteria Bacteria 155 6.39e-42   NR WP_316479312.1 210 g375 i0 97.3 0.12877030162413 74 2 12.9 0 989 1210 1 74 WP_316479312.1 hypothetical protein, partial [Helicobacter pylori] diamond 222 155 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29949993 29949993 PRJNA488043_P_NODE_20731_length_164_cov_23.066667_g18489_i0 PRJNA488043 20731 164 23.066667 37.82933388 Helicobacter pylori 210 Bacteria Bacteria 39.7 0.0245   NR GAA8930966.1 210 g18489 i0 66.7 0.439024390243902 24 8 43.9 0 19 90 8 31 GAA8930966.1 hypothetical protein Kyoto166A_4300 [Helicobacter pylori] diamond 72 39.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30044619 30044619 PRJNA488043_P_NODE_3611_length_756_cov_2.570839_g1993_i0 PRJNA488043 3611 756 2.570839 19.43554284 Helicobacter pylori 210 Bacteria Bacteria 126 1.55e-33   NR WP_316479292.1 210 g1993 i0 83.3 0.30952380952381 78 6 28.2 1 679 467 1 78 WP_316479292.1 hypothetical protein, partial [Helicobacter pylori] diamond 234 126 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30202498 30202498 PRJNA488043_P_NODE_8772_length_382_cov_1.796034_g6554_i0 PRJNA488043 8772 382 1.796034 6.86084988 Campylobacterota bacterium 2026809 Bacteria Bacteria 149 6.21e-39   NR MDQ1245100.1 2026809 g6554 i0 100 0.596858638743455 76 0 59.7 0 382 155 230 305 MDQ1245100.1 hypothetical protein [Campylobacterota bacterium] diamond 228 149 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
30392737 30392737 PRJNA488043_P_NODE_16053_length_213_cov_2.755435_g13811_i0 PRJNA488043 16053 213 2.755435 5.86907655 Desulfurellales bacterium 2482794 Bacteria Bacteria 114 4.08e-31   NR TXH46803.1 2482794 g13811 i0 91.7 0.845070422535211 60 5 84.5 0 34 213 1 60 TXH46803.1 MAG: hypothetical protein E6Q97_28645 [Desulfurellales bacterium] diamond 180 114 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
31466973 31466973 PRJNA488043_P_NODE_11176_length_303_cov_5.124088_g8935_i0 PRJNA488043 11176 303 5.124088 15.52598664 Helicobacter pylori 210 Bacteria Bacteria 47 1.2e-4   NR GAA8766134.1 210 g8935 i0 95 0.198019801980198 20 1 19.8 0 161 220 1 20 GAA8766134.1 hypothetical protein Kyoto147A_4290 [Helicobacter pylori] diamond 60 47 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31719833 31719833 PRJNA488043_P_NODE_13277_length_256_cov_1.506608_g11035_i0 PRJNA488043 13277 256 1.506608 3.85691648 Campylobacterota bacterium 2026809 Bacteria Bacteria 100 1.5100000000000001e-22   NR MDQ1245100.1 2026809 g11035 i0 100 0.59765625 51 0 59.8 0 102 254 1 51 MDQ1245100.1 hypothetical protein [Campylobacterota bacterium] diamond 153 100 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
32321291 32321291 PRJNA488043_P_NODE_16759_length_205_cov_2.318182_g14517_i0 PRJNA488043 16759 205 2.318182 4.7522731 Desulfurellales bacterium 2482794 Bacteria Bacteria 44.7 0.00259   NR TXH42837.1 2482794 g14517 i0 51.3 0.570731707317073 39 18 57.1 1 82 198 1 38 TXH42837.1 MAG: hypothetical protein E6Q97_35100 [Desulfurellales bacterium] diamond 117 44.7 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales 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);;