contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA944406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14952692 | 14952692 | PRJNA944406_P_NODE_60772_length_253_cov_1.500000_g59813_i0 | PRJNA944406 | 60772 | 253 | 1.5 | 3.795 | Geobacterales bacterium | 3069300 | Bacteria | Bacteria | 132 | 1.2e-34 | NR | HWJ18771.1 | 3069300 | g59813 | i0 | 91.4 | 1.6600790513834 | 70 | 6 | 83 | 0 | 2 | 211 | 337 | 406 | HWJ18771.1 IS256 family transposase [Geobacterales bacterium] | diamond | 420 | 132 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacterales bacterium | ||||
| 26778981 | 26778981 | PRJNA944406_P_NODE_64021_length_251_cov_0.865169_g63062_i0 | PRJNA944406 | 64021 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 76.3 | 5.11e-14 | NR | KRT66328.1 | 1640508 | g63062 | i0 | 45.6 | 2.86852589641434 | 79 | 37 | 94.4 | 2 | 238 | 2 | 218 | 290 | KRT66328.1 MAG: FAD-dependent pyridine nucleotide-disulfide oxidoreductase [Candidatus Dadabacteria bacterium CSP1-2] | diamond | 720 | 76.6 | 0.996083550913838 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium CSP1-2 | |||||
| 26803707 | 26803707 | PRJNA944406_P_NODE_67301_length_250_cov_1.666667_g66342_i0 | PRJNA944406 | 67301 | 250 | 1.666667 | 4.1666675 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 93.2 | 6.39e-20 | NR | MCP4347920.1 | 2044940 | g66342 | i0 | 51.2 | 3.936 | 82 | 40 | 98.4 | 0 | 250 | 5 | 189 | 270 | MCP4347920.1 IS701 family transposase [Desulfobacterales bacterium] | diamond | 984 | 93.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 26898836 | 26898836 | PRJNA944406_P_NODE_107961_length_241_cov_0.916667_g107002_i0 | PRJNA944406 | 107961 | 241 | 0.916667 | 2.20916747 | Desulfobulbus propionicus | 894 | Bacteria | Bacteria | 60.1 | 2.45e-8 | NR | WP_015722870.1 | 894 | g107002 | i0 | 84.8 | 0.821576763485477 | 33 | 5 | 41.1 | 0 | 2 | 100 | 291 | 323 | WP_015722870.1 hypothetical protein [Desulfobulbus propionicus] | diamond | 198 | 60.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus propionicus | ||
| 27278268 | 27278268 | PRJNA944406_P_NODE_29003_length_283_cov_1.276190_g28044_i0 | PRJNA944406 | 29003 | 283 | 1.27619 | 3.6116177 | Syntrophotalea acetylenica | 29542 | Bacteria | Bacteria | 58.5 | 9.24e-8 | NR | MDD4457008.1 | 29542 | g28044 | i0 | 44.3 | 0.742049469964664 | 70 | 36 | 74.2 | 1 | 60 | 269 | 170 | 236 | MDD4457008.1 putative molybdenum carrier protein [Syntrophotalea acetylenica] | diamond | 210 | 58.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Syntrophotaleaceae | Syntrophotalea | Syntrophotalea acetylenica | ||
| 27664117 | 27664117 | PRJNA944406_P_NODE_90984_length_245_cov_0.895349_g90025_i0 | PRJNA944406 | 90984 | 245 | 0.895349 | 2.19360505 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 79 | 6.47e-15 | NR | MFC1835761.1 | 2202153 | g90025 | i0 | 50 | 5.93877551020408 | 80 | 40 | 98 | 0 | 241 | 2 | 258 | 337 | MFC1835761.1 ATP-dependent RecD-like DNA helicase [Thermodesulfobacteriota bacterium] | diamond | 1455 | 79 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27720830 | 27720830 | PRJNA944406_P_NODE_73744_length_249_cov_0.875000_g72785_i0 | PRJNA944406 | 73744 | 249 | 0.875 | 2.17875 | Geobacter sp. | 46610 | Bacteria | Bacteria | 117 | 2.18e-28 | NR | WP_298439051.1 | 46610 | g72785 | i0 | 65.9 | 1.97590361445783 | 82 | 28 | 98.8 | 0 | 247 | 2 | 1043 | 1124 | WP_298439051.1 putative baseplate assembly protein [Geobacter sp.] | diamond | 492 | 117 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sp. | ||
| 27941398 | 27941398 | PRJNA944406_P_NODE_107905_length_241_cov_0.916667_g106946_i0 | PRJNA944406 | 107905 | 241 | 0.916667 | 2.20916747 | Geobacteraceae bacterium | 2282154 | Bacteria | Bacteria | 75.1 | 1.46e-13 | NR | KAF0217726.1 | 2282154 | g106946 | i0 | 41 | 0.970954356846473 | 78 | 46 | 97.1 | 0 | 1 | 234 | 275 | 352 | KAF0217726.1 MAG: PAS/PAC sensor signal transduction histidine [Geobacteraceae bacterium] | diamond | 234 | 75.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacteraceae bacterium | |||
| 28415088 | 28415088 | PRJNA944406_P_NODE_44206_length_268_cov_2.307692_g43247_i0 | PRJNA944406 | 44206 | 268 | 2.307692 | 6.18461456 | Pelobacteraceae bacterium | 3024407 | Bacteria | Bacteria | 49.3 | 2.45e-4 | NR | MFA7405999.1 | 3024407 | g43247 | i0 | 57.5 | 1.42164179104478 | 40 | 17 | 44.8 | 0 | 122 | 3 | 73 | 112 | MFA7405999.1 PAS domain S-box protein [Pelobacteraceae bacterium] | diamond | 381 | 49.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Pelobacteraceae | Pelobacteraceae bacterium | |||
| 28572803 | 28572803 | PRJNA944406_P_NODE_60307_length_253_cov_1.961111_g59348_i0 | PRJNA944406 | 60307 | 253 | 1.961111 | 4.96161083 | uncultured Desulfobacterium sp. | 201089 | Bacteria | Bacteria | 110 | 4.68e-26 | NR | SPD75420.1 | 201089 | g59348 | i0 | 62.5 | 0.948616600790514 | 80 | 30 | 94.9 | 0 | 253 | 14 | 929 | 1008 | SPD75420.1 putative Serine/threonine protein kinase [uncultured Desulfobacterium sp.] | diamond | 240 | 110 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteriaceae | Desulfobacterium | uncultured Desulfobacterium sp. | ||
| 28667712 | 28667712 | PRJNA944406_P_NODE_71627_length_249_cov_1.698864_g70668_i0 | PRJNA944406 | 71627 | 249 | 1.698864 | 4.23017136 | Desulforegula conservatrix | 153026 | Bacteria | Bacteria | 91.3 | 6.25e-20 | NR | WP_027360242.1 | 153026 | g70668 | i0 | 74.5 | 0.614457831325301 | 51 | 12 | 61.4 | 1 | 93 | 245 | 1 | 50 | WP_027360242.1 DNA (cytosine-5-)-methyltransferase [Desulforegula conservatrix] | diamond | 153 | 91.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulforegulaceae | Desulforegula | Desulforegula conservatrix | ||
| 28793705 | 28793705 | PRJNA944406_P_NODE_41787_length_271_cov_1.287879_g40828_i0 | PRJNA944406 | 41787 | 271 | 1.287879 | 3.49015209 | Geobacter sp. AOG1 | 1566346 | Bacteria | Bacteria | 178 | 5.62e-54 | NR | WP_223907757.1 | 1566346 | g40828 | i0 | 85.9 | 1.92619926199262 | 85 | 12 | 94.1 | 0 | 269 | 15 | 57 | 141 | WP_223907757.1 4Fe-4S dicluster domain-containing protein [Geobacter sp. AOG1] | diamond | 522 | 178 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sp. AOG1 | ||
| 28919970 | 28919970 | PRJNA944406_P_NODE_43728_length_269_cov_1.459184_g42769_i0 | PRJNA944406 | 43728 | 269 | 1.459184 | 3.92520496 | Citrifermentans bremense | 60035 | Bacteria | Bacteria | 49.3 | 5.1e-5 | NR | WP_226377764.1 | 60035 | g42769 | i0 | 38 | 0.8810408921933092 | 79 | 41 | 83.6 | 3 | 227 | 3 | 10 | 84 | WP_226377764.1 GNAT family N-acetyltransferase [Citrifermentans bremense] | diamond | 237 | 49.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Citrifermentans | Citrifermentans bremense | ||
| 29141357 | 29141357 | PRJNA944406_P_NODE_16129_length_321_cov_1.733871_g15170_i0 | PRJNA944406 | 16129 | 321 | 1.733871 | 5.56572591 | Malonomonas rubra | 57040 | Bacteria | Bacteria | 79.7 | 2.44e-16 | NR | WP_072910218.1 | 57040 | g15170 | i0 | 42.3 | 1.69158878504673 | 104 | 50 | 97.2 | 4 | 8 | 319 | 7 | 100 | WP_072910218.1 Hsp20/alpha crystallin family protein [Malonomonas rubra] | diamond | 543 | 79.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geopsychrobacteraceae | Malonomonas | Malonomonas rubra | ||
| 29235959 | 29235959 | PRJNA944406_P_NODE_102709_length_242_cov_0.911243_g101750_i0 | PRJNA944406 | 102709 | 242 | 0.911243 | 2.20520806 | Geobacteraceae bacterium | 2282154 | Bacteria | Bacteria | 89.4 | 2.32e-20 | NR | HZV82819.1 | 2282154 | g101750 | i0 | 70.5 | 0.756198347107438 | 61 | 16 | 73.1 | 1 | 24 | 200 | 102 | 162 | HZV82819.1 type II secretion system protein [Geobacteraceae bacterium] | diamond | 183 | 89.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacteraceae bacterium | |||
| 29488299 | 29488299 | PRJNA944406_P_NODE_70510_length_250_cov_0.870056_g69551_i0 | PRJNA944406 | 70510 | 250 | 0.870056 | 2.17514 | Syntrophobacter sp. | 66700 | Bacteria | Bacteria | 103 | 2.2699999999999994e-23 | NR | MEN6438702.1 | 66700 | g69551 | i0 | 61 | 1.968 | 82 | 32 | 98.4 | 0 | 246 | 1 | 773 | 854 | MEN6438702.1 MG2 domain-containing protein [Syntrophobacter sp.] | diamond | 492 | 103 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Syntrophobacter | Syntrophobacter sp. | ||
| 30214745 | 30214745 | PRJNA944406_P_NODE_69392_length_250_cov_0.870056_g68433_i0 | PRJNA944406 | 69392 | 250 | 0.870056 | 2.17514 | Desulfuromonas sp. KJ2 | 892 | Bacteria | Bacteria | 57.4 | 2.77e-7 | NR | WP_253960274.1 | 2919173 | g68433 | i0 | 43.7 | 0.852 | 71 | 40 | 85.2 | 0 | 37 | 249 | 124 | 194 | WP_253960274.1 DUF3466 family protein [Desulfuromonas sp. KJ2020] | diamond | 213 | 57.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. KJ2020 | ||
| 30310227 | 30310227 | PRJNA944406_P_NODE_66232_length_251_cov_0.865169_g65273_i0 | PRJNA944406 | 66232 | 251 | 0.865169 | 2.17157419 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 59.3 | 5.36e-9 | NR | NIR13553.1 | 2044940 | g65273 | i0 | 47.5 | 0.729083665338645 | 61 | 32 | 72.9 | 0 | 67 | 249 | 12 | 72 | NIR13553.1 DUF1599 domain-containing protein [Desulfobacterales bacterium] | diamond | 183 | 59.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 30404865 | 30404865 | PRJNA944406_P_NODE_106813_length_241_cov_1.476190_g105854_i0 | PRJNA944406 | 106813 | 241 | 1.47619 | 3.5576179 | Desulfobacterales bacterium S373 | 2044940 | Bacteria | Bacteria | 90.1 | 1.31e-19 | NR | OEU52104.1 | 1869298 | g105854 | i0 | 56.2 | 0.908713692946058 | 73 | 32 | 90.9 | 0 | 221 | 3 | 3 | 75 | OEU52104.1 MAG: hypothetical protein BA861_01000 [Desulfobacterales bacterium S3730MH5] | diamond | 219 | 90.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium S3730MH5 | ||||
| 30436394 | 30436394 | PRJNA944406_P_NODE_96613_length_244_cov_0.900585_g95654_i0 | PRJNA944406 | 96613 | 244 | 0.900585 | 2.1974274 | Geobacteraceae bacterium | 2282154 | Bacteria | Bacteria | 63.2 | 2.42e-9 | NR | HEY5973117.1 | 2282154 | g95654 | i0 | 49.2 | 1.57377049180328 | 65 | 29 | 77.5 | 3 | 49 | 237 | 349 | 411 | HEY5973117.1 Ig-like domain-containing protein [Geobacteraceae bacterium] | diamond | 384 | 63.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacteraceae bacterium | |||
| 31289082 | 31289082 | PRJNA944406_P_NODE_102055_length_242_cov_1.781065_g101096_i0 | PRJNA944406 | 102055 | 242 | 1.781065 | 4.3101773 | Geobacter sulfurreducens | 35554 | Bacteria | Bacteria | 98.2 | 5.03e-23 | NR | WP_214303090.1 | 35554 | g101096 | i0 | 59 | 0.966942148760331 | 78 | 32 | 96.7 | 0 | 9 | 242 | 100 | 177 | WP_214303090.1 class I SAM-dependent methyltransferase [Geobacter sulfurreducens] | diamond | 234 | 98.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sulfurreducens | ||
| 31890168 | 31890168 | PRJNA944406_P_NODE_76017_length_248_cov_1.680000_g75058_i0 | PRJNA944406 | 76017 | 248 | 1.68 | 4.1664 | Malonomonas sp. | 3050478 | Bacteria | Bacteria | 89 | 1.86e-18 | NR | HEY5673792.1 | 3050478 | g75058 | i0 | 58.9 | 0.883064516129032 | 73 | 30 | 88.3 | 0 | 246 | 28 | 403 | 475 | HEY5673792.1 PKD domain-containing protein [Malonomonas sp.] | diamond | 219 | 89 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geopsychrobacteraceae | Malonomonas | Malonomonas sp. | ||
| 31953436 | 31953436 | PRJNA944406_P_NODE_70157_length_250_cov_0.870056_g69198_i0 | PRJNA944406 | 70157 | 250 | 0.870056 | 2.17514 | Geobacter metallireducens | 28232 | Bacteria | Bacteria | 113 | 7.249999999999998e-30 | NR | WP_187148453.1 | 28232 | g69198 | i0 | 65.4 | 1.896 | 78 | 27 | 93.6 | 0 | 243 | 10 | 16 | 93 | WP_187148453.1 hypothetical protein [Geobacter metallireducens] | diamond | 474 | 113 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter metallireducens | ||
| 32206707 | 32206707 | PRJNA944406_P_NODE_89518_length_245_cov_1.197674_g88559_i0 | PRJNA944406 | 89518 | 245 | 1.197674 | 2.9343013 | Syntrophorhabdaceae bacterium | 2660714 | Bacteria | Bacteria | 92 | 1.73e-19 | NR | HEY3278343.1 | 2660714 | g88559 | i0 | 53.1 | 6.93061224489796 | 81 | 38 | 99.2 | 0 | 2 | 244 | 481 | 561 | HEY3278343.1 SBBP repeat-containing protein [Syntrophorhabdaceae bacterium] | diamond | 1698 | 92 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophorhabdia | Syntrophorhabdales | Syntrophorhabdaceae | Syntrophorhabdaceae bacterium | |||
| 32238558 | 32238558 | PRJNA944406_P_NODE_53298_length_260_cov_1.588235_g52339_i0 | PRJNA944406 | 53298 | 260 | 1.588235 | 4.129411 | Desulfovibrionaceae bacterium | 2049043 | Bacteria | Bacteria | 73.6 | 6.56e-13 | NR | MBQ7585133.1 | 2049043 | g52339 | i0 | 57.8 | 3.41538461538462 | 64 | 27 | 73.8 | 0 | 4 | 195 | 583 | 646 | MBQ7585133.1 DEAD/DEAH box helicase [Desulfovibrionaceae bacterium] | diamond | 888 | 73.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrionaceae bacterium | |||
| 32869585 | 32869585 | PRJNA944406_P_NODE_68980_length_250_cov_0.870056_g68021_i0 | PRJNA944406 | 68980 | 250 | 0.870056 | 2.17514 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 88.6 | 1.46e-19 | NR | HEY7534659.1 | 2202153 | g68021 | i0 | 48.1 | 1.908 | 77 | 40 | 92.4 | 0 | 250 | 20 | 111 | 187 | HEY7534659.1 DUF1579 domain-containing protein [Thermodesulfobacteriota bacterium] | diamond | 477 | 88.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 32869597 | 32869597 | PRJNA944406_P_NODE_85040_length_246_cov_1.381503_g84081_i0 | PRJNA944406 | 85040 | 246 | 1.381503 | 3.39849738 | Geobacter sp. | 46610 | Bacteria | Bacteria | 84.3 | 8.77e-17 | NR | WP_306534704.1 | 46610 | g84081 | i0 | 52.6 | 1.90243902439024 | 78 | 35 | 92.7 | 2 | 245 | 18 | 5 | 82 | WP_306534704.1 HEAT repeat domain-containing protein [Geobacter sp.] | diamond | 468 | 84.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sp. |
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);;