contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax_phylum = "Candidatus Absconditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9459361 | 9459361 | PRJNA556992_P_NODE_608908_length_258_cov_2.200000_g606719_i0 | PRJNA556992 | 608908 | 258 | 2.2 | 5.676 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 110 | 3.35e-28 | NR | MFA6256485.1 | 2927939 | g606719 | i0 | 62.1 | 1.01162790697674 | 87 | 32 | 100 | 1 | 258 | 1 | 15 | 101 | MFA6256485.1 class II glutamine amidotransferase [Candidatus Absconditabacterales bacterium] | diamond | 261 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 14562526 | 14562526 | PRJNA556992_P_NODE_831872_length_244_cov_2.280702_g829682_i0 | PRJNA556992 | 831872 | 244 | 2.280702 | 5.56491288 | candidate division SR1 bacterium Aalborg_AAW-1 | 1643353 | Bacteria | Bacteria | 69.3 | 1.89e-12 | NR | AKH32733.1 | 1643353 | g829682 | i0 | 67.4 | 0.528688524590164 | 43 | 14 | 52.9 | 0 | 244 | 116 | 73 | 115 | AKH32733.1 hypothetical protein XF24_00393 [candidate division SR1 bacterium Aalborg_AAW-1] | diamond | 129 | 69.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium Aalborg_AAW-1 | ||||||
| 27583753 | 27583753 | PRJNA556992_P_NODE_1078984_length_217_cov_10.548611_g1076793_i0 | PRJNA556992 | 1078984 | 217 | 10.548611 | 22.89048587 | candidate division SR1 bacterium Aalborg_AAW-1 | 1643353 | Bacteria | Bacteria | 83.2 | 5.21e-18 | NR | AKH32899.1 | 1643353 | g1076793 | i0 | 56.3 | 0.981566820276498 | 71 | 30 | 96.8 | 1 | 7 | 216 | 32 | 102 | AKH32899.1 hypothetical protein XF24_00570 [candidate division SR1 bacterium Aalborg_AAW-1] | diamond | 213 | 83.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium Aalborg_AAW-1 | ||||||
| 28594317 | 28594317 | PRJNA556992_P_NODE_1118227_length_208_cov_7.607407_g1116036_i0 | PRJNA556992 | 1118227 | 208 | 7.607407 | 15.82340656 | candidate division SR1 bacterium Aalborg_AAW-1 | 1643353 | Bacteria | Bacteria | 60.8 | 5.26e-9 | NR | AKH33146.1 | 1643353 | g1116036 | i0 | 52.8 | 0.764423076923077 | 53 | 25 | 76.4 | 0 | 163 | 5 | 120 | 172 | AKH33146.1 Methane monooxygenase component C [candidate division SR1 bacterium Aalborg_AAW-1] | diamond | 159 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium Aalborg_AAW-1 | ||||||
| 28942011 | 28942011 | PRJNA556992_P_NODE_483268_length_268_cov_10.651282_g481079_i0 | PRJNA556992 | 483268 | 268 | 10.651282 | 28.54543576 | Candidatus Absconditicoccus praedator | 2735562 | Bacteria | Bacteria | 83.6 | 2.07e-16 | NR | WP_231180564.1 | 2735562 | g481079 | i0 | 58.2 | 1.51119402985075 | 67 | 28 | 75 | 0 | 63 | 263 | 367 | 433 | WP_231180564.1 hypothetical protein [Candidatus Absconditicoccus praedator] | diamond | 405 | 83.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditicoccaceae | Candidatus Absconditicoccus | Candidatus Absconditicoccus praedator | |||
| 28973195 | 28973195 | PRJNA556992_P_NODE_1074868_length_218_cov_10.151724_g1072677_i0 | PRJNA556992 | 1074868 | 218 | 10.151724 | 22.13075832 | candidate division SR1 bacterium Aalborg_AAW-1 | 1643353 | Bacteria | Bacteria | 78.6 | 6.4e-15 | NR | AKH33020.1 | 1643353 | g1072677 | i0 | 54.8 | 1.0045871559633 | 73 | 31 | 99.1 | 2 | 3 | 218 | 36 | 107 | AKH33020.1 hypothetical protein XF24_00694 [candidate division SR1 bacterium Aalborg_AAW-1] | diamond | 219 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium Aalborg_AAW-1 | ||||||
| 29889297 | 29889297 | PRJNA556992_P_NODE_78251_length_437_cov_10.843407_g76072_i0 | PRJNA556992 | 78251 | 437 | 10.843407 | 47.38568859 | SR1 bacterium human oral taxon HOT-345 | 1540874 | Bacteria | Bacteria | 116 | 7.22e-28 | NR | RAL57243.1 | 1540874 | g76072 | i0 | 43.9 | 2.97254004576659 | 148 | 75 | 98.2 | 4 | 9 | 437 | 178 | 322 | RAL57243.1 hypothetical protein BSK20_03130 [SR1 bacterium human oral taxon HOT-345] | diamond | 1299 | 116 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | SR1 bacterium human oral taxon HOT-345 | ||||||
| 30299935 | 30299935 | PRJNA556992_P_NODE_1085572_length_216_cov_5.020979_g1083381_i0 | PRJNA556992 | 1085572 | 216 | 5.020979 | 10.84531464 | candidate division SR1 bacterium Aalborg_AAW-1 | 1643353 | Bacteria | Bacteria | 75.5 | 1.64e-14 | NR | AKH32388.1 | 1643353 | g1083381 | i0 | 52.9 | 0.972222222222222 | 70 | 33 | 97.2 | 0 | 2 | 211 | 104 | 173 | AKH32388.1 Protein YceI [candidate division SR1 bacterium Aalborg_AAW-1] | diamond | 210 | 75.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium Aalborg_AAW-1 | ||||||
| 31058478 | 31058478 | PRJNA556992_P_NODE_709775_length_250_cov_5.745763_g707586_i0 | PRJNA556992 | 709775 | 250 | 5.745763 | 14.3644075 | Candidatus Absconditabacteria bacterium | 3018262 | Bacteria | Bacteria | 52 | 1.07e-5 | NR | MEF2175655.1 | 3018262 | g707586 | i0 | 40.6 | 0.828 | 69 | 38 | 79.2 | 1 | 36 | 233 | 1 | 69 | MEF2175655.1 hypothetical protein [Candidatus Absconditabacteria bacterium] | diamond | 207 | 52 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacteria bacterium | ||||||
| 31374390 | 31374390 | PRJNA556992_P_NODE_709216_length_250_cov_7.587571_g707027_i0 | PRJNA556992 | 709216 | 250 | 7.587571 | 18.9689275 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 144 | 2.3e-39 | NR | HMS90950.1 | 2927939 | g707027 | i0 | 82.9 | 0.984 | 82 | 14 | 98.4 | 0 | 250 | 5 | 8 | 89 | HMS90950.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 246 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 31500775 | 31500775 | PRJNA556992_P_NODE_40616_length_556_cov_2.755694_g38473_i0 | PRJNA556992 | 40616 | 556 | 2.755694 | 15.32165864 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 110 | 6.699999999999999e-26 | NR | HMS90907.1 | 2927939 | g38473 | i0 | 50.5 | 0.588129496402878 | 109 | 53 | 58.3 | 1 | 548 | 225 | 141 | 249 | HMS90907.1 HNH endonuclease signature motif containing protein [Candidatus Absconditabacterales bacterium] | diamond | 327 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 31595762 | 31595762 | PRJNA556992_P_NODE_443776_length_272_cov_2.402010_g441587_i0 | PRJNA556992 | 443776 | 272 | 2.40201 | 6.5334672 | candidate division SR1 bacterium RAAC1_SR1_1 | 1394709 | Bacteria | Bacteria | 47.4 | 0.00119 | NR | AHB41182.1 | 1394709 | g441587 | i0 | 41.8 | 0.738970588235294 | 67 | 37 | 71.7 | 1 | 248 | 54 | 225 | 291 | AHB41182.1 F-box associated region protein [candidate division SR1 bacterium RAAC1_SR1_1] | diamond | 201 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium RAAC1_SR1_1 | ||||||
| 31880276 | 31880276 | PRJNA556992_P_NODE_941157_length_236_cov_5.343558_g938967_i0 | PRJNA556992 | 941157 | 236 | 5.343558 | 12.61079688 | Candidatus Absconditabacterales bacterium | 2927939 | Bacteria | Bacteria | 108 | 1.6e-27 | NR | HMY80265.1 | 2927939 | g938967 | i0 | 68.4 | 1.86864406779661 | 76 | 24 | 96.6 | 0 | 2 | 229 | 47 | 122 | HMY80265.1 hypothetical protein [Candidatus Absconditabacterales bacterium] | diamond | 441 | 108 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditabacterales bacterium | |||||
| 32418191 | 32418191 | PRJNA556992_P_NODE_453519_length_271_cov_2.747475_g451330_i0 | PRJNA556992 | 453519 | 271 | 2.747475 | 7.44565725 | Candidatus Vampirococcus lugosii | 2789015 | Bacteria | Bacteria | 58.2 | 2.06e-7 | NR | WP_213348134.1 | 2789015 | g451330 | i0 | 34.1 | 0.940959409594096 | 85 | 55 | 93 | 1 | 265 | 14 | 2124 | 2208 | WP_213348134.1 Ig-like domain-containing alpha-2-macroglobulin family protein [Candidatus Vampirococcus lugosii] | diamond | 255 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Vampirococcus | Candidatus Vampirococcus lugosii |
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);;