RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA404067" 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

  • PRJNA404067 · 5 ✖

analysis 1

  • blastn · 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
9342860 9342860 PRJNA404067_P_NODE_32528_length_207_cov_1.945205_g32141_i0 PRJNA404067 32528 207 1.945205 4.02657435 Peredibacter sp. HCB2-198 3383025 Bacteria Bacteria 261 2.7600000000000002e-65   NTclustered gi|2867657404|gb|CP174607.1| 3383025 g32141 i0 89.372 2 207 22 100 0 1 207 291686 291480 Peredibacter sp. HCB2-198 chromosome, complete genome blastn 414 261 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter sp. HCB2-198
10009501 10009501 PRJNA404067_P_NODE_38488_length_201_cov_1.221429_g38101_i0 PRJNA404067 38488 201 1.221429 2.45507229 Bdellovibrio 958 Bacteria Bacteria 187 4.5899999999999985e-43   NTclustered gi|485099167|ref|NR_102561.1| 959 g38101 i0 89.796 85.5223880597015 147 13 95 1 56 200 1748 1602 Bdellovibrio bacteriovorus strain Tiberius 23S ribosomal RNA gene, complete sequence blastn 17190 187 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio bacteriovorus
16992356 16992356 PRJNA404067_P_NODE_40174_length_196_cov_2.703704_g39787_i0 PRJNA404067 40174 196 2.703704 5.29925984 Bdellovibrio sp. HCB-162 3394234 Bacteria Bacteria 171 4.49e-38   NTclustered gi|2898207634|gb|CP178861.1| 3394234 g39787 i0 86.076 15.7551020408163 158 22 81 0 1 158 1623426 1623583 Bdellovibrio sp. HCB-162 chromosome, complete genome blastn 3088 171 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp. HCB-162
21483103 21483103 PRJNA404067_P_NODE_32017_length_208_cov_1.013605_g31630_i0 PRJNA404067 32017 208 1.013605 2.1082984 Bdellovibrio 958 Bacteria Bacteria 219 1.7e-52   NTclustered gi|2800924434|gb|CP168967.1| 959 g31630 i0 91.72 9.17307692307692 157 13 75 0 52 208 1332687 1332843 Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome blastn 1908 219 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio bacteriovorus
23366841 23366841 PRJNA404067_P_NODE_36719_length_203_cov_0.901408_g36332_i0 PRJNA404067 36719 203 0.901408 1.82985824 Bdellovibrio sp. SKB1291214 1732569 Bacteria Bacteria 54.7 0.005   NTclustered gi|2328635023|gb|CP106855.1| 1732569 g36332 i0 100 0.142857142857143 29 0 14 0 58 86 3006100 3006072 Bdellovibrio sp. SKB1291214 chromosome, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp. SKB1291214

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