contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1233465" and tax_phylum = "Bdellovibrionota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25531197 | 25531197 | PRJNA1233465a_S_NODE_133089_length_205_cov_1.282051_g131815_i0 | PRJNA1233465 | 133089 | 205 | 1.282051 | 2.62820455 | Fluviispira sanaruensis | 2493639 | Bacteria | Bacteria | 52.8 | 0.018 | NTclustered | gi|1566193515|dbj|AP019368.1| | 2493639 | g131815 | i0 | 100 | 0.136585365853659 | 28 | 0 | 14 | 0 | 40 | 67 | 1116180 | 1116207 | Silvanigrellales bacterium RF1110005 DNA, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Fluviispira | Fluviispira sanaruensis | ||
| 25538427 | 25538427 | PRJNA1233465b_S_NODE_265721_length_185_cov_1.154412_g264036_i0 | PRJNA1233465 | 265721 | 185 | 1.154412 | 2.1356622 | Bacteriovorax sp. HI3 | 2984118 | Bacteria | Bacteria | 52.8 | 0.016 | NTclustered | gi|2321225508|dbj|AP026946.1| | 2984118 | g264036 | i0 | 96.774 | 0.167567567567568 | 31 | 1 | 17 | 0 | 52 | 82 | 1329933 | 1329963 | Bacteriovorax sp. HI3 DNA, complete genome | blastn | 31 | 52.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax sp. HI3 | ||
| 25674011 | 25674011 | PRJNA1233465b_S_NODE_237242_length_194_cov_4.096552_g235557_i0 | PRJNA1233465 | 237242 | 194 | 4.096552 | 7.94731088 | Bdellovibrio sp. HCB2 | 28201 | Bacteria | Bacteria | 244 | 2.57e-60 | NTclustered | gi|2895998570|gb|CP178618.1| | 3394354 | g235557 | i0 | 90.71 | 3.77319587628866 | 183 | 17 | 94 | 0 | 12 | 194 | 2030324 | 2030142 | Bdellovibrio sp. HCB209 chromosome, complete genome | blastn | 732 | 244 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB209 | ||
| 25953079 | 25953079 | PRJNA1233465d_S_NODE_76724_length_203_cov_2.558442_g75613_i0 | PRJNA1233465 | 76724 | 203 | 2.558442 | 5.19363726 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 60.2 | 1.06e-4 | NTclustered | gi|1950812799|gb|CP066681.1| | 349221 | g75613 | i0 | 92.857 | 0.206896551724138 | 42 | 2 | 21 | 1 | 121 | 162 | 557394 | 557434 | Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome | blastn | 42 | 60.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 26211541 | 26211541 | PRJNA1233465a_S_NODE_123238_length_211_cov_1.561728_g121964_i0 | PRJNA1233465 | 123238 | 211 | 1.561728 | 3.29524608 | Bdellovibrio sp. CKG | 28201 | Bacteria | Bacteria | 268 | 1.6899999999999994e-67 | NTclustered | gi|2663425168|dbj|AP029173.1| | 3113893 | g121964 | i0 | 89.573 | 1 | 211 | 22 | 100 | 0 | 1 | 211 | 2081821 | 2082031 | Bdellovibrio sp. CKG001 DNA, complete genome | blastn | 211 | 268 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. CKG001 | ||
| 26231644 | 26231644 | PRJNA1233465e_S_NODE_95910_length_196_cov_1.387755_g94600_i0 | PRJNA1233465 | 95910 | 196 | 1.387755 | 2.7199998 | Bdellovibrio sp. TP | 743912 | Bacteria | Bacteria | 56.5 | 0.001 | NTclustered | gi|290909000|gb|GQ273740.1| | 743912 | g94600 | i0 | 100 | 0.295918367346939 | 30 | 0 | 15 | 0 | 165 | 194 | 701 | 672 | Bdellovibrio sp. TP 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 58 | 56.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. TP | ||
| 26348822 | 26348822 | PRJNA1233465a_S_NODE_183239_length_180_cov_1.167939_g181965_i0 | PRJNA1233465 | 183239 | 180 | 1.167939 | 2.1022902 | Bdellovibrio sp. HCB2 | 28201 | Bacteria | Bacteria | 145 | 2.45e-30 | NTclustered | gi|2895998570|gb|CP178618.1| | 3394354 | g181965 | i0 | 82.081 | 0.961111111111111 | 173 | 27 | 95 | 4 | 10 | 180 | 3006868 | 3006698 | Bdellovibrio sp. HCB209 chromosome, complete genome | blastn | 173 | 145 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB209 | ||
| 26371896 | 26371896 | PRJNA1233465f_S_NODE_198943_length_178_cov_1.565891_g196663_i0 | PRJNA1233465 | 198943 | 178 | 1.565891 | 2.78728598 | Bacteriovorax sp. HI3 | 2984118 | Bacteria | Bacteria | 161 | 2.4e-35 | NTclustered | gi|2321225508|dbj|AP026946.1| | 2984118 | g196663 | i0 | 83.051 | 2.95505617977528 | 177 | 30 | 99 | 0 | 1 | 177 | 3379340 | 3379164 | Bacteriovorax sp. HI3 DNA, complete genome | blastn | 526 | 161 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax sp. HI3 | ||
| 26489475 | 26489475 | PRJNA1233465b_S_NODE_150768_length_235_cov_1.903226_g149083_i0 | PRJNA1233465 | 150768 | 235 | 1.903226 | 4.4725811 | Bdellovibrio sp. HCB2 | 28201 | Bacteria | Bacteria | 195 | 3.31e-45 | NTclustered | gi|2895998570|gb|CP178618.1| | 3394354 | g149083 | i0 | 83.256 | 6.03404255319149 | 215 | 32 | 91 | 4 | 4 | 216 | 3006794 | 3006582 | Bdellovibrio sp. HCB209 chromosome, complete genome | blastn | 1418 | 195 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB209 | ||
| 26493720 | 26493720 | PRJNA1233465d_S_NODE_106312_length_178_cov_1.201550_g105201_i0 | PRJNA1233465 | 106312 | 178 | 1.20155 | 2.138759 | Bacteriovorax sp. HI3 | 2984118 | Bacteria | Bacteria | 150 | 5.19e-32 | NTclustered | gi|2321225508|dbj|AP026946.1| | 2984118 | g105201 | i0 | 81.921 | 2.95505617977528 | 177 | 32 | 99 | 0 | 1 | 177 | 3379340 | 3379164 | Bacteriovorax sp. HI3 DNA, complete genome | blastn | 526 | 150 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax sp. HI3 |
Advanced export
JSON shape: default, array, newline-delimited
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);;