contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA453567" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2992421 | 2992421 | PRJNA453567_P_NODE_14463_length_238_cov_2.124378_g14226_i0 | PRJNA453567 | 14463 | 238 | 2.124378 | 5.05601964 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 81.3 | 9.19e-16 | NR | HSL39310.1 | 2099376 | g14226 | i0 | 54.5 | 7.6890756302521 | 77 | 35 | 97.1 | 0 | 236 | 6 | 179 | 255 | HSL39310.1 HAD-IC family P-type ATPase [Desulforhopalus sp.] | diamond | 1830 | 81.6 | 0.996323529411765 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulforhopalus | Desulforhopalus sp. | ||
| 14470523 | 14470523 | PRJNA453567_P_NODE_29692_length_161_cov_0.943548_g29455_i0 | PRJNA453567 | 29692 | 161 | 0.943548 | 1.51911228 | root | 1 | Root_unresolved | Root_unresolved | 110 | 1.03e-26 | NR | HCR13096.1 | 885 | g29455 | i0 | 90.6 | 9.87577639751553 | 53 | 5 | 98.8 | 0 | 3 | 161 | 136 | 188 | HCR13096.1 catalase [Desulfovibrio sp.] | diamond | 1590 | 110 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. | ||
| 14470583 | 14470583 | PRJNA453567_P_NODE_6452_length_392_cov_2.149296_g6216_i0 | PRJNA453567 | 6452 | 392 | 2.149296 | 8.42524032 | root | 1 | Root_unresolved | Root_unresolved | 114 | 6.04e-29 | NR | NMC49970.1 | 885 | g6216 | i0 | 53.8 | 9.83418367346939 | 104 | 48 | 79.6 | 0 | 80 | 391 | 17 | 120 | NMC49970.1 50S ribosomal protein L4 [Desulfovibrio sp.] | diamond | 3855 | 115 | 0.991304347826087 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. | ||
| 18293528 | 18293528 | PRJNA453567_P_NODE_31475_length_156_cov_1.571429_g31238_i0 | PRJNA453567 | 31475 | 156 | 1.571429 | 2.45142924 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 85.1 | 4.91e-18 | NR | WP_008870277.1 | 488939 | g31238 | i0 | 69.2 | 10.6346153846154 | 52 | 16 | 100 | 0 | 156 | 1 | 114 | 165 | WP_008870277.1 histone deacetylase [Desulfonatronospira thiodismutans] | diamond | 1659 | 85.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfonatronovibrionaceae | Desulfonatronospira | Desulfonatronospira thiodismutans | ||
| 22118263 | 22118263 | PRJNA453567_P_NODE_1298_length_1030_cov_4.959718_g1185_i0 | PRJNA453567 | 1298 | 1030 | 4.959718 | 51.0850954 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 275 | 9.029999999999998e-86 | NR | RMF15619.1 | 2080303 | g1185 | i0 | 72 | 0.530097087378641 | 182 | 51 | 53 | 0 | 3 | 548 | 251 | 432 | RMF15619.1 MAG: O-acetylhomoserine aminocarboxypropyltransferase/cysteine synthase [Candidatus Dadabacteria bacterium] | diamond | 546 | 275 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 24668090 | 24668090 | PRJNA453567_P_NODE_4660_length_482_cov_2.521348_g4427_i0 | PRJNA453567 | 4660 | 482 | 2.521348 | 12.15289736 | root | 1 | Root_unresolved | Root_unresolved | 193 | 1.74e-58 | NR | WP_024333593.1 | 115781 | g4427 | i0 | 62.4 | 7.94190871369295 | 157 | 59 | 97.7 | 0 | 472 | 2 | 50 | 206 | WP_024333593.1 fumarylacetoacetate hydrolase family protein [Desulfotignum balticum] | diamond | 3828 | 194 | 0.994845360824742 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfotignum | Desulfotignum balticum | ||
| 27976694 | 27976694 | PRJNA453567_P_NODE_15485_length_229_cov_1.843750_g15248_i0 | PRJNA453567 | 15485 | 229 | 1.84375 | 4.2221875 | Desulfobacter | 2289 | Bacteria | Bacteria | 47.4 | 7.02e-4 | NR | WP_287561129.1 | 2294 | g15248 | i0 | 36.4 | 6.02620087336245 | 77 | 36 | 98.3 | 3 | 228 | 4 | 13 | 78 | WP_287561129.1 ADP-ribosylglycohydrolase family protein [Desulfobacter sp.] | diamond | 1380 | 47.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | Desulfobacter sp. | ||
| 28134764 | 28134764 | PRJNA453567_P_NODE_26585_length_170_cov_1.172932_g26348_i0 | PRJNA453567 | 26585 | 170 | 1.172932 | 1.9939844 | Bacteria | 2 | Bacteria | Bacteria | 44.7 | 0.00292 | NR | MBI9086514.1 | 2044940 | g26348 | i0 | 48.6 | 5.06470588235294 | 37 | 19 | 65.3 | 0 | 2 | 112 | 90 | 126 | MBI9086514.1 FAD-dependent oxidoreductase [Desulfobacterales bacterium] | diamond | 861 | 44.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 29602029 | 29602029 | PRJNA453567_P_NODE_19710_length_199_cov_2.141975_g19473_i0 | PRJNA453567 | 19710 | 199 | 2.141975 | 4.26253025 | Desulforapulum autotrophicum | 2296 | Bacteria | Bacteria | 60.1 | 1.54e-8 | NR | WP_015903179.1 | 2296 | g19473 | i0 | 46.8 | 0.934673366834171 | 62 | 31 | 93.5 | 1 | 188 | 3 | 379 | 438 | WP_015903179.1 sulfurtransferase [Desulforapulum autotrophicum] | diamond | 186 | 60.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulforapulum | Desulforapulum autotrophicum | ||
| 30945541 | 30945541 | PRJNA453567_P_NODE_25634_length_173_cov_1.617647_g25397_i0 | PRJNA453567 | 25634 | 173 | 1.617647 | 2.79852931 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 66.6 | 5.43e-11 | NR | MCG8617954.1 | 2044940 | g25397 | i0 | 58.2 | 11.4277456647399 | 55 | 23 | 95.4 | 0 | 8 | 172 | 506 | 560 | MCG8617954.1 response regulator [Desulfobacterales bacterium] | diamond | 1977 | 66.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 31561678 | 31561678 | PRJNA453567_P_NODE_27056_length_168_cov_1.786260_g26819_i0 | PRJNA453567 | 27056 | 168 | 1.78626 | 3.0009168 | Desulfobulbaceae bacterium | 2053307 | Bacteria | Bacteria | 56.6 | 4.2e-8 | NR | NTV13522.1 | 2053307 | g26819 | i0 | 54.3 | 1.66071428571429 | 46 | 21 | 82.1 | 0 | 143 | 6 | 4 | 49 | NTV13522.1 hypothetical protein [Desulfobulbaceae bacterium] | diamond | 279 | 56.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbaceae bacterium | |||
| 32052208 | 32052208 | PRJNA453567_P_NODE_30178_length_159_cov_1.918033_g29941_i0 | PRJNA453567 | 30178 | 159 | 1.918033 | 3.04967247 | Bacteria | 2 | Bacteria | Bacteria | 48.1 | 1.45e-4 | NR | WP_205241668.1 | 869814 | g29941 | i0 | 46.9 | 3.49056603773585 | 49 | 26 | 92.5 | 0 | 148 | 2 | 446 | 494 | WP_205241668.1 glutamate--tRNA ligase [Desulfobulbus alkaliphilus] | diamond | 555 | 48.5 | 0.991752577319588 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus alkaliphilus | ||
| 32873312 | 32873312 | PRJNA453567_P_NODE_13220_length_253_cov_1.083333_g12983_i0 | PRJNA453567 | 13220 | 253 | 1.083333 | 2.74083249 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 42.7 | 0.0337 | NR | WP_167940288.1 | 995050 | g12983 | i0 | 35.9 | 1.61264822134387 | 64 | 36 | 70 | 1 | 179 | 3 | 124 | 187 | WP_167940288.1 phage baseplate assembly protein V [Desulfobaculum xiamenense] | diamond | 408 | 42.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfobaculum | Desulfobaculum xiamenense |
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);;