RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA744060", 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 · 19 ✖

tax_kingdom 1

  • Pseudomonadati · 19 ✖

bioproject 1

  • PRJNA744060 · 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
3274592 3274592 PRJNA744060_P_NODE_29623_length_300_cov_2.370044_g29294_i0 PRJNA744060 29623 300 2.370044 7.110132 Malaciobacter halophilus 197482 Bacteria Bacteria 52.8 0.028   NTclustered gi|1435905597|gb|CP031218.1| 197482 g29294 i0 100 0.0933333333333333 28 0 9 0 241 268 1117331 1117358 Malaciobacter halophilus strain CCUG 53805 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Malaciobacter Malaciobacter halophilus
10127172 10127172 PRJNA744060_P_NODE_29828_length_299_cov_2.561947_g29499_i0 PRJNA744060 29828 299 2.561947 7.66022153 Campylobacter 194 Bacteria Bacteria 189 2.0299999999999993e-43   NTclustered gi|1733427401|gb|CP043426.1| 488545 g29499 i0 79.771 80.819397993311 262 51 87 2 23 283 168309 168569 Campylobacter lari subsp. concheus strain LMG 21009 chromosome, complete genome blastn 24165 189 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter lari
13477022 13477022 PRJNA744060_P_NODE_27571_length_310_cov_2.616034_g27242_i0 PRJNA744060 27571 310 2.616034 8.1097054 Candidatus Sulfurimonas marisnigri 2740405 Bacteria Bacteria 80.5 1.33e-10   NTclustered gi|1929274859|gb|CP054493.1| 2740405 g27242 i0 100 1.8 43 0 18 0 147 189 1752065 1752023 Candidatus Sulfurimonas marisnigri strain SoZ1 chromosome, complete genome blastn 558 80.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Candidatus Sulfurimonas marisnigri
14752134 14752134 PRJNA744060_P_NODE_27572_length_310_cov_2.603376_g27243_i0 PRJNA744060 27572 310 2.603376 8.0704656 Campylobacteraceae bacterium 2268179 Bacteria Bacteria 102 1.16e-23   NR MDR1975662.1 2268179 g27243 i0 69.4 3.39677419354839 72 22 69.7 0 94 309 3 74 MDR1975662.1 J domain-containing protein [Campylobacteraceae bacterium] diamond 1053 102 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae   Campylobacteraceae bacterium
26957624 26957624 PRJNA744060_P_NODE_51422_length_242_cov_0.923077_g51093_i0 PRJNA744060 51422 242 0.923077 2.23384634 Arcobacter sp. 15-2 3374109 Bacteria Bacteria 53.9 4.19e-6   NR WP_412726947.1 3374109 g51093 i0 48.6 0.892561983471074 72 37 89.3 0 5 220 518 589 WP_412726947.1 molecular chaperone DnaK [Arcobacter sp. 15-2] diamond 216 53.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter sp. 15-2
27052772 27052772 PRJNA744060_P_NODE_20802_length_354_cov_5.377224_g20473_i0 PRJNA744060 20802 354 5.377224 19.03537296 uncultured Campylobacter sp. 218934 Bacteria Bacteria 45.1 0.00762   NR WP_299040690.1 218934 g20473 i0 67.9 0.457627118644068 28 9 23.7 0 2 85 1 28 WP_299040690.1 BspA family leucine-rich repeat surface protein [uncultured Campylobacter sp.] diamond 162 45.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
27526610 27526610 PRJNA744060_P_NODE_15183_length_412_cov_2.542773_g14854_i0 PRJNA744060 15183 412 2.542773 10.47622476 Campylobacteraceae bacterium 2268179 Bacteria Bacteria 102 4.63e-22   NR MBT5324067.1 2268179 g14854 i0 40.6 0.932038834951456 128 66 87.4 2 2 361 911 1036 MBT5324067.1 hypothetical protein [Campylobacteraceae bacterium] diamond 384 102 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae   Campylobacteraceae bacterium
27726511 27726511 PRJNA744060_P_NODE_55524_length_197_cov_4.733871_g55195_i0 PRJNA744060 55524 197 4.733871 9.32572587 Pseudomonadati 3379134 Bacteria Bacteria 43.5 0.00334   NR AOO65847.1 1193502 g55195 i0 64.3 0.852791878172589 28 10 42.6 0 24 107 78 105 AOO65847.1 putative lipoprotein [Sulfurospirillum halorespirans DSM 13726] diamond 168 43.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum halorespirans
28189444 28189444 PRJNA744060_P_NODE_15506_length_408_cov_2.752239_g15177_i0 PRJNA744060 15506 408 2.752239 11.22913512 Campylobacterota bacterium 2026809 Bacteria Bacteria 48.5 0.00212   NR MCL4431195.1 2026809 g15177 i0 37 1.57352941176471 92 54 66.9 3 99 371 924 1012 MCL4431195.1 reverse transcriptase domain-containing protein [Campylobacterota bacterium] diamond 642 48.5 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
28221156 28221156 PRJNA744060_P_NODE_8066_length_561_cov_3.026639_g7741_i0 PRJNA744060 8066 561 3.026639 16.97944479 Campylobacterota bacterium 2026809 Bacteria Bacteria 54.3 7.79e-5   NR MCL4431195.1 2026809 g7741 i0 33.8 0.711229946524064 133 82 70.6 4 27 422 923 1050 MCL4431195.1 reverse transcriptase domain-containing protein [Campylobacterota bacterium] diamond 399 54.3 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
28252800 28252800 PRJNA744060_P_NODE_34086_length_282_cov_1.990431_g33757_i0 PRJNA744060 34086 282 1.990431 5.61301542 Campylobacter coli 195 Bacteria Bacteria 43.9 0.0165   NR ELT8453928.1 195 g33757 i0 69.2 0.276595744680851 26 8 27.7 0 3 80 5 30 ELT8453928.1 DUF285 domain-containing protein [Campylobacter coli] diamond 78 43.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
28284228 28284228 PRJNA744060_P_NODE_36926_length_272_cov_3.678392_g36597_i0 PRJNA744060 36926 272 3.678392 10.00522624 Sulfurimonas hongkongensis 1172190 Bacteria Bacteria 50.4 9.08e-5   NR WP_021287763.1 1172190 g36597 i0 30.7 1.94117647058824 88 61 97.1 0 266 3 140 227 WP_021287763.1 ADP-ribosylglycohydrolase family protein [Sulfurimonas hongkongensis] diamond 528 50.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas hongkongensis
28789401 28789401 PRJNA744060_P_NODE_1087_length_1317_cov_8.098071_g948_i0 PRJNA744060 1087 1317 8.098071 106.65159507 Campylobacterota bacterium 2026809 Bacteria Bacteria 150 5.06e-35   NR MCL4431195.1 2026809 g948 i0 30.7 0.920273348519362 404 235 85.2 16 135 1256 321 709 MCL4431195.1 reverse transcriptase domain-containing protein [Campylobacterota bacterium] diamond 1212 150 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
30842687 30842687 PRJNA744060_P_NODE_37894_length_269_cov_2.627551_g37565_i0 PRJNA744060 37894 269 2.627551 7.06811219 Campylobacter jejuni 197 Bacteria Bacteria 42.4 0.043   NR ECP7254359.1 197 g37565 i0 64.3 0.602230483271376 28 10 31.2 0 4 87 1 28 ECP7254359.1 BspA family leucine-rich repeat surface protein [Campylobacter jejuni] diamond 162 42.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
30969114 30969114 PRJNA744060_P_NODE_10954_length_484_cov_2.267640_g10626_i0 PRJNA744060 10954 484 2.26764 10.9753776 Campylobacterota bacterium 2026809 Bacteria Bacteria 58.5 9.87e-7   NR MCL4431196.1 2026809 g10626 i0 36.8 0.471074380165289 76 47 47.1 1 230 3 2 76 MCL4431196.1 hypothetical protein [Campylobacterota bacterium] diamond 228 58.5 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
30979146 30979146 PRJNA744060_P_NODE_34134_length_282_cov_1.492823_g33805_i0 PRJNA744060 34134 282 1.492823 4.20976086 Campylobacter 194 Bacteria Bacteria 43.5 0.0114   NR EHN6916219.1 197 g33805 i0 70.8 0.531914893617021 24 7 25.5 0 280 209 48 71 EHN6916219.1 BspA family leucine-rich repeat surface protein [Campylobacter jejuni] diamond 150 43.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
31136639 31136639 PRJNA744060_P_NODE_39195_length_265_cov_2.239583_g38866_i0 PRJNA744060 39195 265 2.239583 5.93489495 Pseudomonadati 3379134 Bacteria Bacteria 55.1 3.16e-7   NR MRI58576.1 2026809 g38866 i0 62 1.67547169811321 50 18 56.6 1 264 115 61 109 MRI58576.1 deaminase [Campylobacterota bacterium] diamond 444 55.1 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
31474930 31474930 PRJNA744060_P_NODE_49796_length_244_cov_0.912281_g49467_i0 PRJNA744060 49796 244 0.912281 2.22596564 Thiovulum sp. ES 1177931 Bacteria Bacteria 63.5 9.54e-10   NR EJF07359.1 1177931 g49467 i0 48.4 5.16393442622951 64 32 77.5 1 220 32 182 245 EJF07359.1 carbonic anhydrase [Thiovulum sp. ES] diamond 1260 63.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Thiovulum Thiovulum sp. ES
32519078 32519078 PRJNA744060_P_NODE_44679_length_252_cov_0.871508_g44350_i0 PRJNA744060 44679 252 0.871508 2.19620016 Helicobacter japonicus 425400 Bacteria Bacteria 42.7 0.0405   NR WP_276897614.1 425400 g44350 i0 65.5 0.654761904761905 29 10 34.5 0 3 89 296 324 WP_276897614.1 BspA family leucine-rich repeat surface protein [Helicobacter japonicus] diamond 165 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter japonicus

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