contig_metadata
20 rows where bioproject = "PRJNA874604" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3789642 | 3789642 | PRJNA874604_P_NODE_11223_length_513_cov_1.368182_g10872_i0 | PRJNA874604 | 11223 | 513 | 1.368182 | 7.01877366 | Nitratidesulfovibrio | 2802295 | Bacteria | Bacteria | 448 | 5.479999999999999e-121 | NTclustered | gi|46451220|gb|AE017285.1| | 882 | g10872 | i0 | 82.49 | 83.1500974658869 | 514 | 86 | 99 | 3 | 1 | 512 | 2097683 | 2097172 | Desulfovibrio vulgaris subsp. vulgaris str. Hildenborough, complete genome | blastn | 42656 | 448 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Nitratidesulfovibrio | Nitratidesulfovibrio vulgaris | ||
| 14879460 | 14879460 | PRJNA874604_P_NODE_20392_length_400_cov_1.749235_g20040_i0 | PRJNA874604 | 20392 | 400 | 1.749235 | 6.99694 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 57.8 | 4.08e-7 | NR | MBI5895368.1 | 2044940 | g20040 | i0 | 30.3 | 0.8925 | 119 | 82 | 89.3 | 1 | 395 | 39 | 79 | 196 | MBI5895368.1 DUF2589 domain-containing protein [Desulfobacterales bacterium] | diamond | 357 | 57.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 20364101 | 20364101 | PRJNA874604_P_NODE_19636_length_406_cov_1.375375_g19284_i0 | PRJNA874604 | 19636 | 406 | 1.375375 | 5.5840225 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 529 | 1.4799999999999996e-145 | NTclustered | gi|84616844|emb|CT009609.1| | 897 | g19284 | i0 | 91.237 | 34.3152709359606 | 388 | 34 | 96 | 0 | 1 | 388 | 33330 | 33717 | Desulfococcus multivorans vrl island | blastn | 13932 | 529 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfococcus | Desulfococcus multivorans | ||
| 26706743 | 26706743 | PRJNA874604_P_NODE_44841_length_295_cov_1.963964_g44489_i0 | PRJNA874604 | 44841 | 295 | 1.963964 | 5.7936938 | Desulfococcaceae bacterium HSG7 | 3055597 | Bacteria | Bacteria | 79.7 | 5.97e-16 | NR | MDM8557158.1 | 3055597 | g44489 | i0 | 49.3 | 0.722033898305085 | 71 | 36 | 72.2 | 0 | 76 | 288 | 130 | 200 | MDM8557158.1 hypothetical protein [Desulfococcaceae bacterium HSG7] | diamond | 213 | 79.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfococcaceae bacterium HSG7 | |||
| 27031589 | 27031589 | PRJNA874604_P_NODE_76502_length_249_cov_0.875000_g76150_i0 | PRJNA874604 | 76502 | 249 | 0.875 | 2.17875 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 79.3 | 4.85e-15 | NR | MEE9119683.1 | 3024410 | g76150 | i0 | 52.5 | 2.89156626506024 | 80 | 38 | 96.4 | 0 | 3 | 242 | 327 | 406 | MEE9119683.1 hypothetical protein [Syntrophobacteria bacterium] | diamond | 720 | 80.1 | 0.990012484394507 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacteria bacterium | |||||
| 27434695 | 27434695 | PRJNA874604_P_NODE_86003_length_245_cov_1.790698_g85651_i0 | PRJNA874604 | 86003 | 245 | 1.790698 | 4.3872101 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 59.3 | 4.88e-8 | NR | MEW6220043.1 | 2202153 | g85651 | i0 | 47.6 | 1.43265306122449 | 63 | 33 | 77.1 | 0 | 232 | 44 | 238 | 300 | MEW6220043.1 choice-of-anchor A family protein [Thermodesulfobacteriota bacterium] | diamond | 351 | 59.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27939766 | 27939766 | PRJNA874604_P_NODE_92805_length_243_cov_0.905882_g92453_i0 | PRJNA874604 | 92805 | 243 | 0.905882 | 2.20129326 | Trichloromonas sp. | 3069249 | Bacteria | Bacteria | 43.1 | 0.0276 | NR | MDX9709033.1 | 3069249 | g92453 | i0 | 33.8 | 0.950617283950617 | 77 | 50 | 93.8 | 1 | 243 | 16 | 74 | 150 | MDX9709033.1 AAA family ATPase [Trichloromonas sp.] | diamond | 231 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Trichloromonadaceae | Trichloromonas | Trichloromonas sp. | ||
| 28200077 | 28200077 | PRJNA874604_P_NODE_99326_length_241_cov_0.916667_g98974_i0 | PRJNA874604 | 99326 | 241 | 0.916667 | 2.20916747 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 43.5 | 0.019 | NR | WP_072905254.1 | 57040 | g98974 | i0 | 30.1 | 10.195020746888 | 83 | 46 | 88.4 | 2 | 230 | 18 | 334 | 416 | WP_072905254.1 VIT domain-containing protein [Malonomonas rubra] | diamond | 2457 | 43.9 | 0.990888382687927 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geopsychrobacteraceae | Malonomonas | Malonomonas rubra | ||
| 28223636 | 28223636 | PRJNA874604_P_NODE_54466_length_276_cov_1.280788_g54114_i0 | PRJNA874604 | 54466 | 276 | 1.280788 | 3.53497488 | Desulfuromonas soudanensis | 1603606 | Bacteria | Bacteria | 131 | 7.23e-34 | NR | WP_279330578.1 | 1603606 | g54114 | i0 | 65.5 | 9.80434782608696 | 87 | 30 | 94.6 | 0 | 14 | 274 | 92 | 178 | WP_279330578.1 asparagine--tRNA ligase [Desulfuromonas soudanensis] | diamond | 2706 | 131 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas soudanensis | ||
| 28791953 | 28791953 | PRJNA874604_P_NODE_39127_length_312_cov_1.104603_g38775_i0 | PRJNA874604 | 39127 | 312 | 1.104603 | 3.44636136 | Desulfovibrio sp. DV | 1844708 | Bacteria | Bacteria | 43.9 | 0.0289 | NR | WP_075352813.1 | 1844708 | g38775 | i0 | 37.7 | 0.740384615384615 | 77 | 35 | 67.3 | 3 | 35 | 244 | 105 | 175 | WP_075352813.1 LysR family transcriptional regulator [Desulfovibrio sp. DV] | diamond | 231 | 43.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. DV | ||
| 29202729 | 29202729 | PRJNA874604_P_NODE_59429_length_267_cov_1.288660_g59077_i0 | PRJNA874604 | 59429 | 267 | 1.28866 | 3.4407222 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 62.8 | 3.64e-9 | NR | MEW6220043.1 | 2202153 | g59077 | i0 | 40 | 0.955056179775281 | 85 | 51 | 95.5 | 0 | 6 | 260 | 192 | 276 | MEW6220043.1 choice-of-anchor A family protein [Thermodesulfobacteriota bacterium] | diamond | 255 | 62.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 30718636 | 30718636 | PRJNA874604_P_NODE_66094_length_255_cov_1.521978_g65742_i0 | PRJNA874604 | 66094 | 255 | 1.521978 | 3.8810439 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 75.5 | 4.81e-14 | NR | MBS3732837.1 | 2044940 | g65742 | i0 | 50.8 | 2.45882352941176 | 65 | 31 | 76.5 | 1 | 12 | 206 | 177 | 240 | MBS3732837.1 hypothetical protein [Desulfobacterales bacterium] | diamond | 627 | 75.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 30813468 | 30813468 | PRJNA874604_P_NODE_53774_length_277_cov_1.509804_g53422_i0 | PRJNA874604 | 53774 | 277 | 1.509804 | 4.18215708 | Desulfuromonadaceae bacterium | 2099677 | Bacteria | Bacteria | 43.5 | 0.0291 | NR | MDD2850619.1 | 2099677 | g53422 | i0 | 36.4 | 0.833935018050541 | 77 | 47 | 83.4 | 2 | 41 | 271 | 86 | 160 | MDD2850619.1 MFS transporter [Desulfuromonadaceae bacterium] | diamond | 231 | 43.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonadaceae bacterium | |||
| 30853152 | 30853152 | PRJNA874604_P_NODE_35594_length_323_cov_1.544000_g35242_i0 | PRJNA874604 | 35594 | 323 | 1.544 | 4.98712 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 133 | 3.18e-36 | NR | RUM35362.1 | 895 | g35242 | i0 | 64.6 | 14.5170278637771 | 99 | 34 | 92 | 1 | 319 | 23 | 110 | 207 | RUM35362.1 MAG: hypothetical protein DSY50_04930 [Desulfobulbus sp.] | diamond | 4689 | 134 | 0.992537313432836 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus sp. | ||
| 30908450 | 30908450 | PRJNA874604_P_NODE_86634_length_245_cov_0.895349_g86282_i0 | PRJNA874604 | 86634 | 245 | 0.895349 | 2.19360505 | Desulfobulbaceae bacterium BRH_c16a | 1629713 | Bacteria | Bacteria | 89.7 | 4.99e-19 | NR | KJS02832.1 | 1629713 | g86282 | i0 | 66.7 | 0.771428571428571 | 63 | 21 | 77.1 | 0 | 196 | 8 | 5 | 67 | KJS02832.1 MAG: hypothetical protein VR65_03850 [Desulfobulbaceae bacterium BRH_c16a] | diamond | 189 | 89.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbaceae bacterium BRH_c16a | |||
| 31603890 | 31603890 | PRJNA874604_P_NODE_57076_length_271_cov_1.520202_g56724_i0 | PRJNA874604 | 57076 | 271 | 1.520202 | 4.11974742 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 65.9 | 2.24e-10 | NR | MDQ1277081.1 | 2202153 | g56724 | i0 | 40.4 | 6.83025830258303 | 89 | 51 | 98.5 | 2 | 267 | 1 | 35 | 121 | MDQ1277081.1 Peptidase [Thermodesulfobacteriota bacterium] | diamond | 1851 | 65.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 31793370 | 31793370 | PRJNA874604_P_NODE_48837_length_286_cov_1.887324_g48485_i0 | PRJNA874604 | 48837 | 286 | 1.887324 | 5.39774664 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 138 | 8.3e-36 | NR | MBF0120447.1 | 2044940 | g48485 | i0 | 66.3 | 2.98951048951049 | 95 | 32 | 99.7 | 0 | 1 | 285 | 348 | 442 | MBF0120447.1 methylaspartate mutase subunit E [Desulfobacterales bacterium] | diamond | 855 | 138 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 31888390 | 31888390 | PRJNA874604_P_NODE_56097_length_273_cov_1.335000_g55745_i0 | PRJNA874604 | 56097 | 273 | 1.335 | 3.64455 | Syntrophaceae bacterium | 2052184 | Bacteria | Bacteria | 85.9 | 3.43e-17 | NR | MBS3907990.1 | 2052184 | g55745 | i0 | 50 | 1.57142857142857 | 74 | 37 | 81.3 | 0 | 3 | 224 | 232 | 305 | MBS3907990.1 mucoidy inhibitor MuiA family protein [Syntrophaceae bacterium] | diamond | 429 | 85.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophaceae bacterium | |||
| 32458188 | 32458188 | PRJNA874604_P_NODE_53039_length_278_cov_1.936585_g52687_i0 | PRJNA874604 | 53039 | 278 | 1.936585 | 5.3837063 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 62.4 | 1.94e-9 | NR | MDA8418796.1 | 2049433 | g52687 | i0 | 59.6 | 1.01438848920863 | 47 | 19 | 50.7 | 0 | 121 | 261 | 4 | 50 | MDA8418796.1 DUF2589 domain-containing protein [Desulfobacteraceae bacterium] | diamond | 282 | 62.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 32875879 | 32875879 | PRJNA874604_P_NODE_78540_length_248_cov_0.880000_g78188_i0 | PRJNA874604 | 78540 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 43.5 | 0.0107 | NR | WP_028576579.1 | 29503 | g78188 | i0 | 32.1 | 2.83064516129032 | 78 | 51 | 94.4 | 1 | 234 | 1 | 6 | 81 | WP_028576579.1 universal stress protein [Desulfomicrobium escambiense] | diamond | 702 | 43.9 | 0.990888382687927 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfomicrobiaceae | Desulfomicrobium | Desulfomicrobium escambiense |
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);;