RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA532380" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA532380 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
1779009 1779009 PRJNA532380_P_NODE_18682_length_208_cov_1.679245_g18357_i0 PRJNA532380 18682 208 1.679245 3.4928296 Poseidonibacter parvus 1850254 Bacteria Bacteria 370 4.43e-98   NTclustered gi|1133382777|gb|CP019070.1| 1850254 g18357 i0 99.029 358.331730769231 206 2 99 0 1 206 2092461 2092256 Poseidonibacter parvus strain LPB0137 chromosome, complete genome blastn 74533 370 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Poseidonibacter Poseidonibacter parvus
4331246 4331246 PRJNA532380_P_NODE_8164_length_332_cov_1.978799_g7839_i0 PRJNA532380 8164 332 1.978799 6.56961268 Poseidonibacter lekithochrous 1904463 Bacteria Bacteria 580 3.229999999999999e-161   NTclustered gi|1850313845|gb|CP054052.1| 1904463 g7839 i0 98.193 377.493975903614 332 6 100 0 1 332 292278 291947 Poseidonibacter lekithochrous strain DSM 100870 chromosome, complete genome blastn 125328 580 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Poseidonibacter Poseidonibacter lekithochrous
10045969 10045969 PRJNA532380_P_NODE_24528_length_180_cov_1.587786_g24203_i0 PRJNA532380 24528 180 1.587786 2.8580148 Arcobacteraceae 2808963 Bacteria Bacteria 320 3.79e-83   NTclustered gi|1231709647|emb|LT906455.1| 28197 g24203 i0 98.883 407.016666666667 179 2 99 0 2 180 852532 852354 Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1 blastn 73263 320 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
25343815 25343815 PRJNA532380_P_NODE_14060_length_241_cov_3.098958_g13735_i0 PRJNA532380 14060 241 3.098958 7.46848878 Arcobacter 28196 Bacteria Bacteria 337 5.35e-88   NTclustered gi|1509188976|gb|CP032363.1| 2320140 g13735 i0 92.083 340.917012448133 240 17 99 2 1 240 2762073 2762310 Arcobacter peruensis strain PSE-93 chromosome blastn 82161 339 0.994100294985251 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter peruensis

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