RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA312615" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA312615 · 17 ✖

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
13817666 13817666 PRJNA312615_P_NODE_8871_length_414_cov_2.306849_g8721_i0 PRJNA312615 8871 414 2.306849 9.55035486 Pseudomonadati 3379134 Bacteria Bacteria 765 0   NTclustered gi|972494020|gb|CP010483.1| 197 g8721 i0 100 81.8864734299517 414 0 100 0 1 414 1633570 1633157 Campylobacter jejuni strain CJ677CC535, complete genome blastn 33901 765 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
18229366 18229366 PRJNA312615_P_NODE_10115_length_389_cov_10.558824_g9965_i0 PRJNA312615 10115 389 10.558824 41.07382536 Helicobacter pylori 210 Bacteria Bacteria 66.6 3.3e-11   NR GAA6899797.1 210 g9965 i0 64.8 0.416452442159383 54 19 41.6 0 2 163 64 117 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 162 66.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28558747 28558747 PRJNA312615_P_NODE_50767_length_168_cov_0.857143_g50616_i0 PRJNA312615 50767 168 0.857143 1.44000024 Helicobacter pylori 210 Bacteria Bacteria 48.9 1.69e-5   NR GAA8778224.1 210 g50616 i0 62.5 1.26785714285714 40 15 71.4 0 158 39 41 80 GAA8778224.1 hypothetical protein BTM122_15710 [Helicobacter pylori] diamond 213 48.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28937570 28937570 PRJNA312615_P_NODE_21568_length_262_cov_2.469484_g21417_i0 PRJNA312615 21568 262 2.469484 6.47004808 Helicobacter pylori 210 Bacteria Bacteria 44.3 9e-4   NR GAA6795260.1 210 g21417 i0 79.2 0.274809160305344 24 5 27.5 0 168 239 12 35 GAA6795260.1 hypothetical protein Kyoto200A_0190 [Helicobacter pylori] diamond 72 44.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29631799 29631799 PRJNA312615_P_NODE_37810_length_200_cov_0.801325_g37659_i0 PRJNA312615 37810 200 0.801325 1.60265 Helicobacter pylori 210 Bacteria Bacteria 41.6 0.00765   NR GAA8688029.1 210 g37659 i0 65.7 0.525 35 10 49.5 1 154 56 1 35 GAA8688029.1 hypothetical protein Kyoto145A_1790 [Helicobacter pylori] diamond 105 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30042630 30042630 PRJNA312615_P_NODE_31231_length_219_cov_1.082353_g31080_i0 PRJNA312615 31231 219 1.082353 2.37035307 Helicobacter pylori 210 Bacteria Bacteria 51.2 2.26e-6   NR GAA6981306.1 210 g31080 i0 46.7 0.821917808219178 60 32 82.2 0 1 180 4 63 GAA6981306.1 hypothetical protein Kyoto211A_3600 [Helicobacter pylori] diamond 180 51.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30168843 30168843 PRJNA312615_P_NODE_46132_length_179_cov_0.946154_g45981_i0 PRJNA312615 46132 179 0.946154 1.69361566 Helicobacter pylori 210 Bacteria Bacteria 44.7 2.24e-4   NR GAA6795719.1 210 g45981 i0 53.1 0.536312849162011 32 15 53.6 0 84 179 1 32 GAA6795719.1 hypothetical protein Kyoto200A_0590 [Helicobacter pylori] diamond 96 44.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30913465 30913465 PRJNA312615_P_NODE_57094_length_163_cov_0.868421_g56943_i0 PRJNA312615 57094 163 0.868421 1.41552623 Pseudomonadati 3379134 Bacteria Bacteria 50.1 1.29e-6   NR GAA8908969.1 210 g56943 i0 65.7 1.84049079754601 35 12 64.4 0 156 52 8 42 GAA8908969.1 hypothetical protein Kyoto166A_1580 [Helicobacter pylori] diamond 300 50.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31022165 31022165 PRJNA312615_P_NODE_1675_length_824_cov_3.054194_g1560_i0 PRJNA312615 1675 824 3.054194 25.16655856 Helicobacter pylori 210 Bacteria Bacteria 78.2 3.5e-14   NR GAA6899797.1 210 g1560 i0 55.7 0.254854368932039 70 31 25.5 0 319 528 27 96 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 210 78.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31179783 31179783 PRJNA312615_P_NODE_39175_length_196_cov_1.231293_g39024_i0 PRJNA312615 39175 196 1.231293 2.41333428 Helicobacter pylori 210 Bacteria Bacteria 53.9 2.79e-7   NR GAA9037147.1 210 g39024 i0 65.9 2.02040816326531 44 15 67.3 0 196 65 8 51 GAA9037147.1 hypothetical protein Kyoto184A_00210 [Helicobacter pylori] diamond 396 53.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31243286 31243286 PRJNA312615_P_NODE_54555_length_165_cov_0.862069_g54404_i0 PRJNA312615 54555 165 0.862069 1.42241385 Helicobacter pylori 210 Bacteria Bacteria 39.7 0.0473   NR GAA9125671.1 210 g54404 i0 70.8 0.436363636363636 24 7 43.6 0 8 79 17 40 GAA9125671.1 hypothetical protein Kyoto190A_0950 [Helicobacter pylori] diamond 72 39.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31370095 31370095 PRJNA312615_P_NODE_29896_length_224_cov_0.874286_g29745_i0 PRJNA312615 29896 224 0.874286 1.95840064 Campylobacter jejuni 197 Bacteria Bacteria 75.5 5.9e-16   NR WP_214283297.1 197 g29745 i0 73.5 0.65625 49 13 65.6 0 3 149 21 69 WP_214283297.1 hypothetical protein, partial [Campylobacter jejuni] diamond 147 75.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
31766909 31766909 PRJNA312615_P_NODE_14317_length_325_cov_1.108696_g14166_i0 PRJNA312615 14317 325 1.108696 3.603262 Bacteria 2 Bacteria Bacteria 132 1.89e-35   NR WP_227574815.1 195 g14166 i0 61.3 23.4461538461538 106 41 97.8 0 8 325 98 203 WP_227574815.1 AAA family ATPase, partial [Campylobacter coli] diamond 7620 132 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
31907551 31907551 PRJNA312615_P_NODE_25377_length_243_cov_0.969072_g25226_i0 PRJNA312615 25377 243 0.969072 2.35484496 Helicobacter pylori 210 Bacteria Bacteria 44.7 8.24e-4   NR GAA8685368.1 210 g25226 i0 42.4 0.728395061728395 59 34 72.8 0 187 11 11 69 GAA8685368.1 hypothetical protein Kyoto145A_1250 [Helicobacter pylori] diamond 177 44.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31939095 31939095 PRJNA312615_P_NODE_54357_length_165_cov_0.879310_g54206_i0 PRJNA312615 54357 165 0.87931 1.4508615 Campylobacter jejuni 197 Bacteria Bacteria 65.5 2.19e-12   NR MDN2757921.1 197 g54206 i0 71.4 0.890909090909091 49 13 87.3 1 22 165 1 49 MDN2757921.1 hypothetical protein [Campylobacter jejuni] diamond 147 65.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
32256015 32256015 PRJNA312615_P_NODE_4398_length_567_cov_3.816602_g4255_i0 PRJNA312615 4398 567 3.816602 21.64013334 Helicobacter pylori 210 Bacteria Bacteria 94 4.46e-21   NR GAA6899797.1 210 g4255 i0 57.3 0.470899470899471 89 38 47.1 0 75 341 27 115 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 267 94 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32382231 32382231 PRJNA312615_P_NODE_18699_length_282_cov_1.489270_g18548_i0 PRJNA312615 18699 282 1.48927 4.1997414 Helicobacter pylori 210 Bacteria Bacteria 101 2.36e-24   NR GAB0054170.1 210 g18548 i0 57 8.23404255319149 86 37 91.5 0 1 258 32 117 GAB0054170.1 hypothetical protein YGH029_14930 [Helicobacter pylori] diamond 2322 102 0.990196078431373 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);;