contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA900028" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4703007 | 4703007 | PRJNA900028_P_NODE_118084_length_167_cov_1.661017_g117335_i0 | PRJNA900028 | 118084 | 167 | 1.661017 | 2.77389839 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 91.7 | 2.8e-20 | NR | MDF2441490.1 | 2783868 | g117335 | i0 | 72.7 | 0.988023952095808 | 55 | 15 | 98.8 | 0 | 165 | 1 | 135 | 189 | MDF2441490.1 tight adherence protein [Abditibacteriota bacterium] | diamond | 165 | 91.7 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 17452816 | 17452816 | PRJNA900028_P_NODE_135494_length_166_cov_0.871795_g134745_i0 | PRJNA900028 | 135494 | 166 | 0.871795 | 1.4471797 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 96.7 | 1.24e-22 | NR | BCM93351.1 | 2783868 | g134745 | i0 | 90.7 | 1.95180722891566 | 54 | 5 | 97.6 | 0 | 162 | 1 | 11 | 64 | BCM93351.1 sulfur carrier protein FdhD [Abditibacteriota bacterium] | diamond | 324 | 96.7 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 17453041 | 17453041 | PRJNA900028_P_NODE_156194_length_164_cov_0.886957_g155445_i0 | PRJNA900028 | 156194 | 164 | 0.886957 | 1.45460948 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 94.7 | 1.3400000000000002e-21 | NR | HEY0076341.1 | 2800791 | g155445 | i0 | 88.9 | 2.96341463414634 | 54 | 6 | 98.8 | 0 | 162 | 1 | 113 | 166 | HEY0076341.1 thiamine pyrophosphate-dependent dehydrogenase E1 component subunit alpha [Abditibacteriaceae bacterium] | diamond | 486 | 94.7 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 21276411 | 21276411 | PRJNA900028_P_NODE_122497_length_167_cov_0.864407_g121748_i0 | PRJNA900028 | 122497 | 167 | 0.864407 | 1.44355969 | Abditibacterium utsteinense | 1960156 | Bacteria | Bacteria | 87.8 | 1.54e-18 | NR | WP_106380991.1 | 1960156 | g121748 | i0 | 67.3 | 2.94610778443114 | 55 | 18 | 98.8 | 0 | 1 | 165 | 257 | 311 | WP_106380991.1 S41 family peptidase [Abditibacterium utsteinense] | diamond | 492 | 87.8 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium utsteinense | ||
| 26675616 | 26675616 | PRJNA900028_P_NODE_163121_length_164_cov_0.886957_g162372_i0 | PRJNA900028 | 163121 | 164 | 0.886957 | 1.45460948 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 68.2 | 5.62e-12 | NR | HEX8465952.1 | 2109264 | g162372 | i0 | 61.1 | 0.98780487804878 | 54 | 21 | 98.8 | 0 | 162 | 1 | 163 | 216 | HEX8465952.1 MBL fold metallo-hydrolase [Abditibacterium sp.] | diamond | 162 | 68.2 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 27435237 | 27435237 | PRJNA900028_P_NODE_105423_length_173_cov_1.637097_g104674_i0 | PRJNA900028 | 105423 | 173 | 1.637097 | 2.83217781 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 70.1 | 2.84e-12 | NR | BCM91277.1 | 2783868 | g104674 | i0 | 76.7 | 0.745664739884393 | 43 | 10 | 74.6 | 0 | 132 | 4 | 33 | 75 | BCM91277.1 hypothetical protein IAD21_03143 [Abditibacteriota bacterium] | diamond | 129 | 70.1 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 27561125 | 27561125 | PRJNA900028_P_NODE_75384_length_187_cov_1.268116_g74635_i0 | PRJNA900028 | 75384 | 187 | 1.268116 | 2.37137692 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 95.5 | 3.59e-23 | NR | BCM88848.1 | 2783868 | g74635 | i0 | 76.7 | 0.962566844919786 | 60 | 14 | 96.3 | 0 | 6 | 185 | 34 | 93 | BCM88848.1 hypothetical protein IAD21_00690 [Abditibacteriota bacterium] | diamond | 180 | 95.5 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 27600728 | 27600728 | PRJNA900028_P_NODE_83364_length_183_cov_1.522388_g82615_i0 | PRJNA900028 | 83364 | 183 | 1.522388 | 2.78597004 | Bacteria | 2 | Bacteria | Bacteria | 51.6 | 9.64e-7 | NR | MBV9471232.1 | 2800791 | g82615 | i0 | 45.3 | 3.50819672131148 | 53 | 29 | 86.9 | 0 | 159 | 1 | 8 | 60 | MBV9471232.1 response regulator [Abditibacteriaceae bacterium] | diamond | 642 | 51.6 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 27656227 | 27656227 | PRJNA900028_P_NODE_90064_length_180_cov_1.557252_g89315_i0 | PRJNA900028 | 90064 | 180 | 1.557252 | 2.8030536 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 99 | 2.5000000000000002e-22 | NR | HEX8235601.1 | 2800791 | g89315 | i0 | 71.2 | 0.983333333333333 | 59 | 17 | 98.3 | 0 | 3 | 179 | 328 | 386 | HEX8235601.1 glutamate synthase large subunit [Abditibacteriaceae bacterium] | diamond | 177 | 99 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 27688022 | 27688022 | PRJNA900028_P_NODE_75164_length_187_cov_1.427536_g74415_i0 | PRJNA900028 | 75164 | 187 | 1.427536 | 2.66949232 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 96.7 | 1.58e-21 | NR | BCM92284.1 | 2783868 | g74415 | i0 | 71 | 0.994652406417112 | 62 | 18 | 99.5 | 0 | 2 | 187 | 177 | 238 | BCM92284.1 sodium, potassium, lithium and rubidium/H(+) antiporter [Abditibacteriota bacterium] | diamond | 186 | 96.7 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 27845289 | 27845289 | PRJNA900028_P_NODE_106944_length_172_cov_1.658537_g106195_i0 | PRJNA900028 | 106944 | 172 | 1.658537 | 2.85268364 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 85.9 | 9.05e-18 | NR | HEX8464872.1 | 2109264 | g106195 | i0 | 65.1 | 1.09883720930233 | 63 | 16 | 99.4 | 1 | 2 | 172 | 164 | 226 | HEX8464872.1 CRTAC1 family protein [Abditibacterium sp.] | diamond | 189 | 85.9 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 28003543 | 28003543 | PRJNA900028_P_NODE_125005_length_167_cov_0.864407_g124256_i0 | PRJNA900028 | 125005 | 167 | 0.864407 | 1.44355969 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 64.3 | 1.88e-10 | NR | HEX8465068.1 | 2109264 | g124256 | i0 | 60 | 0.898203592814371 | 50 | 20 | 89.8 | 0 | 152 | 3 | 34 | 83 | HEX8465068.1 ankyrin repeat domain-containing protein [Abditibacterium sp.] | diamond | 150 | 64.3 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 28319065 | 28319065 | PRJNA900028_P_NODE_68106_length_190_cov_1.446809_g67357_i0 | PRJNA900028 | 68106 | 190 | 1.446809 | 2.7489371 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 66.2 | 3.89e-11 | NR | HEX9998806.1 | 2109264 | g67357 | i0 | 51.6 | 0.978947368421053 | 62 | 20 | 97.9 | 1 | 4 | 189 | 127 | 178 | HEX9998806.1 Sir2 family NAD-dependent protein deacetylase [Abditibacterium sp.] | diamond | 186 | 66.2 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 29305433 | 29305433 | PRJNA900028_P_NODE_138809_length_166_cov_0.871795_g138060_i0 | PRJNA900028 | 138809 | 166 | 0.871795 | 1.4471797 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 79.3 | 1.64e-15 | NR | BCM92284.1 | 2783868 | g138060 | i0 | 76.9 | 2.81927710843373 | 52 | 12 | 94 | 0 | 11 | 166 | 1 | 52 | BCM92284.1 sodium, potassium, lithium and rubidium/H(+) antiporter [Abditibacteriota bacterium] | diamond | 468 | 79.3 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 29361060 | 29361060 | PRJNA900028_P_NODE_125309_length_167_cov_0.864407_g124560_i0 | PRJNA900028 | 125309 | 167 | 0.864407 | 1.44355969 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 114 | 1.05e-29 | NR | HEX8465271.1 | 2109264 | g124560 | i0 | 92.7 | 0.988023952095808 | 55 | 4 | 98.8 | 0 | 165 | 1 | 140 | 194 | HEX8465271.1 DUF444 family protein [Abditibacterium sp.] | diamond | 165 | 114 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 29992690 | 29992690 | PRJNA900028_P_NODE_74511_length_187_cov_1.478261_g73762_i0 | PRJNA900028 | 74511 | 187 | 1.478261 | 2.76434807 | Abditibacterium utsteinense | 1960156 | Bacteria | Bacteria | 96.7 | 2.0299999999999998e-23 | NR | WP_105482445.1 | 1960156 | g73762 | i0 | 63.5 | 1.01069518716578 | 63 | 22 | 99.5 | 1 | 186 | 1 | 107 | 169 | WP_105482445.1 transposase [Abditibacterium utsteinense] | diamond | 189 | 96.7 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium utsteinense | ||
| 30719224 | 30719224 | PRJNA900028_P_NODE_92014_length_179_cov_1.569231_g91265_i0 | PRJNA900028 | 92014 | 179 | 1.569231 | 2.80892349 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 95.1 | 5.47e-21 | NR | MDF2439798.1 | 2783868 | g91265 | i0 | 74.2 | 1.0391061452514 | 62 | 13 | 98.9 | 1 | 1 | 177 | 345 | 406 | MDF2439798.1 cell division protein FtsA [Abditibacteriota bacterium] | diamond | 186 | 95.1 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 30972155 | 30972155 | PRJNA900028_P_NODE_132434_length_166_cov_0.871795_g131685_i0 | PRJNA900028 | 132434 | 166 | 0.871795 | 1.4471797 | Abditibacterium utsteinense | 1960156 | Bacteria | Bacteria | 92 | 5.71e-20 | NR | WP_105483252.1 | 1960156 | g131685 | i0 | 78.2 | 1.98795180722892 | 55 | 12 | 99.4 | 0 | 1 | 165 | 1062 | 1116 | WP_105483252.1 alpha-2-macroglobulin family protein [Abditibacterium utsteinense] | diamond | 330 | 92 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium utsteinense | ||
| 31035558 | 31035558 | PRJNA900028_P_NODE_196615_length_161_cov_0.910714_g195866_i0 | PRJNA900028 | 196615 | 161 | 0.910714 | 1.46624954 | Abditibacterium sp. | 2109264 | Bacteria | Bacteria | 104 | 1.64e-25 | NR | HEX8463648.1 | 2109264 | g195866 | i0 | 100 | 0.987577639751553 | 53 | 0 | 98.8 | 0 | 1 | 159 | 88 | 140 | HEX8463648.1 AEC family transporter [Abditibacterium sp.] | diamond | 159 | 104 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacterium | Abditibacterium sp. | ||
| 31857319 | 31857319 | PRJNA900028_P_NODE_152657_length_164_cov_1.773913_g151908_i0 | PRJNA900028 | 152657 | 164 | 1.773913 | 2.90921732 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 64.7 | 2.18e-11 | NR | HEX8834145.1 | 2800791 | g151908 | i0 | 58.8 | 1.92073170731707 | 51 | 21 | 93.3 | 0 | 155 | 3 | 43 | 93 | HEX8834145.1 hypothetical protein [Abditibacteriaceae bacterium] | diamond | 315 | 64.7 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriia | Abditibacteriales | Abditibacteriaceae | Abditibacteriaceae bacterium | |||
| 32742622 | 32742622 | PRJNA900028_P_NODE_101020_length_175_cov_1.619048_g100271_i0 | PRJNA900028 | 101020 | 175 | 1.619048 | 2.833334 | Abditibacteriota bacterium | 2783868 | Bacteria | Bacteria | 70.1 | 2.38e-12 | NR | MDF2440561.1 | 2783868 | g100271 | i0 | 55.6 | 1.08 | 63 | 22 | 97.7 | 1 | 173 | 3 | 71 | 133 | MDF2440561.1 gluconolactonase [Abditibacteriota bacterium] | diamond | 189 | 70.1 | 1 | Bacteria | Pseudomonadati | Abditibacteriota | Abditibacteriota bacterium | ||||||
| 32836866 | 32836866 | PRJNA900028_P_NODE_101600_length_175_cov_1.277778_g100851_i0 | PRJNA900028 | 101600 | 175 | 1.277778 | 2.2361115 | Abditibacteriaceae bacterium | 2800791 | Bacteria | Bacteria | 48.9 | 2.27e-5 | NR | HEX8236307.1 | 2800791 | g100851 | i0 | 83.3 | 0.411428571428571 | 24 | 3 | 41.1 | 1 | 2 | 73 | 97 | 119 | HEX8236307.1 hypothetical protein [Abditibacteriaceae bacterium] | diamond | 72 | 48.9 | 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);;