contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA316313" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26870733 | 26870733 | PRJNA316313_P_NODE_210621_length_187_cov_3.286667_g209235_i0 | PRJNA316313 | 210621 | 187 | 3.286667 | 6.14606729 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 93.2 | 1.13e-20 | NR | WP_198015318.1 | 42252 | g209235 | i0 | 79 | 7.9572192513369 | 62 | 5 | 99.5 | 1 | 186 | 1 | 221 | 274 | WP_198015318.1 polysaccharide biosynthesis/export family protein [Nitratidesulfovibrio termitidis] | diamond | 1488 | 93.6 | 0.995726495726496 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Nitratidesulfovibrio | Nitratidesulfovibrio termitidis | ||
| 27801205 | 27801205 | PRJNA316313_P_NODE_392684_length_154_cov_2.452991_g391298_i0 | PRJNA316313 | 392684 | 154 | 2.452991 | 3.77760614 | Desulfurivibrio sp. C | 2093369 | Bacteria | Bacteria | 86.3 | 4.9e-18 | NR | WP_395493285.1 | 3374371 | g391298 | i0 | 87.8 | 1.92857142857143 | 49 | 6 | 95.5 | 0 | 3 | 149 | 792 | 840 | WP_395493285.1 ATP-binding protein [Desulfurivibrio sp. C05AmB] | diamond | 297 | 86.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfurivibrio | Desulfurivibrio sp. C05AmB | ||
| 28937803 | 28937803 | PRJNA316313_P_NODE_202788_length_187_cov_3.413333_g201402_i0 | PRJNA316313 | 202788 | 187 | 3.413333 | 6.38293271 | Syntrophaceae bacterium | 2052184 | Bacteria | Bacteria | 53.1 | 3.73e-6 | NR | MDD3474045.1 | 2052184 | g201402 | i0 | 92 | 0.401069518716578 | 25 | 2 | 40.1 | 0 | 75 | 1 | 5 | 29 | MDD3474045.1 glycosyltransferase family 1 protein [Syntrophaceae bacterium] | diamond | 75 | 53.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophaceae bacterium | |||
| 29302397 | 29302397 | PRJNA316313_P_NODE_316429_length_187_cov_2.293333_g315043_i0 | PRJNA316313 | 316429 | 187 | 2.293333 | 4.28853271 | Bacteria | 2 | Bacteria | Bacteria | 48.5 | 1.62e-4 | NR | HAJ25753.1 | 48412 | g315043 | i0 | 96 | 8.21390374331551 | 25 | 1 | 40.1 | 0 | 187 | 113 | 216 | 240 | HAJ25753.1 nucleotide sugar dehydrogenase [Syntrophus sp. (in: bacteria)] | diamond | 1536 | 48.9 | 0.991820040899796 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophus | Syntrophus sp. (in: bacteria) | ||
| 29631998 | 29631998 | PRJNA316313_P_NODE_251130_length_187_cov_2.840000_g249744_i0 | PRJNA316313 | 251130 | 187 | 2.84 | 5.3108 | Desulfovibrio sp. 6_1_46AFAA | 665942 | Bacteria | Bacteria | 52.4 | 7.05e-6 | NR | WP_009302255.1 | 665942 | g249744 | i0 | 42.9 | 2.18181818181818 | 77 | 28 | 97.9 | 1 | 184 | 2 | 338 | 414 | WP_009302255.1 Ig-like domain-containing protein, partial [Desulfovibrio sp. 6_1_46AFAA] | diamond | 408 | 52.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. 6_1_46AFAA | ||
| 29632046 | 29632046 | PRJNA316313_P_NODE_498970_length_150_cov_3.469027_g497584_i0 | PRJNA316313 | 498970 | 150 | 3.469027 | 5.2035405 | Syntrophaceae bacterium | 2052184 | Bacteria | Bacteria | 88.2 | 1.03e-18 | NR | MDD3471670.1 | 2052184 | g497584 | i0 | 84.9 | 1.06 | 53 | 5 | 100 | 1 | 150 | 1 | 335 | 387 | MDD3471670.1 asparagine synthase (glutamine-hydrolyzing) [Syntrophaceae bacterium] | diamond | 159 | 88.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophaceae bacterium | |||
| 29790082 | 29790082 | PRJNA316313_P_NODE_446691_length_151_cov_3.728070_g445305_i0 | PRJNA316313 | 446691 | 151 | 3.72807 | 5.6293857 | Deferrisoma camini | 1035120 | Bacteria | Bacteria | 45.4 | 0.00119 | NR | WP_084319572.1 | 1035120 | g445305 | i0 | 56.7 | 1.8476821192053 | 30 | 13 | 59.6 | 0 | 91 | 2 | 22 | 51 | WP_084319572.1 TIR domain-containing protein [Deferrisoma camini] | diamond | 279 | 45.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Deferrisomatia | Deferrisomatales | Deferrisomataceae | Deferrisoma | Deferrisoma camini | ||
| 29979751 | 29979751 | PRJNA316313_P_NODE_424151_length_151_cov_4.684211_g422765_i0 | PRJNA316313 | 424151 | 151 | 4.684211 | 7.07315861 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 56.2 | 1.77e-7 | NR | MEW5914430.1 | 2202153 | g422765 | i0 | 59.3 | 1.0728476821192101 | 54 | 18 | 99.3 | 2 | 150 | 1 | 152 | 205 | MEW5914430.1 SAM-dependent methyltransferase [Thermodesulfobacteriota bacterium] | diamond | 162 | 56.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 30154827 | 30154827 | PRJNA316313_P_NODE_62272_length_242_cov_2.921951_g60886_i0 | PRJNA316313 | 62272 | 242 | 2.921951 | 7.07112142 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 134 | 2.55e-34 | NR | WP_374290838.1 | 876 | g60886 | i0 | 82.5 | 5.9504132231405 | 80 | 14 | 99.2 | 0 | 1 | 240 | 328 | 407 | WP_374290838.1 ATP-binding protein [Desulfovibrio desulfuricans] | diamond | 1440 | 135 | 0.992592592592593 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio desulfuricans | ||
| 30485369 | 30485369 | PRJNA316313_P_NODE_82213_length_220_cov_3.469945_g80827_i0 | PRJNA316313 | 82213 | 220 | 3.469945 | 7.633879 | Desulfurivibrio sp. C | 2093369 | Bacteria | Bacteria | 128 | 1.73e-32 | NR | WP_395493285.1 | 3374371 | g80827 | i0 | 83.3 | 1.93636363636364 | 72 | 12 | 98.2 | 0 | 3 | 218 | 716 | 787 | WP_395493285.1 ATP-binding protein [Desulfurivibrio sp. C05AmB] | diamond | 426 | 128 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfurivibrio | Desulfurivibrio sp. C05AmB | ||
| 30516871 | 30516871 | PRJNA316313_P_NODE_39993_length_282_cov_3.200000_g38611_i0 | PRJNA316313 | 39993 | 282 | 3.2 | 9.024 | Desulfobotulus mexicanus | 2586642 | Bacteria | Bacteria | 51.6 | 3.87e-5 | NR | WP_342774313.1 | 2586642 | g38611 | i0 | 96 | 3.19148936170213 | 25 | 1 | 26.6 | 0 | 207 | 281 | 1 | 25 | WP_342774313.1 glucose-1-phosphate thymidylyltransferase RfbA [Desulfobotulus mexicanus] | diamond | 900 | 51.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobotulus | Desulfobotulus mexicanus | ||
| 30643067 | 30643067 | PRJNA316313_P_NODE_157173_length_187_cov_4.406667_g155787_i0 | PRJNA316313 | 157173 | 187 | 4.406667 | 8.24046729 | Desulfovibrio | 872 | Bacteria | Bacteria | 47.8 | 2.94e-4 | NR | WP_195840930.1 | 872 | g155787 | i0 | 83.3 | 0.385026737967914 | 24 | 4 | 38.5 | 0 | 114 | 185 | 489 | 512 | WP_195840930.1 MULTISPECIES: sigma 54-interacting transcriptional regulator [Desulfovibrio] | diamond | 72 | 47.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | |||
| 30864309 | 30864309 | PRJNA316313_P_NODE_343654_length_182_cov_4.572414_g342268_i0 | PRJNA316313 | 343654 | 182 | 4.572414 | 8.32179348 | Candidatus Adiutrix sp. | 2872164 | Bacteria | Bacteria | 48.9 | 1.09e-4 | NR | MDR1045021.1 | 2872164 | g342268 | i0 | 50.9 | 0.873626373626374 | 53 | 26 | 87.4 | 0 | 166 | 8 | 15 | 67 | MDR1045021.1 tetratricopeptide repeat protein [Candidatus Adiutrix sp.] | diamond | 159 | 48.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfarculia | Candidatus Adiutricales | Candidatus Adiutricaceae | Candidatus Adiutrix | Candidatus Adiutrix sp. | ||
| 30896133 | 30896133 | PRJNA316313_P_NODE_176634_length_187_cov_3.866667_g175248_i0 | PRJNA316313 | 176634 | 187 | 3.866667 | 7.23066729 | Geobacter sp. | 46610 | Bacteria | Bacteria | 46.2 | 9.71e-4 | NR | MFA6823724.1 | 46610 | g175248 | i0 | 95.8 | 0.385026737967914 | 24 | 1 | 38.5 | 0 | 114 | 185 | 24 | 47 | MFA6823724.1 UDP-N-acetylglucosamine 1-carboxyvinyltransferase [Geobacter sp.] | diamond | 72 | 46.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sp. | ||
| 30959259 | 30959259 | PRJNA316313_P_NODE_333134_length_186_cov_3.255034_g331748_i0 | PRJNA316313 | 333134 | 186 | 3.255034 | 6.05436324 | Syntrophaceae bacterium | 2052184 | Bacteria | Bacteria | 47.4 | 4.17e-4 | NR | MDD3472921.1 | 2052184 | g331748 | i0 | 76 | 0.806451612903226 | 25 | 6 | 40.3 | 0 | 186 | 112 | 119 | 143 | MDD3472921.1 DUF6178 family protein [Syntrophaceae bacterium] | diamond | 150 | 47.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophaceae bacterium | |||
| 32824160 | 32824160 | PRJNA316313_P_NODE_213420_length_187_cov_3.240000_g212034_i0 | PRJNA316313 | 213420 | 187 | 3.24 | 6.0588 | Desulfobaccales bacterium | 3064668 | Bacteria | Bacteria | 43.1 | 0.0133 | NR | MFA5110773.1 | 3064668 | g212034 | i0 | 41 | 0.978609625668449 | 61 | 30 | 88.2 | 1 | 1 | 165 | 44 | 104 | MFA5110773.1 hypothetical protein [Desulfobaccales bacterium] | diamond | 183 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobaccia | Desulfobaccales | Desulfobaccales 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);;