RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB4632" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB4632 · 6 ✖

analysis 1

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
1335890 1335890 PRJEB4632_P_NODE_302_length_426_cov_3.116147_g264_i0 PRJEB4632 302 426 3.1161469999999998 13.27478622 Campylobacter showae 204 Bacteria Bacteria 776 0   NTclustered gi|1483583529|emb|LT631453.1| 204 g264 i0 99.531 249.816901408451 426 2 100 0 1 426 390825 390400 Campylobacter showae strain B91_SCBr genome assembly, chromosome: I blastn 106422 776 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
6439708 6439708 PRJEB4632_P_NODE_826_length_248_cov_1.462857_g788_i0 PRJEB4632 826 248 1.462857 3.62788536 Campylobacter showae 204 Bacteria Bacteria 459 1.13e-124   NTclustered gi|1483583529|emb|LT631453.1| 204 g788 i0 100 237.947580645161 248 0 100 0 1 248 390089 390336 Campylobacter showae strain B91_SCBr genome assembly, chromosome: I blastn 59011 459 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
7367601 7367601 PRJEB4632_P_NODE_1006_length_235_cov_3.796296_g968_i0 PRJEB4632 1006 235 3.796296 8.9212956 Campylobacter 194 Bacteria Bacteria 435 1.79e-117   NTclustered gi|1207769205|gb|MF351718.1| 199 g968 i0 100 250 235 0 100 0 1 235 1155 921 Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence blastn 58750 435 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
11193420 11193420 PRJEB4632_P_NODE_769_length_251_cov_0.865169_g731_i0 PRJEB4632 769 251 0.865169 2.17157419 Campylobacter 194 Bacteria Bacteria 459 1.1499999999999996e-124   NTclustered gi|285196851|gb|GU427165.1| 204 g731 i0 99.602 103.98406374502 251 1 100 0 1 251 255 5 Campylobacter showae clone EO016 16S ribosomal RNA gene, partial sequence blastn 26100 459 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
15017868 15017868 PRJEB4632_P_NODE_332_length_399_cov_2.690184_g294_i0 PRJEB4632 332 399 2.690184 10.73383416 Arcobacter 28196 Bacteria Bacteria 737 0   NTclustered gi|1847331607|gb|CP053835.1| 873191 g294 i0 100 410.84962406015 399 0 100 0 1 399 1010550 1010948 Arcobacter defluvii strain LMG 25694 chromosome, complete genome blastn 163929 737 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter defluvii
20116581 20116581 PRJEB4632_P_NODE_1056_length_222_cov_4.906040_g1018_i0 PRJEB4632 1056 222 4.90604 10.8914088 Arcobacter 28196 Bacteria Bacteria 411 2.8199999999999996e-110   NTclustered gi|1474790806|gb|CP032100.1| 663365 g1018 i0 100 366.86036036036 222 0 100 0 1 222 1733096 1733317 Arcobacter suis CECT 7833 chromosome, complete genome blastn 81443 411 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter suis

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