RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 14 ✖

bioproject 1

  • PRJNA1022392 · 14 ✖

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
1003737 1003737 PRJNA1022392_P_NODE_19341_length_243_cov_4.352041_g18672_i0 PRJNA1022392 19341 243 4.352041 10.57545963 root 1 Root_unresolved Root_unresolved 390 4.089999999999999e-104   NTclustered gi|1226876681|gb|CP022559.1| 197 g18672 i0 95.885 100 243 2 100 1 1 243 698252 698018 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 24300 390 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
10365223 10365223 PRJNA1022392_P_NODE_32409_length_206_cov_2.955975_g31740_i0 PRJNA1022392 32409 206 2.955975 6.0893085 Campylobacter ureolyticus 827 Bacteria Bacteria 182 2.2e-41   NTclustered gi|1829985141|gb|CP050963.1| 827 g31740 i0 100 5.02912621359223 98 0 95 0 109 206 780307 780210 Campylobacter ureolyticus strain FDAARGOS_673 chromosome blastn 1036 182 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
15464777 15464777 PRJNA1022392_P_NODE_33273_length_206_cov_2.767296_g32604_i0 PRJNA1022392 33273 206 2.767296 5.70062976 Campylobacter curvus 200 Bacteria Bacteria 143 1.04e-29   NTclustered gi|1861373391|gb|CP053826.1| 200 g32604 i0 92.857 0.951456310679612 98 7 48 0 1 98 1516493 1516396 Campylobacter curvus strain ATCC 35224 chromosome, complete genome blastn 196 143 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter curvus
17581826 17581826 PRJNA1022392_P_NODE_74914_length_161_cov_1.728070_g74245_i0 PRJNA1022392 74914 161 1.72807 2.7821927 Pseudomonadati 3379134 Bacteria Bacteria 292 7.24e-75   NTclustered gi|1226876681|gb|CP022559.1| 197 g74245 i0 99.379 100 161 1 100 0 1 161 701294 701134 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 16100 292 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
23114275 23114275 PRJNA1022392_P_NODE_30999_length_206_cov_3.320755_g30330_i0 PRJNA1022392 30999 206 3.320755 6.8407553 Helicobacter sp. MIT 99-55 218 Bacteria Bacteria 70.9 1.7e-13   NR WP_115583185.1 152489 g30330 i0 100 0.466019417475728 32 0 46.6 0 97 2 110 141 WP_115583185.1 rRNA maturation RNase YbeY [Helicobacter sp. MIT 99-5507] diamond 96 70.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter sp. MIT 99-5507
25230086 25230086 PRJNA1022392_P_NODE_46820_length_193_cov_4.698630_g46151_i0 PRJNA1022392 46820 193 4.69863 9.0683559 root 1 Root_unresolved Root_unresolved 259 9.13e-65   NTclustered gi|1226876681|gb|CP022559.1| 197 g46151 i0 90.187 111.989637305699 214 0 100 1 1 193 699056 698843 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 21614 259 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
27098165 27098165 PRJNA1022392_P_NODE_69382_length_165_cov_3.686441_g68713_i0 PRJNA1022392 69382 165 3.686441 6.08262765 Campylobacter ureolyticus 827 Bacteria Bacteria 99 2.0900000000000002e-22   NR WP_016647430.1 827 g68713 i0 98.2 1.98181818181818 55 1 100 0 165 1 816 870 WP_016647430.1 valine--tRNA ligase [Campylobacter ureolyticus] diamond 327 99 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
28511462 28511462 PRJNA1022392_P_NODE_62147_length_174_cov_3.259843_g61478_i0 PRJNA1022392 62147 174 3.259843 5.67212682 Pseudomonadati 3379134 Bacteria Bacteria 46.2 5.75e-5   NR GAA6795254.1 210 g61478 i0 65.5 1.44827586206897 29 10 50 0 172 86 4 32 GAA6795254.1 hypothetical protein Kyoto200A_0170 [Helicobacter pylori] diamond 252 46.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28519463 28519463 PRJNA1022392_P_NODE_45167_length_194_cov_4.489796_g44498_i0 PRJNA1022392 45167 194 4.489796 8.71020424 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 44.7 3.98e-4   NR HNW66573.1 28198 g44498 i0 64.3 0.881443298969072 28 10 43.3 0 2 85 35 62 HNW66573.1 hypothetical protein [Aliarcobacter cryaerophilus] diamond 171 44.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
29940383 29940383 PRJNA1022392_P_NODE_24091_length_214_cov_3.401198_g23422_i0 PRJNA1022392 24091 214 3.401198 7.27856372 Helicobacter pylori 210 Bacteria Bacteria 71.2 1.19e-14   NR GAA6795254.1 210 g23422 i0 66.7 0.630841121495327 45 15 63.1 0 182 48 2 46 GAA6795254.1 hypothetical protein Kyoto200A_0170 [Helicobacter pylori] diamond 135 71.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31583801 31583801 PRJNA1022392_P_NODE_82476_length_154_cov_2.719626_g81807_i0 PRJNA1022392 82476 154 2.719626 4.18822404 Helicobacter pylori 210 Bacteria Bacteria 49.3 5.86e-6   NR GAA8683376.1 210 g81807 i0 74.1 0.974025974025974 27 7 52.6 0 2 82 2 28 GAA8683376.1 hypothetical protein Kyoto145A_0600 [Helicobacter pylori] diamond 150 49.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32279806 32279806 PRJNA1022392_P_NODE_77919_length_159_cov_0.910714_g77250_i0 PRJNA1022392 77919 159 0.910714 1.44803526 Desulfurellales bacterium 2482794 Bacteria Bacteria 42.4 0.0162   NR TXH50042.1 2482794 g77250 i0 43.6 0.735849056603774 39 21 73.6 1 158 42 223 260 TXH50042.1 MAG: hypothetical protein E6Q97_21155 [Desulfurellales bacterium] diamond 117 42.4 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
32532963 32532963 PRJNA1022392_P_NODE_75559_length_160_cov_8.601770_g74890_i0 PRJNA1022392 75559 160 8.60177 13.762832 Helicobacter pylori 210 Bacteria Bacteria 61.6 3.72e-11   NR GAA9176259.1 210 g74890 i0 69.2 0.73125 39 11 71.3 1 146 33 11 49 GAA9176259.1 hypothetical protein Kyoto193A_0410 [Helicobacter pylori] diamond 117 61.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32871385 32871385 PRJNA1022392_P_NODE_63340_length_173_cov_1.500000_g62671_i0 PRJNA1022392 63340 173 1.5 2.595 Pseudomonadati 3379134 Bacteria Bacteria 99.4 1.19e-25   NR MDN2892833.1 197 g62671 i0 100 2.70520231213873 52 0 90.2 0 3 158 28 79 MDN2892833.1 STAS domain-containing protein [Campylobacter jejuni] diamond 468 99.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni

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