contig_metadata
8 rows where bioproject = "PRJNA784298", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9693593 | 9693593 | PRJNA784298_P_NODE_12928_length_347_cov_1.686131_g12727_i0 | PRJNA784298 | 12928 | 347 | 1.686131 | 5.85087457 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 157 | 9.349999999999999e-42 | NR | MFC1868133.1 | 2202153 | g12727 | i0 | 60 | 2.98270893371758 | 115 | 46 | 99.4 | 0 | 347 | 3 | 42 | 156 | MFC1868133.1 leucine--tRNA ligase [Thermodesulfobacteriota bacterium] | diamond | 1035 | 157 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 26895657 | 26895657 | PRJNA784298_P_NODE_7201_length_471_cov_1.316583_g7000_i0 | PRJNA784298 | 7201 | 471 | 1.316583 | 6.20110593 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 68.6 | 3.88e-10 | NR | MEN8136170.1 | 2202153 | g7000 | i0 | 34.7 | 1.94267515923567 | 150 | 79 | 89.2 | 7 | 50 | 469 | 125 | 265 | MEN8136170.1 hypothetical protein [Thermodesulfobacteriota bacterium] | diamond | 915 | 68.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27284205 | 27284205 | PRJNA784298_P_NODE_22163_length_261_cov_0.861702_g21962_i0 | PRJNA784298 | 22163 | 261 | 0.861702 | 2.24904222 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 57.4 | 3.31e-7 | NR | MEW6136806.1 | 2202153 | g21962 | i0 | 34.1 | 3.68965517241379 | 82 | 54 | 94.3 | 0 | 249 | 4 | 618 | 699 | MEW6136806.1 response regulator [Thermodesulfobacteriota bacterium] | diamond | 963 | 57.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27654055 | 27654055 | PRJNA784298_P_NODE_164_length_2918_cov_11.550088_g133_i0 | PRJNA784298 | 164 | 2918 | 11.550088 | 337.03156784 | Geomonas nitrogeniifigens | 2843197 | Bacteria | Bacteria | 278 | 1.49e-80 | NR | WP_217299618.1 | 2847991 | g133 | i0 | 46.7 | 0.970527758738862 | 315 | 164 | 32 | 4 | 2918 | 1986 | 92 | 406 | WP_217299618.1 alanine racemase [Geomonas nitrogeniifigens] | diamond | 2832 | 278 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geomonas | Geomonas nitrogeniifigens | ||
| 27748877 | 27748877 | PRJNA784298_P_NODE_224_length_2611_cov_5.536643_g185_i0 | PRJNA784298 | 224 | 2611 | 5.536643 | 144.56174873 | Geomonas fuzhouensis | 2847989 | Bacteria | Bacteria | 316 | 5.26e-97 | NR | WP_224957445.1 | 2873701 | g185 | i0 | 53.2 | 0.682497127537342 | 297 | 137 | 33.9 | 1 | 1823 | 939 | 3 | 299 | WP_224957445.1 branched-chain amino acid transaminase [Geomonas fuzhouensis] | diamond | 1782 | 316 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geomonas | Geomonas fuzhouensis | ||
| 29210458 | 29210458 | PRJNA784298_P_NODE_27929_length_228_cov_2.670968_g27728_i0 | PRJNA784298 | 27929 | 228 | 2.670968 | 6.08980704 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 58.2 | 1.04e-7 | NR | WP_214172953.1 | 60036 | g27728 | i0 | 47.7 | 1.73684210526316 | 65 | 34 | 85.5 | 0 | 34 | 228 | 5 | 69 | WP_214172953.1 glycosyltransferase family 2 protein [Geoanaerobacter pelophilus] | diamond | 396 | 58.5 | 0.994871794871795 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geoanaerobacter | Geoanaerobacter pelophilus | ||
| 29905113 | 29905113 | PRJNA784298_P_NODE_3951_length_640_cov_3.991182_g3754_i0 | PRJNA784298 | 3951 | 640 | 3.991182 | 25.5435648 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 51.6 | 1.05e-4 | NR | WP_347288965.1 | 35833 | g3754 | i0 | 38 | 2.0203125 | 79 | 48 | 36.6 | 1 | 531 | 298 | 35 | 113 | WP_347288965.1 GNAT family N-acetyltransferase [Bilophila wadsworthia] | diamond | 1293 | 52 | 0.992307692307692 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Bilophila | Bilophila wadsworthia | ||
| 32529242 | 32529242 | PRJNA784298_P_NODE_23899_length_250_cov_1.875706_g23698_i0 | PRJNA784298 | 23899 | 250 | 1.875706 | 4.689265 | root | 1 | Root_unresolved | Root_unresolved | 90.1 | 9.99e-21 | NR | MCK9227634.1 | 2660714 | g23698 | i0 | 56.9 | 2.352 | 65 | 28 | 78 | 0 | 12 | 206 | 40 | 104 | MCK9227634.1 DUF4326 domain-containing protein [Syntrophorhabdaceae bacterium] | diamond | 588 | 90.9 | 0.991199119911991 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophorhabdia | Syntrophorhabdales | Syntrophorhabdaceae | Syntrophorhabdaceae 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);;