contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA773247" and tax_phylum = "Candidatus Kaiseribacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2024880 | 2024880 | PRJNA773247_P_NODE_30062_length_251_cov_3.865169_g29978_i0 | PRJNA773247 | 30062 | 251 | 3.865169 | 9.70157419 | Bacteria | 2 | Bacteria | Bacteria | 161 | 1.45e-44 | NR | OGG86188.1 | 1798531 | g29978 | i0 | 97.6 | 63.394422310757 | 83 | 2 | 99.2 | 0 | 3 | 251 | 35 | 117 | OGG86188.1 MAG: GTP-binding protein TypA [Candidatus Kaiserbacteria bacterium RIFOXYB1_FULL_46_14] | diamond | 15912 | 162 | 0.993827160493827 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFOXYB1_FULL_46_14 | ||||||
| 2025043 | 2025043 | PRJNA773247_P_NODE_6282_length_683_cov_19.965574_g6201_i0 | PRJNA773247 | 6282 | 683 | 19.965574 | 136.36487042 | Bacteria | 2 | Bacteria | Bacteria | 239 | 4.7e-76 | NR | OGG58395.1 | 1798487 | g6201 | i0 | 77.7 | 8.46412884333821 | 148 | 33 | 65 | 0 | 1 | 444 | 87 | 234 | OGG58395.1 MAG: 30S ribosomal protein S2 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_56_24] | diamond | 5781 | 239 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_56_24 | ||||||
| 10952995 | 10952995 | PRJNA773247_P_NODE_26249_length_272_cov_4.271357_g26165_i0 | PRJNA773247 | 26249 | 272 | 4.271357 | 11.61809104 | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_ | 2030810 | Bacteria | Bacteria | 149 | 9.559999999999998e-42 | NR | OGG49069.1 | 1798481 | g26165 | i0 | 84.4 | 1.98529411764706 | 90 | 14 | 99.3 | 0 | 270 | 1 | 160 | 249 | OGG49069.1 MAG: rod shape-determining protein [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_53_31] | diamond | 540 | 149 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_53_31 | ||||||
| 26609925 | 26609925 | PRJNA773247_P_NODE_36361_length_228_cov_3.509677_g36277_i0 | PRJNA773247 | 36361 | 228 | 3.509677 | 8.00206356 | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_ | 2030810 | Bacteria | Bacteria | 114 | 1.26e-28 | NR | OGG50768.1 | 1798482 | g36277 | i0 | 87.7 | 1.67105263157895 | 65 | 8 | 85.5 | 0 | 34 | 228 | 198 | 262 | OGG50768.1 MAG: UDP-N-acetylenolpyruvoylglucosamine reductase [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_54_36] | diamond | 381 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_54_36 | ||||||
| 27021720 | 27021720 | PRJNA773247_P_NODE_26282_length_272_cov_3.035176_g26198_i0 | PRJNA773247 | 26282 | 272 | 3.035176 | 8.25567872 | Candidatus Kaiserbacteria bacterium RIFCSPLOWO2_ | 2030810 | Bacteria | Bacteria | 172 | 9.22e-50 | NR | OGG73908.1 | 1798513 | g26198 | i0 | 85.6 | 0.992647058823529 | 90 | 13 | 99.3 | 0 | 3 | 272 | 94 | 183 | OGG73908.1 MAG: hypothetical protein A3A40_02075 [Candidatus Kaiserbacteria bacterium RIFCSPLOWO2_01_FULL_54_20] | diamond | 270 | 172 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPLOWO2_01_FULL_54_20 | ||||||
| 28262851 | 28262851 | PRJNA773247_P_NODE_26686_length_270_cov_1.497462_g26602_i0 | PRJNA773247 | 26686 | 270 | 1.497462 | 4.0431474 | Bacteria | 2 | Bacteria | Bacteria | 154 | 1.84e-43 | NR | KKW17822.1 | 1618668 | g26602 | i0 | 91.9 | 21.9777777777778 | 86 | 7 | 95.6 | 0 | 268 | 11 | 124 | 209 | KKW17822.1 MAG: gyrase subunit B protein, partial [Candidatus Kaiserbacteria bacterium GW2011_GWA1_50_28] | diamond | 5934 | 155 | 0.993548387096774 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium GW2011_GWA1_50_28 | ||||||
| 28578854 | 28578854 | PRJNA773247_P_NODE_20127_length_319_cov_4.678862_g20043_i0 | PRJNA773247 | 20127 | 319 | 4.678862 | 14.92556978 | Bacteria | 2 | Bacteria | Bacteria | 142 | 7.799999999999998e-39 | NR | MCA9358748.1 | 2030810 | g20043 | i0 | 65 | 1.93730407523511 | 103 | 36 | 96.9 | 0 | 319 | 11 | 40 | 142 | MCA9358748.1 D-alanine--D-alanine ligase [Candidatus Kaiserbacteria bacterium] | diamond | 618 | 142 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 28632613 | 28632613 | PRJNA773247_P_NODE_36747_length_222_cov_7.570470_g36663_i0 | PRJNA773247 | 36747 | 222 | 7.57047 | 16.8064434 | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_ | 2030810 | Bacteria | Bacteria | 105 | 2.34e-25 | NR | OGG55998.1 | 1798485 | g36663 | i0 | 85.2 | 1.66216216216216 | 61 | 9 | 82.4 | 0 | 39 | 221 | 226 | 286 | OGG55998.1 MAG: hypothetical protein A2680_00485 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_55_37] | diamond | 369 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_55_37 | ||||||
| 29421506 | 29421506 | PRJNA773247_P_NODE_11689_length_449_cov_22.199468_g11606_i0 | PRJNA773247 | 11689 | 449 | 22.199468 | 99.67561132 | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_ | 2030810 | Bacteria | Bacteria | 129 | 1.7699999999999996e-31 | NR | OGG59808.1 | 1798487 | g11606 | i0 | 48.6 | 0.948775055679287 | 142 | 70 | 93.5 | 3 | 6 | 425 | 103 | 243 | OGG59808.1 MAG: hypothetical protein A2765_04445 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_56_24] | diamond | 426 | 129 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_56_24 | ||||||
| 29905042 | 29905042 | PRJNA773247_P_NODE_10771_length_474_cov_26.945137_g10688_i0 | PRJNA773247 | 10771 | 474 | 26.945137 | 127.71994938 | Bacteria | 2 | Bacteria | Bacteria | 261 | 7.119999999999998e-83 | NR | OGG87731.1 | 1798532 | g10688 | i0 | 90.2 | 11.6772151898734 | 153 | 15 | 96.8 | 0 | 474 | 16 | 61 | 213 | OGG87731.1 MAG: hypothetical protein A2592_03340 [Candidatus Kaiserbacteria bacterium RIFOXYD1_FULL_42_15] | diamond | 5535 | 261 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFOXYD1_FULL_42_15 | ||||||
| 31158808 | 31158808 | PRJNA773247_P_NODE_20135_length_319_cov_3.878049_g20051_i0 | PRJNA773247 | 20135 | 319 | 3.878049 | 12.37097631 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 132 | 3.1e-33 | NR | MBI5457733.1 | 2030810 | g20051 | i0 | 90.3 | 0.677115987460815 | 72 | 7 | 67.7 | 0 | 309 | 94 | 81 | 152 | MBI5457733.1 peptidoglycan-binding protein [Candidatus Kaiserbacteria bacterium] | diamond | 216 | 132 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 31485153 | 31485153 | PRJNA773247_P_NODE_12556_length_430_cov_4.260504_g12473_i0 | PRJNA773247 | 12556 | 430 | 4.260504 | 18.3201672 | Bacteria | 2 | Bacteria | Bacteria | 153 | 2.39e-41 | NR | OGG59748.1 | 1798487 | g12473 | i0 | 71.4 | 5.07209302325581 | 105 | 28 | 73.3 | 2 | 113 | 427 | 329 | 431 | OGG59748.1 MAG: nicotinate phosphoribosyltransferase [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_56_24] | diamond | 2181 | 153 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_56_24 | ||||||
| 31832695 | 31832695 | PRJNA773247_P_NODE_30517_length_250_cov_4.553672_g30433_i0 | PRJNA773247 | 30517 | 250 | 4.553672 | 11.38418 | Bacteria | 2 | Bacteria | Bacteria | 74.7 | 2.19e-13 | NR | OGG76540.1 | 1798516 | g30433 | i0 | 48.5 | 4.872 | 66 | 34 | 79.2 | 0 | 52 | 249 | 191 | 256 | OGG76540.1 MAG: hypothetical protein A2950_02140 [Candidatus Kaiserbacteria bacterium RIFCSPLOWO2_01_FULL_55_19] | diamond | 1218 | 75.1 | 0.994673768308922 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPLOWO2_01_FULL_55_19 | ||||||
| 31918269 | 31918269 | PRJNA773247_P_NODE_23137_length_293_cov_6.827273_g23053_i0 | PRJNA773247 | 23137 | 293 | 6.827273 | 20.00390989 | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_ | 2030810 | Bacteria | Bacteria | 124 | 2.3699999999999998e-32 | NR | OGG55724.1 | 1798485 | g23053 | i0 | 91.2 | 2.08873720136519 | 68 | 6 | 69.6 | 0 | 216 | 13 | 1 | 68 | OGG55724.1 MAG: zinc metalloprotease HtpX [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_55_37] | diamond | 612 | 124 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_55_37 | ||||||
| 31981420 | 31981420 | PRJNA773247_P_NODE_37038_length_211_cov_8.442029_g36954_i0 | PRJNA773247 | 37038 | 211 | 8.442029 | 17.81268119 | Candidatus Kaiserbacteria bacterium CG_4_1 | 2030810 | Bacteria | Bacteria | 95.5 | 4.65e-22 | NR | PJA00304.1 | 1974598 | g36954 | i0 | 70.8 | 0.924170616113744 | 65 | 19 | 92.4 | 0 | 7 | 201 | 36 | 100 | PJA00304.1 MAG: hypothetical protein COX76_02070 [Candidatus Kaiserbacteria bacterium CG_4_10_14_0_2_um_filter_50_16] | diamond | 195 | 95.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium CG_4_10_14_0_2_um_filter_50_16 | ||||||
| 32676884 | 32676884 | PRJNA773247_P_NODE_37340_length_200_cov_6.653543_g37256_i0 | PRJNA773247 | 37340 | 200 | 6.653543 | 13.307086 | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_ | 2030810 | Bacteria | Bacteria | 127 | 2.9699999999999997e-35 | NR | OGG57600.1 | 1798484 | g37256 | i0 | 90.9 | 2.955 | 66 | 6 | 99 | 0 | 1 | 198 | 69 | 134 | OGG57600.1 MAG: hypothetical protein A2853_01895 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_55_17] | diamond | 591 | 127 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_55_17 |
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);;