RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA573544 · 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
26649758 26649758 PRJNA573544_P_NODE_6061_length_250_cov_0.881356_g6043_i0 PRJNA573544 6061 250 0.881356 2.20339 Tahibacter 1453544 Bacteria Bacteria 132 1.2699999999999998e-35   NR HVH33847.1 2056211 g6043 i0 79.5 2.988 83 17 99.6 0 2 250 163 245 HVH33847.1 ABC transporter permease [Tahibacter sp.] diamond 747 132 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Rhodanobacteraceae Tahibacter Tahibacter sp.
27661939 27661939 PRJNA573544_P_NODE_6144_length_250_cov_0.881356_g6126_i0 PRJNA573544 6144 250 0.881356 2.20339 Sphingomonadaceae 41297 Bacteria Bacteria 163 1.58e-44   NR WP_062126125.1 152682 g6126 i0 100 1.92 80 0 96 0 248 9 782 861 WP_062126125.1 type IV secretion system protein TraC [Sphingomonas melonis] diamond 480 163 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas melonis
28406008 28406008 PRJNA573544_P_NODE_5406_length_253_cov_0.866667_g5388_i0 PRJNA573544 5406 253 0.866667 2.19266751 Sphingomonas sp. TX 28214 Bacteria Bacteria 171 5.58e-48   NR WP_198356560.1 2479205 g5388 i0 100 0.99604743083004 84 0 99.6 0 252 1 81 164 WP_198356560.1 phage terminase large subunit family protein, partial [Sphingomonas sp. TX0522] diamond 252 171 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp. TX0522
31501819 31501819 PRJNA573544_P_NODE_7236_length_245_cov_0.906977_g7218_i0 PRJNA573544 7236 245 0.906977 2.22209365 Sphingomonas 13687 Bacteria Bacteria 129 1.87e-36   NR WP_203309122.1 13687 g7218 i0 100 0.808163265306122 66 0 80.8 0 243 46 57 122 WP_203309122.1 MULTISPECIES: hypothetical protein [Sphingomonas] diamond 198 129 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas  

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