contig_metadata
11 rows where bioproject = "PRJNA1240804", tax_clade = "PVC group" and tax_phylum = "Kiritimatiellota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 349114 | 349114 | PRJNA1240804_P_NODE_91821_length_178_cov_2.798450_g91455_i0 | PRJNA1240804 | 91821 | 178 | 2.79845 | 4.981241 | Tichowtungia aerotolerans | 2697043 | Bacteria | Bacteria | 119 | 1.46e-22 | NTclustered | gi|1798450978|gb|CP047593.1| | 2697043 | g91455 | i0 | 89.474 | 8.66292134831461 | 95 | 8 | 53 | 2 | 73 | 166 | 320223 | 320316 | Tichowtungia aerotolerans strain S-5007 chromosome, complete genome | blastn | 1542 | 119 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Tichowtungiia | Tichowtungiales | Tichowtungiaceae | Tichowtungia | Tichowtungia aerotolerans | |
| 9275221 | 9275221 | PRJNA1240804_P_NODE_116688_length_168_cov_0.873950_g116322_i0 | PRJNA1240804 | 116688 | 168 | 0.87395 | 1.468236 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 113 | 8.19e-28 | NR | HPB10230.1 | 2212473 | g116322 | i0 | 96.2 | 5.57142857142857 | 52 | 2 | 92.9 | 0 | 12 | 167 | 245 | 296 | HPB10230.1 Gfo/Idh/MocA family oxidoreductase [Kiritimatiellia bacterium] | diamond | 936 | 113 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 26630304 | 26630304 | PRJNA1240804_P_NODE_111181_length_169_cov_0.866667_g110815_i0 | PRJNA1240804 | 111181 | 169 | 0.866667 | 1.46466723 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 63.2 | 8.55e-10 | NR | HPO37797.1 | 2212473 | g110815 | i0 | 100 | 0.514792899408284 | 29 | 0 | 51.5 | 0 | 156 | 70 | 187 | 215 | HPO37797.1 alpha-N-arabinofuranosidase [Kiritimatiellia bacterium] | diamond | 87 | 63.2 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27104987 | 27104987 | PRJNA1240804_P_NODE_76502_length_189_cov_1.192857_g76136_i0 | PRJNA1240804 | 76502 | 189 | 1.192857 | 2.25449973 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 117 | 2.36e-30 | NR | MFA6632653.1 | 2212473 | g76136 | i0 | 96.6 | 0.920634920634921 | 58 | 2 | 92.1 | 0 | 176 | 3 | 171 | 228 | MFA6632653.1 glycerophosphodiester phosphodiesterase family protein [Kiritimatiellia bacterium] | diamond | 174 | 117 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27452877 | 27452877 | PRJNA1240804_P_NODE_108163_length_169_cov_0.866667_g107797_i0 | PRJNA1240804 | 108163 | 169 | 0.866667 | 1.46466723 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 85.5 | 1.14e-17 | NR | MCO5043738.1 | 2212473 | g107797 | i0 | 80.4 | 0.905325443786982 | 51 | 10 | 90.5 | 0 | 3 | 155 | 527 | 577 | MCO5043738.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 153 | 85.5 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27515925 | 27515925 | PRJNA1240804_P_NODE_82703_length_185_cov_0.955882_g82337_i0 | PRJNA1240804 | 82703 | 185 | 0.955882 | 1.7683817 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 66.6 | 6.46e-11 | NR | HMP77251.1 | 2212473 | g82337 | i0 | 54.5 | 0.891891891891892 | 55 | 25 | 89.2 | 0 | 179 | 15 | 868 | 922 | HMP77251.1 alpha/beta fold hydrolase [Kiritimatiellia bacterium] | diamond | 165 | 66.6 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28305165 | 28305165 | PRJNA1240804_P_NODE_148686_length_162_cov_0.920354_g148320_i0 | PRJNA1240804 | 148686 | 162 | 0.920354 | 1.49097348 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 68.9 | 7.28e-12 | NR | MCB1102807.1 | 2212473 | g148320 | i0 | 72.3 | 2.61111111111111 | 47 | 13 | 87 | 0 | 159 | 19 | 231 | 277 | MCB1102807.1 choice-of-anchor D domain-containing protein [Kiritimatiellia bacterium] | diamond | 423 | 68.9 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29915722 | 29915722 | PRJNA1240804_P_NODE_53831_length_213_cov_1.878049_g53465_i0 | PRJNA1240804 | 53831 | 213 | 1.878049 | 4.00024437 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 123 | 4.999999999999999e-32 | NR | MDE0839304.1 | 2212473 | g53465 | i0 | 93.9 | 0.929577464788732 | 66 | 4 | 93 | 0 | 199 | 2 | 243 | 308 | MDE0839304.1 IS5 family transposase [Kiritimatiellia bacterium] | diamond | 198 | 123 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30768722 | 30768722 | PRJNA1240804_P_NODE_83774_length_184_cov_1.259259_g83408_i0 | PRJNA1240804 | 83774 | 184 | 1.259259 | 2.31703656 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 40 | 0.0251 | NR | HMP91047.1 | 2212473 | g83408 | i0 | 85 | 0.326086956521739 | 20 | 3 | 32.6 | 0 | 75 | 16 | 3 | 22 | HMP91047.1 antirestriction protein ArdA [Kiritimatiellia bacterium] | diamond | 60 | 40 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31115930 | 31115930 | PRJNA1240804_P_NODE_71315_length_192_cov_2.153846_g70949_i0 | PRJNA1240804 | 71315 | 192 | 2.153846 | 4.13538432 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 70.1 | 5.16e-13 | NR | HMO03702.1 | 2212473 | g70949 | i0 | 66.7 | 0.75 | 48 | 16 | 75 | 0 | 10 | 153 | 126 | 173 | HMO03702.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 144 | 70.1 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31874985 | 31874985 | PRJNA1240804_P_NODE_121817_length_167_cov_0.881356_g121451_i0 | PRJNA1240804 | 121817 | 167 | 0.881356 | 1.47186452 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 53.1 | 2.85e-6 | NR | MBN1675890.1 | 2212473 | g121451 | i0 | 52 | 0.898203592814371 | 50 | 24 | 89.8 | 0 | 16 | 165 | 2221 | 2270 | MBN1675890.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Kiritimatiellia bacterium] | diamond | 150 | 53.1 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia 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);;