contig_metadata
24 rows where bioproject = "PRJNA688352", tax_clade = "PVC group" and tax_phylum = "Kiritimatiellota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 666929 | 666929 | PRJNA688352_P_NODE_9581_length_246_cov_0.890173_g9478_i0 | PRJNA688352 | 9581 | 246 | 0.890173 | 2.18982558 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 165 | 4.459999999999999e-47 | NR | MBQ6009645.1 | 2212473 | g9478 | i0 | 95 | 0.975609756097561 | 80 | 4 | 97.6 | 0 | 2 | 241 | 229 | 308 | MBQ6009645.1 ATP-binding protein [Kiritimatiellia bacterium] | diamond | 240 | 165 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 13420806 | 13420806 | PRJNA688352_P_NODE_11111_length_243_cov_0.905882_g11008_i0 | PRJNA688352 | 11111 | 243 | 0.905882 | 2.20129326 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 145 | 1.7499999999999999e-40 | NR | MBO4448237.1 | 2212473 | g11008 | i0 | 85 | 16.4074074074074 | 80 | 12 | 98.8 | 0 | 242 | 3 | 3 | 82 | MBO4448237.1 tRNA glutamyl-Q(34) synthetase GluQRS [Kiritimatiellia bacterium] | diamond | 3987 | 145 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 26765766 | 26765766 | PRJNA688352_P_NODE_9041_length_247_cov_0.885057_g8938_i0 | PRJNA688352 | 9041 | 247 | 0.885057 | 2.18609079 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 69.7 | 1.27e-11 | NR | MBN1673103.1 | 2212473 | g8938 | i0 | 51.9 | 0.983805668016194 | 81 | 37 | 98.4 | 2 | 2 | 244 | 403 | 481 | MBN1673103.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 243 | 69.7 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 26924100 | 26924100 | PRJNA688352_P_NODE_9722_length_246_cov_0.890173_g9619_i0 | PRJNA688352 | 9722 | 246 | 0.890173 | 2.18982558 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 69.3 | 5.19e-12 | NR | HMP97524.1 | 2212473 | g9619 | i0 | 44.3 | 1.92682926829268 | 79 | 44 | 96.3 | 0 | 239 | 3 | 105 | 183 | HMP97524.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 474 | 69.3 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27303636 | 27303636 | PRJNA688352_P_NODE_9083_length_247_cov_0.885057_g8980_i0 | PRJNA688352 | 9083 | 247 | 0.885057 | 2.18609079 | Candidatus Colisoma equi | 3083071 | Bacteria | Bacteria | 107 | 2.86e-25 | NR | MBQ0033356.1 | 3083071 | g8980 | i0 | 80.3 | 0.801619433198381 | 66 | 13 | 80.2 | 0 | 49 | 246 | 1 | 66 | MBQ0033356.1 chloride channel protein [Candidatus Colisoma equi] | diamond | 198 | 107 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Candidatus Colisoma | Candidatus Colisoma equi | |||
| 27303637 | 27303637 | PRJNA688352_P_NODE_9323_length_247_cov_0.885057_g9220_i0 | PRJNA688352 | 9323 | 247 | 0.885057 | 2.18609079 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 96.3 | 3.82e-22 | NR | MBQ3289140.1 | 2212473 | g9220 | i0 | 67.5 | 1.94331983805668 | 80 | 25 | 97.2 | 1 | 1 | 240 | 5 | 83 | MBQ3289140.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 480 | 96.3 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27840135 | 27840135 | PRJNA688352_P_NODE_9724_length_246_cov_0.890173_g9621_i0 | PRJNA688352 | 9724 | 246 | 0.890173 | 2.18982558 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 140 | 1.9199999999999999e-38 | NR | MDZ4199312.1 | 2212473 | g9621 | i0 | 79 | 0.98780487804878 | 81 | 17 | 98.8 | 0 | 1 | 243 | 239 | 319 | MDZ4199312.1 GTPase ObgE [Kiritimatiellia bacterium] | diamond | 243 | 140 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28092906 | 28092906 | PRJNA688352_P_NODE_12085_length_241_cov_0.916667_g11982_i0 | PRJNA688352 | 12085 | 241 | 0.916667 | 2.20916747 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 92 | 2.7900000000000003e-22 | NR | MFA7157874.1 | 2212473 | g11982 | i0 | 100 | 0.572614107883817 | 46 | 0 | 57.3 | 0 | 240 | 103 | 43 | 88 | MFA7157874.1 transposase [Kiritimatiellia bacterium] | diamond | 138 | 92 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28156296 | 28156296 | PRJNA688352_P_NODE_9385_length_247_cov_0.885057_g9282_i0 | PRJNA688352 | 9385 | 247 | 0.885057 | 2.18609079 | Kiritimatiellales bacterium | 2202731 | Bacteria | Bacteria | 141 | 4.83e-37 | NR | MCF7864735.1 | 2202731 | g9282 | i0 | 77.8 | 3.93522267206478 | 81 | 18 | 98.4 | 0 | 3 | 245 | 564 | 644 | MCF7864735.1 hypothetical protein [Kiritimatiellales bacterium] | diamond | 972 | 141 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellales | Kiritimatiellales bacterium | |||
| 29292702 | 29292702 | PRJNA688352_P_NODE_12429_length_241_cov_0.916667_g12326_i0 | PRJNA688352 | 12429 | 241 | 0.916667 | 2.20916747 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 102 | 1.55e-23 | NR | HPF99238.1 | 2212473 | g12326 | i0 | 58.8 | 1.9792531120332 | 80 | 33 | 99.6 | 0 | 1 | 240 | 49 | 128 | HPF99238.1 Na(+)-translocating NADH-quinone reductase subunit A [Kiritimatiellia bacterium] | diamond | 477 | 102 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29829449 | 29829449 | PRJNA688352_P_NODE_7271_length_251_cov_0.865169_g7168_i0 | PRJNA688352 | 7271 | 251 | 0.865169 | 2.17157419 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 96.3 | 1.5600000000000002e-21 | NR | MBR2488350.1 | 2212473 | g7168 | i0 | 67.1 | 0.836653386454183 | 70 | 23 | 83.7 | 0 | 40 | 249 | 1 | 70 | MBR2488350.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 210 | 96.3 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30315473 | 30315473 | PRJNA688352_P_NODE_10432_length_245_cov_0.889535_g10329_i0 | PRJNA688352 | 10432 | 245 | 0.889535 | 2.17936075 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 138 | 2.5699999999999996e-37 | NR | MCX7006498.1 | 2599938 | g10329 | i0 | 75.3 | 6.96734693877551 | 81 | 20 | 99.2 | 0 | 245 | 3 | 126 | 206 | MCX7006498.1 alpha-L-fucosidase [Kiritimatiellota bacterium] | diamond | 1707 | 138 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellota bacterium | |||||
| 30398690 | 30398690 | PRJNA688352_P_NODE_9893_length_246_cov_0.890173_g9790_i0 | PRJNA688352 | 9893 | 246 | 0.890173 | 2.18982558 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 84 | 9.2e-17 | NR | HPF99134.1 | 2212473 | g9790 | i0 | 64.2 | 0.98780487804878 | 81 | 26 | 97.6 | 2 | 3 | 242 | 340 | 418 | HPF99134.1 S41 family peptidase [Kiritimatiellia bacterium] | diamond | 243 | 84 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30461821 | 30461821 | PRJNA688352_P_NODE_12513_length_241_cov_0.916667_g12410_i0 | PRJNA688352 | 12513 | 241 | 0.916667 | 2.20916747 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 127 | 1.38e-32 | NR | MBP7830689.1 | 2212473 | g12410 | i0 | 78.2 | 0.970954356846473 | 78 | 17 | 97.1 | 0 | 240 | 7 | 339 | 416 | MBP7830689.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 234 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30650702 | 30650702 | PRJNA688352_P_NODE_10673_length_244_cov_0.900585_g10570_i0 | PRJNA688352 | 10673 | 244 | 0.900585 | 2.1974274 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 114 | 1.48e-27 | NR | MDD4024628.1 | 2212473 | g10570 | i0 | 68.8 | 0.983606557377049 | 80 | 24 | 98.4 | 1 | 242 | 3 | 42 | 120 | MDD4024628.1 metallophosphoesterase [Kiritimatiellia bacterium] | diamond | 240 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31282846 | 31282846 | PRJNA688352_P_NODE_10255_length_245_cov_0.895349_g10152_i0 | PRJNA688352 | 10255 | 245 | 0.895349 | 2.19360505 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 52 | 2.13e-5 | NR | MDD5706579.1 | 2212473 | g10152 | i0 | 40.4 | 0.697959183673469 | 57 | 34 | 69.8 | 0 | 173 | 3 | 21 | 77 | MDD5706579.1 LamG domain-containing protein [Kiritimatiellia bacterium] | diamond | 171 | 52 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31567851 | 31567851 | PRJNA688352_P_NODE_10536_length_244_cov_0.900585_g10433_i0 | PRJNA688352 | 10536 | 244 | 0.900585 | 2.1974274 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 69.7 | 1.04e-11 | NR | MBO7721978.1 | 2212473 | g10433 | i0 | 48.1 | 0.971311475409836 | 79 | 40 | 97.1 | 1 | 237 | 1 | 100 | 177 | MBO7721978.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 237 | 69.7 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31694079 | 31694079 | PRJNA688352_P_NODE_11417_length_243_cov_0.905882_g11314_i0 | PRJNA688352 | 11417 | 243 | 0.905882 | 2.20129326 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 105 | 4.98e-26 | NR | MBR2837578.1 | 2212473 | g11314 | i0 | 66.3 | 1.97530864197531 | 80 | 27 | 98.8 | 0 | 4 | 243 | 79 | 158 | MBR2837578.1 response regulator transcription factor [Kiritimatiellia bacterium] | diamond | 480 | 105 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32137143 | 32137143 | PRJNA688352_P_NODE_11358_length_243_cov_0.905882_g11255_i0 | PRJNA688352 | 11358 | 243 | 0.905882 | 2.20129326 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 122 | 3.6199999999999995e-30 | NR | HMP75224.1 | 2212473 | g11255 | i0 | 72.5 | 0.987654320987654 | 80 | 21 | 97.5 | 1 | 237 | 1 | 118 | 197 | HMP75224.1 RyR domain-containing protein [Kiritimatiellia bacterium] | diamond | 240 | 122 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32263889 | 32263889 | PRJNA688352_P_NODE_8238_length_249_cov_0.875000_g8135_i0 | PRJNA688352 | 8238 | 249 | 0.875 | 2.17875 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 147 | 3.05e-39 | NR | MDD6030822.1 | 2212473 | g8135 | i0 | 81.7 | 1.98795180722892 | 82 | 15 | 98.8 | 0 | 246 | 1 | 432 | 513 | MDD6030822.1 2-hydroxyacyl-CoA dehydratase [Kiritimatiellia bacterium] | diamond | 495 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32358818 | 32358818 | PRJNA688352_P_NODE_9659_length_246_cov_0.890173_g9556_i0 | PRJNA688352 | 9659 | 246 | 0.890173 | 2.18982558 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 57.8 | 1.57e-7 | NR | MBQ6327616.1 | 2212473 | g9556 | i0 | 36.9 | 2.04878048780488 | 84 | 45 | 98.8 | 3 | 246 | 4 | 134 | 212 | MBQ6327616.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 504 | 57.8 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32485269 | 32485269 | PRJNA688352_P_NODE_11559_length_242_cov_0.911243_g11456_i0 | PRJNA688352 | 11559 | 242 | 0.911243 | 2.20520806 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 110 | 5.16e-26 | NR | MCQ2393395.1 | 2212473 | g11456 | i0 | 61.3 | 1.98347107438017 | 80 | 31 | 99.2 | 0 | 240 | 1 | 99 | 178 | MCQ2393395.1 TonB-dependent receptor [Kiritimatiellia bacterium] | diamond | 480 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32516975 | 32516975 | PRJNA688352_P_NODE_11379_length_243_cov_0.905882_g11276_i0 | PRJNA688352 | 11379 | 243 | 0.905882 | 2.20129326 | Pontiella sulfatireligans | 2750658 | Bacteria | Bacteria | 102 | 5.3e-23 | NR | WP_136061628.1 | 2750658 | g11276 | i0 | 66.7 | 1 | 81 | 25 | 97.5 | 1 | 240 | 4 | 512 | 592 | WP_136061628.1 beta strand repeat-containing protein [Pontiella sulfatireligans] | diamond | 243 | 102 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellales | Pontiellaceae | Pontiella | Pontiella sulfatireligans | |
| 32894684 | 32894684 | PRJNA688352_P_NODE_9540_length_246_cov_0.890173_g9437_i0 | PRJNA688352 | 9540 | 246 | 0.890173 | 2.18982558 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 142 | 5.039999999999999e-42 | NR | MBO7685147.1 | 2212473 | g9437 | i0 | 88.9 | 0.98780487804878 | 81 | 9 | 98.8 | 0 | 246 | 4 | 9 | 89 | MBO7685147.1 DNA-directed RNA polymerase subunit omega [Kiritimatiellia bacterium] | diamond | 243 | 142 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia 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);;