contig_metadata
11 rows where bioproject = "PRJNA492406", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9380142 | 9380142 | PRJNA492406_P_NODE_13448_length_341_cov_2.783582_g13149_i0 | PRJNA492406 | 13448 | 341 | 2.783582 | 9.49201462 | PVC group | 1783257 | Bacteria | Bacteria | 159 | 6.74e-44 | NR | PLX74580.1 | 892 | g13149 | i0 | 67 | 43.4076246334311 | 112 | 33 | 98.5 | 1 | 340 | 5 | 367 | 474 | PLX74580.1 MAG: adenosylhomocysteinase [Desulfuromonas sp.] | diamond | 14802 | 159 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. | ||
| 15754940 | 15754940 | PRJNA492406_P_NODE_15833_length_315_cov_1.871901_g15534_i0 | PRJNA492406 | 15833 | 315 | 1.871901 | 5.89648815 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 173 | 2.26e-53 | NR | GJM17621.1 | 2202153 | g15534 | i0 | 83.8 | 0.942857142857143 | 99 | 16 | 94.3 | 0 | 299 | 3 | 1 | 99 | GJM17621.1 MAG: hypothetical protein DHS20C13_29480 [Thermodesulfobacteriota bacterium] | diamond | 297 | 173 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 18304103 | 18304103 | PRJNA492406_P_NODE_22195_length_273_cov_0.925000_g21896_i0 | PRJNA492406 | 22195 | 273 | 0.925 | 2.52525 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 162 | 4.25e-49 | NR | GJM17675.1 | 2202153 | g21896 | i0 | 86.5 | 8.89010989010989 | 89 | 12 | 97.8 | 0 | 272 | 6 | 67 | 155 | GJM17675.1 MAG: hypothetical protein DHS20C13_30020 [Thermodesulfobacteriota bacterium] | diamond | 2427 | 162 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27613671 | 27613671 | PRJNA492406_P_NODE_28344_length_248_cov_0.880000_g28045_i0 | PRJNA492406 | 28344 | 248 | 0.88 | 2.1824 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 45.8 | 0.00309 | NR | HHC24909.1 | 2044940 | g28045 | i0 | 35.8 | 0.810483870967742 | 67 | 43 | 81 | 0 | 43 | 243 | 97 | 163 | HHC24909.1 DUF4388 domain-containing protein [Desulfobacterales bacterium] | diamond | 201 | 45.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 28213160 | 28213160 | PRJNA492406_P_NODE_4546_length_561_cov_1.735656_g4251_i0 | PRJNA492406 | 4546 | 561 | 1.735656 | 9.73703016 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 47 | 0.0119 | NR | GJM17643.1 | 2202153 | g4251 | i0 | 32.9 | 0.422459893048128 | 79 | 52 | 41.7 | 1 | 398 | 165 | 135 | 213 | GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] | diamond | 237 | 47 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 29034577 | 29034577 | PRJNA492406_P_NODE_24808_length_259_cov_2.440860_g24509_i0 | PRJNA492406 | 24808 | 259 | 2.44086 | 6.3218274 | Desulfobacula sp. | 2593537 | Bacteria | Bacteria | 59.7 | 4.82e-8 | NR | NJM01828.1 | 2593537 | g24509 | i0 | 40.3 | 4.87644787644788 | 72 | 36 | 83.4 | 1 | 216 | 1 | 435 | 499 | NJM01828.1 response regulator [Desulfobacula sp.] | diamond | 1263 | 59.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacula | Desulfobacula sp. | ||
| 29918580 | 29918580 | PRJNA492406_P_NODE_10591_length_379_cov_2.003268_g10292_i0 | PRJNA492406 | 10591 | 379 | 2.003268 | 7.59238572 | Desulfobulbaceae bacterium | 2053307 | Bacteria | Bacteria | 48.1 | 0.00158 | NR | NLZ17542.1 | 2053307 | g10292 | i0 | 51.2 | 0.66490765171504 | 41 | 20 | 32.5 | 0 | 325 | 203 | 186 | 226 | NLZ17542.1 CAP domain-containing protein [Desulfobulbaceae bacterium] | diamond | 252 | 48.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbaceae bacterium | |||
| 31087480 | 31087480 | PRJNA492406_P_NODE_8275_length_424_cov_1.270655_g7976_i0 | PRJNA492406 | 8275 | 424 | 1.270655 | 5.3875772 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 96.3 | 5.43e-20 | NR | MFC1516347.1 | 2202153 | g7976 | i0 | 45.9 | 0.955188679245283 | 135 | 65 | 94.1 | 6 | 400 | 2 | 170 | 298 | MFC1516347.1 SMP-30/gluconolactonase/LRE family protein [Thermodesulfobacteriota bacterium] | diamond | 405 | 96.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 31435153 | 31435153 | PRJNA492406_P_NODE_10576_length_379_cov_2.849673_g10277_i0 | PRJNA492406 | 10576 | 379 | 2.849673 | 10.80026067 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 45.4 | 0.0128 | NR | HKQ33371.1 | 2202153 | g10277 | i0 | 34.3 | 1.77308707124011 | 105 | 61 | 81.5 | 4 | 9 | 317 | 113 | 211 | HKQ33371.1 DUF4203 domain-containing protein [Thermodesulfobacteriota bacterium] | diamond | 672 | 45.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 32352990 | 32352990 | PRJNA492406_P_NODE_31119_length_243_cov_0.905882_g30820_i0 | PRJNA492406 | 31119 | 243 | 0.905882 | 2.20129326 | Desulfovibrio legallii | 571438 | Bacteria | Bacteria | 89.4 | 1.89e-19 | NR | WP_270229345.1 | 571438 | g30820 | i0 | 54.2 | 0.888888888888889 | 72 | 33 | 88.9 | 0 | 23 | 238 | 53 | 124 | WP_270229345.1 class I SAM-dependent methyltransferase [Desulfovibrio legallii] | diamond | 216 | 89.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio legallii | ||
| 32574435 | 32574435 | PRJNA492406_P_NODE_28539_length_247_cov_1.551724_g28240_i0 | PRJNA492406 | 28539 | 247 | 1.551724 | 3.83275828 | Halodesulfovibrio spirochaetisodalis | 1560234 | Bacteria | Bacteria | 69.7 | 1.94e-13 | NR | WP_066856293.1 | 1560234 | g28240 | i0 | 50 | 0.874493927125506 | 72 | 36 | 87.4 | 0 | 247 | 32 | 4 | 75 | WP_066856293.1 RNA recognition motif domain-containing protein [Halodesulfovibrio spirochaetisodalis] | diamond | 216 | 69.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Halodesulfovibrio | Halodesulfovibrio spirochaetisodalis |
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);;