RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA309466", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 6 ✖

tax_phylum 1

  • Campylobacterota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA309466 · 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
3613644 3613644 PRJNA309466_P_NODE_2543_length_412_cov_1.862259_g2487_i0 PRJNA309466 2543 412 1.862259 7.67250708 Pseudomonadati 3379134 Bacteria Bacteria 761 0   NTclustered gi|1226876681|gb|CP022559.1| 197 g2487 i0 100 100 412 0 100 0 1 412 701750 702161 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 41200 761 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
8715610 8715610 PRJNA309466_P_NODE_13727_length_177_cov_1.765625_g13670_i0 PRJNA309466 13727 177 1.765625 3.12515625 Campylobacter 194 Bacteria Bacteria 318 1.34e-82   NTclustered gi|77379267|gb|DQ211918.1| 200 g13670 i0 99.432 131.491525423729 176 0 99 1 1 175 7 182 Campylobacter curvus isolate MDL 95M294 16S ribosomal RNA gene, partial sequence blastn 23274 318 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter curvus
12541701 12541701 PRJNA309466_P_NODE_7010_length_226_cov_0.881356_g6953_i0 PRJNA309466 7010 226 0.881356 1.99186456 root 1 Root_unresolved Root_unresolved 412 8.01e-111   NTclustered gi|1226876681|gb|CP022559.1| 197 g6953 i0 99.558 100 226 1 100 0 1 226 698866 698641 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 22600 412 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
15090865 15090865 PRJNA309466_P_NODE_6072_length_238_cov_1.587302_g6015_i0 PRJNA309466 6072 238 1.587302 3.77777876 Campylobacter 194 Bacteria Bacteria 435 1.8200000000000003e-117   NTclustered gi|1483583505|emb|LT631429.1| 204 g6015 i0 99.58 235.563025210084 238 1 100 0 1 238 30832 30595 Campylobacter showae genome assembly, plasmid: V blastn 56064 435 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
16954126 16954126 PRJNA309466_P_NODE_12534_length_183_cov_2.708955_g12477_i0 PRJNA309466 12534 183 2.708955 4.95738765 Campylobacter ureolyticus 827 Bacteria Bacteria 324 2.99e-84   NTclustered gi|1829985141|gb|CP050963.1| 827 g12477 i0 100 229.284153005464 175 0 96 0 2 176 204071 203897 Campylobacter ureolyticus strain FDAARGOS_673 chromosome blastn 41959 324 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
22740049 22740049 PRJNA309466_P_NODE_9738_length_201_cov_2.026316_g9681_i0 PRJNA309466 9738 201 2.026316 4.07289516 Campylobacter 194 Bacteria Bacteria 364 1.98e-96   NTclustered gi|1938724023|gb|CP060707.1| 199 g9681 i0 99.5 246.069651741294 200 1 99 0 1 200 724049 723850 Campylobacter concisus strain P1CDO2 chromosome, complete genome blastn 49460 364 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus

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