RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA839281 · 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
26643007 26643007 PRJNA839281_S_NODE_29861_length_165_cov_0.879310_g29592_i0 PRJNA839281 29861 165 0.87931 1.4508615 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 57 1.22e-7   NR MBY0412862.1 2053517 g29592 i0 68.2 0.8 44 13 78.2 1 165 37 401 444 MBY0412862.1 IS1380 family transposase [Bdellovibrionales bacterium] diamond 132 57 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
27220925 27220925 PRJNA839281_S_NODE_20142_length_185_cov_2.507353_g19873_i0 PRJNA839281 20142 185 2.507353 4.63860305 root 1 Root_unresolved Root_unresolved 76.3 1.12e-14   NR RME14072.1 28201 g19873 i0 62.3 5.93513513513513 61 22 98.9 1 185 3 94 153 RME14072.1 MAG: pyridoxal-phosphate dependent enzyme, partial [Bdellovibrio sp.] diamond 1098 76.6 0.996083550913838 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp.
30465724 30465724 PRJNA839281_S_NODE_35373_length_162_cov_0.902655_g35104_i0 PRJNA839281 35373 162 0.902655 1.4623011 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 75.9 2.37e-14   NR MBS1985076.1 2053517 g35104 i0 61.5 0.962962962962963 52 20 96.3 0 5 160 105 156 MBS1985076.1 hypothetical protein [Bdellovibrionales bacterium] diamond 156 75.9 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
32014509 32014509 PRJNA839281_S_NODE_28858_length_166_cov_0.871795_g28589_i0 PRJNA839281 28858 166 0.871795 1.4471797 Bacteriovoracaceae bacterium 2081706 Bacteria Bacteria 57.4 8.65e-8   NR MBY0518778.1 2081706 g28589 i0 72.5 0.72289156626506 40 10 72.3 1 164 45 1023 1061 MBY0518778.1 hypothetical protein [Bacteriovoracaceae bacterium] diamond 120 57.4 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae   Bacteriovoracaceae 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);;