contig_metadata
7 rows where bioproject = "PRJNA421571" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27265388 | 27265388 | PRJNA421571_P_NODE_74743_length_290_cov_1.078341_g72194_i0 | PRJNA421571 | 74743 | 290 | 1.078341 | 3.1271889 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 167 | 5.129999999999999e-47 | NR | HZX14979.1 | 2202153 | g72194 | i0 | 78.9 | 0.982758620689655 | 95 | 20 | 98.3 | 0 | 5 | 289 | 236 | 330 | HZX14979.1 hypothetical protein [Thermodesulfobacteriota bacterium] | diamond | 285 | 167 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 29997615 | 29997615 | PRJNA421571_P_NODE_94911_length_249_cov_0.875000_g92362_i0 | PRJNA421571 | 94911 | 249 | 0.875 | 2.17875 | FCB group | 1783270 | Bacteria | Bacteria | 77 | 3.46e-14 | NR | WP_025323774.1 | 1035120 | g92362 | i0 | 56.9 | 3.46987951807229 | 72 | 31 | 86.7 | 0 | 219 | 4 | 525 | 596 | WP_025323774.1 DNA helicase RecQ [Deferrisoma camini] | diamond | 864 | 77 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Deferrisomatia | Deferrisomatales | Deferrisomataceae | Deferrisoma | Deferrisoma camini | ||
| 30075523 | 30075523 | PRJNA421571_P_NODE_69012_length_307_cov_1.307692_g66463_i0 | PRJNA421571 | 69012 | 307 | 1.307692 | 4.01461444 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 179 | 1.979999999999999e-55 | NR | GJM17675.1 | 2202153 | g66463 | i0 | 85.3 | 0.996742671009772 | 102 | 15 | 99.7 | 0 | 307 | 2 | 43 | 144 | GJM17675.1 MAG: hypothetical protein DHS20C13_30020 [Thermodesulfobacteriota bacterium] | diamond | 306 | 179 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 30486439 | 30486439 | PRJNA421571_P_NODE_23133_length_720_cov_3.714065_g20722_i0 | PRJNA421571 | 23133 | 720 | 3.714065 | 26.741268 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 45.4 | 0.0418 | NR | MEW6335375.1 | 2202153 | g20722 | i0 | 36 | 0.370833333333333 | 89 | 43 | 35.8 | 3 | 409 | 666 | 14 | 91 | MEW6335375.1 tripartite tricarboxylate transporter TctB family protein [Thermodesulfobacteriota bacterium] | diamond | 267 | 45.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 30802331 | 30802331 | PRJNA421571_P_NODE_85994_length_263_cov_1.610526_g83445_i0 | PRJNA421571 | 85994 | 263 | 1.610526 | 4.23568338 | Desulfovibrio sp. | 885 | Bacteria | Bacteria | 43.1 | 0.0171 | NR | MCR5815042.1 | 885 | g83445 | i0 | 46.8 | 0.536121673003802 | 47 | 24 | 53.6 | 1 | 3 | 143 | 100 | 145 | MCR5815042.1 Hsp20/alpha crystallin family protein [Desulfovibrio sp.] | diamond | 141 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Desulfovibrio | Desulfovibrio sp. | ||
| 30977034 | 30977034 | PRJNA421571_P_NODE_93774_length_250_cov_0.870056_g91225_i0 | PRJNA421571 | 93774 | 250 | 0.870056 | 2.17514 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 43.1 | 0.0314 | NR | GFO54927.1 | 2740183 | g91225 | i0 | 44.7 | 3.192 | 76 | 33 | 84 | 2 | 40 | 249 | 2396 | 2468 | GFO54927.1 hypothetical protein GMSM_19340 [Geomonas sp. Red276] | diamond | 798 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geomonas | Geomonas sp. Red276 | ||
| 30992051 | 30992051 | PRJNA421571_P_NODE_6954_length_1428_cov_3.011808_g5902_i0 | PRJNA421571 | 6954 | 1428 | 3.011808 | 43.00861824 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 207 | 4.400000000000001e-59 | NR | MBL7203351.1 | 2049433 | g5902 | i0 | 48.9 | 0.476890756302521 | 227 | 112 | 47.5 | 2 | 18 | 695 | 106 | 329 | MBL7203351.1 hypothetical protein [Desulfobacteraceae bacterium] | diamond | 681 | 207 | 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);;