contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA688655" and tax_phylum = "Candidatus Aminicenantota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26702221 | 26702221 | PRJNA688655_P_NODE_16661_length_241_cov_0.916667_g16596_i0 | PRJNA688655 | 16661 | 241 | 0.916667 | 2.20916747 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 122 | 4.7399999999999994e-30 | NR | MCK4646082.1 | 2052149 | g16596 | i0 | 72.5 | 1.99170124481328 | 80 | 22 | 99.6 | 0 | 1 | 240 | 642 | 721 | MCK4646082.1 hypothetical protein [Candidatus Aminicenantes bacterium] | diamond | 480 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 26924116 | 26924116 | PRJNA688655_P_NODE_1702_length_425_cov_0.875000_g1637_i0 | PRJNA688655 | 1702 | 425 | 0.875 | 3.71875 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 269 | 4.7200000000000004e-86 | NR | HNX42244.1 | 2052149 | g1637 | i0 | 99.3 | 0.995294117647059 | 141 | 1 | 99.5 | 0 | 1 | 423 | 295 | 435 | HNX42244.1 amino acid permease [Candidatus Aminicenantes bacterium] | diamond | 423 | 269 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 27208475 | 27208475 | PRJNA688655_P_NODE_15642_length_242_cov_0.911243_g15577_i0 | PRJNA688655 | 15642 | 242 | 0.911243 | 2.20520806 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 156 | 3.389999999999999e-42 | NR | HNX41020.1 | 2052149 | g15577 | i0 | 96.3 | 0.991735537190083 | 80 | 3 | 99.2 | 0 | 241 | 2 | 59 | 138 | HNX41020.1 ABC transporter permease subunit [Candidatus Aminicenantes bacterium] | diamond | 240 | 156 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 27220002 | 27220002 | PRJNA688655_P_NODE_13062_length_245_cov_0.895349_g12997_i0 | PRJNA688655 | 13062 | 245 | 0.895349 | 2.19360505 | root | 1 | Root_unresolved | Root_unresolved | 71.6 | 1.5e-12 | NR | UCH97810.1 | 2052149 | g12997 | i0 | 56.3 | 1.61632653061224 | 64 | 28 | 78.4 | 0 | 241 | 50 | 60 | 123 | UCH97810.1 MAG: hypothetical protein JSV88_13415, partial [Candidatus Aminicenantes bacterium] | diamond | 396 | 71.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 27367007 | 27367007 | PRJNA688655_P_NODE_3643_length_326_cov_1.035573_g3578_i0 | PRJNA688655 | 3643 | 326 | 1.035573 | 3.37596798 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 197 | 1.55e-59 | NR | HNX41577.1 | 2052149 | g3578 | i0 | 98.1 | 0.993865030674847 | 108 | 2 | 99.4 | 0 | 324 | 1 | 229 | 336 | HNX41577.1 MATE family efflux transporter [Candidatus Aminicenantes bacterium] | diamond | 324 | 197 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 28314036 | 28314036 | PRJNA688655_P_NODE_14886_length_243_cov_0.905882_g14821_i0 | PRJNA688655 | 14886 | 243 | 0.905882 | 2.20129326 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 91.7 | 2.25e-19 | NR | MCX6579816.1 | 2052149 | g14821 | i0 | 65.4 | 0.962962962962963 | 78 | 25 | 93.8 | 1 | 14 | 241 | 334 | 411 | MCX6579816.1 SNF2-related protein [Candidatus Aminicenantes bacterium] | diamond | 234 | 91.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 28471947 | 28471947 | PRJNA688655_P_NODE_10706_length_248_cov_0.880000_g10641_i0 | PRJNA688655 | 10706 | 248 | 0.88 | 2.1824 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 142 | 1.73e-38 | NR | HNX42382.1 | 2052149 | g10641 | i0 | 100 | 0.786290322580645 | 65 | 0 | 78.6 | 0 | 52 | 246 | 1 | 65 | HNX42382.1 replication-associated recombination protein A [Candidatus Aminicenantes bacterium] | diamond | 195 | 142 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 29008931 | 29008931 | PRJNA688655_P_NODE_10108_length_248_cov_0.880000_g10043_i0 | PRJNA688655 | 10108 | 248 | 0.88 | 2.1824 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 85.1 | 8.43e-18 | NR | MBM3296053.1 | 2052149 | g10043 | i0 | 56.3 | 0.967741935483871 | 80 | 34 | 95.6 | 1 | 12 | 248 | 111 | 190 | MBM3296053.1 phosphatase PAP2 family protein [Candidatus Aminicenantes bacterium] | diamond | 240 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 29008944 | 29008944 | PRJNA688655_P_NODE_15628_length_242_cov_0.911243_g15563_i0 | PRJNA688655 | 15628 | 242 | 0.911243 | 2.20520806 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 105 | 1.36e-24 | NR | NIM91136.1 | 2052149 | g15563 | i0 | 58.2 | 0.979338842975207 | 79 | 33 | 97.9 | 0 | 238 | 2 | 296 | 374 | NIM91136.1 serine hydrolase [Candidatus Aminicenantes bacterium] | diamond | 237 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 29545234 | 29545234 | PRJNA688655_P_NODE_8550_length_250_cov_0.870056_g8485_i0 | PRJNA688655 | 8550 | 250 | 0.870056 | 2.17514 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 149 | 1.03e-39 | NR | MCX6573970.1 | 2052149 | g8485 | i0 | 92.8 | 0.996 | 83 | 6 | 99.6 | 0 | 250 | 2 | 481 | 563 | MCX6573970.1 ATP-dependent DNA helicase [Candidatus Aminicenantes bacterium] | diamond | 249 | 149 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 29746092 | 29746092 | PRJNA688655_P_NODE_8670_length_250_cov_0.870056_g8605_i0 | PRJNA688655 | 8670 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 115 | 1.34e-27 | NR | OQX53096.1 | 1968529 | g8605 | i0 | 63.9 | 5.964 | 83 | 30 | 99.6 | 0 | 249 | 1 | 226 | 308 | OQX53096.1 MAG: peptidase M3, partial [Candidatus Aminicenantes bacterium 4484_214] | diamond | 1491 | 115 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium 4484_214 | ||||||
| 30113754 | 30113754 | PRJNA688655_P_NODE_12992_length_245_cov_0.895349_g12927_i0 | PRJNA688655 | 12992 | 245 | 0.895349 | 2.19360505 | Candidatus Aminicenantes bacterium ADurb.Bin5 | 2052149 | Bacteria | Bacteria | 155 | 5.38e-44 | NR | OPZ59925.1 | 1852832 | g12927 | i0 | 91.3 | 0.979591836734694 | 80 | 7 | 98 | 0 | 5 | 244 | 174 | 253 | OPZ59925.1 MAG: Nudix hydrolase [Candidatus Aminicenantes bacterium ADurb.Bin508] | diamond | 240 | 155 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium ADurb.Bin508 | ||||||
| 30335428 | 30335428 | PRJNA688655_P_NODE_16792_length_241_cov_0.880952_g16727_i0 | PRJNA688655 | 16792 | 241 | 0.880952 | 2.12309432 | Candidatus Aminicenantes bacterium ADurb.Bin147 | 1852831 | Bacteria | Bacteria | 156 | 8.319999999999999e-45 | NR | OQB58176.1 | 1852831 | g16727 | i0 | 96.3 | 0.995850622406639 | 80 | 2 | 99.6 | 1 | 2 | 241 | 6 | 84 | OQB58176.1 MAG: hypothetical protein BWX98_00910 [Candidatus Aminicenantes bacterium ADurb.Bin147] | diamond | 240 | 156 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium ADurb.Bin147 | ||||||
| 30714108 | 30714108 | PRJNA688655_P_NODE_11094_length_247_cov_0.885057_g11029_i0 | PRJNA688655 | 11094 | 247 | 0.885057 | 2.18609079 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 109 | 8.41e-26 | NR | MBP1769929.1 | 2052149 | g11029 | i0 | 81.3 | 0.910931174089069 | 75 | 13 | 91.1 | 1 | 22 | 246 | 306 | 379 | MBP1769929.1 type and secretion system protein [Candidatus Aminicenantes bacterium] | diamond | 225 | 109 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 31124513 | 31124513 | PRJNA688655_P_NODE_11315_length_247_cov_0.885057_g11250_i0 | PRJNA688655 | 11315 | 247 | 0.885057 | 2.18609079 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 131 | 4.26e-34 | NR | MCX6564331.1 | 2052149 | g11250 | i0 | 79.3 | 0.995951417004049 | 82 | 17 | 99.6 | 0 | 1 | 246 | 368 | 449 | MCX6564331.1 cation-efflux pump [Candidatus Aminicenantes bacterium] | diamond | 246 | 131 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 31124514 | 31124514 | PRJNA688655_P_NODE_11515_length_247_cov_0.885057_g11450_i0 | PRJNA688655 | 11515 | 247 | 0.885057 | 2.18609079 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 163 | 4.359999999999999e-47 | NR | HNX41932.1 | 2052149 | g11450 | i0 | 93.8 | 1.94331983805668 | 81 | 5 | 98.4 | 0 | 3 | 245 | 96 | 176 | HNX41932.1 N-acetyltransferase [Candidatus Aminicenantes bacterium] | diamond | 480 | 163 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 31389566 | 31389566 | PRJNA688655_P_NODE_14456_length_243_cov_0.905882_g14391_i0 | PRJNA688655 | 14456 | 243 | 0.905882 | 2.20129326 | Bacteria | 2 | Bacteria | Bacteria | 57.4 | 2.54e-7 | NR | MCJ7581339.1 | 2052149 | g14391 | i0 | 64.3 | 2.07407407407407 | 42 | 15 | 51.9 | 0 | 3 | 128 | 765 | 806 | MCJ7581339.1 ABC transporter permease [Candidatus Aminicenantes bacterium] | diamond | 504 | 57.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 31452816 | 31452816 | PRJNA688655_P_NODE_10176_length_248_cov_0.880000_g10111_i0 | PRJNA688655 | 10176 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 157 | 4.12e-46 | NR | OPZ60061.1 | 1852832 | g10111 | i0 | 98.8 | 1.98387096774194 | 82 | 1 | 99.2 | 0 | 247 | 2 | 129 | 210 | OPZ60061.1 MAG: Chemotaxis protein methyltransferase [Candidatus Aminicenantes bacterium ADurb.Bin508] | diamond | 492 | 157 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium ADurb.Bin508 |
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);;