contig_metadata
11 rows where bioproject = "PRJEB39269" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1331363 | 1331363 | PRJEB39269_P_NODE_60842_length_177_cov_1.347826_g60437_i0 | PRJEB39269 | 60842 | 177 | 1.347826 | 2.38565202 | Desulfobacter hydrogenophilus | 2291 | Bacteria | Bacteria | 90.1 | 1.5300000000000002e-21 | NR | WP_282959083.1 | 2291 | g60437 | i0 | 98 | 0.830508474576271 | 49 | 1 | 83.1 | 0 | 148 | 2 | 1 | 49 | WP_282959083.1 histidine kinase dimerization/phospho-acceptor domain-containing protein, partial [Desulfobacter hydrogenophilus] | diamond | 147 | 90.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | Desulfobacter hydrogenophilus | ||
| 27665386 | 27665386 | PRJEB39269_P_NODE_87604_length_153_cov_1.078947_g87199_i0 | PRJEB39269 | 87604 | 153 | 1.078947 | 1.65078891 | Geobacteraceae bacterium | 2282154 | Bacteria | Bacteria | 107 | 1.8e-25 | NR | HEX2769741.1 | 2282154 | g87199 | i0 | 92 | 2.94117647058824 | 50 | 4 | 98 | 0 | 152 | 3 | 384 | 433 | HEX2769741.1 oleate hydratase [Geobacteraceae bacterium] | diamond | 450 | 107 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacteraceae bacterium | |||
| 28517774 | 28517774 | PRJEB39269_P_NODE_26247_length_272_cov_2.064378_g25842_i0 | PRJEB39269 | 26247 | 272 | 2.064378 | 5.61510816 | Geobacteraceae bacterium | 2282154 | Bacteria | Bacteria | 56.6 | 6.77e-7 | NR | HEX2769741.1 | 2282154 | g25842 | i0 | 93.1 | 1.27941176470588 | 29 | 2 | 32 | 0 | 186 | 272 | 1 | 29 | HEX2769741.1 oleate hydratase [Geobacteraceae bacterium] | diamond | 348 | 56.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacteraceae bacterium | |||
| 28864976 | 28864976 | PRJEB39269_P_NODE_90428_length_151_cov_1.098214_g90023_i0 | PRJEB39269 | 90428 | 151 | 1.098214 | 1.65830314 | Desulfuromonadaceae bacterium | 2099677 | Bacteria | Bacteria | 56.2 | 1.77e-7 | NR | NLC72002.1 | 2099677 | g90023 | i0 | 52.2 | 1.82781456953642 | 46 | 22 | 91.4 | 0 | 140 | 3 | 486 | 531 | NLC72002.1 amino acid adenylation domain-containing protein [Desulfuromonadaceae bacterium] | diamond | 276 | 56.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonadaceae bacterium | |||
| 29149579 | 29149579 | PRJEB39269_P_NODE_79549_length_159_cov_1.508333_g79144_i0 | PRJEB39269 | 79549 | 159 | 1.508333 | 2.39824947 | Nitratidesulfovibrio vulgaris | 881 | Bacteria | Bacteria | 45.1 | 0.00162 | NR | WCB48149.1 | 881 | g79144 | i0 | 44 | 1.75471698113208 | 50 | 28 | 94.3 | 0 | 154 | 5 | 58 | 107 | WCB48149.1 DotG/IcmE/VirB10 family protein [Nitratidesulfovibrio vulgaris] | diamond | 279 | 45.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Nitratidesulfovibrio | Nitratidesulfovibrio vulgaris | ||
| 29559499 | 29559499 | PRJEB39269_P_NODE_34250_length_236_cov_1.436548_g33845_i0 | PRJEB39269 | 34250 | 236 | 1.436548 | 3.39025328 | Desulfovibrio sp. JC | 885 | Bacteria | Bacteria | 47 | 4.07e-4 | NR | WP_163350893.1 | 2593641 | g33845 | i0 | 32.5 | 0.978813559322034 | 77 | 48 | 97.9 | 4 | 5 | 235 | 67 | 139 | WP_163350893.1 type IV pilus biogenesis protein PilM [Desulfovibrio sp. JC010] | diamond | 231 | 47 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. JC010 | ||
| 30785038 | 30785038 | PRJEB39269_P_NODE_82854_length_156_cov_5.059829_g82449_i0 | PRJEB39269 | 82854 | 156 | 5.059829 | 7.89333324 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 42.4 | 0.0153 | NR | WP_011736612.1 | 29543 | g82449 | i0 | 69.2 | 2.61538461538462 | 26 | 8 | 50 | 0 | 154 | 77 | 177 | 202 | WP_011736612.1 glycosyltransferase [Pelobacter propionicus] | diamond | 408 | 42.7 | 0.992974238875878 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Pelobacter | Pelobacter propionicus | ||
| 31550549 | 31550549 | PRJEB39269_P_NODE_72816_length_165_cov_1.301587_g72411_i0 | PRJEB39269 | 72816 | 165 | 1.301587 | 2.14761855 | Desulfurivibrio alkaliphilus | 427923 | Bacteria | Bacteria | 72.4 | 2.67e-13 | NR | WP_013164016.1 | 427923 | g72411 | i0 | 64.8 | 0.981818181818182 | 54 | 19 | 98.2 | 0 | 162 | 1 | 88 | 141 | WP_013164016.1 NAD-dependent epimerase/dehydratase family protein [Desulfurivibrio alkaliphilus] | diamond | 162 | 72.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfurivibrio | Desulfurivibrio alkaliphilus | ||
| 31739925 | 31739925 | PRJEB39269_P_NODE_75457_length_162_cov_1.821138_g75052_i0 | PRJEB39269 | 75457 | 162 | 1.821138 | 2.95024356 | Syntrophus sp. (in: bacteria) | 48412 | Bacteria | Bacteria | 55.1 | 5.41e-7 | NR | MEI7637697.1 | 48412 | g75052 | i0 | 48 | 1.87037037037037 | 50 | 26 | 92.6 | 0 | 161 | 12 | 677 | 726 | MEI7637697.1 protein DpdF [Syntrophus sp. (in: bacteria)] | diamond | 303 | 55.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophus | Syntrophus sp. (in: bacteria) | ||
| 32745178 | 32745178 | PRJEB39269_P_NODE_86240_length_154_cov_1.165217_g85835_i0 | PRJEB39269 | 86240 | 154 | 1.165217 | 1.79443418 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 65.5 | 1.06e-10 | NR | MBQ3060199.1 | 885 | g85835 | i0 | 62.7 | 16.8701298701299 | 51 | 19 | 99.4 | 0 | 154 | 2 | 262 | 312 | MBQ3060199.1 TraM recognition domain-containing protein [Desulfovibrio sp.] | diamond | 2598 | 65.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. | ||
| 32751636 | 32751636 | PRJEB39269_P_NODE_59560_length_179_cov_1.171429_g59155_i0 | PRJEB39269 | 59560 | 179 | 1.171429 | 2.09685791 | Maridesulfovibrio sp. | 2795000 | Bacteria | Bacteria | 83.2 | 8.76e-17 | NR | WP_320008771.1 | 2795000 | g59155 | i0 | 65.1 | 4.91061452513966 | 63 | 17 | 97.2 | 1 | 176 | 3 | 485 | 547 | WP_320008771.1 S9 family peptidase [Maridesulfovibrio sp.] | diamond | 879 | 83.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Maridesulfovibrio | Maridesulfovibrio 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);;