contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax_phylum = "Abditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1807837 | 1807837 | PRJNA556992_P_NODE_723322_length_250_cov_0.870056_g721133_i0 | PRJNA556992 | 723322 | 250 | 0.870056 | 2.17514 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 162 | 1.03e-46 | NR | HEX9995666.1 | 2109264 | g721133 | i0 | 89.2 | 0.996 | 83 | 9 | 99.6 | 0 | 249 | 1 | 125 | 207 | HEX9995666.1 Gfo/Idh/MocA family oxidoreductase [Abditibacterium sp.] | diamond | 249 | 162 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 15835238 | 15835238 | PRJNA556992_P_NODE_737113_length_249_cov_2.028409_g734924_i0 | PRJNA556992 | 737113 | 249 | 2.028409 | 5.05073841 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 163 | 6.199999999999999e-48 | NR | MBV9470481.1 | 2800791 | g734924 | i0 | 86.7 | 5 | 83 | 11 | 100 | 0 | 1 | 249 | 93 | 175 | MBV9470481.1 succinate--CoA ligase subunit alpha [Abditibacteriaceae bacterium] | diamond | 1245 | 163 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 26635372 | 26635372 | PRJNA556992_P_NODE_621961_length_257_cov_2.097826_g619772_i0 | PRJNA556992 | 621961 | 257 | 2.097826 | 5.39141282 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 128 | 3.54e-32 | NR | BCM88312.1 | 2783868 | g619772 | i0 | 89.7 | 0.793774319066148 | 68 | 7 | 79.4 | 0 | 255 | 52 | 628 | 695 | BCM88312.1 hypothetical protein IAD21_00143 [Abditibacteriota bacterium] | diamond | 204 | 128 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 26730019 | 26730019 | PRJNA556992_P_NODE_577701_length_260_cov_6.229947_g575512_i0 | PRJNA556992 | 577701 | 260 | 6.229947 | 16.1978622 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 108 | 4.53e-25 | NR | HEX8550985.1 | 2800791 | g575512 | i0 | 57.5 | 1.97307692307692 | 87 | 36 | 99.2 | 1 | 260 | 3 | 2259 | 2345 | HEX8550985.1 translocation/assembly module TamB domain-containing protein [Abditibacteriaceae bacterium] | diamond | 513 | 108 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 27741976 | 27741976 | PRJNA556992_P_NODE_1010984_length_229_cov_3.865385_g1008794_i0 | PRJNA556992 | 1010984 | 229 | 3.865385 | 8.85173165 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 43.9 | 0.0122 | NR | MDF2439826.1 | 2783868 | g1008794 | i0 | 47.5 | 0.799126637554585 | 61 | 26 | 72.1 | 1 | 2 | 166 | 196 | 256 | MDF2439826.1 hypothetical protein [Abditibacteriota bacterium] | diamond | 183 | 43.9 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 27836653 | 27836653 | PRJNA556992_P_NODE_717804_length_250_cov_2.067797_g715615_i0 | PRJNA556992 | 717804 | 250 | 2.067797 | 5.1694925 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 58.2 | 1.13e-7 | NR | HEX8551957.1 | 2800791 | g715615 | i0 | 43.8 | 1.884 | 80 | 40 | 93.6 | 2 | 240 | 7 | 3 | 79 | HEX8551957.1 TIM barrel protein [Abditibacteriaceae bacterium] | diamond | 471 | 58.2 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 28152351 | 28152351 | PRJNA556992_P_NODE_1085685_length_216_cov_4.930070_g1083494_i0 | PRJNA556992 | 1085685 | 216 | 4.93007 | 10.6489512 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 77 | 2.74e-15 | NR | HEX8463050.1 | 2109264 | g1083494 | i0 | 57.6 | 0.916666666666667 | 66 | 28 | 91.7 | 0 | 19 | 216 | 132 | 197 | HEX8463050.1 TetR/AcrR family transcriptional regulator [Abditibacterium sp.] | diamond | 198 | 77 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 28973636 | 28973636 | PRJNA556992_P_NODE_821888_length_245_cov_0.895349_g819698_i0 | PRJNA556992 | 821888 | 245 | 0.895349 | 2.19360505 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 159 | 4.8599999999999995e-45 | NR | BCM91986.1 | 2783868 | g819698 | i0 | 86.4 | 0.991836734693878 | 81 | 11 | 99.2 | 0 | 244 | 2 | 16 | 96 | BCM91986.1 putative teichuronic acid biosynthesis glycosyltransferase TuaH [Abditibacteriota bacterium] | diamond | 243 | 159 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 29226113 | 29226113 | PRJNA556992_P_NODE_393669_length_277_cov_2.117647_g391480_i0 | PRJNA556992 | 393669 | 277 | 2.117647 | 5.86588219 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 100 | 1.99e-22 | NR | HEY0075316.1 | 2800791 | g391480 | i0 | 60.4 | 0.985559566787004 | 91 | 32 | 98.6 | 2 | 3 | 275 | 73 | 159 | HEY0075316.1 heavy metal translocating P-type ATPase [Abditibacteriaceae bacterium] | diamond | 273 | 100 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 29604176 | 29604176 | PRJNA556992_P_NODE_1027170_length_227_cov_7.357143_g1024980_i0 | PRJNA556992 | 1027170 | 227 | 7.357143 | 16.70071461 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 124 | 6.0000000000000005e-31 | NR | HEX8237544.1 | 2800791 | g1024980 | i0 | 78.7 | 0.991189427312775 | 75 | 16 | 99.1 | 0 | 2 | 226 | 195 | 269 | HEX8237544.1 PAS domain S-box protein [Abditibacteriaceae bacterium] | diamond | 225 | 124 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 29604614 | 29604614 | PRJNA556992_P_NODE_784910_length_247_cov_0.885057_g782720_i0 | PRJNA556992 | 784910 | 247 | 0.885057 | 2.18609079 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 75.1 | 1.56e-13 | NR | HEX8552361.1 | 2800791 | g782720 | i0 | 45.6 | 0.959514170040486 | 79 | 43 | 96 | 0 | 245 | 9 | 1174 | 1252 | HEX8552361.1 tetratricopeptide repeat protein [Abditibacteriaceae bacterium] | diamond | 237 | 75.1 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 30773897 | 30773897 | PRJNA556992_P_NODE_651154_length_255_cov_1.285714_g648965_i0 | PRJNA556992 | 651154 | 255 | 1.285714 | 3.2785707 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 100 | 1.29e-23 | NR | MBV9866827.1 | 2800791 | g648965 | i0 | 64 | 0.882352941176471 | 75 | 26 | 88.2 | 1 | 253 | 29 | 42 | 115 | MBV9866827.1 DUF1559 domain-containing protein [Abditibacteriaceae bacterium] | diamond | 225 | 100 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 31120894 | 31120894 | PRJNA556992_P_NODE_574675_length_261_cov_1.563830_g572486_i0 | PRJNA556992 | 574675 | 261 | 1.56383 | 4.0815963 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 135 | 8.689999999999998e-35 | NR | MDF2440493.1 | 2783868 | g572486 | i0 | 78.3 | 0.954022988505747 | 83 | 18 | 95.4 | 0 | 250 | 2 | 301 | 383 | MDF2440493.1 hypothetical protein [Abditibacteriota bacterium] | diamond | 249 | 135 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 31596004 | 31596004 | PRJNA556992_P_NODE_895856_length_241_cov_0.916667_g893666_i0 | PRJNA556992 | 895856 | 241 | 0.916667 | 2.20916747 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 105 | 9.77e-25 | NR | MEO6907142.1 | 2800791 | g893666 | i0 | 83.9 | 4.18257261410788 | 56 | 9 | 69.7 | 0 | 169 | 2 | 1 | 56 | MEO6907142.1 ribonuclease J [Abditibacteriaceae bacterium] | diamond | 1008 | 105 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 31626887 | 31626887 | PRJNA556992_P_NODE_1119356_length_208_cov_5.696296_g1117165_i0 | PRJNA556992 | 1119356 | 208 | 5.696296 | 11.84829568 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 71.6 | 1.47e-12 | NR | MBV9469975.1 | 2800791 | g1117165 | i0 | 52.1 | 2.04807692307692 | 73 | 31 | 99.5 | 1 | 2 | 208 | 175 | 247 | MBV9469975.1 hypothetical protein [Abditibacteriaceae bacterium] | diamond | 426 | 71.6 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 31690557 | 31690557 | PRJNA556992_P_NODE_872417_length_242_cov_1.822485_g870227_i0 | PRJNA556992 | 872417 | 242 | 1.822485 | 4.4104137 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 53.9 | 2.21e-6 | NR | HEX8237835.1 | 2800791 | g870227 | i0 | 43.4 | 1.77272727272727 | 83 | 42 | 96.7 | 1 | 240 | 7 | 22 | 104 | HEX8237835.1 hypothetical protein [Abditibacteriaceae bacterium] | diamond | 429 | 53.9 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 31975007 | 31975007 | PRJNA556992_P_NODE_240718_length_309_cov_2.500000_g238530_i0 | PRJNA556992 | 240718 | 309 | 2.5 | 7.725 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 77 | 1.18e-14 | NR | HEX8236528.1 | 2800791 | g238530 | i0 | 71.4 | 0.475728155339806 | 49 | 14 | 47.6 | 0 | 309 | 163 | 129 | 177 | HEX8236528.1 DUF1559 domain-containing protein [Abditibacteriaceae bacterium] | diamond | 147 | 77 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 31975049 | 31975049 | PRJNA556992_P_NODE_319818_length_286_cov_1.446009_g317629_i0 | PRJNA556992 | 319818 | 286 | 1.446009 | 4.13558574 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 134 | 4.809999999999999e-37 | NR | HEY0076636.1 | 2800791 | g317629 | i0 | 66.3 | 0.996503496503496 | 95 | 32 | 99.7 | 0 | 286 | 2 | 115 | 209 | HEY0076636.1 metal-dependent transcriptional regulator [Abditibacteriaceae bacterium] | diamond | 285 | 134 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 32165355 | 32165355 | PRJNA556992_P_NODE_845978_length_243_cov_3.976471_g843788_i0 | PRJNA556992 | 845978 | 243 | 3.976471 | 9.66282453 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 128 | 2.93e-33 | NR | MBV9868599.1 | 2800791 | g843788 | i0 | 82.3 | 2.85185185185185 | 79 | 14 | 97.5 | 0 | 6 | 242 | 111 | 189 | MBV9868599.1 glycosyltransferase family 2 protein [Abditibacteriaceae bacterium] | diamond | 693 | 128 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae 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);;