contig_metadata
21 rows where bioproject = "PRJNA556992" and tax_phylum = "Balneolota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12006706 | 12006706 | PRJNA556992_P_NODE_366850_length_280_cov_1.922705_g364661_i0 | PRJNA556992 | 366850 | 280 | 1.922705 | 5.383574 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 217 | 8.649999999999999e-52 | NTclustered | gi|2021937725|gb|CP051242.1| | 2053516 | g364661 | i0 | 81.609 | 12.7357142857143 | 261 | 48 | 93 | 0 | 1 | 261 | 3513701 | 3513441 | MAG: Balneolaceae bacterium isolate ih13 chromosome | blastn | 3566 | 217 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 18978414 | 18978414 | PRJNA556992_P_NODE_662235_length_254_cov_1.563536_g660046_i0 | PRJNA556992 | 662235 | 254 | 1.563536 | 3.97138144 | Balneolales bacterium | 2497613 | Bacteria | Bacteria | 161 | 7.21e-44 | NR | MCH8569489.1 | 2497613 | g660046 | i0 | 90.5 | 1.98425196850394 | 84 | 8 | 99.2 | 0 | 2 | 253 | 585 | 668 | MCH8569489.1 DEAD/DEAH box helicase [Balneolales bacterium] | diamond | 504 | 161 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolales bacterium | |||
| 24757989 | 24757989 | PRJNA556992_P_NODE_68880_length_456_cov_5.738903_g66707_i0 | PRJNA556992 | 68880 | 456 | 5.738903 | 26.16939768 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 243 | 4.54e-78 | NR | MDX1592072.1 | 2053516 | g66707 | i0 | 80.4 | 2.95394736842105 | 148 | 29 | 97.4 | 0 | 448 | 5 | 58 | 205 | MDX1592072.1 ornithine--oxo-acid transaminase [Balneolaceae bacterium] | diamond | 1347 | 243 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 26635048 | 26635048 | PRJNA556992_P_NODE_1065241_length_221_cov_4.587838_g1063051_i0 | PRJNA556992 | 1065241 | 221 | 4.587838 | 10.13912198 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 42.4 | 0.025 | NR | MBO6522900.1 | 2053516 | g1063051 | i0 | 31.5 | 0.990950226244344 | 73 | 44 | 91 | 2 | 6 | 206 | 92 | 164 | MBO6522900.1 hypothetical protein [Balneolaceae bacterium] | diamond | 219 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 27015184 | 27015184 | PRJNA556992_P_NODE_420082_length_274_cov_4.164179_g417893_i0 | PRJNA556992 | 420082 | 274 | 4.164179 | 11.40985046 | Fodinibius sp. | 1872440 | Bacteria | Bacteria | 120 | 3.8999999999999997e-31 | NR | WP_322574423.1 | 1872440 | g417893 | i0 | 92.8 | 2.26642335766423 | 69 | 5 | 75.5 | 0 | 2 | 208 | 211 | 279 | WP_322574423.1 ZIP family metal transporter [Fodinibius sp.] | diamond | 621 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Fodinibius | Fodinibius sp. | |
| 27204722 | 27204722 | PRJNA556992_P_NODE_459322_length_271_cov_1.373737_g457133_i0 | PRJNA556992 | 459322 | 271 | 1.373737 | 3.72282727 | Gracilimonas sp. | 1974203 | Bacteria | Bacteria | 154 | 7.059999999999999e-45 | NR | MDR9417040.1 | 1974203 | g457133 | i0 | 79.8 | 2.96678966789668 | 89 | 18 | 98.5 | 0 | 267 | 1 | 150 | 238 | MDR9417040.1 hypothetical protein [Gracilimonas sp.] | diamond | 804 | 154 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Gracilimonas | Gracilimonas sp. | |
| 27647458 | 27647458 | PRJNA556992_P_NODE_602864_length_258_cov_5.129730_g600675_i0 | PRJNA556992 | 602864 | 258 | 5.12973 | 13.2347034 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 88.2 | 6.59e-21 | NR | HCD53191.1 | 2053516 | g600675 | i0 | 77 | 2.12790697674419 | 61 | 14 | 70.9 | 0 | 185 | 3 | 1 | 61 | HCD53191.1 DUF2892 domain-containing protein [Balneolaceae bacterium] | diamond | 549 | 88.2 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 27819567 | 27819567 | PRJNA556992_P_NODE_1128684_length_206_cov_5.390977_g1126493_i0 | PRJNA556992 | 1128684 | 206 | 5.390977 | 11.10541262 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 118 | 1.2599999999999998e-29 | NR | WP_069131249.1 | 1812810 | g1126493 | i0 | 88.2 | 7.92233009708738 | 68 | 8 | 99 | 0 | 206 | 3 | 48 | 115 | WP_069131249.1 transcription termination factor NusA [Rhodohalobacter halophilus] | diamond | 1632 | 119 | 0.991596638655462 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Rhodohalobacter | Rhodohalobacter halophilus | |
| 28373219 | 28373219 | PRJNA556992_P_NODE_256866_length_302_cov_1.598253_g254677_i0 | PRJNA556992 | 256866 | 302 | 1.598253 | 4.82672406 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 119 | 8.909999999999998e-32 | NR | HBQ58562.1 | 2053516 | g254677 | i0 | 76.1 | 4.67880794701987 | 67 | 16 | 66.6 | 0 | 3 | 203 | 98 | 164 | HBQ58562.1 IS3 family transposase [Balneolaceae bacterium] | diamond | 1413 | 119 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 28720620 | 28720620 | PRJNA556992_P_NODE_1134407_length_205_cov_4.462121_g1132216_i0 | PRJNA556992 | 1134407 | 205 | 4.462121 | 9.14734805 | Balneola sp. | 2024824 | Bacteria | Bacteria | 68.6 | 1.24e-12 | NR | MAL19258.1 | 2024824 | g1132216 | i0 | 54.7 | 5.2390243902439 | 53 | 24 | 77.6 | 0 | 205 | 47 | 87 | 139 | MAL19258.1 hypothetical protein [Balneola sp.] | diamond | 1074 | 68.6 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneola | Balneola sp. | |
| 28987844 | 28987844 | PRJNA556992_P_NODE_271508_length_296_cov_1.910314_g269319_i0 | PRJNA556992 | 271508 | 296 | 1.910314 | 5.65452944 | Cyclonatronum | 2489367 | Bacteria | Bacteria | 63.2 | 4.75e-9 | NR | MCC5934966.1 | 2497613 | g269319 | i0 | 36.7 | 2.38175675675676 | 79 | 49 | 80.1 | 1 | 1 | 237 | 1077 | 1154 | MCC5934966.1 CotH kinase family protein [Balneolales bacterium] | diamond | 705 | 63.5 | 0.995275590551181 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolales bacterium | |||
| 29225890 | 29225890 | PRJNA556992_P_NODE_1011529_length_229_cov_3.628205_g1009339_i0 | PRJNA556992 | 1011529 | 229 | 3.628205 | 8.30858945 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 126 | 7.659999999999999e-32 | NR | TVR28452.1 | 2053516 | g1009339 | i0 | 76.3 | 0.995633187772926 | 76 | 18 | 99.6 | 0 | 1 | 228 | 199 | 274 | TVR28452.1 MAG: S9 family peptidase, partial [Balneolaceae bacterium] | diamond | 228 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 29573117 | 29573117 | PRJNA556992_P_NODE_585070_length_260_cov_1.962567_g582881_i0 | PRJNA556992 | 585070 | 260 | 1.962567 | 5.1026742 | Gracilimonas sp. | 1974203 | Bacteria | Bacteria | 63.9 | 1.4e-10 | NR | WP_395080273.1 | 1974203 | g582881 | i0 | 36.8 | 1.00384615384615 | 87 | 54 | 99.2 | 1 | 1 | 258 | 14 | 100 | WP_395080273.1 HK97 gp10 family phage protein [Gracilimonas sp.] | diamond | 261 | 63.9 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Gracilimonas | Gracilimonas sp. | |
| 29573312 | 29573312 | PRJNA556992_P_NODE_978810_length_232_cov_7.742138_g976620_i0 | PRJNA556992 | 978810 | 232 | 7.742138 | 17.96176016 | Balneolales bacterium | 2497613 | Bacteria | Bacteria | 79.7 | 8.25e-16 | NR | HKJ30336.1 | 2497613 | g976620 | i0 | 49.4 | 1.02155172413793 | 79 | 38 | 99.6 | 1 | 232 | 2 | 13 | 91 | HKJ30336.1 pyrroline-5-carboxylate reductase [Balneolales bacterium] | diamond | 237 | 79.7 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolales bacterium | |||
| 30078394 | 30078394 | PRJNA556992_P_NODE_482032_length_269_cov_1.295918_g479843_i0 | PRJNA556992 | 482032 | 269 | 1.295918 | 3.48601942 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 42.7 | 0.0483 | NR | MFA5669398.1 | 2053516 | g479843 | i0 | 30.7 | 0.981412639405205 | 88 | 48 | 97 | 2 | 6 | 266 | 217 | 292 | MFA5669398.1 HK97-fold major capsid protein [Balneolaceae bacterium] | diamond | 264 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 30773695 | 30773695 | PRJNA556992_P_NODE_307634_length_288_cov_1.074419_g305445_i0 | PRJNA556992 | 307634 | 288 | 1.074419 | 3.09432672 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 102 | 8.91e-23 | NR | MFA5669389.1 | 2053516 | g305445 | i0 | 53.2 | 0.979166666666667 | 94 | 44 | 97.9 | 0 | 3 | 284 | 55 | 148 | MFA5669389.1 toprim domain-containing protein [Balneolaceae bacterium] | diamond | 282 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 31089837 | 31089837 | PRJNA556992_P_NODE_940855_length_236_cov_5.791411_g938665_i0 | PRJNA556992 | 940855 | 236 | 5.791411 | 13.66772996 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 91.7 | 1.16e-19 | NR | HCD51181.1 | 2053516 | g938665 | i0 | 53.8 | 2.91101694915254 | 78 | 36 | 99.2 | 0 | 3 | 236 | 224 | 301 | HCD51181.1 Bcr/CflA family drug resistance efflux transporter [Balneolaceae bacterium] | diamond | 687 | 91.7 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 31120757 | 31120757 | PRJNA556992_P_NODE_317675_length_286_cov_2.164319_g315486_i0 | PRJNA556992 | 317675 | 286 | 2.164319 | 6.18995234 | Rhodohalobacter sp. | 1974210 | Bacteria | Bacteria | 60.1 | 3.51e-8 | NR | WP_372905063.1 | 1974210 | g315486 | i0 | 37.2 | 0.818181818181818 | 78 | 47 | 81.8 | 1 | 51 | 284 | 1 | 76 | WP_372905063.1 hypothetical protein [Rhodohalobacter sp.] | diamond | 234 | 60.1 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Rhodohalobacter | Rhodohalobacter sp. | |
| 31310537 | 31310537 | PRJNA556992_P_NODE_1063075_length_221_cov_7.222973_g1060885_i0 | PRJNA556992 | 1063075 | 221 | 7.222973 | 15.96277033 | Rhodohalobacter mucosus | 2079485 | Bacteria | Bacteria | 57.4 | 1.13e-8 | NR | WP_109647493.1 | 2079485 | g1060885 | i0 | 93.1 | 1.18099547511312 | 29 | 2 | 39.4 | 0 | 135 | 221 | 1 | 29 | WP_109647493.1 nucleotidyltransferase family protein [Rhodohalobacter mucosus] | diamond | 261 | 57.4 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Rhodohalobacter | Rhodohalobacter mucosus | |
| 32432635 | 32432635 | PRJNA556992_P_NODE_688439_length_252_cov_1.424581_g686250_i0 | PRJNA556992 | 688439 | 252 | 1.424581 | 3.58994412 | Balneolaceae | 1813606 | Bacteria | Bacteria | 73.9 | 9.2e-15 | NR | HKK24731.1 | 1974203 | g686250 | i0 | 47 | 5.98809523809524 | 83 | 43 | 98.8 | 1 | 252 | 4 | 27 | 108 | HKK24731.1 hypothetical protein [Gracilimonas sp.] | diamond | 1509 | 73.9 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Gracilimonas | Gracilimonas sp. | |
| 32527664 | 32527664 | PRJNA556992_P_NODE_594559_length_259_cov_2.629032_g592370_i0 | PRJNA556992 | 594559 | 259 | 2.629032 | 6.80919288 | Rhodohalobacter | 1974209 | Bacteria | Bacteria | 120 | 4e-30 | NR | MEX0649072.1 | 2053516 | g592370 | i0 | 70.6 | 3.9034749034749 | 85 | 25 | 98.5 | 0 | 257 | 3 | 219 | 303 | MEX0649072.1 efflux RND transporter periplasmic adaptor subunit [Balneolaceae bacterium] | diamond | 1011 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae 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);;