RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA533623", tax_kingdom = "Pseudomonadati" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 22 ✖

tax_kingdom 1

  • Pseudomonadati · 22 ✖

bioproject 1

  • PRJNA533623 · 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
506826 506826 PRJNA533623_P_NODE_51041_length_289_cov_17.697368_g49262_i0 PRJNA533623 51041 289 17.697368 51.14539352 Bacteria 2 Bacteria Bacteria 129 1.73e-32   NR GAA8844942.1 210 g49262 i0 78.4 8.17993079584775 88 19 91.3 0 26 289 509 596 GAA8844942.1 selenocysteine-specific translation elongation factor [Helicobacter pylori] diamond 2364 130 0.992307692307692 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
507162 507162 PRJNA533623_P_NODE_67941_length_226_cov_6.369697_g66160_i0 PRJNA533623 67941 226 6.369697 14.39551522 Campylobacter ureolyticus 827 Bacteria Bacteria 357 3.81e-94   NTclustered gi|1829985141|gb|CP050963.1| 827 g66160 i0 98.515 3.57522123893805 202 3 89 0 5 206 465331 465532 Campylobacter ureolyticus strain FDAARGOS_673 chromosome blastn 808 357 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
3057826 3057826 PRJNA533623_P_NODE_58523_length_259_cov_10.166667_g56743_i0 PRJNA533623 58523 259 10.166667 26.33166753 Helicobacter typhlonius 76936 Bacteria Bacteria 451 1.99e-122   NTclustered gi|953940668|emb|LN907858.1| 76936 g56743 i0 99.2 0.965250965250965 250 2 97 0 1 250 1089063 1088814 Helicobacter typhlonius genome assembly htyphlonius_mit97-6810, chromosome : I blastn 250 451 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter typhlonius
9434399 9434399 PRJNA533623_P_NODE_22828_length_485_cov_5.040094_g21074_i0 PRJNA533623 22828 485 5.040094 24.4444559 Sulfurimonas sp. 2022749 Bacteria Bacteria 107 1.9599999999999994e-23   NR WP_295007451.1 2022749 g21074 i0 80.6 0.383505154639175 62 12 38.4 0 467 282 1158 1219 WP_295007451.1 type V CRISPR-associated protein Cas12a/Cpf1 [Sulfurimonas sp.] diamond 186 107 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas sp.
9435482 9435482 PRJNA533623_P_NODE_70568_length_218_cov_2.783439_g68787_i0 PRJNA533623 70568 218 2.783439 6.06789702 Campylobacter showae 204 Bacteria Bacteria 289 1.3499999999999998e-73   NTclustered gi|1483583495|emb|LT631419.1| 204 g68787 i0 93.333 15.7614678899083 195 13 89 0 1 195 120928 120734 Campylobacter showae genome assembly, chromosome: I blastn 3436 289 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
15809231 15809231 PRJNA533623_P_NODE_41793_length_334_cov_13.637363_g40019_i0 PRJNA533623 41793 334 13.637363 45.54879242 Helicobacter typhlonius 76936 Bacteria Bacteria 553 7.079999999999998e-153   NTclustered gi|953940668|emb|LN907858.1| 76936 g40019 i0 99.669 0.904191616766467 302 1 90 0 24 325 1129829 1130130 Helicobacter typhlonius genome assembly htyphlonius_mit97-6810, chromosome : I blastn 302 553 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter typhlonius
15809653 15809653 PRJNA533623_P_NODE_59993_length_254_cov_1.979275_g58213_i0 PRJNA533623 59993 254 1.979275 5.0273585 Arcobacter suis 1278212 Bacteria Bacteria 126 1.3399999999999999e-24   NTclustered gi|1474790806|gb|CP032100.1| 663365 g58213 i0 89.109 3.63779527559055 101 11 40 0 21 121 2487412 2487512 Arcobacter suis CECT 7833 chromosome, complete genome blastn 924 126 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter suis
17695726 17695726 PRJNA533623_P_NODE_26374_length_447_cov_14.018135_g24605_i0 PRJNA533623 26374 447 14.018135 62.66106345 Pseudomonadati 3379134 Bacteria Bacteria 743 0   NTclustered gi|1226876681|gb|CP022559.1| 197 g24605 i0 100 89.9328859060403 402 0 90 0 23 424 701325 701726 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 40200 743 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
17695994 17695994 PRJNA533623_P_NODE_58434_length_260_cov_1.306533_g56654_i0 PRJNA533623 58434 260 1.306533 3.3969858 Pseudomonadati 3379134 Bacteria Bacteria 429 9.37e-116   NTclustered gi|1226876681|gb|CP022559.1| 197 g56654 i0 100 89.2307692307692 232 0 89 0 13 244 701840 702071 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 23200 429 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
18969463 18969463 PRJNA533623_P_NODE_46295_length_311_cov_26.204000_g44517_i0 PRJNA533623 46295 311 26.204 81.49444 Campylobacter 194 Bacteria Bacteria 484 2.4199999999999994e-132   NTclustered gi|1207769205|gb|MF351718.1| 199 g44517 i0 98.897 193.543408360129 272 1 87 1 22 291 1582 1853 Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence blastn 60192 484 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
19632953 19632953 PRJNA533623_P_NODE_56056_length_269_cov_1.875000_g54276_i0 PRJNA533623 56056 269 1.875 5.04375 Campylobacter ureolyticus 827 Bacteria Bacteria 470 5.74e-128   NTclustered gi|909715533|gb|CP012195.1| 1032069 g54276 i0 99.231 1.93308550185874 260 2 97 0 10 269 1361060 1361319 Campylobacter ureolyticus RIGS 9880 chromosome, complete genome blastn 520 470 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
20909366 20909366 PRJNA533623_P_NODE_80017_length_185_cov_5.177419_g78236_i0 PRJNA533623 80017 185 5.177419 9.57822515 Helicobacter hepaticus 32025 Bacteria Bacteria 302 1.42e-77   NTclustered gi|32263428|gb|AE017125.1| 235279 g78236 i0 98.256 2.57297297297297 172 3 93 0 1 172 660896 661067 Helicobacter hepaticus ATCC 51449, complete genome blastn 476 302 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter hepaticus
21519985 21519985 PRJNA533623_P_NODE_44637_length_320_cov_1.606178_g42863_i0 PRJNA533623 44637 320 1.606178 5.1397696 root 1 Root_unresolved Root_unresolved 279 1.26e-70   NTclustered gi|1226876681|gb|CP022559.1| 197 g42863 i0 94.054 58.96875 185 10 58 1 1 185 699760 699577 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 18870 279 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
21520213 21520213 PRJNA533623_P_NODE_75397_length_206_cov_0.958621_g73616_i0 PRJNA533623 75397 206 0.958621 1.97475926 root 1 Root_unresolved Root_unresolved 204 4.7e-48   NTclustered gi|1226876681|gb|CP022559.1| 197 g73616 i0 84.466 101.601941747573 206 32 100 0 1 206 699491 699696 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 20930 204 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
24731986 24731986 PRJNA533623_P_NODE_21520_length_501_cov_5.134091_g19771_i0 PRJNA533623 21520 501 5.134091 25.72179591 Candidatus Campylobacter infans 2561898 Bacteria Bacteria 58.4 0.001   NTclustered gi|1870124224|gb|CP049075.1| 2561898 g19771 i0 92.5 0.0798403193612774 40 3 8 0 302 341 579436 579397 Candidatus Campylobacter infans strain 19S00001 chromosome, complete genome blastn 40 58.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Candidatus Campylobacter infans
26951054 26951054 PRJNA533623_P_NODE_77002_length_202_cov_15.475177_g75221_i0 PRJNA533623 77002 202 15.475177 31.25985754 Helicobacter pylori 210 Bacteria Bacteria 41.6 0.0168   NR GAA6800385.1 210 g75221 i0 100 0.252475247524752 17 0 25.2 0 190 140 1 17 GAA6800385.1 hypothetical protein Kyoto200A_2080 [Helicobacter pylori] diamond 51 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27267406 27267406 PRJNA533623_P_NODE_52623_length_283_cov_1.171171_g50844_i0 PRJNA533623 52623 283 1.171171 3.31441393 Helicobacter pylori 210 Bacteria Bacteria 52.4 9.84e-7   NR GAA8908381.1 210 g50844 i0 69.7 0.34982332155477 33 10 35 0 248 150 5 37 GAA8908381.1 hypothetical protein Kyoto166A_1430 [Helicobacter pylori] diamond 99 52.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27693253 27693253 PRJNA533623_P_NODE_74204_length_208_cov_4.428571_g72423_i0 PRJNA533623 74204 208 4.428571 9.21142768 Bacteria 2 Bacteria Bacteria 43.1 0.0154   NR GAA9247141.1 210 g72423 i0 85.7 0.605769230769231 21 3 30.3 0 182 120 1 21 GAA9247141.1 hypothetical protein Kyoto199A_1050 [Helicobacter pylori] diamond 126 43.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27772925 27772925 PRJNA533623_P_NODE_32984_length_390_cov_10.079027_g31213_i0 PRJNA533623 32984 390 10.079027 39.3082053 Desulfurellales bacterium 2482794 Bacteria Bacteria 61.2 6.78e-8   NR TXH46962.1 2482794 g31213 i0 33.3 0.807692307692308 105 61 80.8 1 379 65 640 735 TXH46962.1 MAG: hypothetical protein E6Q97_28150 [Desulfurellales bacterium] diamond 315 61.2 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
30077602 30077602 PRJNA533623_P_NODE_28352_length_428_cov_18.196185_g26582_i0 PRJNA533623 28352 428 18.196185 77.8796718 Campylobacterota bacterium 2026809 Bacteria Bacteria 127 4.42e-33   NR MEA1918718.1 2026809 g26582 i0 53.3 0.855140186915888 122 49 85.5 4 402 37 154 267 MEA1918718.1 aldo/keto reductase [Campylobacterota bacterium] diamond 366 127 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
31310000 31310000 PRJNA533623_P_NODE_25215_length_459_cov_2.587940_g23450_i0 PRJNA533623 25215 459 2.58794 11.8786446 Helicobacter pylori 210 Bacteria Bacteria 43.1 0.0392   NR GAA9106486.1 210 g23450 i0 97.4 0.503267973856209 77 2 50.3 0 458 228 4 80 GAA9106486.1 hypothetical protein Kyoto184A_09600 [Helicobacter pylori] diamond 231 43.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32322725 32322725 PRJNA533623_P_NODE_24339_length_468_cov_14.754300_g22578_i0 PRJNA533623 24339 468 14.7543 69.050124 Desulfurellales bacterium 2482794 Bacteria Bacteria 89 2.27e-19   NR TXH45790.1 2482794 g22578 i0 40.6 0.916666666666667 143 69 88.5 5 31 444 1 132 TXH45790.1 MAG: hypothetical protein E6Q97_30805 [Desulfurellales bacterium] diamond 429 89 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);;