RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA832865" 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

  • PRJNA832865 · 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
16531289 16531289 PRJNA832865_S_NODE_55053_length_338_cov_1.162264_g49967_i0 PRJNA832865 55053 338 1.162264 3.92845232 Pseudomonadati 3379134 Bacteria Bacteria 76.3 1.43e-13   NR MCB4773626.1 1969726 g49967 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.
30812864 30812864 PRJNA832865_S_NODE_89874_length_257_cov_1.635870_g84788_i0 PRJNA832865 89874 257 1.63587 4.2041859 Sulfurovum sp. 1969726 Bacteria Bacteria 48.9 2.89e-4   NR MCB4781100.1 1969726 g84788 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.
31856172 31856172 PRJNA832865_S_NODE_68877_length_297_cov_2.285714_g63791_i0 PRJNA832865 68877 297 2.285714 6.78857058 Arcobacteraceae bacterium 2808971 Bacteria Bacteria 43.9 0.0259   NR MCK5293339.1 2808971 g63791 i0 40.7 0.595959595959596 59 33 59.6 1 266 90 47 103 MCK5293339.1 NnrS family protein [Arcobacteraceae bacterium] diamond 177 43.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae   Arcobacteraceae bacterium

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