RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB83101" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJEB83101 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
3548738 3548738 PRJEB83101_P_NODE_70643_length_250_cov_0.881356_g70338_i0 PRJEB83101 70643 250 0.881356 2.20339 Arcobacter 28196 Bacteria Bacteria 462 8.83e-126   NTclustered gi|1474790806|gb|CP032100.1| 663365 g70338 i0 100 355.128 250 0 100 0 1 250 1733065 1733314 Arcobacter suis CECT 7833 chromosome, complete genome blastn 88782 462 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter suis
10345532 10345532 PRJEB83101_P_NODE_65149_length_253_cov_0.866667_g64844_i0 PRJEB83101 65149 253 0.866667 2.19266751 Halarcobacter bivalviorum 663364 Bacteria Bacteria 176 1.31e-39   NTclustered gi|1435902972|gb|CP031217.1| 663364 g64844 i0 85.976 0.648221343873518 164 23 65 0 3 166 2058037 2058200 Halarcobacter bivalviorum strain LMG 26154 chromosome, complete genome blastn 164 176 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Halarcobacter Halarcobacter bivalviorum
10345646 10345646 PRJEB83101_P_NODE_69609_length_250_cov_3.435028_g69304_i0 PRJEB83101 69609 250 3.435028 8.58757 Arcobacter defluvii 873191 Bacteria Bacteria 385 1.97e-102   NTclustered gi|1847331607|gb|CP053835.1| 873191 g69304 i0 94.4 1.968 250 14 100 0 1 250 1308083 1307834 Arcobacter defluvii strain LMG 25694 chromosome, complete genome blastn 492 385 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter defluvii
10346028 10346028 PRJEB83101_P_NODE_84569_length_243_cov_0.917647_g84264_i0 PRJEB83101 84569 243 0.917647 2.22988221 Arcobacter ellisii 913109 Bacteria Bacteria 233 7.289999999999999e-57   NTclustered gi|1474793334|gb|CP032097.1| 913109 g84264 i0 83.951 8.39506172839506 243 39 100 0 1 243 1492975 1492733 Arcobacter ellisii strain LMG 26155 chromosome, complete genome blastn 2040 233 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter ellisii
13751393 13751393 PRJEB83101_P_NODE_50731_length_275_cov_1.237624_g50426_i0 PRJEB83101 50731 275 1.237624 3.403466 Aliarcobacter 2321111 Bacteria Bacteria 508 1.2499999999999999e-139   NTclustered gi|2305706618|gb|CP104378.1| 28197 g50426 i0 100 10.5127272727273 275 0 100 0 1 275 2350628 2350902 Aliarcobacter butzleri strain P1100 chromosome, complete genome blastn 2891 508 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
14171159 14171159 PRJEB83101_P_NODE_70432_length_250_cov_0.881356_g70127_i0 PRJEB83101 70432 250 0.881356 2.20339 Sulfurospirillum cavolei 366522 Bacteria Bacteria 451 1.91e-122   NTclustered gi|757804896|dbj|AP014724.1| 366522 g70127 i0 99.2 2 250 2 100 0 1 250 847891 848140 Sulfurospirillum cavolei DNA, complete genome blastn 500 451 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum cavolei
18849822 18849822 PRJEB83101_P_NODE_67615_length_252_cov_0.871508_g67310_i0 PRJEB83101 67615 252 0.871508 2.19620016 Sulfurospirillum 57665 Bacteria Bacteria 444 3.2299999999999996e-120   NTclustered gi|757804896|dbj|AP014724.1| 366522 g67310 i0 98.413 2 252 4 100 0 1 252 2367016 2366765 Sulfurospirillum cavolei DNA, complete genome blastn 504 444 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurospirillaceae Sulfurospirillum Sulfurospirillum cavolei
24367930 24367930 PRJEB83101_P_NODE_50240_length_276_cov_1.034483_g49935_i0 PRJEB83101 50240 276 1.034483 2.85517308 Arcobacter ellisii 913109 Bacteria Bacteria 436 5.999999999999999e-118   NTclustered gi|1474793334|gb|CP032097.1| 913109 g49935 i0 95.588 5.14855072463768 272 12 99 0 1 272 959545 959816 Arcobacter ellisii strain LMG 26155 chromosome, complete genome blastn 1421 436 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter ellisii

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