RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA982106" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA982106 · 16 ✖

analysis 1

  • blastn · 16 ✖

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
2546606 2546606 PRJNA982106_P_NODE_16002_length_278_cov_1.126829_g15762_i0 PRJNA982106 16002 278 1.126829 3.13258462 Campylobacter 194 Bacteria Bacteria 514 2.7199999999999996e-141   NTclustered gi|2096311395|gb|CP083378.1| 195 g15762 i0 100 19 278 0 100 0 1 278 1324267 1324544 Campylobacter coli strain C203112 chromosome, complete genome blastn 5282 514 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
6375129 6375129 PRJNA982106_P_NODE_26905_length_246_cov_0.890173_g26665_i0 PRJNA982106 26905 246 0.890173 2.18982558 Pseudomonadati 3379134 Bacteria Bacteria 455 1.4500000000000002e-123   NTclustered gi|1145145120|gb|KX686749.1| 195 g26665 i0 100 108.056910569106 246 0 100 0 1 246 45230 44985 Campylobacter coli strain Tx40 plasmid unnamed, complete sequence blastn 26582 455 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
7341410 7341410 PRJNA982106_P_NODE_1166_length_828_cov_0.948344_g956_i0 PRJNA982106 1166 828 0.948344 7.85228832 Campylobacter jejuni 197 Bacteria Bacteria 1513 0   NTclustered gi|2523971971|dbj|AP028356.1| 197 g956 i0 99.638 89.8188405797101 828 3 100 0 1 828 16721 15894 Campylobacter jejuni BCH-10539 plasmid pTet_BCH-10539 DNA, complete sequence blastn 74370 1513 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
10199587 10199587 PRJNA982106_P_NODE_16808_length_273_cov_0.960000_g16568_i0 PRJNA982106 16808 273 0.96 2.6208 root 1 Root_unresolved Root_unresolved 494 3.46e-135   NTclustered gi|2323232558|gb|CP109813.1| 195 g16568 i0 99.267 113 273 2 100 0 1 273 315421 315149 Campylobacter coli strain CC20JX12 chromosome, complete genome blastn 30849 494 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
10199676 10199676 PRJNA982106_P_NODE_22188_length_250_cov_0.870056_g21948_i0 PRJNA982106 22188 250 0.870056 2.17514 PVC group 1783257 Bacteria Bacteria 462 8.83e-126   NTclustered gi|2523954314|dbj|AP028341.1| 195 g21948 i0 100 16.924 250 0 100 0 1 250 156857 156608 Campylobacter coli BCH-10328 DNA, complete genome blastn 4231 462 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
14024687 14024687 PRJNA982106_P_NODE_11991_length_307_cov_1.393162_g11751_i0 PRJNA982106 11991 307 1.393162 4.27700734 root 1 Root_unresolved Root_unresolved 568 2.3e-157   NTclustered gi|2423708788|gb|CP115181.1| 195 g11751 i0 100 126.087947882736 307 0 100 0 1 307 595148 594842 Campylobacter coli strain 18JS15S chromosome, complete genome blastn 38709 568 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
14024961 14024961 PRJNA982106_P_NODE_30631_length_242_cov_1.366864_g30391_i0 PRJNA982106 30631 242 1.366864 3.30781088 FCB group 1783270 Bacteria Bacteria 448 2.3799999999999995e-121   NTclustered gi|959099187|gb|KT953380.1| 195 g30391 i0 100 92.3471074380165 242 0 100 0 1 242 6439 6198 Campylobacter coli strain ZTA09/02204 antimicrobial resistance gene cluster, complete sequence blastn 22348 448 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
14025078 14025078 PRJNA982106_P_NODE_8351_length_346_cov_1.128205_g8111_i0 PRJNA982106 8351 346 1.128205 3.9035893 root 1 Root_unresolved Root_unresolved 640 5.4999999999999996e-179   NTclustered gi|2794627034|gb|CP126368.1| 195 g8111 i0 100 103 346 0 100 0 1 346 39679 40024 Campylobacter coli strain BfR-CA-15687 plasmid pBfR-CA-15687, complete sequence blastn 35638 640 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
16573424 16573424 PRJNA982106_P_NODE_11673_length_310_cov_1.299578_g11433_i0 PRJNA982106 11673 310 1.299578 4.0286918 root 1 Root_unresolved Root_unresolved 568 2.3299999999999995e-157   NTclustered gi|2323232558|gb|CP109813.1| 195 g11433 i0 99.677 100 310 1 100 0 1 310 570707 570398 Campylobacter coli strain CC20JX12 chromosome, complete genome blastn 31000 573 0.991273996509599 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
19122217 19122217 PRJNA982106_P_NODE_1195_length_819_cov_1.693029_g983_i0 PRJNA982106 1195 819 1.693029 13.86590751 Bacteria 2 Bacteria Bacteria 1256 0   NTclustered gi|1293068902|gb|MF134831.1| 195 g983 i0 100 86.2735042735043 680 0 83 0 1 680 4258 4937 Campylobacter coli strain ZTA14/01086 tetracycline resistance protein (tetO), phosphorylase (pnp), erythromycin resistance methylase B (ermB), and truncated TetO (tetO) genes, complete cds blastn 70658 1256 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
19122577 19122577 PRJNA982106_P_NODE_6775_length_370_cov_1.599327_g6535_i0 PRJNA982106 6775 370 1.599327 5.9175099 root 1 Root_unresolved Root_unresolved 684 0   NTclustered gi|2323242367|gb|CP109820.1| 195 g6535 i0 100 102 370 0 100 0 1 370 48515 48884 Campylobacter coli strain CC21NB04a plasmid pCC21NB04-51K, complete sequence blastn 37740 684 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
19122599 19122599 PRJNA982106_P_NODE_7875_length_352_cov_1.448029_g7635_i0 PRJNA982106 7875 352 1.448029 5.09706208 Bacteria 2 Bacteria Bacteria 651 0   NTclustered gi|1377039872|gb|MF037584.1| 195 g7635 i0 100 106.096590909091 352 0 100 0 1 352 2002 1651 Campylobacter coli strain SHP40 cfrC gene cluster, complete sequence blastn 37346 651 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
21673513 21673513 PRJNA982106_P_NODE_32957_length_239_cov_2.518072_g32717_i0 PRJNA982106 32957 239 2.518072 6.01819208 Bacteria 2 Bacteria Bacteria 436 5.0799999999999985e-118   NTclustered gi|2484233124|gb|OQ390086.1| 195 g32717 i0 99.582 149.481171548117 239 1 100 0 1 239 546 308 Campylobacter coli strain 368C tetracycline resistance ribosomal protection (tet(O)) gene, partial cds blastn 35726 436 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
21673600 21673600 PRJNA982106_P_NODE_897_length_957_cov_1.735294_g711_i0 PRJNA982106 897 957 1.735294 16.60676358 root 1 Root_unresolved Root_unresolved 1762 0   NTclustered gi|2323242367|gb|CP109820.1| 195 g711 i0 99.896 101.69696969697 957 1 100 0 1 957 49867 50823 Campylobacter coli strain CC21NB04a plasmid pCC21NB04-51K, complete sequence blastn 97324 1768 0.996606334841629 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
25497330 25497330 PRJNA982106_P_NODE_1260_length_795_cov_1.958449_g1045_i0 PRJNA982106 1260 795 1.958449 15.56966955 Bacteria 2 Bacteria Bacteria 1463 0   NTclustered gi|2794627034|gb|CP126368.1| 195 g1045 i0 99.874 105.31572327044 795 1 100 0 1 795 37421 38215 Campylobacter coli strain BfR-CA-15687 plasmid pBfR-CA-15687, complete sequence blastn 83726 1463 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
25497592 25497592 PRJNA982106_P_NODE_31740_length_242_cov_0.869822_g31500_i0 PRJNA982106 31740 242 0.869822 2.10496924 Pseudomonadati 3379134 Bacteria Bacteria 436 5.1499999999999985e-118   NTclustered gi|2053375327|gb|CP076511.1| 195 g31500 i0 99.174 122.896694214876 242 2 100 0 1 242 6623 6382 Campylobacter coli strain R19.0802 plasmid pR19.0802_49k, complete sequence blastn 29741 436 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli

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