contig_metadata
15 rows where bioproject = "PRJNA400391", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2356507 | 2356507 | PRJNA400391_S_NODE_842_length_375_cov_5.979412_g781_i0 | PRJNA400391 | 842 | 375 | 5.979412 | 22.422795 | Bacteriovorax | 146784 | Bacteria | Bacteria | 669 | 0 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g781 | i0 | 98.93 | 25.6506666666667 | 374 | 4 | 99 | 0 | 2 | 375 | 1661618 | 1661991 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 9619 | 669 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 3631902 | 3631902 | PRJNA400391_S_NODE_603_length_423_cov_9.180412_g543_i0 | PRJNA400391 | 603 | 423 | 9.180412 | 38.83314276 | Pseudobdellovibrionaceae | 213483 | Bacteria | Bacteria | 656 | 0 | NTclustered | gi|507148233|ref|NR_103040.1| | 453816 | g543 | i0 | 95.204 | 167.981087470449 | 417 | 16 | 98 | 3 | 10 | 423 | 999 | 584 | Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence | blastn | 71056 | 656 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 4241094 | 4241094 | PRJNA400391_S_NODE_1164_length_340_cov_86.619672_g1103_i0 | PRJNA400391 | 1164 | 340 | 86.619672 | 294.5068848 | Fluviispira vulneris | 2763012 | Bacteria | Bacteria | 364 | 3.6299999999999996e-96 | NTclustered | gi|1889345316|gb|MT879459.1| | 2763012 | g1103 | i0 | 91.078 | 111.4 | 269 | 24 | 79 | 0 | 72 | 340 | 68 | 336 | Fluviispira vulneris strain GX5518 16S ribosomal RNA gene, partial sequence | blastn | 37876 | 364 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Fluviispira | Fluviispira vulneris | ||
| 4241187 | 4241187 | PRJNA400391_S_NODE_4904_length_179_cov_165.458333_g4843_i0 | PRJNA400391 | 4904 | 179 | 165.458333 | 296.17041607 | uncultured Bdellovibrio sp. | 239744 | Bacteria | Bacteria | 257 | 2.99e-64 | NTclustered | gi|679036719|gb|KM016289.1| | 239744 | g4843 | i0 | 92.737 | 110.631284916201 | 179 | 12 | 99 | 1 | 2 | 179 | 65 | 243 | Uncultured Bdellovibrio sp. clone CO2-OTU4 16S ribosomal RNA gene, partial sequence | blastn | 19803 | 257 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | uncultured Bdellovibrio sp. | ||
| 7458991 | 7458991 | PRJNA400391_S_NODE_4686_length_184_cov_6.731544_g4625_i0 | PRJNA400391 | 4686 | 184 | 6.731544 | 12.38604096 | Bacteriovorax | 146784 | Bacteria | Bacteria | 331 | 1.8000000000000002e-86 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g4625 | i0 | 99.451 | 427.304347826087 | 182 | 1 | 99 | 0 | 1 | 182 | 1663203 | 1663022 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 78624 | 331 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 7459010 | 7459010 | PRJNA400391_S_NODE_626_length_419_cov_4.989583_g566_i0 | PRJNA400391 | 626 | 419 | 4.989583 | 20.90635277 | Bacteriovorax | 146784 | Bacteria | Bacteria | 664 | 0 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g566 | i0 | 95.227 | 165.195704057279 | 419 | 20 | 100 | 0 | 1 | 419 | 1660767 | 1660349 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 69217 | 664 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 8733898 | 8733898 | PRJNA400391_S_NODE_687_length_402_cov_4.534060_g627_i0 | PRJNA400391 | 687 | 402 | 4.53406 | 18.2269212 | Pseudobdellovibrio | 2862745 | Bacteria | Bacteria | 531 | 4.06e-146 | NTclustered | gi|507148233|ref|NR_103040.1| | 453816 | g627 | i0 | 90.547 | 267.649253731343 | 402 | 37 | 100 | 1 | 1 | 402 | 1111 | 1511 | Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence | blastn | 107595 | 531 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 11284312 | 11284312 | PRJNA400391_S_NODE_2169_length_271_cov_4.584746_g2108_i0 | PRJNA400391 | 2169 | 271 | 4.584746 | 12.42466166 | Bacteriovorax | 146784 | Bacteria | Bacteria | 460 | 3.4799999999999997e-125 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g2108 | i0 | 97.417 | 169.20295202952 | 271 | 5 | 99 | 2 | 1 | 270 | 1662353 | 1662622 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 45854 | 460 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 16383423 | 16383423 | PRJNA400391_S_NODE_2533_length_252_cov_4.087558_g2472_i0 | PRJNA400391 | 2533 | 252 | 4.087558 | 10.30064616 | Bdellovibrio | 958 | Bacteria | Bacteria | 401 | 1.9699999999999995e-107 | NTclustered | gi|2800917394|gb|CP168972.1| | 959 | g2472 | i0 | 95.6 | 93.6150793650794 | 250 | 11 | 99 | 0 | 3 | 252 | 749212 | 749461 | Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome | blastn | 23591 | 401 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 18265735 | 18265735 | PRJNA400391_S_NODE_5255_length_172_cov_3.248175_g5194_i0 | PRJNA400391 | 5255 | 172 | 3.248175 | 5.586861 | Bdellovibrio sp. qaytius | 1916293 | Bacteria | Bacteria | 154 | 3.84e-33 | NTclustered | gi|1552089877|gb|CP025734.1| | 1916293 | g5194 | i0 | 83.14 | 125.854651162791 | 172 | 25 | 99 | 4 | 1 | 170 | 666000 | 665831 | Bdellovibrio sp. qaytius chromosome, complete genome | blastn | 21647 | 154 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. qaytius | ||
| 20815685 | 20815685 | PRJNA400391_S_NODE_1997_length_280_cov_18.685714_g1936_i0 | PRJNA400391 | 1997 | 280 | 18.685714 | 52.3199992 | Bacteriovorax stolpii | 960 | Bacteria | Bacteria | 405 | 1.72e-108 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g1936 | i0 | 94.007 | 310.292857142857 | 267 | 16 | 95 | 0 | 1 | 267 | 1661394 | 1661128 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 86882 | 405 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 22090477 | 22090477 | PRJNA400391_S_NODE_1878_length_287_cov_4.567460_g1817_i0 | PRJNA400391 | 1878 | 287 | 4.56746 | 13.1086102 | Peredibacter sp. HCB2-198 | 3383025 | Bacteria | Bacteria | 470 | 6.18e-128 | NTclustered | gi|2867657404|gb|CP174607.1| | 3383025 | g1817 | i0 | 96.167 | 32.5783972125436 | 287 | 11 | 100 | 0 | 1 | 287 | 1292599 | 1292313 | Peredibacter sp. HCB2-198 chromosome, complete genome | blastn | 9350 | 470 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter sp. HCB2-198 | ||
| 22090582 | 22090582 | PRJNA400391_S_NODE_5978_length_160_cov_4.000000_g5917_i0 | PRJNA400391 | 5978 | 160 | 4 | 6.4 | uncultured Bacteriovorax sp. | 346638 | Bacteria | Bacteria | 296 | 5.55e-76 | NTclustered | gi|1820356865|gb|MT177531.1| | 346638 | g5917 | i0 | 100 | 99.99375 | 160 | 0 | 100 | 0 | 1 | 160 | 194 | 35 | Uncultured Bacteriovorax sp. clone 197 16S ribosomal RNA gene, partial sequence | blastn | 15999 | 296 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | uncultured Bacteriovorax sp. | ||
| 24032811 | 24032811 | PRJNA400391_S_NODE_499_length_451_cov_4.360577_g439_i0 | PRJNA400391 | 499 | 451 | 4.360577 | 19.66620227 | Peredibacter | 263370 | Bacteria | Bacteria | 667 | 0 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g439 | i0 | 94.091 | 131.70066518847 | 440 | 24 | 97 | 2 | 13 | 451 | 512566 | 512128 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 59397 | 667 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 25307177 | 25307177 | PRJNA400391_S_NODE_280_length_532_cov_10.543260_g226_i0 | PRJNA400391 | 280 | 532 | 10.54326 | 56.0901432 | Pseudobdellovibrio | 2862745 | Bacteria | Bacteria | 540 | 9.14e-149 | NTclustered | gi|507148233|ref|NR_103040.1| | 453816 | g226 | i0 | 85.165 | 203.586466165414 | 546 | 60 | 100 | 18 | 1 | 532 | 584 | 1122 | Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence | blastn | 108308 | 540 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus |
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);;