contig_metadata
7 rows where bioproject = "PRJNA549880", tax_phylum = "Deinococcota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1787311 | 1787311 | PRJNA549880_P_NODE_14582_length_243_cov_0.905882_g14489_i0 | PRJNA549880 | 14582 | 243 | 0.905882 | 2.20129326 | Deinococcus sp. VB142 | 3112952 | Bacteria | Bacteria | 449 | 6.65e-122 | NTclustered | gi|2706837832|gb|CP149782.1| | 3112952 | g14489 | i0 | 100 | 17.0617283950617 | 243 | 0 | 100 | 0 | 1 | 243 | 1920214 | 1919972 | Deinococcus sp. VB142 chromosome 1, complete sequence | blastn | 4146 | 449 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB142 | ||
| 4947813 | 4947813 | PRJNA549880_P_NODE_9044_length_270_cov_1.294416_g8951_i0 | PRJNA549880 | 9044 | 270 | 1.294416 | 3.4949232 | Deinococcus | 1298 | Bacteria | Bacteria | 416 | 7.619999999999998e-112 | NTclustered | gi|1751871007|dbj|AP021849.1| | 57498 | g8951 | i0 | 94.465 | 187.392592592593 | 271 | 14 | 100 | 1 | 1 | 270 | 72974 | 73244 | Deinococcus grandis ATCC 43672 DNA, complete genome | blastn | 50596 | 416 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus grandis | ||
| 15147820 | 15147820 | PRJNA549880_P_NODE_9212_length_267_cov_3.768041_g9119_i0 | PRJNA549880 | 9212 | 267 | 3.768041 | 10.06066947 | Deinococcus | 1298 | Bacteria | Bacteria | 424 | 4.49e-114 | NTclustered | gi|1751871007|dbj|AP021849.1| | 57498 | g9119 | i0 | 97.571 | 216.322097378277 | 247 | 6 | 93 | 0 | 14 | 260 | 423776 | 424022 | Deinococcus grandis ATCC 43672 DNA, complete genome | blastn | 57758 | 424 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus grandis | ||
| 15814835 | 15814835 | PRJNA549880_P_NODE_9333_length_266_cov_1.176166_g9240_i0 | PRJNA549880 | 9333 | 266 | 1.176166 | 3.12860156 | Deinococcus aetherius | 200252 | Bacteria | Bacteria | 396 | 9.759999999999997e-106 | NTclustered | gi|2281894955|dbj|AP026560.1| | 200252 | g9240 | i0 | 93.609 | 260.812030075188 | 266 | 15 | 100 | 2 | 1 | 266 | 822689 | 822952 | Deinococcus aetherius ST0316 DNA, complete genome | blastn | 69376 | 396 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aetherius | ||
| 20914053 | 20914053 | PRJNA549880_P_NODE_7797_length_287_cov_1.341121_g7704_i0 | PRJNA549880 | 7797 | 287 | 1.341121 | 3.84901727 | Deinococcus sp. VB343 | 3385567 | Bacteria | Bacteria | 520 | 6.049999999999999e-143 | NTclustered | gi|2905211496|gb|CP179945.1| | 3385567 | g7704 | i0 | 99.303 | 3.98954703832753 | 287 | 2 | 100 | 0 | 1 | 287 | 29068 | 29354 | Deinococcus sp. VB343 chromosome 1, complete sequence | blastn | 1145 | 520 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB343 | ||
| 25345991 | 25345991 | PRJNA549880_P_NODE_2300_length_475_cov_1.323383_g2207_i0 | PRJNA549880 | 2300 | 475 | 1.323383 | 6.28606925 | Deinococcus | 1298 | Bacteria | Bacteria | 592 | 2.2e-164 | NTclustered | gi|2264081587|gb|CP094462.1| | 1299 | g2207 | i0 | 89.308 | 204.206315789474 | 477 | 44 | 100 | 7 | 1 | 475 | 881442 | 880971 | Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence | blastn | 96998 | 592 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiodurans | ||
| 31405308 | 31405308 | PRJNA549880_P_NODE_9656_length_261_cov_1.335106_g9563_i0 | PRJNA549880 | 9656 | 261 | 1.335106 | 3.48462666 | Deinococcus antarcticus | 1298767 | Bacteria | Bacteria | 171 | 1.66e-53 | NR | WP_380076431.1 | 1298767 | g9563 | i0 | 96.6 | 1 | 87 | 3 | 100 | 0 | 1 | 261 | 1 | 87 | WP_380076431.1 YlxR family protein [Deinococcus antarcticus] | diamond | 261 | 171 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus antarcticus |
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);;