contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA816047" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25728155 | 25728155 | PRJNA816047a_S_NODE_2698_length_1627_cov_4.083655_g827_i0 | PRJNA816047 | 2698 | 1627 | 4.083655 | 66.44106685 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 536 | 7.509999999999998e-182 | NR | HEX8361269.1 | 2029185 | g827 | i0 | 57.1 | 0.929317762753534 | 504 | 202 | 91.6 | 6 | 1615 | 125 | 151 | 647 | HEX8361269.1 TULIP family P47-like protein [Longimicrobium sp.] | diamond | 1512 | 536 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 25907039 | 25907039 | PRJNA816047b_S_NODE_7291_length_547_cov_2.010549_g5035_i0 | PRJNA816047 | 7291 | 547 | 2.010549 | 10.99770303 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 152 | 1.71e-42 | NR | HEY9228765.1 | 2026741 | g5035 | i0 | 73.4 | 2.07312614259598 | 94 | 25 | 51.6 | 0 | 388 | 107 | 97 | 190 | HEY9228765.1 SMC-Scp complex subunit ScpB [Gemmatimonadaceae bacterium] | diamond | 1134 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 26013704 | 26013704 | PRJNA816047d_S_NODE_63516_length_285_cov_1.706897_g61681_i0 | PRJNA816047 | 63516 | 285 | 1.706897 | 4.86465645 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 174 | 7.96e-51 | NR | HEX8212320.1 | 2029185 | g61681 | i0 | 92.6 | 0.989473684210526 | 94 | 7 | 98.9 | 0 | 284 | 3 | 317 | 410 | HEX8212320.1 IS256 family transposase [Longimicrobium sp.] | diamond | 282 | 174 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 26136106 | 26136106 | PRJNA816047a_S_NODE_2269_length_1992_cov_9.231371_g525_i0 | PRJNA816047 | 2269 | 1992 | 9.231371 | 183.88891032 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 391 | 8.11e-122 | NR | HEX8361270.1 | 2029185 | g525 | i0 | 47 | 0.721385542168675 | 479 | 238 | 70.5 | 8 | 585 | 1988 | 1 | 474 | HEX8361270.1 hypothetical protein [Longimicrobium sp.] | diamond | 1437 | 391 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 26137547 | 26137547 | PRJNA816047a_S_NODE_39661_length_330_cov_20.182879_g37001_i0 | PRJNA816047 | 39661 | 330 | 20.182879 | 66.6035007 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 94.4 | 2.2700000000000004e-21 | NR | GJG86747.1 | 2839016 | g37001 | i0 | 60.8 | 3.83636363636364 | 79 | 26 | 67.3 | 1 | 226 | 5 | 107 | 185 | GJG86747.1 nitroreductase [Gemmatimonadetes bacterium T265] | diamond | 1266 | 94.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadetes bacterium T265 | |||||
| 26180420 | 26180420 | PRJNA816047d_S_NODE_47341_length_319_cov_2.255639_g45506_i0 | PRJNA816047 | 47341 | 319 | 2.255639 | 7.19548841 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 130 | 1.08e-34 | NR | HST58352.1 | 2029185 | g45506 | i0 | 61.5 | 2.93416927899687 | 104 | 40 | 97.8 | 0 | 4 | 315 | 27 | 130 | HST58352.1 ABC transporter ATP-binding protein [Longimicrobium sp.] | diamond | 936 | 130 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 26543840 | 26543840 | PRJNA816047a_S_NODE_19304_length_460_cov_3.439276_g16659_i0 | PRJNA816047 | 19304 | 460 | 3.439276 | 15.8206696 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 109 | 2.9100000000000004e-26 | NR | MDB4917957.1 | 2026742 | g16659 | i0 | 46.9 | 0.958695652173913 | 147 | 78 | 95.9 | 0 | 1 | 441 | 17 | 163 | MDB4917957.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 441 | 109 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 26543948 | 26543948 | PRJNA816047a_S_NODE_20440_length_448_cov_2.229333_g17792_i0 | PRJNA816047 | 20440 | 448 | 2.229333 | 9.98741184 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 153 | 1.9e-43 | NR | HYS70631.1 | 2026741 | g17792 | i0 | 81.4 | 0.575892857142857 | 86 | 16 | 57.6 | 0 | 3 | 260 | 148 | 233 | HYS70631.1 VOC family protein [Gemmatimonadaceae bacterium] | diamond | 258 | 153 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 26549179 | 26549179 | PRJNA816047a_S_NODE_872_length_6648_cov_8.313308_g121_i0 | PRJNA816047 | 872 | 6648 | 8.313308 | 552.66871584 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 415 | 1.54e-125 | NR | HEX8361267.1 | 2029185 | g121 | i0 | 52.2 | 0.203068592057762 | 450 | 203 | 20 | 5 | 1075 | 2406 | 1 | 444 | HEX8361267.1 hypothetical protein [Longimicrobium sp.] | diamond | 1350 | 415 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 26556762 | 26556762 | PRJNA816047d_S_NODE_45656_length_324_cov_0.948339_g43821_i0 | PRJNA816047 | 45656 | 324 | 0.948339 | 3.07261836 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 101 | 1.04e-22 | NR | NIQ56021.1 | 2026742 | g43821 | i0 | 60 | 2.43518518518519 | 85 | 32 | 76.9 | 1 | 324 | 76 | 75 | 159 | NIQ56021.1 glycoside hydrolase family 15 protein [Gemmatimonadota bacterium] | diamond | 789 | 102 | 0.990196078431373 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32955548 | 32955548 | PRJNA816047a_S_NODE_2778_length_1576_cov_9.059880_g884_i0 | PRJNA816047 | 2778 | 1576 | 9.05988 | 142.7837088 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 144 | 1.5999999999999998e-32 | NR | HEX8361270.1 | 2029185 | g884 | i0 | 34.3 | 0.671954314720812 | 353 | 191 | 61.1 | 9 | 25 | 987 | 460 | 803 | HEX8361270.1 hypothetical protein [Longimicrobium sp.] | diamond | 1059 | 144 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 32973451 | 32973451 | PRJNA816047d_S_NODE_37162_length_352_cov_4.337793_g35327_i0 | PRJNA816047 | 37162 | 352 | 4.337793 | 15.26903136 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 66.2 | 5.8e-10 | NR | MEN8144558.1 | 2026742 | g35327 | i0 | 48.3 | 1.02272727272727 | 60 | 31 | 51.1 | 0 | 3 | 182 | 279 | 338 | MEN8144558.1 isocitrate/isopropylmalate family dehydrogenase [Gemmatimonadota bacterium] | diamond | 360 | 66.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32990700 | 32990700 | PRJNA816047d_S_NODE_60467_length_290_cov_4.649789_g58632_i0 | PRJNA816047 | 60467 | 290 | 4.649789 | 13.4843881 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 43.1 | 0.0435 | NR | MEJ2203386.1 | 2026742 | g58632 | i0 | 40 | 0.672413793103448 | 65 | 35 | 63.1 | 1 | 89 | 271 | 10 | 74 | MEJ2203386.1 cyanophycinase [Gemmatimonadota bacterium] | diamond | 195 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 33027494 | 33027494 | PRJNA816047a_S_NODE_74532_length_248_cov_0.880000_g71872_i0 | PRJNA816047 | 74532 | 248 | 0.88 | 2.1824 | FCB group | 1783270 | Bacteria | Bacteria | 43.1 | 0.0263 | NR | MFN2565871.1 | 2026741 | g71872 | i0 | 36.8 | 1.19758064516129 | 68 | 25 | 82.3 | 1 | 210 | 7 | 217 | 266 | MFN2565871.1 pentapeptide repeat-containing protein [Gemmatimonadaceae bacterium] | diamond | 297 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 33109822 | 33109822 | PRJNA816047d_S_NODE_42598_length_333_cov_1.525000_g40763_i0 | PRJNA816047 | 42598 | 333 | 1.525 | 5.07825 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 44.3 | 0.0296 | NR | HEX9486771.1 | 2448054 | g40763 | i0 | 39.6 | 0.432432432432432 | 48 | 26 | 40.5 | 1 | 77 | 211 | 308 | 355 | HEX9486771.1 TonB-dependent receptor [Gemmatimonadales bacterium] | diamond | 144 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 33126871 | 33126871 | PRJNA816047d_S_NODE_44479_length_327_cov_2.208029_g42644_i0 | PRJNA816047 | 44479 | 327 | 2.208029 | 7.22025483 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 127 | 9.25e-35 | NR | MBA3761339.1 | 2448054 | g42644 | i0 | 83.6 | 0.669724770642202 | 73 | 12 | 67 | 0 | 35 | 253 | 98 | 170 | MBA3761339.1 IS3 family transposase [Gemmatimonadales bacterium] | diamond | 219 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 33127072 | 33127072 | PRJNA816047d_S_NODE_76279_length_265_cov_2.080189_g74444_i0 | PRJNA816047 | 76279 | 265 | 2.080189 | 5.51250085 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 126 | 4.52e-33 | NR | MDX2194577.1 | 2448054 | g74444 | i0 | 84.4 | 1.75471698113208 | 77 | 12 | 87.2 | 0 | 1 | 231 | 83 | 159 | MDX2194577.1 sodium-dependent bicarbonate transport family permease [Gemmatimonadales bacterium] | diamond | 465 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 33129943 | 33129943 | PRJNA816047d_S_NODE_14015_length_620_cov_1.835979_g12391_i0 | PRJNA816047 | 14015 | 620 | 1.835979 | 11.3830698 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 162 | 2.3999999999999994e-46 | NR | HEY9228765.1 | 2026741 | g12391 | i0 | 75 | 1.94516129032258 | 100 | 25 | 48.4 | 0 | 337 | 38 | 97 | 196 | HEY9228765.1 SMC-Scp complex subunit ScpB [Gemmatimonadaceae bacterium] | diamond | 1206 | 163 | 0.993865030674847 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 33181247 | 33181247 | PRJNA816047d_S_NODE_65416_length_282_cov_1.087336_g63581_i0 | PRJNA816047 | 65416 | 282 | 1.087336 | 3.06628752 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 84.7 | 1.71e-17 | NR | MBT5800270.1 | 2026742 | g63581 | i0 | 57.4 | 2.42553191489362 | 68 | 28 | 72.3 | 1 | 252 | 49 | 35 | 101 | MBT5800270.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 684 | 84.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota 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);;