RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 11 ✖

bioproject 1

  • PRJNA414225 · 11 ✖

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
24034836 24034836 PRJNA414225_P_NODE_30519_length_178_cov_2.046512_g30432_i0 PRJNA414225 30519 178 2.046512 3.64279136 Bacteria 2 Bacteria Bacteria 329 6.21e-86   NTclustered gi|2562786027|gb|CP120256.1| 197 g30432 i0 100 101 178 0 100 0 1 178 1303026 1302849 Campylobacter jejuni strain PS_41_2021 chromosome, complete genome blastn 17978 329 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
27661007 27661007 PRJNA414225_P_NODE_9044_length_215_cov_1.638554_g8957_i0 PRJNA414225 9044 215 1.638554 3.5228911 Pseudomonadati 3379134 Bacteria Bacteria 75.9 3.24e-16   NR GAA9038100.1 210 g8957 i0 77.1 1.46511627906977 48 10 65.6 1 21 161 1 48 GAA9038100.1 hypothetical protein Kyoto184A_01000 [Helicobacter pylori] diamond 315 75.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28560001 28560001 PRJNA414225_P_NODE_44627_length_168_cov_2.218487_g44540_i0 PRJNA414225 44627 168 2.218487 3.72705816 Helicobacter pylori 210 Bacteria Bacteria 39.7 0.0362   NR GAA6966648.1 210 g44540 i0 58.8 0.607142857142857 34 11 55.4 1 165 73 7 40 GAA6966648.1 hypothetical protein Kyoto211A_2720 [Helicobacter pylori] diamond 102 39.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28717834 28717834 PRJNA414225_P_NODE_20027_length_187_cov_1.478261_g19940_i0 PRJNA414225 20027 187 1.478261 2.76434807 Helicobacter pylori 210 Bacteria Bacteria 45.1 1.61e-4   NR GAA9037979.1 210 g19940 i0 62.5 0.513368983957219 32 12 51.3 0 17 112 6 37 GAA9037979.1 hypothetical protein Kyoto184A_00910 [Helicobacter pylori] diamond 96 45.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28906946 28906946 PRJNA414225_P_NODE_4888_length_244_cov_1.379487_g4801_i0 PRJNA414225 4888 244 1.379487 3.36594828 Helicobacter pylori 210 Bacteria Bacteria 42.7 0.00263   NR GAA6916578.1 210 g4801 i0 67.9 0.344262295081967 28 9 34.4 0 243 160 2 29 GAA6916578.1 hypothetical protein Kyoto207A_3550 [Helicobacter pylori] diamond 84 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28970393 28970393 PRJNA414225_P_NODE_90108_length_159_cov_2.781818_g90021_i0 PRJNA414225 90108 159 2.781818 4.42309062 Helicobacter pylori 210 Bacteria Bacteria 53.1 1.85e-7   NR GAA8948737.1 210 g90021 i0 75.8 1.28301886792453 33 7 60.4 1 31 126 1 33 GAA8948737.1 hypothetical protein Kyoto181A_0640 [Helicobacter pylori] diamond 204 53.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29380790 29380790 PRJNA414225_P_NODE_3389_length_265_cov_0.962963_g3302_i0 PRJNA414225 3389 265 0.962963 2.55185195 Helicobacter pylori 210 Bacteria Bacteria 72 1.18e-14   NR GAA9176259.1 210 g3302 i0 76.6 1.05283018867925 47 8 50.9 3 20 154 4 49 GAA9176259.1 hypothetical protein Kyoto193A_0410 [Helicobacter pylori] diamond 279 72 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29443696 29443696 PRJNA414225_P_NODE_18570_length_188_cov_2.215827_g18483_i0 PRJNA414225 18570 188 2.215827 4.16575476 Helicobacter pylori 210 Bacteria Bacteria 56.6 7.26e-9   NR GAA6899098.1 210 g18483 i0 69.7 1.08510638297872 33 10 52.7 0 90 188 4 36 GAA6899098.1 hypothetical protein Kyoto207A_0760 [Helicobacter pylori] diamond 204 56.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29570125 29570125 PRJNA414225_P_NODE_45810_length_168_cov_1.369748_g45723_i0 PRJNA414225 45810 168 1.369748 2.30117664 Helicobacter pylori 210 Bacteria Bacteria 72.8 5.55e-15   NR GAA6912895.1 210 g45723 i0 79.7 3.16071428571429 59 9 100 2 168 1 2 60 GAA6912895.1 hypothetical protein Kyoto207A_3080 [Helicobacter pylori] diamond 531 72.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30517904 30517904 PRJNA414225_P_NODE_80673_length_163_cov_0.894737_g80586_i0 PRJNA414225 80673 163 0.894737 1.45842131 Helicobacter pylori 210 Bacteria Bacteria 50.1 3.3e-6   NR GAA8733134.1 210 g80586 i0 73.5 0.625766871165644 34 7 62.6 1 163 62 10 41 GAA8733134.1 hypothetical protein Kyoto147A_1050 [Helicobacter pylori] diamond 102 50.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32098670 32098670 PRJNA414225_P_NODE_18058_length_189_cov_1.457143_g17971_i0 PRJNA414225 18058 189 1.457143 2.75400027 Helicobacter pylori 210 Bacteria Bacteria 61.2 1.79e-10   NR GAA8948737.1 210 g17971 i0 57.9 1.66666666666667 57 22 88.9 2 19 186 1 56 GAA8948737.1 hypothetical protein Kyoto181A_0640 [Helicobacter pylori] diamond 315 61.2 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);;