RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJEB83101" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJEB83101 · 13 ✖

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
27034287 27034287 PRJEB83101_P_NODE_47562_length_280_cov_1.864734_g47257_i0 PRJEB83101 47562 280 1.864734 5.2212552 Arcobacter cloacae 1054034 Bacteria Bacteria 52.4 2.06e-5   NR WP_129013981.1 1054034 g47257 i0 61.5 0.835714285714286 39 15 41.8 0 5 121 255 293 WP_129013981.1 hypothetical protein [Arcobacter cloacae] diamond 234 52.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter cloacae
27539978 27539978 PRJEB83101_P_NODE_84964_length_242_cov_2.585799_g84659_i0 PRJEB83101 84964 242 2.585799 6.25763358 Helicobacter pylori 210 Bacteria Bacteria 60.1 1.32e-9   NR GAA8686254.1 210 g84659 i0 100 0.384297520661157 31 0 38.4 0 117 25 1 31 GAA8686254.1 hypothetical protein Kyoto145A_1480 [Helicobacter pylori] diamond 93 60.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28708264 28708264 PRJEB83101_P_NODE_57807_length_263_cov_1.957895_g57502_i0 PRJEB83101 57807 263 1.957895 5.14926385 Desulfurellales bacterium 2482794 Bacteria Bacteria 120 3.7199999999999997e-32   NR TXH50932.1 2482794 g57502 i0 64.7 0.96958174904943 85 30 97 0 257 3 20 104 TXH50932.1 MAG: HNH endonuclease [Desulfurellales bacterium] diamond 255 120 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
29213540 29213540 PRJEB83101_P_NODE_56069_length_266_cov_1.492228_g55764_i0 PRJEB83101 56069 266 1.492228 3.96932648 Campylobacter majalis 2790656 Bacteria Bacteria 135 3.67e-39   NR CAD7289866.1 2790656 g55764 i0 97.3 0.845864661654135 75 2 84.6 0 225 1 1 75 CAD7289866.1 hypothetical protein LMG7974_01952 [Campylobacter majalis] diamond 225 135 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter majalis
30065807 30065807 PRJEB83101_P_NODE_24232_length_373_cov_2.623333_g23927_i0 PRJEB83101 24232 373 2.623333 9.78503209 Helicobacter pylori 210 Bacteria Bacteria 61.6 1.83e-9   NR GAA6799321.1 210 g23927 i0 100 0.20911528150134 26 0 20.9 0 346 269 1 26 GAA6799321.1 hypothetical protein Kyoto200A_1680 [Helicobacter pylori] diamond 78 61.6 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);;