contig_metadata
8 rows where bioproject = "PRJNA744060", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26863242 | 26863242 | PRJNA744060_P_NODE_53921_length_229_cov_2.544872_g53592_i0 | PRJNA744060 | 53921 | 229 | 2.544872 | 5.82775688 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 52 | 1.66e-5 | NR | HEY3284726.1 | 2033014 | g53592 | i0 | 40.3 | 0.812227074235808 | 62 | 31 | 81.2 | 1 | 227 | 42 | 589 | 644 | HEY3284726.1 dockerin type I domain-containing protein [Armatimonadota bacterium] | diamond | 186 | 52 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27536699 | 27536699 | PRJNA744060_P_NODE_2523_length_964_cov_4.193042_g2282_i0 | PRJNA744060 | 2523 | 964 | 4.193042 | 40.42092488 | PVC group | 1783257 | Bacteria | Bacteria | 56.6 | 7.65e-5 | NR | NLH99045.1 | 2282151 | g2282 | i0 | 57.9 | 0.454356846473029 | 38 | 16 | 11.8 | 0 | 4 | 117 | 283 | 320 | NLH99045.1 protein kinase [Chthonomonadales bacterium] | diamond | 438 | 56.6 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 28252764 | 28252764 | PRJNA744060_P_NODE_11986_length_463_cov_1.000000_g11658_i0 | PRJNA744060 | 11986 | 463 | 1 | 4.63 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 89.4 | 2.34e-17 | NR | MFN8220026.1 | 2682145 | g11658 | i0 | 42 | 0.894168466522678 | 138 | 64 | 89.4 | 2 | 453 | 40 | 785 | 906 | MFN8220026.1 tandem-95 repeat protein [Fimbriimonadales bacterium] | diamond | 414 | 89.4 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 28473925 | 28473925 | PRJNA744060_P_NODE_14226_length_426_cov_1.090652_g13897_i0 | PRJNA744060 | 14226 | 426 | 1.090652 | 4.64617752 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 52.4 | 1.17e-4 | NR | HUV04759.1 | 2033014 | g13897 | i0 | 32.2 | 1.55633802816901 | 115 | 75 | 80.3 | 3 | 343 | 2 | 254 | 366 | HUV04759.1 tetratricopeptide repeat protein [Armatimonadota bacterium] | diamond | 663 | 52.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28695131 | 28695131 | PRJNA744060_P_NODE_9707_length_514_cov_3.582766_g9380_i0 | PRJNA744060 | 9707 | 514 | 3.582766 | 18.41541724 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 170 | 2.0199999999999998e-46 | NR | MCB0826406.1 | 2033014 | g9380 | i0 | 52 | 2.00194552529183 | 171 | 60 | 99.8 | 3 | 2 | 514 | 377 | 525 | MCB0826406.1 alpha amylase C-terminal domain-containing protein [Armatimonadota bacterium] | diamond | 1029 | 170 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28820930 | 28820930 | PRJNA744060_P_NODE_8848_length_537_cov_3.711207_g8523_i0 | PRJNA744060 | 8848 | 537 | 3.711207 | 19.92918159 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 73.6 | 1.39e-11 | NR | MBM3465436.1 | 2033014 | g8523 | i0 | 36.8 | 0.653631284916201 | 117 | 72 | 64.8 | 2 | 358 | 11 | 117 | 232 | MBM3465436.1 DUF1565 domain-containing protein [Armatimonadota bacterium] | diamond | 351 | 73.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30021254 | 30021254 | PRJNA744060_P_NODE_23731_length_333_cov_2.173077_g23402_i0 | PRJNA744060 | 23731 | 333 | 2.173077 | 7.23634641 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 61.2 | 4.32e-9 | NR | HEV2472425.1 | 2282151 | g23402 | i0 | 38.2 | 3.53153153153153 | 102 | 47 | 82.9 | 2 | 279 | 4 | 36 | 131 | HEV2472425.1 universal stress protein [Chthonomonadales bacterium] | diamond | 1176 | 61.2 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 32012564 | 32012564 | PRJNA744060_P_NODE_24818_length_326_cov_1.948617_g24489_i0 | PRJNA744060 | 24818 | 326 | 1.948617 | 6.35249142 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 52 | 5.57e-5 | NR | HLK60280.1 | 2739509 | g24489 | i0 | 37.6 | 0.782208588957055 | 85 | 49 | 78.2 | 2 | 62 | 316 | 456 | 536 | HLK60280.1 SBBP repeat-containing protein [Chthonomonadaceae bacterium] | diamond | 255 | 52 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae 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);;