contig_metadata
8 rows where bioproject = "PRJNA898105" and tax_phylum = "Deinococcota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6348226 | 6348226 | PRJNA898105_P_NODE_4785_length_276_cov_1.320197_g4585_i0 | PRJNA898105 | 4785 | 276 | 1.320197 | 3.64374372 | Thermus | 270 | Bacteria | Bacteria | 499 | 7.54e-137 | NTclustered | gi|320149275|gb|CP001962.1| | 743525 | g4585 | i0 | 99.275 | 56.1268115942029 | 276 | 2 | 100 | 0 | 1 | 276 | 1166085 | 1166360 | Thermus scotoductus SA-01, complete genome | blastn | 15491 | 499 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus scotoductus | ||
| 7251965 | 7251965 | PRJNA898105_P_NODE_4486_length_281_cov_1.413462_g4286_i0 | PRJNA898105 | 4486 | 281 | 1.413462 | 3.97182822 | uncultured Deinococcus sp. | 158789 | Bacteria | Bacteria | 442 | 1.3199999999999993e-119 | NTclustered | gi|389546625|gb|JQ401553.1| | 158789 | g4286 | i0 | 95.018 | 105.174377224199 | 281 | 14 | 100 | 0 | 1 | 281 | 638 | 358 | Uncultured Deinococcus sp. clone CNY_01678 16S ribosomal RNA gene, partial sequence | blastn | 29554 | 442 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | uncultured Deinococcus sp. | ||
| 9801734 | 9801734 | PRJNA898105_P_NODE_6548_length_249_cov_0.875000_g6348_i0 | PRJNA898105 | 6548 | 249 | 0.875 | 2.17875 | Deinococcus peraridilitoris | 432329 | Bacteria | Bacteria | 99.4 | 2.4399999999999999e-23 | NR | WP_015235812.1 | 432329 | g6348 | i0 | 59.7 | 2.67469879518072 | 72 | 29 | 86.7 | 0 | 218 | 3 | 75 | 146 | WP_015235812.1 3-hydroxybutyrate dehydrogenase [Deinococcus peraridilitoris] | diamond | 666 | 99.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus peraridilitoris | ||
| 16546751 | 16546751 | PRJNA898105_P_NODE_5393_length_265_cov_1.333333_g5193_i0 | PRJNA898105 | 5393 | 265 | 1.333333 | 3.53333245 | Deinococcus | 1298 | Bacteria | Bacteria | 484 | 2.0199999999999998e-132 | NTclustered | gi|1435316362|gb|CP031158.1| | 980427 | g5193 | i0 | 99.623 | 28.622641509434 | 265 | 1 | 100 | 0 | 1 | 265 | 873446 | 873182 | Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome | blastn | 7585 | 484 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus wulumuqiensis | ||
| 19095761 | 19095761 | PRJNA898105_P_NODE_5275_length_267_cov_1.463918_g5075_i0 | PRJNA898105 | 5275 | 267 | 1.463918 | 3.90866106 | Deinococcus | 1298 | Bacteria | Bacteria | 488 | 1.5699999999999998e-133 | NTclustered | gi|470488003|ref|NR_076846.1| | 55148 | g5075 | i0 | 99.625 | 249.483146067416 | 267 | 1 | 100 | 0 | 1 | 267 | 1013 | 747 | Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence | blastn | 66612 | 488 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus proteolyticus | ||
| 25470979 | 25470979 | PRJNA898105_P_NODE_880_length_697_cov_3.243590_g693_i0 | PRJNA898105 | 880 | 697 | 3.24359 | 22.6078223 | Truepera | 332248 | Bacteria | Bacteria | 902 | 0 | NTclustered | gi|470486385|ref|NR_076754.1| | 332249 | g693 | i0 | 90.762 | 182.691535150646 | 682 | 53 | 97 | 8 | 2 | 677 | 1920 | 1243 | Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence | blastn | 127336 | 902 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 30150290 | 30150290 | PRJNA898105_P_NODE_5752_length_258_cov_1.291892_g5552_i0 | PRJNA898105 | 5752 | 258 | 1.291892 | 3.33308136 | Deinococcus ficus | 317577 | Bacteria | Bacteria | 127 | 6.479999999999998e-35 | NR | WP_027464351.1 | 317577 | g5552 | i0 | 70.6 | 0.988372093023256 | 85 | 25 | 98.8 | 0 | 256 | 2 | 19 | 103 | WP_027464351.1 hypothetical protein [Deinococcus ficus] | diamond | 255 | 127 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus ficus | ||
| 32015572 | 32015572 | PRJNA898105_P_NODE_7758_length_244_cov_0.900585_g7558_i0 | PRJNA898105 | 7758 | 244 | 0.900585 | 2.1974274 | Thermus sp. | 275 | Bacteria | Bacteria | 114 | 2.38e-27 | NR | MEN2982684.1 | 275 | g7558 | i0 | 98.2 | 0.700819672131147 | 57 | 1 | 70.1 | 0 | 72 | 242 | 1 | 57 | MEN2982684.1 type IV secretory system conjugative DNA transfer family protein [Thermus sp.] | diamond | 171 | 114 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus sp. |
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);;