RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA768450" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA768450 · 4 ✖

analysis 1

  • diamond · 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
28474444 28474444 PRJNA768450_S_NODE_2826_length_362_cov_12.015974_g2777_i0 PRJNA768450 2826 362 12.015974 43.49782588 Enterobacter hormaechei 158836 Bacteria Bacteria 124 6.2099999999999985e-34   NR WP_096179768.1 158836 g2777 i0 96.4 0.92817679558011 112 4 92.8 0 338 3 1 112 WP_096179768.1 hypothetical protein, partial [Enterobacter hormaechei] diamond 336 124 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter hormaechei
29895365 29895365 PRJNA768450_S_NODE_6031_length_268_cov_2.068493_g5982_i0 PRJNA768450 6031 268 2.068493 5.54356124 Roseovarius sp. C7 3398643 Bacteria Bacteria 45.4 0.00514   NR WP_416005436.1 3398643 g5982 i0 32.8 0.75 67 38 68.3 2 45 227 209 274 WP_416005436.1 glycosyltransferase family 2 protein [Roseovarius sp. C7] diamond 201 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Roseobacteraceae Roseovarius Roseovarius sp. C7
29990070 29990070 PRJNA768450_S_NODE_22711_length_164_cov_0.878261_g22662_i0 PRJNA768450 22711 164 0.878261 1.44034804 uncultured Pseudomonas sp. 114707 Bacteria Bacteria 110 2.69e-28   NR WP_288522084.1 114707 g22662 i0 98.1 1.97560975609756 54 1 98.8 0 3 164 157 210 WP_288522084.1 RelA/SpoT domain-containing protein [uncultured Pseudomonas sp.] diamond 324 110 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas uncultured Pseudomonas sp.
30590273 30590273 PRJNA768450_P_NODE_753_length_374_cov_6.994203_g683_i0 PRJNA768450 753 374 6.994203 26.15831922 Salmonella sp. ZJHZ21_ 599 Bacteria Bacteria 42.7 0.0238   NR WP_395236951.1 3160111 g683 i0 42.9 0.336898395721925 42 24 33.7 0 195 320 15 56 WP_395236951.1 glycoside hydrolase family 3 N-terminal domain-containing protein, partial [Salmonella sp. ZJHZ21_0184] diamond 126 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella sp. ZJHZ21_0184

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