RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA986481" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA986481 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
4801550 4801550 PRJNA986481_P_NODE_41124_length_262_cov_1.309859_g40599_i0 PRJNA986481 41124 262 1.309859 3.43183058 Nitrosophilus kaiyonis 2930200 Bacteria Bacteria 52.8 0.024   NTclustered gi|2329051130|dbj|AP025696.1| 2930200 g40599 i0 100 0.106870229007634 28 0 11 0 175 202 680831 680858 Nitrosophilus sp. MOT50 DNA, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Nautiliales Nitratiruptoraceae Nitrosophilus Nitrosophilus kaiyonis
6076771 6076771 PRJNA986481_P_NODE_33565_length_282_cov_1.690987_g33040_i0 PRJNA986481 33565 282 1.690987 4.76858334 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 52.8 0.026   NTclustered gi|1679706893|gb|CP021072.1| 1032070 g33040 i0 100 0.198581560283688 28 0 10 0 74 101 210876 210849 Arcobacter cryaerophilus ATCC 43158 strain LMG 9904 genome blastn 56 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
8626988 8626988 PRJNA986481_P_NODE_62447_length_227_cov_6.707865_g61922_i0 PRJNA986481 62447 227 6.707865 15.22685355 Arcobacter ellisii 913109 Bacteria Bacteria 385 1.76e-102   NTclustered gi|1474793334|gb|CP032097.1| 913109 g61922 i0 100 353.753303964758 208 0 92 0 20 227 953668 953875 Arcobacter ellisii strain LMG 26155 chromosome, complete genome blastn 80302 385 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter ellisii
9901405 9901405 PRJNA986481_P_NODE_14428_length_431_cov_16.808901_g13903_i0 PRJNA986481 14428 431 16.808901 72.44636331 Helicobacter pylori 210 Bacteria Bacteria 58.4 8.94e-4   NTclustered gi|2641629600|gb|CP078226.1| 210 g13903 i0 100 0.359628770301624 31 0 7 0 76 106 1619221 1619191 Helicobacter pylori strain HpGP-USA-204 chromosome, complete genome blastn 155 58.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
23925987 23925987 PRJNA986481_P_NODE_28019_length_310_cov_1.402299_g27494_i0 PRJNA986481 28019 310 1.402299 4.3471269 Campylobacter sp. GTC17093 3382266 Bacteria Bacteria 56.5 0.002   NTclustered gi|2866683719|dbj|AP038832.1| 3382266 g27494 i0 100 0.2 30 0 10 0 263 292 694606 694577 Campylobacter sp. GTC17093 DNA, complete genome blastn 62 56.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. GTC17093
23926454 23926454 PRJNA986481_P_NODE_56399_length_245_cov_1.030612_g55874_i0 PRJNA986481 56399 245 1.030612 2.5249994 Aliarcobacter butzleri 28197 Bacteria Bacteria 52.8 0.022   NTclustered gi|2305706618|gb|CP104378.1| 28197 g55874 i0 100 0.114285714285714 28 0 11 0 34 61 523970 523943 Aliarcobacter butzleri strain P1100 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri

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