contig_metadata
7 rows where bioproject = "PRJNA744060" and tax_phylum = "Rhodothermota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24949966 | 24949966 | PRJNA744060_P_NODE_41740_length_258_cov_1.924324_g41411_i0 | PRJNA744060 | 41740 | 258 | 1.924324 | 4.96475592 | Rhodocaloribacter litoris | 2558931 | Bacteria | Bacteria | 165 | 2.89e-36 | NTclustered | gi|2076465437|gb|CP076718.1| | 2558931 | g41411 | i0 | 78.776 | 1.89147286821705 | 245 | 52 | 95 | 0 | 1 | 245 | 2707957 | 2707713 | Rhodocaloribacter litoris strain ISCAR-4553 chromosome | blastn | 488 | 165 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodocaloribacter | Rhodocaloribacter litoris | |
| 26957572 | 26957572 | PRJNA744060_P_NODE_17442_length_385_cov_4.756410_g17113_i0 | PRJNA744060 | 17442 | 385 | 4.75641 | 18.3121785 | Rhodothermales bacterium | 2306054 | Bacteria | Bacteria | 151 | 3.05e-44 | NR | MEX0600558.1 | 2306054 | g17113 | i0 | 56.2 | 2.83636363636364 | 121 | 52 | 93.5 | 1 | 362 | 3 | 6 | 126 | MEX0600558.1 NAD(P)-binding protein [Rhodothermales bacterium] | diamond | 1092 | 151 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium | |||
| 27147102 | 27147102 | PRJNA744060_P_NODE_52622_length_236_cov_2.208589_g52293_i0 | PRJNA744060 | 52622 | 236 | 2.208589 | 5.21227004 | Rhodothermales bacterium | 2306054 | Bacteria | Bacteria | 54.3 | 2.09e-6 | NR | HET6568231.1 | 2306054 | g52293 | i0 | 40.6 | 0.877118644067797 | 69 | 40 | 87.7 | 1 | 5 | 211 | 46 | 113 | HET6568231.1 hypothetical protein [Rhodothermales bacterium] | diamond | 207 | 54.3 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales bacterium | |||
| 27810994 | 27810994 | PRJNA744060_P_NODE_17884_length_381_cov_1.886364_g17555_i0 | PRJNA744060 | 17884 | 381 | 1.886364 | 7.18704684 | Rhodothermaceae bacterium | 2026787 | Bacteria | Bacteria | 124 | 3.76e-30 | NR | NNF58571.1 | 2026787 | g17555 | i0 | 53.2 | 5.92125984251969 | 126 | 57 | 99.2 | 1 | 2 | 379 | 432 | 555 | NNF58571.1 M28 family peptidase [Rhodothermaceae bacterium] | diamond | 2256 | 124 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodothermaceae bacterium | ||
| 28347592 | 28347592 | PRJNA744060_P_NODE_6266_length_633_cov_2.675000_g5946_i0 | PRJNA744060 | 6266 | 633 | 2.675 | 16.93275 | Rhodothermus bifroesti | 2823335 | Bacteria | Bacteria | 179 | 3.39e-52 | NR | WP_210376410.1 | 2823335 | g5946 | i0 | 46.9 | 0.919431279620853 | 194 | 97 | 89.1 | 3 | 67 | 630 | 42 | 235 | WP_210376410.1 GH12 family glycosyl hydrolase domain-containing protein [Rhodothermus bifroesti] | diamond | 582 | 179 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermaceae | Rhodothermus | Rhodothermus bifroesti | |
| 29241680 | 29241680 | PRJNA744060_P_NODE_35889_length_276_cov_1.522167_g35560_i0 | PRJNA744060 | 35889 | 276 | 1.522167 | 4.20118092 | root | 1 | Root_unresolved | Root_unresolved | 55.1 | 2.62e-6 | NR | WP_245846175.1 | 1850348 | g35560 | i0 | 49.2 | 1.95652173913043 | 59 | 29 | 63 | 1 | 189 | 16 | 116 | 174 | WP_245846175.1 glycoside hydrolase family 3 N-terminal domain-containing protein [Longibacter salinarum] | diamond | 540 | 55.5 | 0.992792792792793 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Salisaetaceae | Longibacter | Longibacter salinarum | |
| 32592070 | 32592070 | PRJNA744060_P_NODE_23499_length_335_cov_1.118321_g23170_i0 | PRJNA744060 | 23499 | 335 | 1.118321 | 3.74637535 | Bacteria | 2 | Bacteria | Bacteria | 76.6 | 1.37e-13 | NR | MDZ4699481.1 | 2306054 | g23170 | i0 | 36.9 | 3.04477611940298 | 111 | 41 | 99.4 | 2 | 3 | 335 | 523 | 604 | MDZ4699481.1 glucosamine-6-phosphate deaminase [Rhodothermales bacterium] | diamond | 1020 | 76.6 | 1 | Bacteria | FCB group | Pseudomonadati | Rhodothermota | Rhodothermia | Rhodothermales | Rhodothermales 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);;