RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1072736 · 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
27288606 27288606 PRJNA1072736_S_NODE_1983_length_244_cov_2.338308_g1978_i0 PRJNA1072736 1983 244 2.338308 5.70547152 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 45.1 0.00434   NR WP_395587210.1 251699 g1978 i0 40 0.983606557377049 80 42 92.2 4 229 5 126 204 WP_395587210.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 240 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
27731081 27731081 PRJNA1072736_S_NODE_2244_length_233_cov_2.878947_g2239_i0 PRJNA1072736 2244 233 2.878947 6.70794651 Shigella sonnei 624 Bacteria Bacteria 82.8 9.47e-19   NR WP_353763804.1 624 g2239 i0 95.5 0.566523605150215 44 2 56.7 0 102 233 38 81 WP_353763804.1 hypothetical protein, partial [Shigella sonnei] diamond 132 82.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
27754101 27754101 PRJNA1072736_S_NODE_2964_length_211_cov_3.017857_g2959_i0 PRJNA1072736 2964 211 3.017857 6.36767827 root 1 Root_unresolved Root_unresolved 42.4 0.00431   NR WP_217900948.1 573 g2959 i0 54.8 0.881516587677725 31 13 42.7 1 2 91 3 33 WP_217900948.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 186 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32312335 32312335 PRJNA1072736_S_NODE_1559_length_264_cov_1.647059_g1554_i0 PRJNA1072736 1559 264 1.647059 4.34823576 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 112 1.8e-27   NR RLA04755.1 1913989 g1554 i0 68.6 1.95454545454545 86 27 97.7 0 260 3 77 162 RLA04755.1 MAG: hypothetical protein DRQ45_00060 [Gammaproteobacteria bacterium] diamond 516 112 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria 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);;