contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3152380 | 3152380 | PRJNA630162_P_NODE_116623_length_176_cov_1.685039_g115100_i0 | PRJNA630162 | 116623 | 176 | 1.685039 | 2.96566864 | Bacteria | 2 | Bacteria | Bacteria | 89 | 1.04e-20 | NR | WP_014560202.1 | 591197 | g115100 | i0 | 75 | 6.71590909090909 | 56 | 14 | 95.5 | 0 | 4 | 171 | 65 | 120 | WP_014560202.1 thioredoxin-dependent thiol peroxidase [Ignavibacterium album] | diamond | 1182 | 89.7 | 0.992196209587514 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium album | |
| 19002576 | 19002576 | PRJNA630162_P_NODE_110895_length_179_cov_1.853846_g109372_i0 | PRJNA630162 | 110895 | 179 | 1.853846 | 3.31838434 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 109 | 3.9e-27 | NR | MBK9247294.1 | 2053306 | g109372 | i0 | 93 | 0.955307262569832 | 57 | 4 | 95.5 | 0 | 7 | 177 | 253 | 309 | MBK9247294.1 type I glyceraldehyde-3-phosphate dehydrogenase [Ignavibacteria bacterium] | diamond | 171 | 109 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 27124656 | 27124656 | PRJNA630162_P_NODE_119682_length_174_cov_3.080000_g118159_i0 | PRJNA630162 | 119682 | 174 | 3.08 | 5.3592 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 100 | 3.84e-25 | NR | OGU60908.1 | 1798430 | g118159 | i0 | 75 | 5.79310344827586 | 56 | 14 | 96.6 | 0 | 169 | 2 | 32 | 87 | OGU60908.1 MAG: 50S ribosomal protein L13 [Ignavibacteria bacterium GWF2_33_9] | diamond | 1008 | 101 | 0.99009900990099 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium GWF2_33_9 | ||||
| 27238822 | 27238822 | PRJNA630162_P_NODE_96823_length_187_cov_2.920290_g95300_i0 | PRJNA630162 | 96823 | 187 | 2.92029 | 5.4609423 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 113 | 8.83e-28 | NR | MBI2419561.1 | 2049428 | g95300 | i0 | 100 | 0.962566844919786 | 60 | 0 | 96.3 | 0 | 181 | 2 | 365 | 424 | MBI2419561.1 signal recognition particle protein [Ignavibacteriales bacterium] | diamond | 180 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 27409694 | 27409694 | PRJNA630162_P_NODE_93063_length_190_cov_1.255319_g91540_i0 | PRJNA630162 | 93063 | 190 | 1.255319 | 2.3851061 | Bacteria | 2 | Bacteria | Bacteria | 94.4 | 1.24e-20 | NR | MBI1806985.1 | 2053306 | g91540 | i0 | 75.8 | 3.91578947368421 | 62 | 15 | 97.9 | 0 | 2 | 187 | 643 | 704 | MBI1806985.1 G8 domain-containing protein [Ignavibacteria bacterium] | diamond | 744 | 94.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 27586291 | 27586291 | PRJNA630162_P_NODE_160304_length_162_cov_0.920354_g158781_i0 | PRJNA630162 | 160304 | 162 | 0.920354 | 1.49097348 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 92.8 | 3.5299999999999995e-23 | NR | MBK7253449.1 | 2053306 | g158781 | i0 | 93.6 | 2.61111111111111 | 47 | 3 | 87 | 0 | 143 | 3 | 1 | 47 | MBK7253449.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 423 | 92.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28975703 | 28975703 | PRJNA630162_P_NODE_83108_length_198_cov_1.885906_g81585_i0 | PRJNA630162 | 83108 | 198 | 1.885906 | 3.73409388 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 61.6 | 1.79e-9 | NR | MDZ7762844.1 | 2614255 | g81585 | i0 | 75.7 | 6.5 | 37 | 9 | 56.1 | 0 | 111 | 1 | 10 | 46 | MDZ7762844.1 sodium/proton-translocating pyrophosphatase [Melioribacteraceae bacterium] | diamond | 1287 | 61.6 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 29007389 | 29007389 | PRJNA630162_P_NODE_153148_length_164_cov_0.904348_g151625_i0 | PRJNA630162 | 153148 | 164 | 0.904348 | 1.48313072 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 104 | 4.3e-25 | NR | MBK9247750.1 | 2053306 | g151625 | i0 | 98.1 | 0.951219512195122 | 52 | 1 | 95.1 | 0 | 158 | 3 | 277 | 328 | MBK9247750.1 tRNA 2-selenouridine(34) synthase MnmH [Ignavibacteria bacterium] | diamond | 156 | 104 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29101811 | 29101811 | PRJNA630162_P_NODE_130888_length_169_cov_1.491667_g129365_i0 | PRJNA630162 | 130888 | 169 | 1.491667 | 2.52091723 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 43.5 | 0.00749 | NR | MBM4179798.1 | 2053306 | g129365 | i0 | 54.2 | 0.42603550295858 | 24 | 11 | 42.6 | 0 | 7 | 78 | 564 | 587 | MBM4179798.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 72 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29228325 | 29228325 | PRJNA630162_P_NODE_171089_length_153_cov_2.846154_g169566_i0 | PRJNA630162 | 171089 | 153 | 2.846154 | 4.35461562 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 95.1 | 2.4600000000000003e-21 | NR | MBK9249298.1 | 2053306 | g169566 | i0 | 91.8 | 0.96078431372549 | 49 | 4 | 96.1 | 0 | 149 | 3 | 111 | 159 | MBK9249298.1 amidohydrolase family protein [Ignavibacteria bacterium] | diamond | 147 | 95.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29809015 | 29809015 | PRJNA630162_P_NODE_89551_length_192_cov_1.601399_g88028_i0 | PRJNA630162 | 89551 | 192 | 1.601399 | 3.07468608 | Bacteria | 2 | Bacteria | Bacteria | 87.8 | 2.47e-18 | NR | MCE2755581.1 | 2026749 | g88028 | i0 | 66 | 3.390625 | 53 | 18 | 82.8 | 0 | 33 | 191 | 214 | 266 | MCE2755581.1 glutamine synthetase III [Ignavibacteriota bacterium] | diamond | 651 | 88.2 | 0.99546485260771 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 29954514 | 29954514 | PRJNA630162_P_NODE_97911_length_187_cov_1.275362_g96388_i0 | PRJNA630162 | 97911 | 187 | 1.275362 | 2.38492694 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 77.8 | 4.61e-15 | NR | HRK00912.1 | 2053306 | g96388 | i0 | 63.9 | 1.94117647058824 | 61 | 21 | 96.3 | 1 | 5 | 184 | 265 | 325 | HRK00912.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 363 | 77.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30428741 | 30428741 | PRJNA630162_P_NODE_80733_length_200_cov_3.099338_g79210_i0 | PRJNA630162 | 80733 | 200 | 3.099338 | 6.198676 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 42 | 0.0301 | NR | MBM2816524.1 | 2053306 | g79210 | i0 | 56.8 | 0.555 | 37 | 16 | 55.5 | 0 | 86 | 196 | 26 | 62 | MBM2816524.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 111 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30554469 | 30554469 | PRJNA630162_P_NODE_158293_length_162_cov_2.716814_g156770_i0 | PRJNA630162 | 158293 | 162 | 2.716814 | 4.40123868 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 79 | 6.43e-17 | NR | MBM2814034.1 | 2053306 | g156770 | i0 | 70.5 | 2.44444444444444 | 44 | 13 | 81.5 | 0 | 30 | 161 | 7 | 50 | MBM2814034.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 396 | 79 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30775903 | 30775903 | PRJNA630162_P_NODE_144614_length_166_cov_0.888889_g143091_i0 | PRJNA630162 | 144614 | 166 | 0.888889 | 1.47555574 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 48.1 | 2.39e-5 | NR | MBI3260506.1 | 2026749 | g143091 | i0 | 45.1 | 0.921686746987952 | 51 | 28 | 92.2 | 0 | 11 | 163 | 15 | 65 | MBI3260506.1 hypothetical protein [Ignavibacteriota bacterium] | diamond | 153 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 30902263 | 30902263 | PRJNA630162_P_NODE_169454_length_155_cov_2.245283_g167931_i0 | PRJNA630162 | 169454 | 155 | 2.245283 | 3.48018865 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 60.1 | 5.82e-10 | NR | MBK9404748.1 | 2053306 | g167931 | i0 | 93.3 | 0.580645161290323 | 30 | 2 | 58.1 | 0 | 148 | 59 | 79 | 108 | MBK9404748.1 DUF3127 domain-containing protein [Ignavibacteria bacterium] | diamond | 90 | 60.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31281305 | 31281305 | PRJNA630162_P_NODE_135555_length_168_cov_0.873950_g134032_i0 | PRJNA630162 | 135555 | 168 | 0.87395 | 1.468236 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 118 | 2.69e-29 | NR | MBI3259723.1 | 2026749 | g134032 | i0 | 94.4 | 0.964285714285714 | 54 | 3 | 96.4 | 0 | 5 | 166 | 247 | 300 | MBI3259723.1 T9SS type A sorting domain-containing protein [Ignavibacteriota bacterium] | diamond | 162 | 118 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 31692576 | 31692576 | PRJNA630162_P_NODE_166417_length_158_cov_2.036697_g164894_i0 | PRJNA630162 | 166417 | 158 | 2.036697 | 3.21798126 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 48.1 | 1.47e-4 | NR | NLJ13626.1 | 2053306 | g164894 | i0 | 54.5 | 2.22151898734177 | 33 | 15 | 62.7 | 0 | 151 | 53 | 904 | 936 | NLJ13626.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 351 | 48.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32008974 | 32008974 | PRJNA630162_P_NODE_156638_length_163_cov_0.912281_g155115_i0 | PRJNA630162 | 156638 | 163 | 0.912281 | 1.48701803 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 52 | 6.66e-6 | NR | HRK00963.1 | 2053306 | g155115 | i0 | 44.2 | 0.957055214723926 | 52 | 29 | 95.7 | 0 | 3 | 158 | 1373 | 1424 | HRK00963.1 ParB N-terminal domain-containing protein [Ignavibacteria bacterium] | diamond | 156 | 52 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32547028 | 32547028 | PRJNA630162_P_NODE_138839_length_167_cov_1.415254_g137316_i0 | PRJNA630162 | 138839 | 167 | 1.415254 | 2.36347418 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 114 | 8.22e-28 | NR | MBK9247740.1 | 2053306 | g137316 | i0 | 94.5 | 0.988023952095808 | 55 | 3 | 98.8 | 0 | 1 | 165 | 745 | 799 | MBK9247740.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium] | diamond | 165 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32798733 | 32798733 | PRJNA630162_P_NODE_67440_length_215_cov_3.536145_g65917_i0 | PRJNA630162 | 67440 | 215 | 3.536145 | 7.60271175 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 43.9 | 0.00989 | NR | MEE9431252.1 | 2614255 | g65917 | i0 | 45.7 | 1.01860465116279 | 35 | 19 | 48.8 | 0 | 102 | 206 | 33 | 67 | MEE9431252.1 T9SS type A sorting domain-containing protein [Melioribacteraceae bacterium] | diamond | 219 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae 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);;