RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA459724", tax_kingdom = "Pseudomonadati" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 9 ✖

tax_kingdom 1

  • Pseudomonadati · 9 ✖

bioproject 1

  • PRJNA459724 · 9 ✖

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
26759516 26759516 PRJNA459724_P_NODE_4141_length_208_cov_1.776536_g3749_i0 PRJNA459724 4141 208 1.776536 3.69519488 Desulfurellales bacterium 2482794 Bacteria Bacteria 42 0.0448   NR TXH47192.1 2482794 g3749 i0 77.3 0.317307692307692 22 5 31.7 0 207 142 510 531 TXH47192.1 MAG: hypothetical protein E6Q97_27770 [Desulfurellales bacterium] diamond 66 42 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
26854897 26854897 PRJNA459724_P_NODE_4881_length_182_cov_2.215686_g4489_i0 PRJNA459724 4881 182 2.215686 4.03254852 Desulfurellales bacterium 2482794 Bacteria Bacteria 58.2 4.68e-8   NR TXH55603.1 2482794 g4489 i0 46.6 0.956043956043956 58 31 95.6 0 182 9 74 131 TXH55603.1 MAG: hypothetical protein E6Q97_08520 [Desulfurellales bacterium] diamond 174 58.2 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
26854898 26854898 PRJNA459724_P_NODE_661_length_733_cov_2.576705_g446_i0 PRJNA459724 661 733 2.576705 18.88724765 Desulfurellales bacterium 2482794 Bacteria Bacteria 186 6.45e-57   NR TXH46803.1 2482794 g446 i0 92.1 0.413369713506139 101 8 41.3 0 246 548 1 101 TXH46803.1 MAG: hypothetical protein E6Q97_28645 [Desulfurellales bacterium] diamond 303 186 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
27297418 27297418 PRJNA459724_P_NODE_2023_length_378_cov_4.707736_g1638_i0 PRJNA459724 2023 378 4.707736 17.79524208 Helicobacter pylori 210 Bacteria Bacteria 54.7 2.35e-7   NR GAA6795286.1 210 g1638 i0 100 0.19047619047619 24 0 19 0 351 280 1 24 GAA6795286.1 hypothetical protein Kyoto200A_0270 [Helicobacter pylori] diamond 72 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27297421 27297421 PRJNA459724_P_NODE_5643_length_159_cov_1.800000_g5251_i0 PRJNA459724 5643 159 1.8 2.862 Helicobacter pylori 210 Bacteria Bacteria 50.8 1.32e-6   NR WP_316479292.1 210 g5251 i0 96 0.471698113207547 25 1 47.2 0 158 84 54 78 WP_316479292.1 hypothetical protein, partial [Helicobacter pylori] diamond 75 50.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28307946 28307946 PRJNA459724_P_NODE_1966_length_387_cov_2.094972_g1583_i0 PRJNA459724 1966 387 2.094972 8.10754164 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 57.4 1.62e-7   NR HNW65791.1 28198 g1583 i0 46.1 0.589147286821705 76 40 58.9 1 159 386 27 101 HNW65791.1 hypothetical protein [Aliarcobacter cryaerophilus] diamond 228 57.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
29886752 29886752 PRJNA459724_S_NODE_1951_length_169_cov_7.701493_g1948_i0 PRJNA459724 1951 169 7.701493 13.01552317 Helicobacter pylori 210 Bacteria Bacteria 69.7 2.94e-14   NR GAA6798490.1 210 g1948 i0 98 0.869822485207101 49 1 87 0 156 10 5 53 GAA6798490.1 hypothetical protein Kyoto200A_1590 [Helicobacter pylori] diamond 147 69.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30092163 30092163 PRJNA459724_P_NODE_5592_length_161_cov_1.803030_g5200_i0 PRJNA459724 5592 161 1.80303 2.9028783 Pseudomonadati 3379134 Bacteria Bacteria 96.7 5.96e-22   NR WP_322377339.1 210 g5200 i0 86.8 6.8944099378882 53 7 98.8 0 161 3 90 142 WP_322377339.1 PBSX family phage terminase large subunit [Helicobacter pylori] diamond 1110 96.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30329447 30329447 PRJNA459724_P_NODE_4132_length_208_cov_2.486034_g3740_i0 PRJNA459724 4132 208 2.486034 5.1709507199999996 Helicobacter pylori 210 Bacteria Bacteria 89 2.0200000000000003e-21   NR WP_316479312.1 210 g3740 i0 95.6 0.649038461538462 45 2 64.9 0 1 135 30 74 WP_316479312.1 hypothetical protein, partial [Helicobacter pylori] diamond 135 89 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);;