RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA846086", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 12 ✖

tax_phylum 1

  • Campylobacterota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA846086 · 12 ✖

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
12312044 12312044 PRJNA846086_P_NODE_5350_length_242_cov_0.911243_g5284_i0 PRJNA846086 5350 242 0.911243 2.20520806 Campylobacter showae 204 Bacteria Bacteria 364 2.4699999999999992e-96   NTclustered gi|1483583529|emb|LT631453.1| 204 g5284 i0 93.802 13.297520661157 242 15 100 0 1 242 257041 256800 Campylobacter showae strain B91_SCBr genome assembly, chromosome: I blastn 3218 364 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
13586487 13586487 PRJNA846086_P_NODE_2271_length_273_cov_1.255000_g2205_i0 PRJNA846086 2271 273 1.255 3.42615 Campylobacter showae 204 Bacteria Bacteria 433 7.66e-117   NTclustered gi|1483583529|emb|LT631453.1| 204 g2205 i0 95.238 11 273 13 100 0 1 273 534916 535188 Campylobacter showae strain B91_SCBr genome assembly, chromosome: I blastn 3003 433 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
13586505 13586505 PRJNA846086_P_NODE_3191_length_251_cov_0.865169_g3125_i0 PRJNA846086 3191 251 0.865169 2.17157419 Campylobacter showae 204 Bacteria Bacteria 298 2.65e-76   NTclustered gi|1483583565|emb|LT631545.1| 204 g3125 i0 88.353 9.30677290836653 249 28 99 1 1 248 71421 71173 Campylobacter showae strain B32_SW genome assembly, chromosome: I blastn 2336 298 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
15259199 15259199 PRJNA846086_P_NODE_272_length_740_cov_27.790105_g211_i0 PRJNA846086 272 740 27.790105 205.646777 Campylobacter 194 Bacteria Bacteria 935 0   NTclustered gi|1483583529|emb|LT631453.1| 204 g211 i0 89.623 109.972972972973 742 67 99 9 5 740 393448 392711 Campylobacter showae strain B91_SCBr genome assembly, chromosome: I blastn 81380 939 0.995740149094782 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
16135583 16135583 PRJNA846086_P_NODE_3753_length_248_cov_0.880000_g3687_i0 PRJNA846086 3753 248 0.88 2.1824 Campylobacter showae 204 Bacteria Bacteria 436 5.3e-118   NTclustered gi|1483583525|emb|LT631449.1| 204 g3687 i0 98.387 9.89112903225806 248 4 100 0 1 248 1109439 1109192 Campylobacter showae strain 129_VTPPs genome assembly, chromosome: I blastn 2453 436 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
16135612 16135612 PRJNA846086_P_NODE_5393_length_242_cov_0.911243_g5327_i0 PRJNA846086 5393 242 0.911243 2.20520806 Campylobacter showae 204 Bacteria Bacteria 355 1.48e-93   NTclustered gi|1622747600|gb|CP012544.1| 204 g5327 i0 93.333 8.96280991735537 240 16 99 0 3 242 964975 965214 Campylobacter showae strain ATCC 51146 chromosome, complete genome blastn 2169 355 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
19959267 19959267 PRJNA846086_P_NODE_2616_length_262_cov_1.629630_g2550_i0 PRJNA846086 2616 262 1.62963 4.2696306 Campylobacter showae 204 Bacteria Bacteria 446 9.379999999999998e-121   NTclustered gi|1483583494|emb|LT631418.1| 204 g2550 i0 97.328 9.09541984732824 262 7 100 0 1 262 224015 224276 Campylobacter showae genome assembly, chromosome: I blastn 2383 446 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
23785186 23785186 PRJNA846086_P_NODE_5519_length_241_cov_0.916667_g5453_i0 PRJNA846086 5519 241 0.916667 2.20916747 Campylobacter showae 204 Bacteria Bacteria 399 6.729999999999998e-107   NTclustered gi|1483583529|emb|LT631453.1| 204 g5453 i0 96.667 9.94605809128631 240 8 99 0 2 241 1585715 1585476 Campylobacter showae strain B91_SCBr genome assembly, chromosome: I blastn 2397 399 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
25059018 25059018 PRJNA846086_P_NODE_2040_length_280_cov_1.352657_g1974_i0 PRJNA846086 2040 280 1.352657 3.7874396 Campylobacter showae 204 Bacteria Bacteria 468 2.16e-127   NTclustered gi|1483583525|emb|LT631449.1| 204 g1974 i0 96.786 11 280 9 100 0 1 280 868422 868701 Campylobacter showae strain 129_VTPPs genome assembly, chromosome: I blastn 3080 468 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
25059029 25059029 PRJNA846086_P_NODE_2920_length_254_cov_1.441989_g2854_i0 PRJNA846086 2920 254 1.441989 3.66265206 Campylobacter gracilis 824 Bacteria Bacteria 368 2.02e-97   NTclustered gi|909717139|gb|CP012196.1| 824 g2854 i0 92.885 1.99212598425197 253 18 99 0 1 253 666891 666639 Campylobacter gracilis strain ATCC 33236, complete genome blastn 506 368 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter gracilis
27157675 27157675 PRJNA846086_P_NODE_4802_length_244_cov_0.900585_g4736_i0 PRJNA846086 4802 244 0.900585 2.1974274 Pseudomonadati 3379134 Bacteria Bacteria 154 2.25e-46   NR MCH3703519.1 201 g4736 i0 100 1.99180327868852 81 0 99.6 0 2 244 25 105 MCH3703519.1 hypothetical protein [Campylobacter lari] diamond 486 154 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter lari
32615532 32615532 PRJNA846086_P_NODE_2800_length_258_cov_1.102703_g2734_i0 PRJNA846086 2800 258 1.102703 2.84497374 Helicobacter pylori 210 Bacteria Bacteria 43.1 0.00287   NR GAA8777965.1 210 g2734 i0 100 0.209302325581395 18 0 20.9 0 170 117 1 18 GAA8777965.1 hypothetical protein BTM122_15620 [Helicobacter pylori] diamond 54 43.1 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);;