RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA909412", tax_kingdom = "Pseudomonadati" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 4 ✖

tax_kingdom 1

  • Pseudomonadati · 4 ✖

bioproject 1

  • PRJNA909412 · 4 ✖

analysis 1

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
27688267 27688267 PRJNA909412_P_NODE_15444_length_154_cov_1.765217_g15303_i0 PRJNA909412 15444 154 1.765217 2.71843418 Halobacteriovoraceae bacterium 2026745 Bacteria Bacteria 72.8 2.69e-13   NR MCB9091039.1 2026745 g15303 i0 66.7 4.75324675324675 48 16 93.5 0 149 6 381 428 MCB9091039.1 threonine--tRNA ligase [Halobacteriovoraceae bacterium] diamond 732 72.8 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Halobacteriovoraceae   Halobacteriovoraceae bacterium
28295156 28295156 PRJNA909412_P_NODE_8346_length_184_cov_2.275862_g8205_i0 PRJNA909412 8346 184 2.275862 4.18758608 Bacteriovorax 146784 Bacteria Bacteria 72 5.48e-13   NR WP_142409471.1 960 g8205 i0 67.9 3.44021739130435 53 17 86.4 0 18 176 1 53 WP_142409471.1 adenosine kinase [Bacteriovorax stolpii] diamond 633 72 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii
28982631 28982631 PRJNA909412_P_NODE_6848_length_201_cov_2.302469_g6707_i0 PRJNA909412 6848 201 2.302469 4.62796269 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 55.8 1.88e-7   NR MCB0371038.1 2053517 g6707 i0 46.8 0.701492537313433 47 25 70.1 0 5 145 137 183 MCB0371038.1 cation transporting ATPase C-terminal domain-containing protein [Bdellovibrionales bacterium] diamond 141 55.8 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
31920979 31920979 PRJNA909412_P_NODE_8937_length_179_cov_1.178571_g8796_i0 PRJNA909412 8937 179 1.178571 2.10964209 Bacteriovorax stolpii 960 Bacteria Bacteria 104 4.46e-25   NR WP_142409471.1 960 g8796 i0 81.4 1.97765363128492 59 11 98.9 0 2 178 87 145 WP_142409471.1 adenosine kinase [Bacteriovorax stolpii] diamond 354 104 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii

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