contig_metadata
12 rows where bioproject = "PRJNA971593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11147965 | 11147965 | PRJNA971593_P_NODE_29589_length_232_cov_2.408805_g29440_i0 | PRJNA971593 | 29589 | 232 | 2.408805 | 5.5884276 | Desulfovibrionaceae bacterium | 2049043 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2621705002|emb|OY762289.1| | 2049043 | g29440 | i0 | 100 | 0.125 | 29 | 0 | 13 | 0 | 137 | 165 | 185379 | 185351 | MAG: Desulfovibrionaceae bacterium isolate 1e2121d5-5174-4668-bae3-9852897706ae genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrionaceae bacterium | |||
| 16246973 | 16246973 | PRJNA971593_P_NODE_14273_length_318_cov_1.963265_g14124_i0 | PRJNA971593 | 14273 | 318 | 1.963265 | 6.2431827 | root | 1 | Root_unresolved | Root_unresolved | 161 | 1.22e-44 | NR | PLX80625.1 | 892 | g14124 | i0 | 85.7 | 46 | 91 | 13 | 85.8 | 0 | 2 | 274 | 177 | 267 | PLX80625.1 MAG: methylcrotonoyl-CoA carboxylase [Desulfuromonas sp.] | diamond | 14628 | 162 | 0.993827160493827 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. | ||
| 27221631 | 27221631 | PRJNA971593_P_NODE_5162_length_534_cov_1.557484_g5015_i0 | PRJNA971593 | 5162 | 534 | 1.557484 | 8.31696456 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 215 | 4.6799999999999996e-68 | NR | WP_306548753.1 | 895 | g5015 | i0 | 63.2 | 18.938202247191 | 163 | 59 | 91.6 | 1 | 20 | 508 | 3 | 164 | WP_306548753.1 DJ-1/PfpI family protein [Desulfobulbus sp.] | diamond | 10113 | 217 | 0.990783410138249 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus sp. | ||
| 27348508 | 27348508 | PRJNA971593_P_NODE_25263_length_247_cov_0.885057_g25114_i0 | PRJNA971593 | 25263 | 247 | 0.885057 | 2.18609079 | root | 1 | Root_unresolved | Root_unresolved | 48.5 | 3.35e-4 | NR | WP_011189660.1 | 84980 | g25114 | i0 | 37.3 | 3.40080971659919 | 67 | 42 | 81.4 | 0 | 203 | 3 | 111 | 177 | WP_011189660.1 serine/threonine-protein kinase [Desulfotalea psychrophila] | diamond | 840 | 48.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulfotalea | Desulfotalea psychrophila | ||
| 27468494 | 27468494 | PRJNA971593_P_NODE_24603_length_248_cov_0.880000_g24454_i0 | PRJNA971593 | 24603 | 248 | 0.88 | 2.1824 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 146 | 5.62e-40 | NR | HJX60212.1 | 2202153 | g24454 | i0 | 91.5 | 0.991935483870968 | 82 | 7 | 99.2 | 0 | 2 | 247 | 256 | 337 | HJX60212.1 SLC13 family permease [Thermodesulfobacteriota bacterium] | diamond | 246 | 146 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 28794282 | 28794282 | PRJNA971593_P_NODE_12467_length_342_cov_1.144981_g12318_i0 | PRJNA971593 | 12467 | 342 | 1.144981 | 3.91583502 | Mailhella massiliensis | 1903261 | Bacteria | Bacteria | 121 | 5.9300000000000005e-33 | NR | WP_077073607.1 | 1903261 | g12318 | i0 | 58 | 2.66666666666667 | 100 | 42 | 87.7 | 0 | 333 | 34 | 25 | 124 | WP_077073607.1 RidA family protein [Mailhella massiliensis] | diamond | 912 | 121 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Mailhella | Mailhella massiliensis | ||
| 29362907 | 29362907 | PRJNA971593_P_NODE_6769_length_468_cov_0.974684_g6621_i0 | PRJNA971593 | 6769 | 468 | 0.974684 | 4.56152112 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 45.4 | 0.0244 | NR | GJM17643.1 | 2202153 | g6621 | i0 | 30.8 | 0.5 | 78 | 53 | 49.4 | 1 | 375 | 145 | 135 | 212 | GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium] | diamond | 234 | 45.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 29488934 | 29488934 | PRJNA971593_P_NODE_21330_length_255_cov_1.269231_g21181_i0 | PRJNA971593 | 21330 | 255 | 1.269231 | 3.23653905 | Desulfomonile tiedjei | 2358 | Bacteria | Bacteria | 124 | 1.5799999999999999e-32 | NR | MBI5252656.1 | 2358 | g21181 | i0 | 67.1 | 1 | 85 | 28 | 100 | 0 | 255 | 1 | 64 | 148 | MBI5252656.1 3-hydroxybutyryl-CoA dehydrogenase [Desulfomonile tiedjei] | diamond | 255 | 124 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfomonilia | Desulfomonilales | Desulfomonilaceae | Desulfomonile | Desulfomonile tiedjei | ||
| 31738771 | 31738771 | PRJNA971593_P_NODE_14937_length_310_cov_2.898734_g14788_i0 | PRJNA971593 | 14937 | 310 | 2.898734 | 8.9860754 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 43.5 | 0.0428 | NR | WP_124330217.1 | 45657 | g14788 | i0 | 56.7 | 0.648387096774194 | 30 | 13 | 29 | 0 | 299 | 210 | 580 | 609 | WP_124330217.1 TMEM43 family protein [Desulfonema ishimotonii] | diamond | 201 | 43.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfococcaceae | Desulfonema | Desulfonema ishimotonii | ||
| 32207293 | 32207293 | PRJNA971593_P_NODE_578_length_1388_cov_2.949810_g506_i0 | PRJNA971593 | 578 | 1388 | 2.94981 | 40.9433628 | Geomesophilobacter sediminis | 2798584 | Bacteria | Bacteria | 48.5 | 0.00982 | NR | WP_199385748.1 | 2798584 | g506 | i0 | 36.7 | 0.170749279538905 | 79 | 49 | 16.9 | 1 | 214 | 447 | 23 | 101 | WP_199385748.1 hypothetical protein [Geomesophilobacter sediminis] | diamond | 237 | 48.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geomesophilobacter | Geomesophilobacter sediminis | ||
| 32245512 | 32245512 | PRJNA971593_P_NODE_28698_length_242_cov_0.911243_g28549_i0 | PRJNA971593 | 28698 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 104 | 5.67e-24 | NR | WP_148895307.1 | 213224 | g28549 | i0 | 77.8 | 12.7438016528926 | 63 | 14 | 78.1 | 0 | 12 | 200 | 67 | 129 | WP_148895307.1 aldehyde dehydrogenase family protein [Geothermobacter ehrlichii] | diamond | 3084 | 105 | 0.990476190476191 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Geothermobacteraceae | Geothermobacter | Geothermobacter ehrlichii | ||
| 32807230 | 32807230 | PRJNA971593_P_NODE_9860_length_386_cov_1.693291_g9711_i0 | PRJNA971593 | 9860 | 386 | 1.693291 | 6.53610326 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 140 | 5.52e-36 | NR | HAO22905.1 | 2049433 | g9711 | i0 | 46.5 | 1.00259067357513 | 129 | 68 | 99.5 | 1 | 384 | 1 | 302 | 430 | HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium] | diamond | 387 | 140 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae 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);;