contig_metadata
17 rows where bioproject = "PRJNA489308", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15752858 | 15752858 | PRJNA489308_P_NODE_26433_length_263_cov_1.621053_g26357_i0 | PRJNA489308 | 26433 | 263 | 1.621053 | 4.26336939 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 85.9 | 6.27e-18 | NR | WP_092214393.1 | 419481 | g26357 | i0 | 65 | 16.5171102661597 | 60 | 19 | 66.2 | 1 | 3 | 176 | 214 | 273 | WP_092214393.1 50S ribosomal protein L2 [Desulfoluna spongiiphila] | diamond | 4344 | 86.3 | 0.995365005793743 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfolunaceae | Desulfoluna | Desulfoluna spongiiphila | ||
| 26601234 | 26601234 | PRJNA489308_P_NODE_12861_length_329_cov_1.148438_g12785_i0 | PRJNA489308 | 12861 | 329 | 1.148438 | 3.77836102 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 115 | 2.7000000000000003e-28 | NR | UCF95232.1 | 2044940 | g12785 | i0 | 54.4 | 7.44984802431611 | 103 | 42 | 93.9 | 1 | 312 | 4 | 266 | 363 | UCF95232.1 MAG: DSD1 family PLP-dependent enzyme [Desulfobacterales bacterium] | diamond | 2451 | 115 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 27266079 | 27266079 | PRJNA489308_P_NODE_7263_length_401_cov_3.347561_g7187_i0 | PRJNA489308 | 7263 | 401 | 3.347561 | 13.42371961 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 51.6 | 2.6e-5 | NR | MEJ2102355.1 | 2044940 | g7187 | i0 | 38.9 | 0.673316708229426 | 90 | 48 | 67.3 | 2 | 397 | 128 | 4 | 86 | MEJ2102355.1 DUF86 domain-containing protein [Desulfobacterales bacterium] | diamond | 270 | 51.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 27313825 | 27313825 | PRJNA489308_P_NODE_40823_length_226_cov_2.888889_g40747_i0 | PRJNA489308 | 40823 | 226 | 2.888889 | 6.52888914 | Bacteria | 2 | Bacteria | Bacteria | 50.1 | 6.96e-5 | NR | RPI74175.1 | 2049433 | g40747 | i0 | 41.2 | 2.5353982300885 | 68 | 35 | 90.3 | 2 | 206 | 3 | 119 | 181 | RPI74175.1 MAG: TraB/GumN family protein, partial [Desulfobacteraceae bacterium] | diamond | 573 | 50.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 27692885 | 27692885 | PRJNA489308_P_NODE_2604_length_609_cov_1.792910_g2528_i0 | PRJNA489308 | 2604 | 609 | 1.79291 | 10.9188219 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 114 | 1.25e-25 | NR | WP_015947357.1 | 218208 | g2528 | i0 | 36.8 | 2.97536945812808 | 201 | 99 | 98 | 9 | 598 | 2 | 261 | 435 | WP_015947357.1 thrombospondin type-1 domain-containing protein [Desulfatibacillum aliphaticivorans] | diamond | 1812 | 114 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfatibacillaceae | Desulfatibacillum | Desulfatibacillum aliphaticivorans | ||
| 27771514 | 27771514 | PRJNA489308_P_NODE_4984_length_469_cov_2.515152_g4908_i0 | PRJNA489308 | 4984 | 469 | 2.515152 | 11.79606288 | Geotalea uraniireducens | 351604 | Bacteria | Bacteria | 132 | 2.3999999999999999e-32 | NR | WP_011936964.1 | 351604 | g4908 | i0 | 54.4 | 2.31556503198294 | 136 | 50 | 87 | 4 | 408 | 1 | 482 | 605 | WP_011936964.1 5-histidylcysteine sulfoxide synthase [Geotalea uraniireducens] | diamond | 1086 | 132 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geotalea | Geotalea uraniireducens | ||
| 28118506 | 28118506 | PRJNA489308_P_NODE_12565_length_331_cov_1.244186_g12489_i0 | PRJNA489308 | 12565 | 331 | 1.244186 | 4.11825566 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 45.1 | 0.0137 | NR | MEW6376070.1 | 2202153 | g12489 | i0 | 70 | 0.181268882175227 | 20 | 6 | 18.1 | 0 | 255 | 314 | 13 | 32 | MEW6376070.1 SurA N-terminal domain-containing protein [Thermodesulfobacteriota bacterium] | diamond | 60 | 45.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 29507811 | 29507811 | PRJNA489308_P_NODE_37770_length_242_cov_1.218935_g37694_i0 | PRJNA489308 | 37770 | 242 | 1.218935 | 2.9498227 | Candidatus Magnetomorum sp. HK-1 | 1509431 | Bacteria | Bacteria | 73.2 | 7.07e-13 | NR | KPA11627.1 | 1509431 | g37694 | i0 | 49.4 | 1.74793388429752 | 77 | 33 | 95.5 | 2 | 11 | 241 | 759 | 829 | KPA11627.1 multi-sensor hybrid histidine kinase [Candidatus Magnetomorum sp. HK-1] | diamond | 423 | 73.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Candidatus Magnetomoraceae | Candidatus Magnetomorum | Candidatus Magnetomorum sp. HK-1 | ||
| 29523953 | 29523953 | PRJNA489308_P_NODE_13550_length_323_cov_2.348000_g13474_i0 | PRJNA489308 | 13550 | 323 | 2.348 | 7.58404 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 125 | 6.3e-32 | NR | WP_367360148.1 | 48412 | g13474 | i0 | 51.4 | 4.56037151702786 | 105 | 50 | 97.5 | 1 | 318 | 4 | 171 | 274 | WP_367360148.1 hypothetical protein [Syntrophus sp. (in: bacteria)] | diamond | 1473 | 125 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophus | Syntrophus sp. (in: bacteria) | ||
| 29839652 | 29839652 | PRJNA489308_P_NODE_6051_length_433_cov_1.669444_g5975_i0 | PRJNA489308 | 6051 | 433 | 1.669444 | 7.22869252 | Desulfofustis | 51194 | Bacteria | Bacteria | 87.8 | 1.19e-17 | NR | MBL0379062.1 | 1385624 | g5975 | i0 | 53.6 | 1.16397228637413 | 84 | 38 | 57.5 | 1 | 323 | 75 | 211 | 294 | MBL0379062.1 ADP-ribosylglycohydrolase family protein [Desulfofustis sp. PB-SRB1] | diamond | 504 | 87.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulfofustis | Desulfofustis sp. PB-SRB1 | ||
| 30739832 | 30739832 | PRJNA489308_P_NODE_1654_length_729_cov_20.647866_g1580_i0 | PRJNA489308 | 1654 | 729 | 20.647866 | 150.52294314 | Desulfobacterales bacterium HSG2 | 3055596 | Bacteria | Bacteria | 83.6 | 1.89e-14 | NR | MDM8549572.1 | 3055596 | g1580 | i0 | 31.9 | 0.748971193415638 | 182 | 107 | 69.1 | 5 | 174 | 677 | 33 | 211 | MDM8549572.1 peptidase inhibitor family I36 protein [Desulfobacterales bacterium HSG2] | diamond | 546 | 83.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium HSG2 | ||||
| 30866180 | 30866180 | PRJNA489308_P_NODE_4514_length_487_cov_2.855072_g4438_i0 | PRJNA489308 | 4514 | 487 | 2.855072 | 13.904200640000001 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 46.6 | 0.00268 | NR | MDX2441450.1 | 2044940 | g4438 | i0 | 48.9 | 0.277207392197125 | 45 | 23 | 27.7 | 0 | 484 | 350 | 62 | 106 | MDX2441450.1 spermidine synthase [Desulfobacterales bacterium] | diamond | 135 | 46.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 31118725 | 31118725 | PRJNA489308_P_NODE_1275_length_809_cov_24.626359_g1211_i0 | PRJNA489308 | 1275 | 809 | 24.626359 | 199.22724431 | Desulfobacterales bacterium HSG2 | 3055596 | Bacteria | Bacteria | 81.6 | 1.52e-13 | NR | MDM8549572.1 | 3055596 | g1211 | i0 | 31.9 | 0.674907292954265 | 182 | 107 | 62.3 | 5 | 174 | 677 | 33 | 211 | MDM8549572.1 peptidase inhibitor family I36 protein [Desulfobacterales bacterium HSG2] | diamond | 546 | 81.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium HSG2 | ||||
| 31340305 | 31340305 | PRJNA489308_P_NODE_22916_length_275_cov_2.039604_g22840_i0 | PRJNA489308 | 22916 | 275 | 2.039604 | 5.608911 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 47.4 | 6.29e-4 | NR | MFB3885833.1 | 2202153 | g22840 | i0 | 45.8 | 1.0581818181818201 | 48 | 25 | 51.3 | 1 | 12 | 152 | 124 | 171 | MFB3885833.1 DUF4833 domain-containing protein [Thermodesulfobacteriota bacterium] | diamond | 291 | 47.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 31466992 | 31466992 | PRJNA489308_P_NODE_1276_length_809_cov_22.652174_g1212_i0 | PRJNA489308 | 1276 | 809 | 22.652174 | 183.25608766 | Desulfobacterales bacterium HSG2 | 3055596 | Bacteria | Bacteria | 81.6 | 1.52e-13 | NR | MDM8549572.1 | 3055596 | g1212 | i0 | 32.4 | 1.35352286773795 | 182 | 106 | 62.3 | 5 | 636 | 133 | 33 | 211 | MDM8549572.1 peptidase inhibitor family I36 protein [Desulfobacterales bacterium HSG2] | diamond | 1095 | 81.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium HSG2 | ||||
| 31672585 | 31672585 | PRJNA489308_P_NODE_36257_length_244_cov_0.900585_g36181_i0 | PRJNA489308 | 36257 | 244 | 0.900585 | 2.1974274 | Nitrospinota/Tectimicrobiota group | 1802340 | Bacteria | Bacteria | 104 | 5.39e-25 | NR | HEA69194.1 | 2044940 | g36181 | i0 | 65.8 | 6.77459016393443 | 79 | 27 | 97.1 | 0 | 241 | 5 | 123 | 201 | HEA69194.1 ribokinase [Desulfobacterales bacterium] | diamond | 1653 | 104 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 31846291 | 31846291 | PRJNA489308_P_NODE_26817_length_262_cov_1.544974_g26741_i0 | PRJNA489308 | 26817 | 262 | 1.544974 | 4.04783188 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 53.5 | 6.98e-6 | NR | MCP3927172.1 | 2044940 | g26741 | i0 | 57.1 | 1.30534351145038 | 35 | 15 | 40.1 | 0 | 78 | 182 | 224 | 258 | MCP3927172.1 DUF1963 domain-containing protein [Desulfobacterales bacterium] | diamond | 342 | 53.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales 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);;