RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA1063685", tax_kingdom = "Pseudomonadati" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 19 ✖

tax_kingdom 1

  • Pseudomonadati · 19 ✖

bioproject 1

  • PRJNA1063685 · 19 ✖

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
2729946 2729946 PRJNA1063685_S_NODE_22903_length_483_cov_4.697561_g22363_i0 PRJNA1063685 22903 483 4.697561 22.68921963 Campylobacter ureolyticus 827 Bacteria Bacteria 848 0   NTclustered gi|1966876394|gb|CP068487.1| 827 g22363 i0 98.542 9.50103519668737 480 7 99 0 1 480 1713843 1713364 Campylobacter ureolyticus strain FDAARGOS_1102 chromosome blastn 4589 848 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
2730188 2730188 PRJNA1063685_S_NODE_48803_length_324_cov_5.370518_g48260_i0 PRJNA1063685 48803 324 5.370518 17.40047832 Campylobacter ureolyticus 827 Bacteria Bacteria 547 3.18e-151   NTclustered gi|1966876394|gb|CP068487.1| 827 g48260 i0 99.666 3.69135802469136 299 1 92 0 1 299 253012 253310 Campylobacter ureolyticus strain FDAARGOS_1102 chromosome blastn 1196 547 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
4840178 4840178 PRJNA1063685_S_NODE_63924_length_267_cov_2.907216_g63381_i0 PRJNA1063685 63924 267 2.907216 7.76226672 Campylobacter 194 Bacteria Bacteria 483 7.31e-132   NTclustered gi|1829985141|gb|CP050963.1| 827 g63381 i0 99.251 2 267 2 100 0 1 267 494429 494695 Campylobacter ureolyticus strain FDAARGOS_673 chromosome blastn 534 483 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
6115167 6115167 PRJNA1063685_S_NODE_43065_length_352_cov_3.781362_g42522_i0 PRJNA1063685 43065 352 3.781362 13.31039424 Campylobacter 194 Bacteria Bacteria 566 9.609999999999999e-157   NTclustered gi|1861380260|gb|CP053831.1| 202 g42522 i0 98.442 215.463068181818 321 5 91 0 14 334 608992 608672 Campylobacter mucosalis strain ATCC 43264 chromosome, complete genome blastn 75843 571 0.991243432574431 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter mucosalis
9107446 9107446 PRJNA1063685_S_NODE_70848_length_248_cov_2.640000_g70305_i0 PRJNA1063685 70848 248 2.64 6.5472 Campylobacter ureolyticus 827 Bacteria Bacteria 287 5.649999999999999e-73   NTclustered gi|1829985141|gb|CP050963.1| 827 g70305 i0 100 4.53225806451613 155 0 91 0 1 155 1275241 1275087 Campylobacter ureolyticus strain FDAARGOS_673 chromosome blastn 1124 287 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
9940084 9940084 PRJNA1063685_S_NODE_34188_length_401_cov_5.420732_g33646_i0 PRJNA1063685 34188 401 5.420732 21.73713532 Campylobacter 194 Bacteria Bacteria 616 1.0899999999999995e-171   NTclustered gi|1966876394|gb|CP068487.1| 827 g33646 i0 96.515 4.60598503740648 373 12 93 1 23 395 119450 119079 Campylobacter ureolyticus strain FDAARGOS_1102 chromosome blastn 1847 616 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
9940097 9940097 PRJNA1063685_S_NODE_36528_length_387_cov_4.461783_g35985_i0 PRJNA1063685 36528 387 4.461783 17.26710021 Campylobacter 194 Bacteria Bacteria 673 0   NTclustered gi|1483583501|emb|LT631425.1| 204 g35985 i0 100 5.63307493540052 364 0 94 0 24 387 9940 10303 Campylobacter showae genome assembly, plasmid: I blastn 2180 673 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
9940157 9940157 PRJNA1063685_S_NODE_45268_length_341_cov_3.227612_g44725_i0 PRJNA1063685 45268 341 3.227612 11.00615692 Campylobacter 194 Bacteria Bacteria 612 1.18e-170   NTclustered gi|1935888393|gb|CP049239.1| 199 g44725 i0 100 228.903225806452 331 0 97 0 11 341 1033031 1032701 Campylobacter concisus strain P3UCO1 chromosome, complete genome blastn 78056 612 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
11657919 11657919 PRJNA1063685_S_NODE_16090_length_549_cov_13.079832_g15560_i0 PRJNA1063685 16090 549 13.079832 71.80827768 Campylobacter ureolyticus 827 Bacteria Bacteria 968 0   NTclustered gi|1966876394|gb|CP068487.1| 827 g15560 i0 98.54 3.99271402550091 548 8 99 0 1 548 1634045 1634592 Campylobacter ureolyticus strain FDAARGOS_1102 chromosome blastn 2192 968 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
11658062 11658062 PRJNA1063685_S_NODE_27490_length_447_cov_9.000000_g26949_i0 PRJNA1063685 27490 447 9 40.23 Campylobacter ureolyticus 827 Bacteria Bacteria 773 0   NTclustered gi|1829985141|gb|CP050963.1| 827 g26949 i0 99.762 5.61073825503356 421 1 94 0 27 447 708572 708992 Campylobacter ureolyticus strain FDAARGOS_673 chromosome blastn 2508 773 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
12933521 12933521 PRJNA1063685_S_NODE_60731_length_277_cov_4.210784_g60188_i0 PRJNA1063685 60731 277 4.210784 11.66387168 Campylobacter ureolyticus 827 Bacteria Bacteria 459 1.29e-124   NTclustered gi|1829985141|gb|CP050963.1| 827 g60188 i0 99.213 85.4007220216607 254 2 92 0 24 277 62272 62019 Campylobacter ureolyticus strain FDAARGOS_673 chromosome blastn 23656 459 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
15039542 15039542 PRJNA1063685_S_NODE_26112_length_457_cov_11.674479_g25571_i0 PRJNA1063685 26112 457 11.674479 53.35236903 Helicobacter 209 Bacteria Bacteria 778 0   NTclustered gi|2157108461|dbj|AP025204.1| 213 g25571 i0 100 128.417943107221 421 0 92 0 1 421 127997 127577 Helicobacter cinaedi 94105 DNA, complete genome blastn 58687 778 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter cinaedi
15039819 15039819 PRJNA1063685_S_NODE_69312_length_251_cov_9.853933_g68769_i0 PRJNA1063685 69312 251 9.853933 24.73337183 Campylobacter 194 Bacteria Bacteria 427 3.2299999999999993e-115   NTclustered gi|1483583501|emb|LT631425.1| 204 g68769 i0 100 4.60159362549801 231 0 92 0 21 251 8430 8660 Campylobacter showae genome assembly, plasmid: I blastn 1155 427 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
17589625 17589625 PRJNA1063685_S_NODE_20174_length_508_cov_5.372414_g19636_i0 PRJNA1063685 20174 508 5.372414 27.29186312 Campylobacter 194 Bacteria Bacteria 922 0   NTclustered gi|1829985141|gb|CP050963.1| 827 g19636 i0 99.409 3.98031496062992 508 3 100 0 1 508 494594 495101 Campylobacter ureolyticus strain FDAARGOS_673 chromosome blastn 2022 922 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
18031332 18031332 PRJNA1063685_S_NODE_43975_length_347_cov_6.989051_g43432_i0 PRJNA1063685 43975 347 6.989051 24.25200697 Campylobacter ureolyticus 827 Bacteria Bacteria 527 4.4799999999999986e-145   NTclustered gi|909715533|gb|CP012195.1| 1032069 g43432 i0 95.988 4.6685878962536 324 13 93 0 1 324 1036391 1036714 Campylobacter ureolyticus RIGS 9880 chromosome, complete genome blastn 1620 527 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
19305370 19305370 PRJNA1063685_S_NODE_45856_length_338_cov_4.886792_g45313_i0 PRJNA1063685 45856 338 4.886792 16.51735696 Campylobacter ureolyticus 827 Bacteria Bacteria 538 2.0099999999999994e-148   NTclustered gi|1966876394|gb|CP068487.1| 827 g45313 i0 97.17 4.60355029585799 318 9 94 0 21 338 1493537 1493854 Campylobacter ureolyticus strain FDAARGOS_1102 chromosome blastn 1556 538 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
30541027 30541027 PRJNA1063685_S_NODE_9733_length_633_cov_3.189286_g9221_i0 PRJNA1063685 9733 633 3.189286 20.18818038 Arcobacter sp. 1872629 Bacteria Bacteria 103 6.88e-22   NR WP_287792238.1 1872629 g9221 i0 48.5 0.919431279620853 99 51 46.9 0 30 326 402 500 WP_287792238.1 Eco57I restriction-modification methylase domain-containing protein [Arcobacter sp.] diamond 582 103 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter sp.
30667430 30667430 PRJNA1063685_S_NODE_69733_length_251_cov_0.865169_g69190_i0 PRJNA1063685 69733 251 0.865169 2.17157419 Arcobacteraceae bacterium 2808971 Bacteria Bacteria 160 1.1399999999999996e-43   NR MDX9795282.1 2808971 g69190 i0 97.6 0.99203187250996006 83 2 99.2 0 249 1 250 332 MDX9795282.1 phenylalanine--tRNA ligase subunit beta [Arcobacteraceae bacterium] diamond 249 160 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae   Arcobacteraceae bacterium
32501832 32501832 PRJNA1063685_S_NODE_21379_length_496_cov_28.983452_g20840_i0 PRJNA1063685 21379 496 28.983452 143.75792192 Campylobacter sp. 2 205 Bacteria Bacteria 108 1.06e-26   NR WP_214120692.1 2836735 g20840 i0 65.2 0.556451612903226 92 32 55.6 0 56 331 17 108 WP_214120692.1 hypothetical protein, partial [Campylobacter sp. 2018MI01] diamond 276 108 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. 2018MI01

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