contig_metadata
22 rows where bioproject = "PRJNA1237347", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18197911 | 18197911 | PRJNA1237347_P_NODE_82935_length_768_cov_2.621583_g76793_i0 | PRJNA1237347 | 82935 | 768 | 2.621583 | 20.13375744 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 334 | 1.5e-112 | NR | NIT61585.1 | 1872440 | g76793 | i0 | 67.7 | 7.12109375 | 229 | 74 | 89.5 | 0 | 3 | 689 | 31 | 259 | NIT61585.1 aspartate aminotransferase family protein [Fodinibius sp.] | diamond | 5469 | 334 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Fodinibius | Fodinibius sp. | |
| 20739065 | 20739065 | PRJNA1237347_P_NODE_160377_length_501_cov_2.761682_g153816_i0 | PRJNA1237347 | 160377 | 501 | 2.761682 | 13.83602682 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 171 | 1.44e-51 | NR | MFU8812469.1 | 2053516 | g153816 | i0 | 71.4 | 8.58682634730539 | 119 | 34 | 71.3 | 0 | 97 | 453 | 1 | 119 | MFU8812469.1 acyl-CoA thioesterase [Balneolaceae bacterium] | diamond | 4302 | 171 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 26870450 | 26870450 | PRJNA1237347_P_NODE_488581_length_249_cov_0.875000_g482008_i0 | PRJNA1237347 | 488581 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 82.8 | 2.9e-16 | NR | HBQ58744.1 | 2053516 | g482008 | i0 | 47.6 | 2.96385542168675 | 82 | 43 | 98.8 | 0 | 247 | 2 | 328 | 409 | HBQ58744.1 phosphoenolpyruvate carboxylase [Balneolaceae bacterium] | diamond | 738 | 83.6 | 0.990430622009569 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 26946344 | 26946344 | PRJNA1237347_P_NODE_276422_length_351_cov_2.982014_g269849_i0 | PRJNA1237347 | 276422 | 351 | 2.982014 | 10.46686914 | Balneola sp. | 2024824 | Bacteria | Bacteria | 52.8 | 2.18e-6 | NR | MEP1306872.1 | 2024824 | g269849 | i0 | 39.4 | 0.606837606837607 | 71 | 39 | 57.3 | 3 | 213 | 13 | 1 | 71 | MEP1306872.1 hypothetical protein [Balneola sp.] | diamond | 213 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneola | Balneola sp. | |
| 27009936 | 27009936 | PRJNA1237347_P_NODE_523182_length_245_cov_0.895349_g516609_i0 | PRJNA1237347 | 523182 | 245 | 0.895349 | 2.19360505 | Fodinibius sediminis | 1214077 | Bacteria | Bacteria | 142 | 5.75e-38 | NR | WP_142715043.1 | 1214077 | g516609 | i0 | 86.1 | 1.93469387755102 | 79 | 11 | 96.7 | 0 | 243 | 7 | 310 | 388 | WP_142715043.1 hypothetical protein [Fodinibius sediminis] | diamond | 474 | 142 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Fodinibius | Fodinibius sediminis | |
| 28196872 | 28196872 | PRJNA1237347_P_NODE_42786_length_1160_cov_3.104876_g38291_i0 | PRJNA1237347 | 42786 | 1160 | 3.104876 | 36.0165616 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 525 | 9.019999999999995e-183 | NR | WP_066220943.1 | 1849360 | g38291 | i0 | 65.4 | 18.5172413793103 | 376 | 128 | 97.2 | 1 | 1139 | 12 | 1 | 374 | WP_066220943.1 RtcB family protein [Balneola sp. EhC07] | diamond | 21480 | 525 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneola | Balneola sp. EhC07 | |
| 28733852 | 28733852 | PRJNA1237347_P_NODE_381967_length_287_cov_1.799065_g375394_i0 | PRJNA1237347 | 381967 | 287 | 1.799065 | 5.16331655 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 83.6 | 3.96e-17 | NR | MCG8374335.1 | 2497613 | g375394 | i0 | 72.2 | 1.77700348432056 | 54 | 14 | 56.4 | 1 | 162 | 1 | 4 | 56 | MCG8374335.1 diphthine--ammonia ligase [Balneolales bacterium] | diamond | 510 | 84 | 0.995238095238095 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolales bacterium | |||
| 28936620 | 28936620 | PRJNA1237347_P_NODE_540688_length_243_cov_0.905882_g534115_i0 | PRJNA1237347 | 540688 | 243 | 0.905882 | 2.20129326 | Fodinibius salinus | 860790 | Bacteria | Bacteria | 66.6 | 1.3099999999999999e-10 | NR | WP_148899349.1 | 860790 | g534115 | i0 | 47.6 | 1.01234567901235 | 82 | 39 | 97.5 | 3 | 242 | 6 | 69 | 149 | WP_148899349.1 DUF4350 domain-containing protein [Fodinibius salinus] | diamond | 246 | 66.6 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Fodinibius | Fodinibius salinus | |
| 29157796 | 29157796 | PRJNA1237347_P_NODE_68669_length_867_cov_1.636020_g62907_i0 | PRJNA1237347 | 68669 | 867 | 1.63602 | 14.1842934 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 60.8 | 5.49e-7 | NR | MDZ7715057.1 | 2053516 | g62907 | i0 | 32.3 | 1.20069204152249 | 93 | 61 | 32.2 | 1 | 239 | 517 | 90 | 180 | MDZ7715057.1 tetratricopeptide repeat protein [Balneolaceae bacterium] | diamond | 1041 | 60.8 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 30041346 | 30041346 | PRJNA1237347_P_NODE_262651_length_363_cov_1.706897_g256078_i0 | PRJNA1237347 | 262651 | 363 | 1.706897 | 6.19603611 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 72.4 | 5.44e-12 | NR | TVP98997.1 | 2053516 | g256078 | i0 | 36.7 | 2.64462809917355 | 109 | 68 | 89.3 | 1 | 361 | 38 | 351 | 459 | TVP98997.1 MAG: aldehyde dehydrogenase family protein [Balneolaceae bacterium] | diamond | 960 | 72.4 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 30104505 | 30104505 | PRJNA1237347_P_NODE_274072_length_353_cov_2.582143_g267499_i0 | PRJNA1237347 | 274072 | 353 | 2.582143 | 9.11496479 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 59.3 | 1.84e-7 | NR | TVR27544.1 | 2053516 | g267499 | i0 | 36.5 | 3.87535410764873 | 96 | 61 | 81.6 | 0 | 58 | 345 | 11 | 106 | TVR27544.1 MAG: hypothetical protein EA390_13695 [Balneolaceae bacterium] | diamond | 1368 | 59.3 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 30609947 | 30609947 | PRJNA1237347_P_NODE_265693_length_360_cov_2.846690_g259120_i0 | PRJNA1237347 | 265693 | 360 | 2.84669 | 10.248084 | Balneolales bacterium | 2497613 | Bacteria | Bacteria | 104 | 2.81e-26 | NR | HKI45632.1 | 2497613 | g259120 | i0 | 53.1 | 0.8 | 96 | 43 | 80 | 1 | 326 | 39 | 1 | 94 | HKI45632.1 hypothetical protein [Balneolales bacterium] | diamond | 288 | 104 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolales bacterium | |||
| 30641758 | 30641758 | PRJNA1237347_P_NODE_420833_length_271_cov_1.404040_g414260_i0 | PRJNA1237347 | 420833 | 271 | 1.40404 | 3.8049484 | Fodinibius sp. | 1872440 | Bacteria | Bacteria | 53.5 | 7.7e-6 | NR | NIT54889.1 | 1872440 | g414260 | i0 | 38.8 | 0.940959409594096 | 85 | 50 | 93 | 2 | 8 | 259 | 30 | 113 | NIT54889.1 hypothetical protein [Fodinibius sp.] | diamond | 255 | 53.5 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Fodinibius | Fodinibius sp. | |
| 31084521 | 31084521 | PRJNA1237347_P_NODE_90115_length_728_cov_6.883969_g83854_i0 | PRJNA1237347 | 90115 | 728 | 6.883969 | 50.11529432 | Gracilimonas mengyeensis | 1302730 | Bacteria | Bacteria | 48.1 | 0.0241 | NR | WP_142456290.1 | 1302730 | g83854 | i0 | 22.6 | 1.24450549450549 | 155 | 116 | 62.2 | 2 | 490 | 38 | 981 | 1135 | WP_142456290.1 ligand-binding sensor domain-containing protein [Gracilimonas mengyeensis] | diamond | 906 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Gracilimonas | Gracilimonas mengyeensis | |
| 31178821 | 31178821 | PRJNA1237347_P_NODE_484155_length_250_cov_0.870056_g477582_i0 | PRJNA1237347 | 484155 | 250 | 0.870056 | 2.17514 | Gracilimonas sp. | 1974203 | Bacteria | Bacteria | 56.2 | 7.02e-7 | NR | WP_290877965.1 | 1974203 | g477582 | i0 | 52.4 | 1.068 | 42 | 20 | 50.4 | 0 | 222 | 97 | 3 | 44 | WP_290877965.1 acetyl-CoA C-acyltransferase [Gracilimonas sp.] | diamond | 267 | 56.2 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Gracilimonas | Gracilimonas sp. | |
| 31431913 | 31431913 | PRJNA1237347_P_NODE_353836_length_301_cov_1.350877_g347263_i0 | PRJNA1237347 | 353836 | 301 | 1.350877 | 4.06613977 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 44.3 | 0.0179 | NR | MCC5912999.1 | 2053516 | g347263 | i0 | 33.3 | 0.777408637873754 | 78 | 50 | 75.7 | 2 | 44 | 271 | 44 | 121 | MCC5912999.1 alpha/beta hydrolase [Balneolaceae bacterium] | diamond | 234 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 31432056 | 31432056 | PRJNA1237347_P_NODE_462196_length_254_cov_2.127072_g455623_i0 | PRJNA1237347 | 462196 | 254 | 2.127072 | 5.40276288 | Fodinibius sp. Rm-B-1B1-1 | 1872440 | Bacteria | Bacteria | 124 | 3.4399999999999997e-32 | NR | WP_342521037.1 | 3140241 | g455623 | i0 | 72.8 | 2.91732283464567 | 81 | 22 | 95.7 | 0 | 249 | 7 | 44 | 124 | WP_342521037.1 DUF4145 domain-containing protein [Fodinibius sp. Rm-B-1B1-1] | diamond | 741 | 124 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Fodinibius | Fodinibius alkaliphilus | |
| 31874415 | 31874415 | PRJNA1237347_P_NODE_140597_length_546_cov_2.568710_g134059_i0 | PRJNA1237347 | 140597 | 546 | 2.56871 | 14.0251566 | Fodinibius halophilus | 1736908 | Bacteria | Bacteria | 64.7 | 2.58e-9 | NR | WP_165267112.1 | 1736908 | g134059 | i0 | 52.5 | 1.01648351648352 | 61 | 28 | 33 | 1 | 188 | 9 | 79 | 139 | WP_165267112.1 PH domain-containing protein [Fodinibius halophilus] | diamond | 555 | 64.7 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Fodinibius | Fodinibius halophilus | |
| 31906389 | 31906389 | PRJNA1237347_P_NODE_351257_length_302_cov_2.851528_g344684_i0 | PRJNA1237347 | 351257 | 302 | 2.851528 | 8.61161456 | Balneolales bacterium | 2497613 | Bacteria | Bacteria | 99 | 1.29e-21 | NR | HKJ31036.1 | 2497613 | g344684 | i0 | 48.9 | 0.874172185430464 | 88 | 43 | 85.4 | 1 | 259 | 2 | 505 | 592 | HKJ31036.1 beta-galactosidase [Balneolales bacterium] | diamond | 264 | 99 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolales bacterium | |||
| 31906583 | 31906583 | PRJNA1237347_P_NODE_501757_length_247_cov_1.764368_g495184_i0 | PRJNA1237347 | 501757 | 247 | 1.764368 | 4.35798896 | Gracilimonas sediminicola | 2952158 | Bacteria | Bacteria | 67.4 | 4.15e-11 | NR | WP_255132219.1 | 2952158 | g495184 | i0 | 44.4 | 0.874493927125506 | 72 | 39 | 86.2 | 1 | 35 | 247 | 83 | 154 | WP_255132219.1 M23 family metallopeptidase [Gracilimonas sediminicola] | diamond | 216 | 67.4 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Gracilimonas | Gracilimonas sediminicola | |
| 31937838 | 31937838 | PRJNA1237347_P_NODE_298757_length_335_cov_1.167939_g292184_i0 | PRJNA1237347 | 298757 | 335 | 1.167939 | 3.91259565 | Cyclonatronum sp. | 3024185 | Bacteria | Bacteria | 47.4 | 0.00262 | NR | WP_291481806.1 | 3024185 | g292184 | i0 | 33.3 | 0.940298507462687 | 105 | 64 | 91.3 | 4 | 307 | 2 | 47 | 148 | WP_291481806.1 T9SS type A sorting domain-containing protein [Cyclonatronum sp.] | diamond | 315 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Cyclonatronaceae | Cyclonatronum | Cyclonatronum sp. | |
| 32064329 | 32064329 | PRJNA1237347_P_NODE_217198_length_411_cov_0.905325_g210626_i0 | PRJNA1237347 | 217198 | 411 | 0.905325 | 3.72088575 | Balneola sp. | 2024824 | Bacteria | Bacteria | 124 | 3.07e-32 | NR | RNC79963.1 | 2024824 | g210626 | i0 | 51.7 | 0.861313868613139 | 118 | 57 | 86.1 | 0 | 58 | 411 | 32 | 149 | RNC79963.1 MAG: SGNH/GDSL hydrolase family protein [Balneola sp.] | diamond | 354 | 124 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneola | Balneola sp. |
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);;