RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA591127", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 19 ✖

tax_phylum 1

  • Campylobacterota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA591127 · 19 ✖

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
3116009 3116009 PRJNA591127_P_NODE_24303_length_172_cov_5.111111_g24134_i0 PRJNA591127 24303 172 5.111111 8.79111092 Campylobacter rectus 203 Bacteria Bacteria 318 1.2899999999999999e-82   NTclustered gi|1622745323|gb|CP012543.1| 203 g24134 i0 100 257.726744186047 172 0 100 0 1 172 161249 161078 Campylobacter rectus strain ATCC 33238, complete genome blastn 44329 318 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter rectus
13892730 13892730 PRJNA591127_P_NODE_1591_length_537_cov_52.966000_g1439_i0 PRJNA591127 1591 537 52.966 284.42742 Campylobacter 194 Bacteria Bacteria 948 0   NTclustered gi|1207769201|gb|MF351714.1| 199 g1439 i0 98.51 240.411545623836 537 8 100 0 1 537 1280 744 Campylobacter concisus strain H3O1 23S ribosomal RNA gene, partial sequence blastn 129101 948 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
13892994 13892994 PRJNA591127_P_NODE_9351_length_240_cov_8.226601_g9183_i0 PRJNA591127 9351 240 8.226601 19.7438424 Campylobacter 194 Bacteria Bacteria 433 6.599999999999997e-117   NTclustered gi|321530460|gb|HQ890330.1| 203 g9183 i0 99.167 110 240 2 100 0 1 240 1450 1211 Campylobacter rectus strain PW1491 16S ribosomal RNA gene, partial sequence blastn 26400 433 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter rectus
14593912 14593912 PRJNA591127_P_NODE_2472_length_449_cov_4.400485_g2306_i0 PRJNA591127 2472 449 4.400485 19.75817765 Campylobacter gracilis 824 Bacteria Bacteria 730 0   NTclustered gi|909717139|gb|CP012196.1| 824 g2306 i0 96.009 249.507795100223 451 15 100 2 1 449 501681 502130 Campylobacter gracilis strain ATCC 33236, complete genome blastn 112029 730 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter gracilis
15166807 15166807 PRJNA591127_P_NODE_15692_length_197_cov_3.143750_g15523_i0 PRJNA591127 15692 197 3.14375 6.1931875 Aliarcobacter 2321111 Bacteria Bacteria 141 3.5400000000000003e-29   NTclustered gi|1898123824|gb|CP060693.1| 28198 g15523 i0 100 21.7106598984772 76 0 39 0 122 197 212115 212190 Aliarcobacter cryaerophilus strain 16CS1285-4 chromosome, complete genome blastn 4277 141 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
17716807 17716807 PRJNA591127_P_NODE_6474_length_289_cov_4.063492_g6306_i0 PRJNA591127 6474 289 4.063492 11.74349188 Arcobacter 28196 Bacteria Bacteria 496 1.03e-135   NTclustered gi|1847331607|gb|CP053835.1| 873191 g6306 i0 97.578 357.868512110727 289 7 100 0 1 289 1009845 1010133 Arcobacter defluvii strain LMG 25694 chromosome, complete genome blastn 103424 501 0.99001996007984 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter defluvii
18990022 18990022 PRJNA591127_P_NODE_11335_length_218_cov_11524.756906_g11166_i0 PRJNA591127 11335 218 11524.756906 25123.97005508 Campylobacter 194 Bacteria Bacteria 403 4.62e-108   NTclustered gi|1830377743|gb|MT323075.1| 203 g11166 i0 100 108 218 0 100 0 1 218 498 281 Campylobacter rectus strain KCOM 3166 (=JS273) 16S ribosomal RNA gene, partial sequence blastn 23544 403 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter rectus
18990292 18990292 PRJNA591127_P_NODE_6275_length_293_cov_63.375000_g6107_i0 PRJNA591127 6275 293 63.375 185.68875 Arcobacteraceae 2808963 Bacteria Bacteria 531 2.86e-146   NTclustered gi|1231709647|emb|LT906455.1| 28197 g6107 i0 99.32 399.464163822526 294 1 100 1 1 293 851032 850739 Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1 blastn 117043 536 0.990671641791045 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
20265202 20265202 PRJNA591127_P_NODE_14556_length_197_cov_4.100000_g14387_i0 PRJNA591127 14556 197 4.1 8.077 Aliarcobacter 2321111 Bacteria Bacteria 141 3.5400000000000003e-29   NTclustered gi|1817415496|gb|CP026656.1| 28198 g14387 i0 100 22.1522842639594 76 0 68 0 1 76 2167614 2167689 Aliarcobacter cryaerophilus strain M830MA chromosome, complete genome blastn 4364 141 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
20967261 20967261 PRJNA591127_P_NODE_2337_length_459_cov_4.021327_g2174_i0 PRJNA591127 2337 459 4.021327 18.45789093 Campylobacter rectus 203 Bacteria Bacteria 843 0   NTclustered gi|1622745323|gb|CP012543.1| 203 g2174 i0 99.782 250.309368191721 459 1 100 0 1 459 158289 157831 Campylobacter rectus strain ATCC 33238, complete genome blastn 114892 843 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter rectus
21540848 21540848 PRJNA591127_P_NODE_5957_length_300_cov_5.555133_g5789_i0 PRJNA591127 5957 300 5.555133 16.665399 Campylobacter 194 Bacteria Bacteria 527 3.799999999999999e-145   NTclustered gi|2305955962|gb|CP012549.1| 1660063 g5789 i0 98.333 229.153333333333 300 5 100 0 1 300 819708 820007 Campylobacter sp. RM16187, complete genome blastn 68746 527 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. RM16187
25364983 25364983 PRJNA591127_P_NODE_17100_length_197_cov_2.593750_g16931_i0 PRJNA591127 17100 197 2.59375 5.1096875 Aliarcobacter 2321111 Bacteria Bacteria 141 3.5400000000000003e-29   NTclustered gi|1817415496|gb|CP026656.1| 28198 g16931 i0 100 21.9187817258883 76 0 77 0 1 76 2143529 2143454 Aliarcobacter cryaerophilus strain M830MA chromosome, complete genome blastn 4318 141 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
26966553 26966553 PRJNA591127_P_NODE_31702_length_150_cov_3.477876_g31533_i0 PRJNA591127 31702 150 3.477876 5.216814 Bacteria 2 Bacteria Bacteria 48.1 1.33e-4   NR MDY0194001.1 28197 g31533 i0 65.5 1.86 29 10 58 0 1 87 299 327 MDY0194001.1 hypothetical protein [Aliarcobacter butzleri] diamond 279 48.5 0.991752577319588 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
27079694 27079694 PRJNA591127_P_NODE_15202_length_197_cov_3.456250_g15033_i0 PRJNA591127 15202 197 3.45625 6.8088125 Campylobacter jejuni 197 Bacteria Bacteria 50.4 1.19e-5   NR MBT0611151.1 197 g15033 i0 100 0.365482233502538 24 0 36.5 0 3 74 64 87 MBT0611151.1 hypothetical protein [Campylobacter jejuni] diamond 72 50.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
27332742 27332742 PRJNA591127_P_NODE_28783_length_151_cov_5.596491_g28614_i0 PRJNA591127 28783 151 5.596491 8.45070141 Aliarcobacter sp. 2321116 Bacteria Bacteria 86.3 4.31e-18   NR MDY0052110.1 2321116 g28614 i0 73.8 1.21192052980132 61 5 99.3 1 1 150 33 93 MDY0052110.1 hypothetical protein [Aliarcobacter sp.] diamond 183 86.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter sp.
27869229 27869229 PRJNA591127_P_NODE_9905_length_234_cov_1.802030_g9737_i0 PRJNA591127 9905 234 1.80203 4.2167502 Sulfurospirillum sp. 2053622 Bacteria Bacteria 65.1 7.4e-11   NR MBE0490916.1 2053622 g9737 i0 41.8 1.01282051282051 79 44 98.7 2 231 1 34 112 MBE0490916.1 lipocalin family protein [Sulfurospirillum sp.] diamond 237 65.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum sp.
28027346 28027346 PRJNA591127_P_NODE_10025_length_232_cov_3.994872_g9857_i0 PRJNA591127 10025 232 3.994872 9.26810304 Helicobacter pylori 210 Bacteria Bacteria 52.4 7.65e-7   NR GAA9176533.1 210 g9857 i0 55.4 0.724137931034483 56 24 72.4 1 228 61 1 55 GAA9176533.1 hypothetical protein Kyoto193A_0850 [Helicobacter pylori] diamond 168 52.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29921886 29921886 PRJNA591127_P_NODE_31211_length_150_cov_5.805310_g31042_i0 PRJNA591127 31211 150 5.80531 8.707965 Campylobacter sp. 205 Bacteria Bacteria 75.1 3.91e-14   NR MDY4860183.1 205 g31042 i0 60 14.2 65 10 98 1 148 2 32 96 MDY4860183.1 ABC transporter permease [Campylobacter sp.] diamond 2130 75.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp.
30237678 30237678 PRJNA591127_P_NODE_13552_length_199_cov_12.308642_g13383_i0 PRJNA591127 13552 199 12.308642 24.49419758 Helicobacter pylori 210 Bacteria Bacteria 65.5 3.05e-12   NR GAA9131729.1 210 g13383 i0 82.4 1.40201005025126 34 6 51.3 0 197 96 2 35 GAA9131729.1 hypothetical protein Kyoto190A_2250 [Helicobacter pylori] diamond 279 65.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori

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