contig_metadata
21 rows where bioproject = "PRJNA473824", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4273942 | 4273942 | PRJNA473824_P_NODE_39544_length_193_cov_2.711538_g38906_i0 | PRJNA473824 | 39544 | 193 | 2.711538 | 5.23326834 | Desulfobacter sp. | 2294 | Bacteria | Bacteria | 75 | 3.55e-9 | NTclustered | gi|2447547639|gb|CP054838.1| | 2294 | g38906 | i0 | 87.5 | 0.33160621761658 | 64 | 8 | 33 | 0 | 107 | 170 | 946969 | 947032 | MAG: Desulfobacter sp. isolate Buss2-1 chromosome, complete genome | blastn | 64 | 75 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | Desulfobacter sp. | ||
| 5550548 | 5550548 | PRJNA473824_P_NODE_37905_length_196_cov_4.823899_g37267_i0 | PRJNA473824 | 37905 | 196 | 4.823899 | 9.45484204 | Bacteria | 2 | Bacteria | Bacteria | 104 | 4.079999999999999e-24 | NR | WP_295544573.1 | 1912772 | g37267 | i0 | 72.3 | 14.9387755102041 | 65 | 13 | 99.5 | 1 | 2 | 196 | 117 | 176 | WP_295544573.1 type IV secretory system conjugative DNA transfer family protein [Halodesulfovibrio sp.] | diamond | 2928 | 104 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Halodesulfovibrio | Halodesulfovibrio sp. | ||
| 8099626 | 8099626 | PRJNA473824_P_NODE_164127_length_150_cov_5.053097_g163489_i0 | PRJNA473824 | 164127 | 150 | 5.053097 | 7.5796455 | Desulfomicrobium orale | 132132 | Bacteria | Bacteria | 141 | 2.53e-29 | NTclustered | gi|987456218|gb|CP014230.1| | 888061 | g163489 | i0 | 100 | 1.01333333333333 | 76 | 0 | 100 | 0 | 1 | 76 | 113790 | 113865 | Desulfomicrobium orale DSM 12838 chromosome, complete genome | blastn | 152 | 141 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfomicrobiaceae | Desulfomicrobium | Desulfomicrobium orale | ||
| 11925146 | 11925146 | PRJNA473824_P_NODE_160390_length_151_cov_2.789474_g159752_i0 | PRJNA473824 | 160390 | 151 | 2.789474 | 4.21210574 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 97.1 | 2.19e-22 | NR | RPH50413.1 | 2049433 | g159752 | i0 | 78.6 | 6.67549668874172 | 56 | 6 | 99.3 | 1 | 1 | 150 | 72 | 127 | RPH50413.1 MAG: GDP-L-fucose synthase [Desulfobacteraceae bacterium] | diamond | 1008 | 97.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 13200791 | 13200791 | PRJNA473824_P_NODE_60171_length_173_cov_4.830882_g59533_i0 | PRJNA473824 | 60171 | 173 | 4.830882 | 8.35742586 | Desulfomicrobium orale | 132132 | Bacteria | Bacteria | 237 | 3.74e-58 | NTclustered | gi|987456218|gb|CP014230.1| | 888061 | g59533 | i0 | 87.356 | 2.7514450867052 | 174 | 21 | 100 | 1 | 1 | 173 | 773098 | 772925 | Desulfomicrobium orale DSM 12838 chromosome, complete genome | blastn | 476 | 237 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfomicrobiaceae | Desulfomicrobium | Desulfomicrobium orale | ||
| 13850064 | 13850064 | PRJNA473824_P_NODE_29891_length_218_cov_1.287293_g29253_i0 | PRJNA473824 | 29891 | 218 | 1.287293 | 2.80629874 | Geotalea | 2910589 | Bacteria | Bacteria | 130 | 8.650000000000001e-26 | NTclustered | gi|221562406|gb|CP001390.1| | 316067 | g29253 | i0 | 79.899 | 29.7660550458716 | 199 | 23 | 86 | 13 | 1 | 188 | 2115156 | 2115348 | Geobacter daltonii FRC-32, complete genome | blastn | 6489 | 130 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geotalea | Geotalea daltonii | ||
| 15749452 | 15749452 | PRJNA473824_P_NODE_29373_length_219_cov_4.500000_g28735_i0 | PRJNA473824 | 29373 | 219 | 4.5 | 9.855 | Desulfarculus baarsii | 453230 | Bacteria | Bacteria | 71.3 | 5.35e-8 | NTclustered | gi|301638057|gb|CP002085.1| | 644282 | g28735 | i0 | 90.741 | 0.246575342465753 | 54 | 3 | 24 | 2 | 101 | 153 | 1890644 | 1890592 | Desulfarculus baarsii DSM 2075, complete genome | blastn | 54 | 71.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculales | Desulfarculaceae | Desulfarculus | Desulfarculus baarsii | ||
| 17024064 | 17024064 | PRJNA473824_P_NODE_27014_length_228_cov_3.952880_g26376_i0 | PRJNA473824 | 27014 | 228 | 3.95288 | 9.0125664 | Oceanidesulfovibrio marinus | 370038 | Bacteria | Bacteria | 52.8 | 0.02 | NTclustered | gi|1841667704|gb|CP039543.1| | 370038 | g26376 | i0 | 100 | 0.12280701754386 | 28 | 0 | 12 | 0 | 184 | 211 | 3134592 | 3134565 | Oceanidesulfovibrio marinus strain CS1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Oceanidesulfovibrio | Oceanidesulfovibrio marinus | ||
| 20847689 | 20847689 | PRJNA473824_P_NODE_103617_length_173_cov_2.698529_g102979_i0 | PRJNA473824 | 103617 | 173 | 2.698529 | 4.66845517 | Geobacter sp. SVR | 2495594 | Bacteria | Bacteria | 91.6 | 3.08e-14 | NTclustered | gi|1976315905|dbj|AP024469.1| | 2495594 | g102979 | i0 | 90 | 10.1965317919075 | 70 | 7 | 40 | 0 | 1 | 70 | 3156244 | 3156175 | Geobacter sp. SVR DNA, complete genome | blastn | 1764 | 91.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sp. SVR | ||
| 20847765 | 20847765 | PRJNA473824_P_NODE_114517_length_173_cov_2.301471_g113879_i0 | PRJNA473824 | 114517 | 173 | 2.301471 | 3.98154483 | Maridesulfovibrio sp. | 2795000 | Bacteria | Bacteria | 108 | 3.06e-19 | NTclustered | gi|2621785158|emb|OY781616.1| | 2795000 | g113879 | i0 | 92.105 | 8.82658959537572 | 76 | 6 | 44 | 0 | 98 | 173 | 228032 | 228107 | MAG: Maridesulfovibrio sp. isolate 7570950b-8a73-422e-b528-09704edcd613 genome assembly, chromosome: 1 | blastn | 1527 | 108 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Maridesulfovibrio | Maridesulfovibrio sp. | ||
| 23398388 | 23398388 | PRJNA473824_P_NODE_113879_length_173_cov_2.360294_g113241_i0 | PRJNA473824 | 113879 | 173 | 2.360294 | 4.08330862 | Desulfomicrobium orale | 132132 | Bacteria | Bacteria | 65.8 | 1.87e-6 | NTclustered | gi|987456218|gb|CP014230.1| | 888061 | g113241 | i0 | 95.122 | 0.445086705202312 | 41 | 2 | 24 | 0 | 21 | 61 | 2425695 | 2425735 | Desulfomicrobium orale DSM 12838 chromosome, complete genome | blastn | 77 | 65.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfomicrobiaceae | Desulfomicrobium | Desulfomicrobium orale | ||
| 23398642 | 23398642 | PRJNA473824_P_NODE_141999_length_151_cov_5.035088_g141361_i0 | PRJNA473824 | 141999 | 151 | 5.035088 | 7.60298288 | Desulfoluna limicola | 2810562 | Bacteria | Bacteria | 54.7 | 0.003 | NTclustered | gi|2158810072|dbj|AP024488.1| | 2810562 | g141361 | i0 | 100 | 0.19205298013245 | 29 | 0 | 19 | 0 | 30 | 58 | 4567007 | 4566979 | Desulfoluna sp. ASN36 ASN36 DNA, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfolunaceae | Desulfoluna | Desulfoluna limicola | ||
| 24048414 | 24048414 | PRJNA473824_P_NODE_42159_length_188_cov_2.072848_g41521_i0 | PRJNA473824 | 42159 | 188 | 2.072848 | 3.89695424 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 113 | 2.7600000000000004e-27 | NR | WP_374290838.1 | 876 | g41521 | i0 | 88.7 | 3.95744680851064 | 62 | 7 | 98.9 | 0 | 188 | 3 | 355 | 416 | WP_374290838.1 ATP-binding protein [Desulfovibrio desulfuricans] | diamond | 744 | 113 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio desulfuricans | ||
| 27708482 | 27708482 | PRJNA473824_P_NODE_27384_length_227_cov_1.536842_g26746_i0 | PRJNA473824 | 27384 | 227 | 1.536842 | 3.48863134 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 72.4 | 8.24e-15 | NR | MCH8014820.1 | 2080303 | g26746 | i0 | 57.6 | 3.11894273127753 | 59 | 24 | 76.7 | 1 | 1 | 174 | 12 | 70 | MCH8014820.1 tetratricopeptide repeat protein [Candidatus Dadabacteria bacterium] | diamond | 708 | 72.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 29475918 | 29475918 | PRJNA473824_P_NODE_66030_length_173_cov_4.213235_g65392_i0 | PRJNA473824 | 66030 | 173 | 4.213235 | 7.28889655 | Syntrophobacter fumaroxidans | 119484 | Bacteria | Bacteria | 43.9 | 0.00576 | NR | WP_011698309.1 | 119484 | g65392 | i0 | 62.5 | 0.416184971098266 | 24 | 9 | 41.6 | 0 | 74 | 3 | 348 | 371 | WP_011698309.1 PAS domain S-box protein [Syntrophobacter fumaroxidans] | diamond | 72 | 43.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Syntrophobacter | Syntrophobacter fumaroxidans | ||
| 29649753 | 29649753 | PRJNA473824_P_NODE_45630_length_181_cov_14.305556_g44992_i0 | PRJNA473824 | 45630 | 181 | 14.305556 | 25.89305636 | Bacteria | 2 | Bacteria | Bacteria | 85.1 | 3.42e-19 | NR | MDQ1269207.1 | 2202153 | g44992 | i0 | 71.2 | 7.70718232044199 | 59 | 17 | 97.8 | 0 | 179 | 3 | 78 | 136 | MDQ1269207.1 rare lipoprotein [Thermodesulfobacteriota bacterium] | diamond | 1395 | 85.9 | 0.990686845168801 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 30613221 | 30613221 | PRJNA473824_P_NODE_143553_length_151_cov_4.649123_g142915_i0 | PRJNA473824 | 143553 | 151 | 4.649123 | 7.02017573 | Desulfuromonadales bacterium | 2099678 | Bacteria | Bacteria | 43.1 | 0.00705 | NR | MBK5275779.1 | 2099678 | g142915 | i0 | 43.5 | 0.913907284768212 | 46 | 26 | 91.4 | 0 | 143 | 6 | 14 | 59 | MBK5275779.1 hypothetical protein [Desulfuromonadales bacterium] | diamond | 138 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadales bacterium | ||||
| 30676399 | 30676399 | PRJNA473824_P_NODE_32813_length_209_cov_3.151163_g32175_i0 | PRJNA473824 | 32813 | 209 | 3.151163 | 6.58593067 | uncultured Desulfovibrio sp. | 167968 | Bacteria | Bacteria | 44.7 | 0.00498 | NR | WP_296303755.1 | 167968 | g32175 | i0 | 60 | 0.502392344497608 | 35 | 14 | 50.2 | 0 | 106 | 2 | 196 | 230 | WP_296303755.1 PcfJ domain-containing protein [uncultured Desulfovibrio sp.] | diamond | 105 | 44.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | uncultured Desulfovibrio sp. | ||
| 32020650 | 32020650 | PRJNA473824_P_NODE_16558_length_292_cov_1.329412_g15920_i0 | PRJNA473824 | 16558 | 292 | 1.329412 | 3.88188304 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 49.3 | 3.38e-4 | NR | MBI5250990.1 | 2358 | g15920 | i0 | 52.4 | 1.36643835616438 | 42 | 20 | 43.2 | 0 | 157 | 32 | 360 | 401 | MBI5250990.1 DUF1311 domain-containing protein [Desulfomonile tiedjei] | diamond | 399 | 49.7 | 0.991951710261569 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfomonilia | Desulfomonilales | Desulfomonilaceae | Desulfomonile | Desulfomonile tiedjei | ||
| 32036070 | 32036070 | PRJNA473824_P_NODE_15918_length_298_cov_5.915709_g15280_i0 | PRJNA473824 | 15918 | 298 | 5.915709 | 17.62881282 | Halodesulfovibrio spirochaetisodalis | 1560234 | Bacteria | Bacteria | 95.1 | 2.88e-20 | NR | WP_066856630.1 | 1560234 | g15280 | i0 | 67.2 | 0.614093959731544 | 61 | 20 | 61.4 | 0 | 115 | 297 | 1 | 61 | WP_066856630.1 DNA topoisomerase III [Halodesulfovibrio spirochaetisodalis] | diamond | 183 | 95.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Halodesulfovibrio | Halodesulfovibrio spirochaetisodalis | ||
| 32888686 | 32888686 | PRJNA473824_P_NODE_34640_length_204_cov_3.970060_g34002_i0 | PRJNA473824 | 34640 | 204 | 3.97006 | 8.0989224 | Syntrophales bacterium | 2928017 | Bacteria | Bacteria | 117 | 1.19e-28 | NR | HVO67705.1 | 2928017 | g34002 | i0 | 76.1 | 0.985294117647059 | 67 | 16 | 98.5 | 0 | 4 | 204 | 770 | 836 | HVO67705.1 PAS domain S-box protein [Syntrophales bacterium] | diamond | 201 | 117 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophales 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);;