contig_metadata
16 rows where bioproject = "PRJNA1115053", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 224912 | 224912 | PRJNA1115053_S_NODE_2081_length_1111_cov_28.750000_g1216_i2 | PRJNA1115053 | 2081 | 1111 | 28.75 | 319.4125 | Peredibacter sp. HCB2-198 | 3383025 | Bacteria | Bacteria | 1581 | 0 | NTclustered | gi|2867657404|gb|CP174607.1| | 3383025 | g1216 | i2 | 94 | 116.740774077408 | 1050 | 54 | 94 | 9 | 26 | 1071 | 1292260 | 1293304 | Peredibacter sp. HCB2-198 chromosome, complete genome | blastn | 129699 | 1581 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter sp. HCB2-198 | ||
| 1499208 | 1499208 | PRJNA1115053_S_NODE_1862_length_1170_cov_29.196983_g1216_i0 | PRJNA1115053 | 1862 | 1170 | 29.196983 | 341.6047011 | Peredibacter sp. HCB2-198 | 3383025 | Bacteria | Bacteria | 1633 | 0 | NTclustered | gi|2867657404|gb|CP174607.1| | 3383025 | g1216 | i0 | 92.509 | 121.223931623932 | 1148 | 74 | 98 | 11 | 26 | 1168 | 1292260 | 1293400 | Peredibacter sp. HCB2-198 chromosome, complete genome | blastn | 141832 | 1633 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter sp. HCB2-198 | ||
| 5325517 | 5325517 | PRJNA1115053_S_NODE_108325_length_251_cov_1.836538_g106508_i0 | PRJNA1115053 | 108325 | 251 | 1.836538 | 4.60971038 | Pseudobdellovibrio exovorus | 453816 | Bacteria | Bacteria | 121 | 6.149999999999999e-23 | NTclustered | gi|469929247|gb|CP003537.1| | 1184267 | g106508 | i0 | 91.86 | 14.4501992031873 | 86 | 7 | 34 | 0 | 162 | 247 | 1628941 | 1628856 | Bdellovibrio exovorus JSS, complete genome | blastn | 3627 | 121 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 7877580 | 7877580 | PRJNA1115053_S_NODE_197307_length_195_cov_1.578947_g195490_i0 | PRJNA1115053 | 197307 | 195 | 1.578947 | 3.07894665 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 195 | 2.65e-45 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g195490 | i0 | 87.574 | 2.57948717948718 | 169 | 19 | 87 | 2 | 1 | 169 | 454843 | 455009 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 503 | 195 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 10428089 | 10428089 | PRJNA1115053_S_NODE_1909_length_1155_cov_31.101619_g1216_i1 | PRJNA1115053 | 1909 | 1155 | 31.101619 | 359.22369945 | Peredibacter sp. HCB2-198 | 3383025 | Bacteria | Bacteria | 1971 | 0 | NTclustered | gi|2867657404|gb|CP174607.1| | 3383025 | g1216 | i1 | 98.142 | 149.506493506494 | 1130 | 21 | 98 | 0 | 1 | 1130 | 1293389 | 1292260 | Peredibacter sp. HCB2-198 chromosome, complete genome | blastn | 172680 | 1971 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter sp. HCB2-198 | ||
| 18079240 | 18079240 | PRJNA1115053_S_NODE_32615_length_390_cov_9.132565_g30802_i0 | PRJNA1115053 | 32615 | 390 | 9.132565 | 35.6170035 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 664 | 0 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g30802 | i0 | 97.436 | 85.6102564102564 | 390 | 9 | 100 | 1 | 1 | 390 | 512145 | 512533 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 33388 | 664 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 18876252 | 18876252 | PRJNA1115053_S_NODE_319375_length_156_cov_2.123894_g317558_i0 | PRJNA1115053 | 319375 | 156 | 2.123894 | 3.31327464 | Peredibacter | 263370 | Bacteria | Bacteria | 278 | 1.95e-70 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g317558 | i0 | 98.718 | 126.134615384615 | 156 | 2 | 100 | 0 | 1 | 156 | 512707 | 512862 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 19677 | 278 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 18876335 | 18876335 | PRJNA1115053_S_NODE_37035_length_373_cov_12.145455_g35220_i0 | PRJNA1115053 | 37035 | 373 | 12.145455 | 45.30254715 | Peredibacter | 263370 | Bacteria | Bacteria | 549 | 1.0299999999999996e-151 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g35220 | i0 | 95.115 | 87.4477211796247 | 348 | 17 | 93 | 0 | 26 | 373 | 508831 | 509178 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 32618 | 549 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 24449622 | 24449622 | PRJNA1115053_S_NODE_143660_length_223_cov_3.305556_g141843_i0 | PRJNA1115053 | 143660 | 223 | 3.305556 | 7.37138988 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 268 | 1.81e-67 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g141843 | i0 | 88.341 | 1 | 223 | 26 | 100 | 0 | 1 | 223 | 2936719 | 2936497 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 223 | 268 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 26973024 | 26973024 | PRJNA1115053_S_NODE_134542_length_230_cov_1.149733_g132725_i0 | PRJNA1115053 | 134542 | 230 | 1.149733 | 2.6443859 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 149 | 6.95e-44 | NR | HEY8278323.1 | 3034175 | g132725 | i0 | 97.3 | 0.965217391304348 | 74 | 2 | 96.5 | 0 | 228 | 7 | 116 | 189 | HEY8278323.1 TraR/DksA C4-type zinc finger protein [Bdellovibrionota bacterium] | diamond | 222 | 149 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 28804688 | 28804688 | PRJNA1115053_S_NODE_50628_length_335_cov_2.794521_g48811_i0 | PRJNA1115053 | 50628 | 335 | 2.794521 | 9.36164535 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 67 | 1.73e-10 | NR | HEY8278372.1 | 3034175 | g48811 | i0 | 52.4 | 0.564179104477612 | 63 | 30 | 56.4 | 0 | 333 | 145 | 8 | 70 | HEY8278372.1 cell envelope integrity protein TolA [Bdellovibrionota bacterium] | diamond | 189 | 67 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 28985700 | 28985700 | PRJNA1115053_S_NODE_219828_length_186_cov_1.342657_g218011_i0 | PRJNA1115053 | 219828 | 186 | 1.342657 | 2.49734202 | Peredibacter | 263370 | Bacteria | Bacteria | 102 | 5.57e-24 | NR | WP_321392745.1 | 28202 | g218011 | i0 | 83.6 | 3.95161290322581 | 61 | 10 | 98.4 | 0 | 184 | 2 | 57 | 117 | WP_321392745.1 FecR family protein [Peredibacter starrii] | diamond | 735 | 102 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 29593899 | 29593899 | PRJNA1115053_S_NODE_291470_length_163_cov_2.683333_g289653_i0 | PRJNA1115053 | 291470 | 163 | 2.683333 | 4.37383279 | Bacteriovoracia bacterium | 3058048 | Bacteria | Bacteria | 83.6 | 4.62e-17 | NR | MFP5385936.1 | 3058048 | g289653 | i0 | 75.5 | 0.975460122699387 | 53 | 13 | 97.5 | 0 | 161 | 3 | 318 | 370 | MFP5385936.1 aldehyde dehydrogenase family protein [Bacteriovoracia bacterium] | diamond | 159 | 83.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracia bacterium | |||||
| 32566041 | 32566041 | PRJNA1115053_S_NODE_110359_length_249_cov_1.985437_g108542_i0 | PRJNA1115053 | 110359 | 249 | 1.985437 | 4.94373813 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 60.1 | 4.44e-9 | NR | HEX4924822.1 | 2053517 | g108542 | i0 | 46.3 | 0.807228915662651 | 67 | 34 | 78.3 | 1 | 53 | 247 | 4 | 70 | HEX4924822.1 GNAT family N-acetyltransferase [Bdellovibrionales bacterium] | diamond | 201 | 60.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32597373 | 32597373 | PRJNA1115053_S_NODE_74140_length_291_cov_2.322581_g72323_i0 | PRJNA1115053 | 74140 | 291 | 2.322581 | 6.75871071 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 77 | 4.65e-14 | NR | HEY8278704.1 | 3034175 | g72323 | i0 | 48 | 1.01030927835052 | 98 | 41 | 91.8 | 2 | 285 | 19 | 107 | 203 | HEY8278704.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 294 | 77 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 32628555 | 32628555 | PRJNA1115053_S_NODE_81060_length_281_cov_2.983193_g79243_i0 | PRJNA1115053 | 81060 | 281 | 2.983193 | 8.38277233 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 93.6 | 6.77e-21 | NR | HEY8279801.1 | 3034175 | g79243 | i0 | 51.1 | 0.96085409252669 | 90 | 40 | 96.1 | 1 | 12 | 281 | 15 | 100 | HEY8279801.1 tetratricopeptide repeat protein [Bdellovibrionota bacterium] | diamond | 270 | 93.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium |
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);;