contig_metadata
7 rows where bioproject = "PRJNA853194" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13594631 | 13594631 | PRJNA853194_S_NODE_67831_length_267_cov_0.953608_g66740_i0 | PRJNA853194 | 67831 | 267 | 0.953608 | 2.54613336 | uncultured Desulfobacter sp. | 240139 | Bacteria | Bacteria | 52.8 | 0.024 | NTclustered | gi|2621785424|emb|OY781882.1| | 240139 | g66740 | i0 | 100 | 0.104868913857678 | 28 | 0 | 10 | 0 | 143 | 170 | 121299 | 121326 | MAG: uncultured Desulfobacter sp. isolate d1cfb46f-64c6-49bd-9162-13cddd374643 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | uncultured Desulfobacter sp. | ||
| 13988419 | 13988419 | PRJNA853194_S_NODE_86491_length_236_cov_2.042945_g85400_i0 | PRJNA853194 | 86491 | 236 | 2.042945 | 4.8213502 | Lawsonia | 41707 | Bacteria | Bacteria | 52.8 | 0.021 | NTclustered | gi|2318587541|gb|CP107054.1| | 29546 | g85400 | i0 | 96.875 | 0.406779661016949 | 32 | 0 | 14 | 1 | 152 | 183 | 491326 | 491356 | Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome | blastn | 96 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Lawsonia | Lawsonia intracellularis | ||
| 16143496 | 16143496 | PRJNA853194_S_NODE_57893_length_287_cov_2.140187_g56802_i0 | PRJNA853194 | 57893 | 287 | 2.140187 | 6.14233669 | uncultured Desulforhopalus sp. | 218291 | Bacteria | Bacteria | 52.8 | 0.027 | NTclustered | gi|2621785518|emb|OY781976.1| | 218291 | g56802 | i0 | 100 | 0.0975609756097561 | 28 | 0 | 10 | 0 | 53 | 80 | 5633023 | 5633050 | MAG: uncultured Desulforhopalus sp. isolate bb11d97f-aff7-40c5-8ccb-5babbf234ee9 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfocapsaceae | Desulforhopalus | uncultured Desulforhopalus sp. | ||
| 22516836 | 22516836 | PRJNA853194_S_NODE_2838_length_1015_cov_165.473461_g2217_i0 | PRJNA853194 | 2838 | 1015 | 165.473461 | 1679.55562915 | Bacteria | 2 | Bacteria | Bacteria | 66.6 | 9.29e-9 | NR | MBK5100830.1 | 2049433 | g2217 | i0 | 32.7 | 1.86502463054187 | 162 | 88 | 45.5 | 6 | 7 | 468 | 64 | 212 | MBK5100830.1 lysoplasmalogenase [Desulfobacteraceae bacterium] | diamond | 1893 | 66.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 28476202 | 28476202 | PRJNA853194_S_NODE_16086_length_489_cov_1.980769_g14997_i0 | PRJNA853194 | 16086 | 489 | 1.980769 | 9.68596041 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 70.9 | 8.41e-11 | NR | MEX1352018.1 | 2044940 | g14997 | i0 | 37.8 | 0.94478527607362 | 82 | 51 | 50.3 | 0 | 294 | 49 | 422 | 503 | MEX1352018.1 pol polyprotein [Desulfobacterales bacterium] | diamond | 462 | 70.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 32109793 | 32109793 | PRJNA853194_S_NODE_8658_length_634_cov_20.081996_g7649_i0 | PRJNA853194 | 8658 | 634 | 20.081996 | 127.31985464 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 76.6 | 8.13e-13 | NR | MDX9788230.1 | 2044940 | g7649 | i0 | 31.1 | 2.59779179810726 | 164 | 102 | 74.3 | 3 | 11 | 481 | 78 | 237 | MDX9788230.1 NRDE family protein [Desulfobacterales bacterium] | diamond | 1647 | 76.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 32331656 | 32331656 | PRJNA853194_S_NODE_73219_length_256_cov_4.202186_g72128_i0 | PRJNA853194 | 73219 | 256 | 4.202186 | 10.75759616 | Desulfobacteraceae bacterium 4572_35.1 | 1971627 | Bacteria | Bacteria | 42.4 | 0.0426 | NR | OQY16268.1 | 1971627 | g72128 | i0 | 31.9 | 0.84375 | 72 | 49 | 84.4 | 0 | 15 | 230 | 70 | 141 | OQY16268.1 MAG: tRNA glutamyl-Q(34) synthetase GluQRS, partial [Desulfobacteraceae bacterium 4572_35.1] | diamond | 216 | 42.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium 4572_35.1 |
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);;