RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA798511" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA798511 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
8870944 8870944 PRJNA798511_P_NODE_54267_length_338_cov_1.162264_g50001_i0 PRJNA798511 54267 338 1.162264 3.92845232 Pseudomonadati 3379134 Bacteria Bacteria 76.3 1.43e-13   NR MCB4773626.1 1969726 g50001 i0 41.2 3.78994082840237 85 49 75.4 1 311 57 253 336 MCB4773626.1 reverse transcriptase family protein [Sulfurovum sp.] diamond 1281 76.6 0.996083550913838 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
27054028 27054028 PRJNA798511_P_NODE_66762_length_297_cov_2.285714_g62496_i0 PRJNA798511 66762 297 2.285714 6.78857058 Arcobacteraceae bacterium 2808971 Bacteria Bacteria 43.9 0.0259   NR MCK5293339.1 2808971 g62496 i0 40.7 0.595959595959596 59 33 59.6 1 32 208 47 103 MCK5293339.1 NnrS family protein [Arcobacteraceae bacterium] diamond 177 43.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae   Arcobacteraceae bacterium
32235632 32235632 PRJNA798511_P_NODE_84658_length_257_cov_1.635870_g80392_i0 PRJNA798511 84658 257 1.63587 4.2041859 Sulfurovum sp. 1969726 Bacteria Bacteria 48.9 2.89e-4   NR MCB4781100.1 1969726 g80392 i0 37.1 1.63424124513619 70 35 71.2 1 190 8 380 449 MCB4781100.1 hypothetical protein [Sulfurovum sp.] diamond 420 48.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.

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