contig_metadata
21 rows where bioproject = "PRJNA661142", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3178995 | 3178995 | PRJNA661142_P_NODE_12203_length_163_cov_0.894737_g12138_i0 | PRJNA661142 | 12203 | 163 | 0.894737 | 1.45842131 | Desulfobaccales bacterium | 3064668 | Bacteria | Bacteria | 113 | 5.34e-29 | NR | HZK12887.1 | 3064668 | g12138 | i0 | 100 | 6.95705521472393 | 54 | 0 | 99.4 | 0 | 162 | 1 | 178 | 231 | HZK12887.1 FAD-binding protein [Desulfobaccales bacterium] | diamond | 1134 | 113 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobaccia | Desulfobaccales | Desulfobaccales bacterium | ||||
| 7006692 | 7006692 | PRJNA661142_P_NODE_11406_length_167_cov_0.864407_g11341_i0 | PRJNA661142 | 11406 | 167 | 0.864407 | 1.44355969 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 108 | 5.37e-26 | NR | MCU0590495.1 | 2044940 | g11341 | i0 | 96.4 | 2.92814371257485 | 55 | 2 | 98.8 | 0 | 1 | 165 | 425 | 479 | MCU0590495.1 fatty acyl-AMP ligase [Desulfobacterales bacterium] | diamond | 489 | 108 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 7006696 | 7006696 | PRJNA661142_P_NODE_11846_length_165_cov_0.879310_g11781_i0 | PRJNA661142 | 11846 | 165 | 0.87931 | 1.4508615 | Geomonas nitrogeniifigens | 2843197 | Bacteria | Bacteria | 300 | 4.46e-77 | NTclustered | gi|2060223057|gb|CP077684.1| | 2847991 | g11781 | i0 | 99.398 | 8.3030303030303 | 166 | 0 | 100 | 1 | 1 | 165 | 2567760 | 2567595 | Geomonas nitrogeniifigens strain RF4 chromosome, complete genome | blastn | 1370 | 300 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geomonas | Geomonas nitrogeniifigens | ||
| 17206183 | 17206183 | PRJNA661142_P_NODE_7654_length_274_cov_1.133333_g7589_i0 | PRJNA661142 | 7654 | 274 | 1.133333 | 3.10533242 | Desulfomicrobium sp. ZS1 | 2952228 | Bacteria | Bacteria | 455 | 1.64e-123 | NTclustered | gi|2269306666|gb|CP100351.1| | 2952228 | g7589 | i0 | 100 | 252.496350364963 | 246 | 0 | 90 | 0 | 1 | 246 | 2625286 | 2625531 | Desulfomicrobium sp. ZS1 chromosome, complete genome | blastn | 69184 | 455 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfomicrobiaceae | Desulfomicrobium | Desulfomicrobium sp. ZS1 | ||
| 27302793 | 27302793 | PRJNA661142_P_NODE_11403_length_167_cov_0.864407_g11338_i0 | PRJNA661142 | 11403 | 167 | 0.864407 | 1.44355969 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 51.6 | 5.74e-7 | NR | MEW6657181.1 | 2202153 | g11338 | i0 | 88.9 | 0.48502994011976 | 27 | 3 | 48.5 | 0 | 167 | 87 | 40 | 66 | MEW6657181.1 cold-shock protein [Thermodesulfobacteriota bacterium] | diamond | 81 | 51.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 28060462 | 28060462 | PRJNA661142_P_NODE_11865_length_165_cov_0.879310_g11800_i0 | PRJNA661142 | 11865 | 165 | 0.87931 | 1.4508615 | Syntrophaceae bacterium | 2052184 | Bacteria | Bacteria | 111 | 5.25e-27 | NR | NTW16117.1 | 2052184 | g11800 | i0 | 100 | 0.981818181818182 | 54 | 0 | 98.2 | 0 | 163 | 2 | 39 | 92 | NTW16117.1 type IV pilus secretin PilQ [Syntrophaceae bacterium] | diamond | 162 | 111 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophaceae bacterium | |||
| 28471119 | 28471119 | PRJNA661142_P_NODE_11986_length_164_cov_0.886957_g11921_i0 | PRJNA661142 | 11986 | 164 | 0.886957 | 1.45460948 | Syntrophobacteraceae bacterium CG23_combo_of_CG | 2052185 | Bacteria | Bacteria | 77.4 | 4.06e-17 | NR | PIP06372.1 | 1974096 | g11921 | i0 | 68.5 | 4.9390243902439 | 54 | 17 | 98.8 | 0 | 163 | 2 | 8 | 61 | PIP06372.1 MAG: hypothetical protein COX51_09025, partial [Syntrophobacteraceae bacterium CG23_combo_of_CG06-09_8_20_14_all_50_8] | diamond | 810 | 77.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Syntrophobacteraceae bacterium CG23_combo_of_CG06-09_8_20_14_all_50_8 | |||
| 29071094 | 29071094 | PRJNA661142_P_NODE_11728_length_166_cov_0.871795_g11663_i0 | PRJNA661142 | 11728 | 166 | 0.871795 | 1.4471797 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 90.9 | 2.71e-20 | NR | HYA92027.1 | 2202153 | g11663 | i0 | 83.3 | 0.975903614457831 | 54 | 9 | 97.6 | 0 | 163 | 2 | 178 | 231 | HYA92027.1 xanthine dehydrogenase family protein subunit M [Thermodesulfobacteriota bacterium] | diamond | 162 | 90.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 30049631 | 30049631 | PRJNA661142_P_NODE_12051_length_164_cov_0.886957_g11986_i0 | PRJNA661142 | 12051 | 164 | 0.886957 | 1.45460948 | Desulfohalobiaceae bacterium | 2683721 | Bacteria | Bacteria | 75.5 | 3.61e-14 | NR | MCF8106865.1 | 2683721 | g11986 | i0 | 67.3 | 1.9390243902439 | 52 | 17 | 95.1 | 0 | 1 | 156 | 207 | 258 | MCF8106865.1 PAS domain S-box protein [Desulfohalobiaceae bacterium] | diamond | 318 | 75.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfohalobiaceae bacterium | |||
| 30713274 | 30713274 | PRJNA661142_P_NODE_12334_length_163_cov_0.894737_g12269_i0 | PRJNA661142 | 12334 | 163 | 0.894737 | 1.45842131 | Syntrophaceae bacterium | 2052184 | Bacteria | Bacteria | 60.8 | 4.93e-9 | NR | MEN6464652.1 | 2052184 | g12269 | i0 | 54.7 | 0.975460122699387 | 53 | 24 | 97.5 | 0 | 161 | 3 | 47 | 99 | MEN6464652.1 SpoIID/LytB domain-containing protein [Syntrophaceae bacterium] | diamond | 159 | 60.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophaceae bacterium | |||
| 30902943 | 30902943 | PRJNA661142_P_NODE_12234_length_163_cov_0.894737_g12169_i0 | PRJNA661142 | 12234 | 163 | 0.894737 | 1.45842131 | Syntrophobacteria bacterium | 3024410 | Bacteria | Bacteria | 43.5 | 0.00611 | NR | HVO84157.1 | 3024410 | g12169 | i0 | 43.2 | 0.809815950920245 | 44 | 24 | 79.1 | 1 | 133 | 5 | 6 | 49 | HVO84157.1 PEP-CTERM sorting domain-containing protein [Syntrophobacteria bacterium] | diamond | 132 | 43.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacteria bacterium | |||||
| 31029504 | 31029504 | PRJNA661142_P_NODE_12135_length_164_cov_0.886957_g12070_i0 | PRJNA661142 | 12135 | 164 | 0.886957 | 1.45460948 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 85.1 | 1.65e-18 | NR | MDO8944357.1 | 2044940 | g12070 | i0 | 80.8 | 2.89024390243902 | 52 | 10 | 95.1 | 0 | 161 | 6 | 109 | 160 | MDO8944357.1 MFS transporter [Desulfobacterales bacterium] | diamond | 474 | 85.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 31029506 | 31029506 | PRJNA661142_P_NODE_5735_length_323_cov_0.930657_g5670_i0 | PRJNA661142 | 5735 | 323 | 0.930657 | 3.00602211 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 100 | 4.6e-23 | NR | HEX7127777.1 | 2202153 | g5670 | i0 | 63.9 | 0.668730650154799 | 72 | 26 | 66.9 | 0 | 3 | 218 | 230 | 301 | HEX7127777.1 alpha/beta hydrolase [Thermodesulfobacteriota bacterium] | diamond | 216 | 100 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 31186946 | 31186946 | PRJNA661142_P_NODE_12255_length_163_cov_0.894737_g12190_i0 | PRJNA661142 | 12255 | 163 | 0.894737 | 1.45842131 | Desulfomonile tiedjei | 2358 | Bacteria | Bacteria | 80.9 | 3.82e-16 | NR | MBI5251393.1 | 2358 | g12190 | i0 | 75.5 | 2.92638036809816 | 53 | 13 | 97.5 | 0 | 160 | 2 | 310 | 362 | MBI5251393.1 ABC transporter substrate-binding protein [Desulfomonile tiedjei] | diamond | 477 | 80.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfomonilia | Desulfomonilales | Desulfomonilaceae | Desulfomonile | Desulfomonile tiedjei | ||
| 31262665 | 31262665 | PRJNA661142_P_NODE_12655_length_161_cov_0.910714_g12590_i0 | PRJNA661142 | 12655 | 161 | 0.910714 | 1.46624954 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 82.8 | 9.24e-17 | NR | TET84539.1 | 2049433 | g12590 | i0 | 71.7 | 2.96273291925466 | 53 | 15 | 98.8 | 0 | 3 | 161 | 211 | 263 | TET84539.1 MAG: hypothetical protein E3J46_10955, partial [Desulfobacteraceae bacterium] | diamond | 477 | 82.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 31693251 | 31693251 | PRJNA661142_P_NODE_9137_length_238_cov_1.365079_g9072_i0 | PRJNA661142 | 9137 | 238 | 1.365079 | 3.24888802 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 45.4 | 0.00396 | NR | HEX7127293.1 | 2202153 | g9072 | i0 | 68.8 | 0.403361344537815 | 32 | 10 | 40.3 | 0 | 2 | 97 | 76 | 107 | HEX7127293.1 prohead protease/major capsid protein fusion protein [Thermodesulfobacteriota bacterium] | diamond | 96 | 45.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 31756538 | 31756538 | PRJNA661142_P_NODE_11517_length_167_cov_0.864407_g11452_i0 | PRJNA661142 | 11517 | 167 | 0.864407 | 1.44355969 | Syntrophobacteraceae bacterium | 2052185 | Bacteria | Bacteria | 80.5 | 1.4e-16 | NR | HQN17943.1 | 2052185 | g11452 | i0 | 74.5 | 0.988023952095808 | 55 | 14 | 98.8 | 0 | 167 | 3 | 68 | 122 | HQN17943.1 hypothetical protein [Syntrophobacteraceae bacterium] | diamond | 165 | 80.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Syntrophobacteraceae bacterium | |||
| 32263038 | 32263038 | PRJNA661142_P_NODE_11838_length_165_cov_0.879310_g11773_i0 | PRJNA661142 | 11838 | 165 | 0.87931 | 1.4508615 | Syntrophobacter sp. | 66700 | Bacteria | Bacteria | 78.6 | 4.75e-16 | NR | MEN6440645.1 | 66700 | g11773 | i0 | 67.3 | 0.945454545454545 | 52 | 17 | 94.5 | 0 | 3 | 158 | 39 | 90 | MEN6440645.1 DUF1614 domain-containing protein [Syntrophobacter sp.] | diamond | 156 | 78.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Syntrophobacter | Syntrophobacter sp. | ||
| 32641795 | 32641795 | PRJNA661142_P_NODE_11460_length_167_cov_0.864407_g11395_i0 | PRJNA661142 | 11460 | 167 | 0.864407 | 1.44355969 | Desulfobaccales bacterium | 3064668 | Bacteria | Bacteria | 107 | 1.87e-26 | NR | MFA4903734.1 | 3064668 | g11395 | i0 | 98.1 | 0.952095808383233 | 53 | 1 | 95.2 | 0 | 160 | 2 | 198 | 250 | MFA4903734.1 NADH-quinone oxidoreductase subunit NuoH [Desulfobaccales bacterium] | diamond | 159 | 107 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobaccia | Desulfobaccales | Desulfobaccales bacterium | ||||
| 32767956 | 32767956 | PRJNA661142_P_NODE_12000_length_164_cov_0.886957_g11935_i0 | PRJNA661142 | 12000 | 164 | 0.886957 | 1.45460948 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 80.9 | 4.61e-16 | NR | HVP79336.1 | 2202153 | g11935 | i0 | 64.8 | 2.96341463414634 | 54 | 19 | 98.8 | 0 | 1 | 162 | 2509 | 2562 | HVP79336.1 PKD domain-containing protein [Thermodesulfobacteriota bacterium] | diamond | 486 | 80.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 32893830 | 32893830 | PRJNA661142_P_NODE_11700_length_166_cov_0.871795_g11635_i0 | PRJNA661142 | 11700 | 166 | 0.871795 | 1.4471797 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 81.3 | 2.39e-16 | NR | HJX60466.1 | 2202153 | g11635 | i0 | 77.8 | 0.975903614457831 | 54 | 12 | 97.6 | 0 | 3 | 164 | 119 | 172 | HJX60466.1 MFS transporter [Thermodesulfobacteriota bacterium] | diamond | 162 | 81.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota 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);;