RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1144090" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1144090 · 10 ✖

analysis 1

  • blastn · 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
1561700 1561700 PRJNA1144090_P_NODE_19382_length_618_cov_394.095413_g18858_i0 PRJNA1144090 19382 618 394.095413 2435.50965234 Arcobacter iocasae 2906515 Bacteria Bacteria 54.7 0.017   NTclustered gi|2809047151|gb|CP090177.1| 2906515 g18858 i0 100 0.0469255663430421 29 0 5 0 96 124 1017122 1017150 Arcobacter sp. KX21116 chromosome, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter iocasae
1562425 1562425 PRJNA1144090_P_NODE_85242_length_272_cov_3.773869_g84707_i0 PRJNA1144090 85242 272 3.773869 10.26492368 Malaciobacter canalis 1912871 Bacteria Bacteria 54.7 0.007   NTclustered gi|2851193446|gb|CP085223.1| 1912871 g84707 i0 100 0.341911764705882 29 0 11 0 173 201 2090370 2090398 Malaciobacter canalis strain ADH2-947 chromosome, complete genome blastn 93 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Malaciobacter Malaciobacter canalis
5390030 5390030 PRJNA1144090_P_NODE_104165_length_248_cov_0.880000_g103630_i0 PRJNA1144090 104165 248 0.88 2.1824 Campylobacter concisus 199 Bacteria Bacteria 442 1.1399999999999995e-119   NTclustered gi|1938728373|gb|CP049272.1| 199 g103630 i0 98.79 7.01209677419355 248 3 100 0 1 248 633959 633712 Campylobacter concisus strain P27CDO-S2 chromosome, complete genome blastn 1739 442 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
6135885 6135885 PRJNA1144090_P_NODE_68825_length_305_cov_1.818966_g68290_i0 PRJNA1144090 68825 305 1.818966 5.5478463 Campylobacter 194 Bacteria Bacteria 54.7 0.008   NTclustered gi|1940031893|gb|CP065357.1| 1813019 g68290 i0 100 0.852459016393443 29 0 10 0 272 300 233094 233066 Campylobacter hepaticus strain UF2019SK1 chromosome, complete genome blastn 260 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter hepaticus
8686079 8686079 PRJNA1144090_P_NODE_117587_length_238_cov_2.333333_g117052_i0 PRJNA1144090 117587 238 2.333333 5.55333254 Aliarcobacter 2321111 Bacteria Bacteria 438 1.4e-118   NTclustered gi|1231709647|emb|LT906455.1| 28197 g117052 i0 100 423.218487394958 237 0 99 0 1 237 852321 852557 Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1 blastn 100726 438 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
12511742 12511742 PRJNA1144090_P_NODE_82570_length_277_cov_1.509804_g82035_i0 PRJNA1144090 82570 277 1.509804 4.18215708 Arcobacteraceae 2808963 Bacteria Bacteria 512 9.73e-141   NTclustered gi|1231709647|emb|LT906455.1| 28197 g82035 i0 100 384.361010830325 277 0 100 0 1 277 851949 851673 Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1 blastn 106468 512 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
15060710 15060710 PRJNA1144090_P_NODE_40052_length_408_cov_1.367164_g39517_i0 PRJNA1144090 40052 408 1.367164 5.57802912 Aliarcobacter 2321111 Bacteria Bacteria 54.7 0.011   NTclustered gi|1231709647|emb|LT906455.1| 28197 g39517 i0 100 0.142156862745098 29 0 7 0 5 33 1821349 1821377 Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1 blastn 58 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
22709894 22709894 PRJNA1144090_P_NODE_33638_length_450_cov_1.599469_g33103_i0 PRJNA1144090 33638 450 1.599469 7.1976105 Aliarcobacter 2321111 Bacteria Bacteria 832 0   NTclustered gi|1231709647|emb|LT906455.1| 28197 g33103 i0 100 379.686666666667 450 0 100 0 1 450 851573 851124 Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1 blastn 170859 832 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
23240065 23240065 PRJNA1144090_P_NODE_79019_length_283_cov_3.233333_g78484_i0 PRJNA1144090 79019 283 3.233333 9.15033239 Arcobacter peruensis 2320140 Bacteria Bacteria 52.8 0.026   NTclustered gi|1509188976|gb|CP032363.1| 2320140 g78484 i0 100 0.0989399293286219 28 0 10 0 188 215 1851250 1851277 Arcobacter peruensis strain PSE-93 chromosome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter peruensis
23985332 23985332 PRJNA1144090_P_NODE_83439_length_275_cov_3.811881_g82904_i0 PRJNA1144090 83439 275 3.811881 10.48267275 Aliarcobacter 2321111 Bacteria Bacteria 503 5.809999999999998e-138   NTclustered gi|1231709647|emb|LT906455.1| 28197 g82904 i0 100 400.472727272727 272 0 100 0 1 272 849691 849962 Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1 blastn 110130 503 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);;