RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA520845" 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

  • PRJNA520845 · 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
3039284 3039284 PRJNA520845_P_NODE_141963_length_313_cov_2.637500_g140464_i0 PRJNA520845 141963 313 2.6375 8.255375 Hippea maritima 84405 Bacteria Bacteria 54.7 0.008   NTclustered gi|327180802|gb|CP002606.1| 760142 g140464 i0 96.875 0.10223642172524 32 1 10 0 159 190 522373 522342 Hippea maritima DSM 10411, complete genome blastn 32 54.7 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales Hippeaceae Hippea Hippea maritima
6214638 6214638 PRJNA520845_P_NODE_118405_length_343_cov_0.855556_g116906_i0 PRJNA520845 118405 343 0.855556 2.93455708 Campylobacter 194 Bacteria Bacteria 634 2.5299999999999996e-177   NTclustered gi|1829615825|gb|CP048760.1| 197 g116906 i0 100 100.020408163265 343 0 100 0 1 343 411779 412121 Campylobacter jejuni strain ZS005 chromosome, complete genome blastn 34307 634 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
6865559 6865559 PRJNA520845_P_NODE_125186_length_334_cov_0.885057_g123687_i0 PRJNA520845 125186 334 0.885057 2.95609038 Campylobacter jejuni 197 Bacteria Bacteria 617 2.48e-172   NTclustered gi|1626698542|gb|CP032522.1| 197 g123687 i0 100 100.359281437126 334 0 100 0 1 334 189629 189962 Campylobacter jejuni strain BC chromosome, complete genome blastn 33520 617 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
13244011 13244011 PRJNA520845_P_NODE_209231_length_254_cov_1.348066_g207732_i0 PRJNA520845 209231 254 1.348066 3.42408764 Aliarcobacter butzleri 28197 Bacteria Bacteria 470 5.37e-128   NTclustered gi|2305706618|gb|CP104378.1| 28197 g207732 i0 100 15.7716535433071 254 0 100 0 1 254 1229220 1229473 Aliarcobacter butzleri strain P1100 chromosome, complete genome blastn 4006 470 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
20237989 20237989 PRJNA520845_P_NODE_203496_length_259_cov_1.225806_g201997_i0 PRJNA520845 203496 259 1.225806 3.17483754 Aliarcobacter 2321111 Bacteria Bacteria 132 2.95e-26   NTclustered gi|2305706618|gb|CP104378.1| 28197 g201997 i0 80.114 21.8880308880309 176 35 68 0 3 178 395989 395814 Aliarcobacter butzleri strain P1100 chromosome, complete genome blastn 5669 132 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
20890495 20890495 PRJNA520845_P_NODE_146397_length_309_cov_0.978814_g144898_i0 PRJNA520845 146397 309 0.978814 3.02453526 Campylobacter jejuni 197 Bacteria Bacteria 571 1.7899999999999995e-158   NTclustered gi|1444889023|gb|CP012220.1| 197 g144898 i0 100 98.7831715210356 309 0 100 0 1 309 1408470 1408162 Campylobacter jejuni strain CJ090CC1332, complete genome blastn 30524 571 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
20891880 20891880 PRJNA520845_P_NODE_198757_length_263_cov_1.115789_g197258_i0 PRJNA520845 198757 263 1.115789 2.93452507 Campylobacter jejuni 197 Bacteria Bacteria 486 5.5499999999999986e-133   NTclustered gi|1626698542|gb|CP032522.1| 197 g197258 i0 100 101 263 0 100 0 1 263 1492765 1492503 Campylobacter jejuni strain BC chromosome, complete genome blastn 26563 486 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
20893921 20893921 PRJNA520845_P_NODE_32517_length_667_cov_1.469697_g31069_i0 PRJNA520845 32517 667 1.469697 9.80287899 Arcobacter ellisii 913109 Bacteria Bacteria 56.5 0.005   NTclustered gi|1474793334|gb|CP032097.1| 913109 g31069 i0 100 0.0449775112443778 30 0 4 0 429 458 81988 81959 Arcobacter ellisii strain LMG 26155 chromosome, complete genome blastn 30 56.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter ellisii
21513240 21513240 PRJNA520845_P_NODE_147257_length_308_cov_0.982979_g145758_i0 PRJNA520845 147257 308 0.982979 3.02757532 Campylobacter 194 Bacteria Bacteria 569 6.419999999999998e-158   NTclustered gi|1626698542|gb|CP032522.1| 197 g145758 i0 100 100 308 0 100 0 1 308 1401294 1400987 Campylobacter jejuni strain BC chromosome, complete genome blastn 30800 569 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
23443065 23443065 PRJNA520845_P_NODE_230139_length_248_cov_0.880000_g228640_i0 PRJNA520845 230139 248 0.88 2.1824 Campylobacter jejuni 197 Bacteria Bacteria 459 1.13e-124   NTclustered gi|1626698542|gb|CP032522.1| 197 g228640 i0 100 100 248 0 100 0 1 248 1164141 1163894 Campylobacter jejuni strain BC chromosome, complete genome blastn 24800 459 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni

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