RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1150539" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1150539 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
2311938 2311938 PRJNA1150539_S_NODE_27802_length_358_cov_3.361404_g27206_i0 PRJNA1150539 27802 358 3.361404 12.03382632 Campylobacter 194 Bacteria Bacteria 662 0   NTclustered gi|1207769205|gb|MF351718.1| 199 g27206 i0 100 235.117318435754 358 0 100 0 1 358 836 479 Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence blastn 84172 662 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
4128760 4128760 PRJNA1150539_S_NODE_95764_length_247_cov_3.287356_g95168_i0 PRJNA1150539 95764 247 3.287356 8.11976932 Malaciobacter marinus 505249 Bacteria Bacteria 52.8 0.022   NTclustered gi|1474785413|gb|CP032101.1| 505249 g95168 i0 100 0.11336032388664 28 0 11 0 113 140 1771291 1771318 Malaciobacter marinus strain JCM 15502 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Malaciobacter Malaciobacter marinus
4864914 4864914 PRJNA1150539_S_NODE_71584_length_277_cov_2.911765_g70988_i0 PRJNA1150539 71584 277 2.911765 8.06558905 Helicobacter 209 Bacteria Bacteria 507 4.53e-139   NTclustered gi|50957138|gb|AY596223.1| 35818 g70988 i0 99.639 131.996389891697 277 1 100 0 1 277 952 676 Helicobacter pullorum strain NCTC 12827 23S ribosomal RNA gene, partial sequence blastn 36563 512 0.990234375 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pullorum
7414543 7414543 PRJNA1150539_S_NODE_33166_length_345_cov_1.705882_g32570_i0 PRJNA1150539 33166 345 1.705882 5.8852929 root 1 Root_unresolved Root_unresolved 63.9 1.51e-5   NTclustered gi|2222034613|gb|CP094108.1| 210 g32570 i0 97.368 0.614492753623188 38 0 11 1 298 334 685185 685148 Helicobacter pylori strain Hpfe073 chromosome, complete genome blastn 212 63.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
11779534 11779534 PRJNA1150539_S_NODE_108550_length_228_cov_5.303226_g107954_i0 PRJNA1150539 108550 228 5.303226 12.09135528 Helicobacter pylori 210 Bacteria Bacteria 93.5 1.2e-14   NTclustered gi|2222028449|gb|CP094103.1| 210 g107954 i0 89.333 27.9429824561403 75 6 33 2 1 75 1292656 1292584 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 6371 93.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
12515391 12515391 PRJNA1150539_S_NODE_31790_length_348_cov_3.225455_g31194_i0 PRJNA1150539 31790 348 3.225455 11.2245834 Arcobacter 28196 Bacteria Bacteria 56.5 0.003   NTclustered gi|2907625740|emb|OZ223300.1| 165434 g31194 i0 92.308 0.304597701149425 39 3 11 0 177 215 1254902 1254864 MAG: uncultured Arcobacter sp. isolate 7fb66f34-7b41-4cab-a2d2-b84adad47d9e genome assembly, chromosome: 1 blastn 106 56.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter uncultured Arcobacter sp.
20163280 20163280 PRJNA1150539_S_NODE_95556_length_248_cov_0.880000_g94960_i0 PRJNA1150539 95556 248 0.88 2.1824 Aliarcobacter 2321111 Bacteria Bacteria 52.8 0.022   NTclustered gi|1231709647|emb|LT906455.1| 28197 g94960 i0 100 0.903225806451613 28 0 11 0 25 52 846966 846993 Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1 blastn 224 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
21978170 21978170 PRJNA1150539_S_NODE_49958_length_311_cov_2.626050_g49362_i0 PRJNA1150539 49958 311 2.62605 8.1670155 Helicobacter pylori 210 Bacteria Bacteria 89.8 2.22e-13   NTclustered gi|2222034613|gb|CP094108.1| 210 g49362 i0 90 0.22508038585209 70 5 23 2 1 70 685115 685182 Helicobacter pylori strain Hpfe073 chromosome, complete genome blastn 70 89.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
23988798 23988798 PRJNA1150539_S_NODE_10499_length_434_cov_5.991690_g9904_i0 PRJNA1150539 10499 434 5.99169 26.0039346 root 1 Root_unresolved Root_unresolved 65.8 5.38e-6   NTclustered gi|2222034613|gb|CP094108.1| 210 g9904 i0 88.889 8.6889400921659 54 5 12 1 1 54 685144 685196 Helicobacter pylori strain Hpfe073 chromosome, complete genome blastn 3771 65.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
25263166 25263166 PRJNA1150539_S_NODE_82360_length_263_cov_1.363158_g81764_i0 PRJNA1150539 82360 263 1.363158 3.58510554 Helicobacter 209 Bacteria Bacteria 475 1.2e-129   NTclustered gi|50957158|gb|AY596243.1| 32025 g81764 i0 99.24 137.311787072243 263 2 100 0 1 263 946 1208 Helicobacter hepaticus strain MIT Hh-2 23S ribosomal RNA gene, partial sequence blastn 36113 475 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter hepaticus

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