contig_metadata
13 rows where bioproject = "PRJNA994052" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7354494 | 7354494 | PRJNA994052_P_NODE_73026_length_208_cov_1072.570370_g71770_i0 | PRJNA994052 | 73026 | 208 | 1072.57037 | 2230.9463696 | Oleidesulfovibrio alaskensis | 58180 | Bacteria | Bacteria | 385 | 1.58e-102 | NTclustered | gi|78217452|gb|CP000112.1| | 207559 | g71770 | i0 | 100 | 1 | 208 | 0 | 100 | 0 | 1 | 208 | 3178680 | 3178473 | Desulfovibrio alaskensis G20, complete genome | blastn | 208 | 385 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Oleidesulfovibrio | Oleidesulfovibrio alaskensis | ||
| 12455540 | 12455540 | PRJNA994052_P_NODE_34510_length_270_cov_79.060914_g33266_i0 | PRJNA994052 | 34510 | 270 | 79.060914 | 213.4644678 | Desulfuromonas sp. DDH964 | 1823759 | Bacteria | Bacteria | 97.1 | 1.13e-15 | NTclustered | gi|1015516084|gb|CP015080.1| | 1823759 | g33266 | i0 | 92.537 | 0.462962962962963 | 67 | 5 | 25 | 0 | 197 | 263 | 3417744 | 3417810 | Desulfuromonas sp. DDH964 chromosome, complete genome | blastn | 125 | 97.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. DDH964 | ||
| 18828281 | 18828281 | PRJNA994052_P_NODE_45415_length_248_cov_1570.394286_g44165_i0 | PRJNA994052 | 45415 | 248 | 1570.394286 | 3894.57782928 | Oleidesulfovibrio alaskensis | 58180 | Bacteria | Bacteria | 459 | 1.13e-124 | NTclustered | gi|78217452|gb|CP000112.1| | 207559 | g44165 | i0 | 100 | 4.95161290322581 | 248 | 0 | 100 | 0 | 1 | 248 | 2516922 | 2517169 | Desulfovibrio alaskensis G20, complete genome | blastn | 1228 | 459 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Oleidesulfovibrio | Oleidesulfovibrio alaskensis | ||
| 25202724 | 25202724 | PRJNA994052_P_NODE_54780_length_233_cov_243.775000_g53525_i0 | PRJNA994052 | 54780 | 233 | 243.775 | 567.99575 | Syntrophotalea acetylenivorans | 1842532 | Bacteria | Bacteria | 189 | 1.5199999999999996e-43 | NTclustered | gi|1109393802|gb|CP015519.1| | 1842532 | g53525 | i0 | 81.858 | 255.712446351931 | 226 | 40 | 97 | 1 | 8 | 233 | 2834446 | 2834222 | Syntrophotalea acetylenivorans strain SFB93 chromosome, complete genome | blastn | 59581 | 189 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Syntrophotaleaceae | Syntrophotalea | Syntrophotalea acetylenivorans | ||
| 25202968 | 25202968 | PRJNA994052_P_NODE_77060_length_204_cov_13.564885_g75803_i0 | PRJNA994052 | 77060 | 204 | 13.564885 | 27.6723654 | uncultured Desulfobacter sp. | 240139 | Bacteria | Bacteria | 174 | 3.64e-39 | NTclustered | gi|2621704716|emb|OY762069.1| | 240139 | g75803 | i0 | 85.143 | 93.1127450980392 | 175 | 21 | 85 | 5 | 28 | 200 | 4511767 | 4511938 | MAG: uncultured Desulfobacter sp. isolate 00b13672-1c6a-4f01-9bd3-5d9cfdb0d95e genome assembly, chromosome: 1 | blastn | 18995 | 174 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | uncultured Desulfobacter sp. | ||
| 26963011 | 26963011 | PRJNA994052_P_NODE_15062_length_313_cov_15.458333_g13841_i0 | PRJNA994052 | 15062 | 313 | 15.458333 | 48.38458229 | Smithella sp. | 2053614 | Bacteria | Bacteria | 158 | 9.5e-47 | NR | MEN6623046.1 | 2053614 | g13841 | i0 | 83 | 0.843450479233227 | 88 | 14 | 84.3 | 1 | 3 | 266 | 102 | 188 | MEN6623046.1 phage tail protein [Smithella sp.] | diamond | 264 | 158 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Smithellaceae | Smithella | Smithella sp. | ||
| 27690306 | 27690306 | PRJNA994052_P_NODE_56024_length_232_cov_6.295597_g54769_i0 | PRJNA994052 | 56024 | 232 | 6.295597 | 14.60578504 | Desulfovibrio sp. | 885 | Bacteria | Bacteria | 40.4 | 0.0475 | NR | MBC17444.1 | 885 | g54769 | i0 | 45.2 | 0.543103448275862 | 42 | 23 | 54.3 | 0 | 105 | 230 | 9 | 50 | MBC17444.1 hypothetical protein [Desulfovibrio sp.] | diamond | 126 | 40.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. | ||
| 28132110 | 28132110 | PRJNA994052_P_NODE_36545_length_266_cov_7.103627_g35299_i0 | PRJNA994052 | 36545 | 266 | 7.103627 | 18.89564782 | Desulfosalsimonadaceae bacterium | 3060584 | Bacteria | Bacteria | 43.1 | 0.0376 | NR | MDO9265179.1 | 3060584 | g35299 | i0 | 42 | 0.56390977443609 | 50 | 25 | 56.4 | 1 | 14 | 163 | 2345 | 2390 | MDO9265179.1 DUF1566 domain-containing protein [Desulfosalsimonadaceae bacterium] | diamond | 150 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosalsimonadaceae | Desulfosalsimonadaceae bacterium | |||
| 28194922 | 28194922 | PRJNA994052_P_NODE_77646_length_203_cov_44.469231_g76389_i0 | PRJNA994052 | 77646 | 203 | 44.469231 | 90.27253893 | Desulfuromusa sp. | 2614228 | Bacteria | Bacteria | 72.8 | 5.56e-13 | NR | MCD6582391.1 | 2614228 | g76389 | i0 | 43.3 | 1.95073891625616 | 67 | 38 | 99 | 0 | 201 | 1 | 2 | 68 | MCD6582391.1 BREX-1 system adenine-specific DNA-methyltransferase PglX [Desulfuromusa sp.] | diamond | 396 | 72.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geopsychrobacteraceae | Desulfuromusa | Desulfuromusa sp. | ||
| 29521191 | 29521191 | PRJNA994052_P_NODE_67650_length_215_cov_76.309859_g66394_i0 | PRJNA994052 | 67650 | 215 | 76.309859 | 164.06619685 | Desulfovibrionales bacterium | 2448050 | Bacteria | Bacteria | 45.4 | 0.00286 | NR | MCG8529688.1 | 2448050 | g66394 | i0 | 43.1 | 1.5906976744186 | 58 | 28 | 75.3 | 2 | 5 | 166 | 419 | 475 | MCG8529688.1 tyrosine-protein phosphatase [Desulfovibrionales bacterium] | diamond | 342 | 45.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionales bacterium | ||||
| 29773657 | 29773657 | PRJNA994052_P_NODE_30971_length_279_cov_29.427184_g29727_i0 | PRJNA994052 | 30971 | 279 | 29.427184 | 82.10184336 | Desulfomarina profundi | 2772557 | Bacteria | Bacteria | 55.8 | 1.14e-6 | NR | WP_228855658.1 | 2772557 | g29727 | i0 | 42.7 | 0.806451612903226 | 75 | 43 | 80.6 | 0 | 271 | 47 | 183 | 257 | WP_228855658.1 PKD domain-containing protein [Desulfomarina profundi] | diamond | 225 | 55.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfomarina | Desulfomarina profundi | ||
| 30285533 | 30285533 | PRJNA994052_P_NODE_83232_length_197_cov_25.000000_g81975_i0 | PRJNA994052 | 83232 | 197 | 25 | 49.25 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 78.6 | 4.79e-15 | NR | NMC48075.1 | 885 | g81975 | i0 | 61.4 | 10.2944162436548 | 57 | 22 | 86.8 | 0 | 176 | 6 | 123 | 179 | NMC48075.1 efflux RND transporter permease subunit [Desulfovibrio sp.] | diamond | 2028 | 79 | 0.994936708860759 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. | ||
| 32239679 | 32239679 | PRJNA994052_P_NODE_35698_length_268_cov_3.497436_g34452_i0 | PRJNA994052 | 35698 | 268 | 3.497436 | 9.37312848 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 124 | 7.859999999999999e-31 | NR | MBC8421200.1 | 2044940 | g34452 | i0 | 64.8 | 10.9477611940299 | 88 | 31 | 98.5 | 0 | 4 | 267 | 481 | 568 | MBC8421200.1 BREX-1 system adenine-specific DNA-methyltransferase PglX [Desulfobacterales bacterium] | diamond | 2934 | 124 | 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);;