contig_metadata
22 rows where bioproject = "PRJNA1144090", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7940061 | 7940061 | PRJNA1144090_P_NODE_121327_length_210_cov_4.744526_g120792_i0 | PRJNA1144090 | 121327 | 210 | 4.744526 | 9.9635046 | Desulfocapsa sulfexigens | 65555 | Bacteria | Bacteria | 52.8 | 0.018 | NTclustered | gi|451904998|gb|CP003985.1| | 1167006 | g120792 | i0 | 100 | 0.133333333333333 | 28 | 0 | 13 | 0 | 3 | 30 | 935159 | 935132 | Desulfocapsa sulfexigens DSM 10523, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulfocapsa | Desulfocapsa sulfexigens | ||
| 10490460 | 10490460 | PRJNA1144090_P_NODE_10589_length_866_cov_2.674653_g10156_i0 | PRJNA1144090 | 10589 | 866 | 2.674653 | 23.16249498 | Desulfovibrio desulfuricans | 876 | Bacteria | Bacteria | 58.4 | 0.002 | NTclustered | gi|2884834435|gb|CP176628.1| | 876 | g10156 | i0 | 97.059 | 0.0785219399538106 | 34 | 1 | 5 | 0 | 180 | 213 | 748355 | 748322 | Desulfovibrio desulfuricans strain SFAD67 chromosome, complete genome | blastn | 68 | 58.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio desulfuricans | ||
| 16864767 | 16864767 | PRJNA1144090_P_NODE_71714_length_298_cov_2.800000_g71179_i0 | PRJNA1144090 | 71714 | 298 | 2.8 | 8.344 | Desulfosarcina ovata | 83564 | Bacteria | Bacteria | 67.6 | 9.89e-7 | NTclustered | gi|1774952549|dbj|AP021879.1| | 2752305 | g71179 | i0 | 86.667 | 0.929530201342282 | 60 | 8 | 20 | 0 | 176 | 235 | 2114025 | 2114084 | Desulfosarcina ovata subsp. ovata oXyS1 DNA, complete genome | blastn | 277 | 67.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosarcinaceae | Desulfosarcina | Desulfosarcina ovata | ||
| 18139410 | 18139410 | PRJNA1144090_P_NODE_73735_length_294_cov_2.045249_g73200_i0 | PRJNA1144090 | 73735 | 294 | 2.045249 | 6.01303206 | root | 1 | Root_unresolved | Root_unresolved | 127 | 3.9699999999999996e-32 | NR | WP_273025747.1 | 1741 | g73200 | i0 | 64.3 | 27.9795918367347 | 98 | 35 | 100 | 0 | 1 | 294 | 74 | 171 | WP_273025747.1 chaperonin GroEL [Thermodesulfobacterium commune] | diamond | 8226 | 128 | 0.9921875 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteria | Thermodesulfobacteriales | Thermodesulfobacteriaceae | Thermodesulfobacterium | Thermodesulfobacterium commune | ||
| 25259388 | 25259388 | PRJNA1144090_P_NODE_67600_length_308_cov_1.310638_g67065_i0 | PRJNA1144090 | 67600 | 308 | 1.310638 | 4.03676504 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 75.5 | 1.08e-13 | NR | MDJ0666783.1 | 2044940 | g67065 | i0 | 44.6 | 1.97727272727273 | 101 | 54 | 98.4 | 1 | 1 | 303 | 156 | 254 | MDJ0666783.1 SDR family oxidoreductase [Desulfobacterales bacterium] | diamond | 609 | 75.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 26774759 | 26774759 | PRJNA1144090_P_NODE_69541_length_303_cov_2.426087_g69006_i0 | PRJNA1144090 | 69541 | 303 | 2.426087 | 7.35104361 | Bacteria | 2 | Bacteria | Bacteria | 122 | 2.46e-31 | NR | RUM36426.1 | 895 | g69006 | i0 | 57.3 | 16.970297029703 | 89 | 38 | 88.1 | 0 | 36 | 302 | 139 | 227 | RUM36426.1 MAG: TIGR01777 family protein [Desulfobulbus sp.] | diamond | 5142 | 122 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus sp. | ||
| 27007118 | 27007118 | PRJNA1144090_P_NODE_97842_length_253_cov_1.055556_g97307_i0 | PRJNA1144090 | 97842 | 253 | 1.055556 | 2.67055668 | Desulfarculales bacterium | 2478484 | Bacteria | Bacteria | 101 | 1.16e-24 | NR | MDR1398206.1 | 2478484 | g97307 | i0 | 60.2 | 0.984189723320158 | 83 | 33 | 98.4 | 0 | 3 | 251 | 23 | 105 | MDR1398206.1 50S ribosomal protein L4 [Desulfarculales bacterium] | diamond | 249 | 101 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculales | Desulfarculales bacterium | ||||
| 27280806 | 27280806 | PRJNA1144090_P_NODE_118143_length_236_cov_2.196319_g117608_i0 | PRJNA1144090 | 118143 | 236 | 2.196319 | 5.18331284 | root | 1 | Root_unresolved | Root_unresolved | 58.2 | 1.26e-7 | NR | MDR1776746.1 | 885 | g117608 | i0 | 51 | 5.3771186440678 | 51 | 23 | 64.8 | 1 | 159 | 7 | 770 | 818 | MDR1776746.1 FkbM family methyltransferase [Desulfovibrio sp.] | diamond | 1269 | 58.5 | 0.994871794871795 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. | ||
| 27291749 | 27291749 | PRJNA1144090_P_NODE_101843_length_249_cov_2.539773_g101308_i0 | PRJNA1144090 | 101843 | 249 | 2.539773 | 6.32403477 | Desulfococcaceae bacterium | 3024398 | Bacteria | Bacteria | 91.3 | 4.83e-21 | NR | MFP4348428.1 | 3024398 | g101308 | i0 | 50.6 | 2.92771084337349 | 81 | 36 | 97.6 | 1 | 243 | 1 | 1 | 77 | MFP4348428.1 hypothetical protein [Desulfococcaceae bacterium] | diamond | 729 | 91.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfococcaceae bacterium | |||
| 27323409 | 27323409 | PRJNA1144090_P_NODE_49363_length_363_cov_2.920690_g48828_i0 | PRJNA1144090 | 49363 | 363 | 2.92069 | 10.6021047 | Desulfosarcinaceae bacterium | 3036616 | Bacteria | Bacteria | 50.1 | 3.93e-4 | NR | MDJ0784654.1 | 3036616 | g48828 | i0 | 37.1 | 0.867768595041322 | 105 | 54 | 85.1 | 3 | 354 | 46 | 260 | 354 | MDJ0784654.1 right-handed parallel beta-helix repeat-containing protein [Desulfosarcinaceae bacterium] | diamond | 315 | 50.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosarcinaceae | Desulfosarcinaceae bacterium | |||
| 27418389 | 27418389 | PRJNA1144090_P_NODE_47463_length_371_cov_1.567114_g46928_i0 | PRJNA1144090 | 47463 | 371 | 1.567114 | 5.81399294 | Desulfurivibrio sp. C | 2093369 | Bacteria | Bacteria | 55.1 | 7.32e-6 | NR | WP_395494133.1 | 3374371 | g46928 | i0 | 30.4 | 1.01078167115903 | 125 | 70 | 96.2 | 6 | 359 | 3 | 226 | 339 | WP_395494133.1 YeiH family protein [Desulfurivibrio sp. C05AmB] | diamond | 375 | 55.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfurivibrio | Desulfurivibrio sp. C05AmB | ||
| 28701739 | 28701739 | PRJNA1144090_P_NODE_14887_length_720_cov_4.655332_g14402_i0 | PRJNA1144090 | 14887 | 720 | 4.655332 | 33.5183904 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 107 | 2.2400000000000002e-22 | NR | PLY07396.1 | 892 | g14402 | i0 | 36.4 | 3.49166666666667 | 217 | 103 | 90.4 | 5 | 13 | 663 | 43 | 224 | PLY07396.1 MAG: hypothetical protein C0624_03645 [Desulfuromonas sp.] | diamond | 2514 | 108 | 0.990740740740741 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. | ||
| 29154976 | 29154976 | PRJNA1144090_P_NODE_44349_length_385_cov_2.608974_g43814_i0 | PRJNA1144090 | 44349 | 385 | 2.608974 | 10.0445499 | Desulfobulbaceae bacterium | 2053307 | Bacteria | Bacteria | 139 | 1.7099999999999998e-35 | NR | MDH4317895.1 | 2053307 | g43814 | i0 | 55.1 | 1.83116883116883 | 118 | 48 | 88.1 | 1 | 384 | 46 | 623 | 740 | MDH4317895.1 NADP-dependent isocitrate dehydrogenase [Desulfobulbaceae bacterium] | diamond | 705 | 139 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbaceae bacterium | |||
| 29218095 | 29218095 | PRJNA1144090_P_NODE_83269_length_276_cov_1.502463_g82734_i0 | PRJNA1144090 | 83269 | 276 | 1.502463 | 4.14679788 | Syntrophus sp. SKADARSKE-3 | 3029837 | Bacteria | Bacteria | 113 | 6.57e-27 | NR | MDQ5986055.1 | 3029837 | g82734 | i0 | 58.1 | 3.97826086956522 | 93 | 36 | 97.8 | 1 | 272 | 3 | 58 | 150 | MDQ5986055.1 putative alkyl/aryl-sulfatase YjcS [Syntrophus sp. SKADARSKE-3] | diamond | 1098 | 113 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophus | Syntrophus sp. SKADARSKE-3 | ||
| 29691130 | 29691130 | PRJNA1144090_P_NODE_45830_length_378_cov_2.386885_g45295_i0 | PRJNA1144090 | 45830 | 378 | 2.386885 | 9.0224253 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 45.8 | 0.0129 | NR | MCH7518166.1 | 2080303 | g45295 | i0 | 36.8 | 1.03968253968254 | 68 | 38 | 50 | 1 | 198 | 10 | 332 | 399 | MCH7518166.1 hypothetical protein [Candidatus Dadabacteria bacterium] | diamond | 393 | 45.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 30153960 | 30153960 | PRJNA1144090_P_NODE_38672_length_415_cov_4.456140_g38137_i0 | PRJNA1144090 | 38672 | 415 | 4.45614 | 18.492981 | Bacteria | 2 | Bacteria | Bacteria | 63.5 | 7.55e-10 | NR | PMP66663.1 | 1295609 | g38137 | i0 | 39 | 4.44578313253012 | 123 | 72 | 88.9 | 1 | 2 | 370 | 3 | 122 | PMP66663.1 MAG: 50S ribosomal protein L14 [Thermodesulfobacterium geofontis] | diamond | 1845 | 63.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteria | Thermodesulfobacteriales | Thermodesulfobacteriaceae | Thermodesulfobacterium | Thermodesulfobacterium geofontis | ||
| 30323798 | 30323798 | PRJNA1144090_P_NODE_2932_length_1607_cov_10.353325_g2737_i0 | PRJNA1144090 | 2932 | 1607 | 10.353325 | 166.37793275 | Desulfarculus baarsii | 453230 | Bacteria | Bacteria | 63.2 | 4.48e-7 | NR | WP_013259897.1 | 453230 | g2737 | i0 | 42.9 | 0.276291225886745 | 70 | 33 | 12.1 | 2 | 54 | 248 | 99 | 166 | WP_013259897.1 hypothetical protein [Desulfarculus baarsii] | diamond | 444 | 63.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Desulfarculales | Desulfarculaceae | Desulfarculus | Desulfarculus baarsii | ||
| 30355413 | 30355413 | PRJNA1144090_P_NODE_91932_length_261_cov_3.047872_g91397_i0 | PRJNA1144090 | 91932 | 261 | 3.047872 | 7.95494592 | Pseudodesulfovibrio indicus | 1716143 | Bacteria | Bacteria | 79.7 | 2.6e-17 | NR | WP_066802444.1 | 1716143 | g91397 | i0 | 64.3 | 1.26436781609195 | 56 | 20 | 64.4 | 0 | 173 | 6 | 2 | 57 | WP_066802444.1 RNA recognition motif domain-containing protein [Pseudodesulfovibrio indicus] | diamond | 330 | 79.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Pseudodesulfovibrio | Pseudodesulfovibrio indicus | ||
| 30533325 | 30533325 | PRJNA1144090_P_NODE_113333_length_243_cov_0.882353_g112798_i0 | PRJNA1144090 | 113333 | 243 | 0.882353 | 2.14411779 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 69.7 | 1.17e-11 | NR | MBE0502605.1 | 2099678 | g112798 | i0 | 46.8 | 2.92592592592593 | 79 | 41 | 97.5 | 1 | 2 | 238 | 115 | 192 | MBE0502605.1 DNA polymerase I [Desulfuromonadales bacterium] | diamond | 711 | 70.1 | 0.994293865905849 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadales bacterium | ||||
| 31872127 | 31872127 | PRJNA1144090_P_NODE_79497_length_283_cov_1.095238_g78962_i0 | PRJNA1144090 | 79497 | 283 | 1.095238 | 3.09952354 | Desulfolithobacter dissulfuricans | 2795293 | Bacteria | Bacteria | 142 | 4.439999999999999e-37 | NR | WP_267928000.1 | 2795293 | g78962 | i0 | 71 | 15.8904593639576 | 93 | 27 | 98.6 | 0 | 1 | 279 | 1128 | 1220 | WP_267928000.1 hydantoinase B/oxoprolinase family protein [Desulfolithobacter dissulfuricans] | diamond | 4497 | 142 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfolithobacter | Desulfolithobacter dissulfuricans | ||
| 32399101 | 32399101 | PRJNA1144090_P_NODE_45819_length_378_cov_2.475410_g45284_i0 | PRJNA1144090 | 45819 | 378 | 2.47541 | 9.3570498 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 102 | 6.389999999999999e-23 | NR | MEE8397509.1 | 2044940 | g45284 | i0 | 46.8 | 5 | 126 | 47 | 99.2 | 2 | 377 | 3 | 142 | 248 | MEE8397509.1 iron-containing alcohol dehydrogenase [Desulfobacterales bacterium] | diamond | 1890 | 102 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 32494104 | 32494104 | PRJNA1144090_P_NODE_74319_length_293_cov_1.686364_g73784_i0 | PRJNA1144090 | 74319 | 293 | 1.686364 | 4.94104652 | Bacteria | 2 | Bacteria | Bacteria | 62.4 | 8.16e-9 | NR | MEE9497616.1 | 2044940 | g73784 | i0 | 38.7 | 2.79522184300341 | 93 | 54 | 95.2 | 1 | 11 | 289 | 365 | 454 | MEE9497616.1 SagB/ThcOx family dehydrogenase [Desulfobacterales bacterium] | diamond | 819 | 62.8 | 0.993630573248408 | 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);;