RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA801875" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA801875 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
27054216 27054216 PRJNA801875_P_NODE_4362_length_156_cov_3.165289_g4259_i0 PRJNA801875 4362 156 3.165289 4.93785084 Pseudobdellovibrionaceae bacterium 2026715 Bacteria Bacteria 83.2 3.6e-17   NR MFA7277246.1 2026715 g4259 i0 76 0.961538461538462 50 12 96.2 0 151 2 26 75 MFA7277246.1 alkene reductase [Pseudobdellovibrionaceae bacterium] diamond 150 83.2 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae   Pseudobdellovibrionaceae bacterium
29936741 29936741 PRJNA801875_P_NODE_3091_length_189_cov_1.500000_g2988_i0 PRJNA801875 3091 189 1.5 2.835 Pseudomonadati 3379134 Bacteria Bacteria 114 1.03e-27   NR NUN04832.1 28201 g2988 i0 86.7 36.3174603174603 60 8 95.2 0 184 5 489 548 NUN04832.1 acetate--CoA ligase [Bdellovibrio sp.] diamond 6864 115 0.991304347826087 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp.
30243862 30243862 PRJNA801875_P_NODE_1912_length_267_cov_1.943966_g1809_i0 PRJNA801875 1912 267 1.943966 5.19038922 Bacteriovorax stolpii 960 Bacteria Bacteria 74.7 2.72e-13   NR WP_102242354.1 960 g1809 i0 54.5 1.48314606741573 66 29 74.2 1 225 28 6 70 WP_102242354.1 NAD-dependent epimerase/dehydratase family protein [Bacteriovorax stolpii] diamond 396 74.7 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii
30622710 30622710 PRJNA801875_P_NODE_2473_length_219_cov_2.163043_g2370_i0 PRJNA801875 2473 219 2.163043 4.73706417 Bacteriovoracaceae bacterium 2081706 Bacteria Bacteria 65.9 1.19e-11   NR MFT6069331.1 2081706 g2370 i0 58.1 4.28767123287671 43 18 58.9 0 88 216 63 105 MFT6069331.1 putative membrane protein YedE/YeeE [Bacteriovoracaceae bacterium] diamond 939 65.9 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae   Bacteriovoracaceae bacterium
31919117 31919117 PRJNA801875_P_NODE_877_length_447_cov_1.667476_g775_i0 PRJNA801875 877 447 1.667476 7.45361772 Bdellovibrionia bacterium 3034169 Bacteria Bacteria 206 4.13e-63   NR MEO5969990.1 3034169 g775 i0 67.4 0.966442953020134 144 47 96.6 0 440 9 85 228 MEO5969990.1 NAD(P)H-quinone oxidoreductase [Bdellovibrionia bacterium] diamond 432 206 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia       Bdellovibrionia 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);;