RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA798511" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA798511 · 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
790099 790099 PRJNA798511_P_NODE_23761_length_672_cov_8.682805_g19613_i0 PRJNA798511 23761 672 8.682805 58.3484496 Hippea maritima 84405 Bacteria Bacteria 54.7 0.019   NTclustered gi|327180802|gb|CP002606.1| 760142 g19613 i0 96.875 0.0476190476190476 32 1 5 0 490 521 522342 522373 Hippea maritima DSM 10411, complete genome blastn 32 54.7 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales Hippeaceae Hippea Hippea maritima
3341983 3341983 PRJNA798511_P_NODE_71583_length_285_cov_1.452830_g67317_i0 PRJNA798511 71583 285 1.45283 4.1405655 Campylobacter ureolyticus 827 Bacteria Bacteria 52.8 0.026   NTclustered gi|1966876394|gb|CP068487.1| 827 g67317 i0 100 0.982456140350877 28 0 10 0 84 111 784124 784151 Campylobacter ureolyticus strain FDAARGOS_1102 chromosome blastn 280 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
4619664 4619664 PRJNA798511_P_NODE_96524_length_245_cov_1.162791_g92258_i0 PRJNA798511 96524 245 1.162791 2.84883795 Campylobacter avium 522485 Bacteria Bacteria 52.8 0.022   NTclustered gi|1226875038|gb|CP022347.1| 522484 g92258 i0 96.875 0.130612244897959 32 0 13 1 69 100 1221544 1221574 Campylobacter avium LMG 24591 chromosome, complete genome blastn 32 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter avium
5045882 5045882 PRJNA798511_P_NODE_84644_length_257_cov_1.673913_g80378_i0 PRJNA798511 84644 257 1.673913 4.30195641 Aliarcobacter 2321111 Bacteria Bacteria 52.8 0.023   NTclustered gi|1817415496|gb|CP026656.1| 28198 g80378 i0 100 0.43579766536965 28 0 11 0 17 44 1712990 1712963 Aliarcobacter cryaerophilus strain M830MA chromosome, complete genome blastn 112 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
8443470 8443470 PRJNA798511_P_NODE_40007_length_421_cov_1.186782_g35744_i0 PRJNA798511 40007 421 1.186782 4.99635222 Helicobacter canadensis 123841 Bacteria Bacteria 52.8 0.041   NTclustered gi|1721134156|emb|LR698957.1| 123841 g35744 i0 100 0.0665083135391924 28 0 7 0 319 346 886763 886790 Helicobacter canadensis isolate MGYG-HGUT-01348 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter canadensis
8870944 8870944 PRJNA798511_P_NODE_54267_length_338_cov_1.162264_g50001_i0 PRJNA798511 54267 338 1.162264 3.92845232 Pseudomonadati 3379134 Bacteria Bacteria 76.3 1.43e-13   NR MCB4773626.1 1969726 g50001 i0 41.2 3.78994082840237 85 49 75.4 1 311 57 253 336 MCB4773626.1 reverse transcriptase family protein [Sulfurovum sp.] diamond 1281 76.6 0.996083550913838 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
13544855 13544855 PRJNA798511_P_NODE_96731_length_245_cov_0.895349_g92465_i0 PRJNA798511 96731 245 0.895349 2.19360505 Aliarcobacter lanthieri 1355374 Bacteria Bacteria 52.8 0.022   NTclustered gi|2922103276|gb|CP182878.1| 1355374 g92465 i0 100 0.114285714285714 28 0 11 0 55 82 1919152 1919125 Aliarcobacter lanthieri strain BNI-3132 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter lanthieri
14818747 14818747 PRJNA798511_P_NODE_36732_length_452_cov_1.232190_g32473_i0 PRJNA798511 36732 452 1.23219 5.5694988 Campylobacter armoricus 2505970 Bacteria Bacteria 54.7 0.012   NTclustered gi|1861371805|gb|CP053825.1| 2505970 g32473 i0 96.875 0.141592920353982 32 1 7 0 378 409 1399575 1399606 Campylobacter armoricus strain CCUG 73571 chromosome, complete genome blastn 64 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter armoricus
27054028 27054028 PRJNA798511_P_NODE_66762_length_297_cov_2.285714_g62496_i0 PRJNA798511 66762 297 2.285714 6.78857058 Arcobacteraceae bacterium 2808971 Bacteria Bacteria 43.9 0.0259   NR MCK5293339.1 2808971 g62496 i0 40.7 0.595959595959596 59 33 59.6 1 32 208 47 103 MCK5293339.1 NnrS family protein [Arcobacteraceae bacterium] diamond 177 43.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae   Arcobacteraceae bacterium
32235632 32235632 PRJNA798511_P_NODE_84658_length_257_cov_1.635870_g80392_i0 PRJNA798511 84658 257 1.63587 4.2041859 Sulfurovum sp. 1969726 Bacteria Bacteria 48.9 2.89e-4   NR MCB4781100.1 1969726 g80392 i0 37.1 1.63424124513619 70 35 71.2 1 190 8 380 449 MCB4781100.1 hypothetical protein [Sulfurovum sp.] diamond 420 48.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.

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