RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA473201", tax_kingdom = "Pseudomonadati" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 7 ✖

tax_kingdom 1

  • Pseudomonadati · 7 ✖

bioproject 1

  • PRJNA473201 · 7 ✖

analysis 1

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
6822381 6822381 PRJNA473201_P_NODE_8926_length_678_cov_25.413223_g8212_i0 PRJNA473201 8926 678 25.413223 172.30165194 root 1 Root_unresolved Root_unresolved 143 5.61e-40   NR WP_238408432.1 210 g8212 i0 63.8 1.39380530973451 105 38 46.5 0 316 2 11 115 WP_238408432.1 DUF1398 family protein, partial [Helicobacter pylori] diamond 945 143 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27913433 27913433 PRJNA473201_P_NODE_87425_length_222_cov_5.671141_g86683_i0 PRJNA473201 87425 222 5.671141 12.58993302 Bacteria 2 Bacteria Bacteria 79.7 9.06e-17   NR WP_203061690.1 210 g86683 i0 71.2 27.1081081081081 59 17 79.7 0 39 215 32 90 WP_203061690.1 ead/Ea22-like family protein, partial [Helicobacter pylori] diamond 6018 79.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28529080 28529080 PRJNA473201_P_NODE_45167_length_304_cov_0.930736_g44425_i0 PRJNA473201 45167 304 0.930736 2.82943744 Campylobacterales bacterium 2268180 Bacteria Bacteria 124 9.31e-34   NR MBY0540710.1 2268180 g44425 i0 77.9 0.759868421052632 77 17 76 0 232 2 1 77 MBY0540710.1 hypothetical protein [Campylobacterales bacterium] diamond 231 124 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales     Campylobacterales bacterium
30819089 30819089 PRJNA473201_P_NODE_33514_length_342_cov_24.657993_g32772_i0 PRJNA473201 33514 342 24.657993 84.33033606 Bacteria 2 Bacteria Bacteria 95.1 4.6e-21   NR WP_227574815.1 195 g32772 i0 60.3 17.2894736842105 73 29 64 0 4 222 24 96 WP_227574815.1 AAA family ATPase, partial [Campylobacter coli] diamond 5913 95.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
32020636 32020636 PRJNA473201_P_NODE_22918_length_411_cov_20.556213_g22176_i0 PRJNA473201 22918 411 20.556213 84.48603543 root 1 Root_unresolved Root_unresolved 104 7.53e-26   NR WP_238408432.1 210 g22176 i0 76.1 4.14598540145985 71 17 51.8 0 316 104 30 100 WP_238408432.1 DUF1398 family protein, partial [Helicobacter pylori] diamond 1704 104 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32052221 32052221 PRJNA473201_P_NODE_31498_length_352_cov_20.587814_g30756_i0 PRJNA473201 31498 352 20.587814 72.46910528 Bacteria 2 Bacteria Bacteria 45.8 0.00871   NR WP_227574815.1 195 g30756 i0 74.3 13.40625 35 9 29.8 0 124 228 154 188 WP_227574815.1 AAA family ATPase, partial [Campylobacter coli] diamond 4719 45.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
32841833 32841833 PRJNA473201_P_NODE_30740_length_356_cov_11.452297_g29998_i0 PRJNA473201 30740 356 11.452297 40.77017732 Bacteria 2 Bacteria Bacteria 67 5.11e-12   NR MCC3141976.1 197 g29998 i0 60.4 5.02247191011236 53 21 44.7 0 346 188 16 68 MCC3141976.1 hypothetical protein [Campylobacter jejuni] diamond 1788 67 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);;