contig_metadata
9 rows where bioproject = "PRJNA773778", tax_kingdom = "Thermotogati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2027424 | 2027424 | PRJNA773778_S_NODE_45682_length_244_cov_1.333333_g45532_i0 | PRJNA773778 | 45682 | 244 | 1.333333 | 3.25333252 | Thermus thermophilus | 274 | Bacteria | Bacteria | 370 | 5.35e-98 | NTclustered | gi|2074864999|dbj|AP024934.1| | 274 | g45532 | i0 | 99.029 | 33.7704918032787 | 206 | 2 | 84 | 0 | 39 | 244 | 179160 | 178955 | Thermus thermophilus AA3-7 plasmid pAA3-7b DNA, complete sequence | blastn | 8240 | 370 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus thermophilus | ||
| 5854344 | 5854344 | PRJNA773778_S_NODE_15365_length_364_cov_3.432990_g15215_i0 | PRJNA773778 | 15365 | 364 | 3.43299 | 12.4960836 | Deinococcus wulumuqiensis | 980427 | Bacteria | Bacteria | 588 | 2.13e-163 | NTclustered | gi|1819261009|gb|CP049357.1| | 1288484 | g15215 | i0 | 98.507 | 20.282967032967 | 335 | 2 | 91 | 1 | 33 | 364 | 2423940 | 2423606 | Deinococcus wulumuqiensis R12 chromosome, complete genome | blastn | 7383 | 588 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus wulumuqiensis | ||
| 6311339 | 6311339 | PRJNA773778_S_NODE_35945_length_263_cov_1.600000_g35795_i0 | PRJNA773778 | 35945 | 263 | 1.6 | 4.208 | Bacteria | 2 | Bacteria | Bacteria | 379 | 9.7e-101 | NTclustered | gi|155128|gb|J04639.1|TTHTAQP1A | 271 | g35795 | i0 | 97.727 | 55.2927756653992 | 220 | 5 | 84 | 0 | 20 | 239 | 340 | 121 | Thermus aquaticus DNA polymerase (PolI) gene | blastn | 14542 | 379 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus aquaticus | ||
| 8860401 | 8860401 | PRJNA773778_S_NODE_14807_length_369_cov_7.320946_g14657_i0 | PRJNA773778 | 14807 | 369 | 7.320946 | 27.01429074 | Truepera | 332248 | Bacteria | Bacteria | 313 | 1.46e-80 | NTclustered | gi|2573973991|gb|CP133611.1| | 332249 | g14657 | i0 | 92.627 | 447.715447154472 | 217 | 16 | 59 | 0 | 2 | 218 | 762032 | 762248 | Truepera radiovictrix strain CIP 108686 chromosome, complete genome | blastn | 165207 | 316 | 0.990506329113924 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 10135995 | 10135995 | PRJNA773778_S_NODE_6328_length_509_cov_9.594037_g6178_i0 | PRJNA773778 | 6328 | 509 | 9.594037 | 48.83364833 | Thermus | 270 | Bacteria | Bacteria | 811 | 0 | NTclustered | gi|320149275|gb|CP001962.1| | 743525 | g6178 | i0 | 99.551 | 6.93123772102161 | 445 | 2 | 87 | 0 | 65 | 509 | 1901424 | 1901868 | Thermus scotoductus SA-01, complete genome | blastn | 3528 | 811 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus scotoductus | ||
| 16054091 | 16054091 | PRJNA773778_S_NODE_48293_length_241_cov_0.916667_g48143_i0 | PRJNA773778 | 48293 | 241 | 0.916667 | 2.20916747 | Deinococcus ficus | 317577 | Bacteria | Bacteria | 355 | 1.48e-93 | NTclustered | gi|1220362168|gb|CP021081.1| | 317577 | g48143 | i0 | 99.487 | 20.7759336099585 | 195 | 1 | 81 | 0 | 47 | 241 | 484464 | 484270 | Deinococcus ficus strain CC-FR2-10, complete genome | blastn | 5007 | 355 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus ficus | ||
| 21609499 | 21609499 | PRJNA773778_S_NODE_49417_length_230_cov_3.745223_g49267_i0 | PRJNA773778 | 49417 | 230 | 3.745223 | 8.6140129 | Deinococcus | 1298 | Bacteria | Bacteria | 366 | 6.46e-97 | NTclustered | gi|2706837832|gb|CP149782.1| | 3112952 | g49267 | i0 | 100 | 4.28260869565217 | 198 | 0 | 86 | 0 | 1 | 198 | 1831932 | 1832129 | Deinococcus sp. VB142 chromosome 1, complete sequence | blastn | 985 | 366 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB142 | ||
| 24159022 | 24159022 | PRJNA773778_S_NODE_8519_length_457_cov_5.213542_g8369_i0 | PRJNA773778 | 8519 | 457 | 5.213542 | 23.82588694 | Thermus | 270 | Bacteria | Bacteria | 819 | 0 | NTclustered | gi|2894814231|gb|CP178485.1| | 56957 | g8369 | i0 | 98.911 | 41.0678336980306 | 459 | 3 | 100 | 1 | 1 | 457 | 50213 | 49755 | Thermus oshimai strain Blanco chromosome, complete genome | blastn | 18768 | 824 | 0.993932038834951 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus oshimai | ||
| 28199661 | 28199661 | PRJNA773778_S_NODE_38566_length_255_cov_2.115385_g38416_i0 | PRJNA773778 | 38566 | 255 | 2.115385 | 5.39423175 | Bacteria | 2 | Bacteria | Bacteria | 78.2 | 7.72e-15 | NR | WP_188974405.1 | 522487 | g38416 | i0 | 48.2 | 9.68235294117647 | 85 | 42 | 100 | 1 | 1 | 255 | 147 | 229 | WP_188974405.1 ice-binding family protein [Deinococcus aerolatus] | diamond | 2469 | 78.6 | 0.994910941475827 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aerolatus |
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);;