contig_metadata
13 rows where bioproject = "PRJNA939415" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 915854 | 915854 | PRJNA939415_P_NODE_62401_length_271_cov_2.959596_g61979_i0 | PRJNA939415 | 62401 | 271 | 2.959596 | 8.02050516 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 281 | 2.91e-71 | NTclustered | gi|2874253687|emb|OY969413.1| | 2030810 | g61979 | i0 | 85.662 | 8.22509225092251 | 272 | 33 | 99 | 5 | 1 | 269 | 887122 | 886854 | MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1 | blastn | 2229 | 281 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 4744602 | 4744602 | PRJNA939415_P_NODE_83824_length_250_cov_3.129944_g83402_i0 | PRJNA939415 | 83824 | 250 | 3.129944 | 7.82486 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 204 | 5.909999999999999e-48 | NTclustered | gi|2874253687|emb|OY969413.1| | 2030810 | g83402 | i0 | 82.203 | 22.788 | 236 | 42 | 94 | 0 | 1 | 236 | 51110 | 51345 | MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1 | blastn | 5697 | 204 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 13669687 | 13669687 | PRJNA939415_P_NODE_73611_length_260_cov_3.016043_g73189_i0 | PRJNA939415 | 73611 | 260 | 3.016043 | 7.8417118 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 303 | 5.92e-78 | NTclustered | gi|2874253687|emb|OY969413.1| | 2030810 | g73189 | i0 | 91.403 | 10.8192307692308 | 221 | 19 | 85 | 0 | 1 | 221 | 888997 | 888777 | MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1 | blastn | 2813 | 303 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 18766553 | 18766553 | PRJNA939415_P_NODE_106575_length_222_cov_4.530201_g106153_i0 | PRJNA939415 | 106575 | 222 | 4.530201 | 10.05704622 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 191 | 4e-44 | NTclustered | gi|1958016626|gb|CP064968.1| | 2030810 | g106153 | i0 | 86.782 | 106.887387387387 | 174 | 19 | 78 | 3 | 43 | 215 | 956418 | 956588 | MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome | blastn | 23729 | 191 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 27025118 | 27025118 | PRJNA939415_P_NODE_85302_length_249_cov_2.403409_g84880_i0 | PRJNA939415 | 85302 | 249 | 2.403409 | 5.98448841 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 127 | 3.14e-33 | NR | MDB5238026.1 | 2030810 | g84880 | i0 | 71.6 | 0.975903614457831 | 81 | 23 | 97.6 | 0 | 2 | 244 | 200 | 280 | MDB5238026.1 oxidoreductase [Candidatus Kaiserbacteria bacterium] | diamond | 243 | 127 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 27821949 | 27821949 | PRJNA939415_P_NODE_105764_length_226_cov_2.013072_g105342_i0 | PRJNA939415 | 105764 | 226 | 2.013072 | 4.54954272 | Bacteria | 2 | Bacteria | Bacteria | 101 | 5.51e-23 | NR | OGG50310.1 | 1798482 | g105342 | i0 | 64.9 | 1.97787610619469 | 74 | 26 | 98.2 | 0 | 225 | 4 | 598 | 671 | OGG50310.1 MAG: hypothetical protein A2763_01455 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_54_36] | diamond | 447 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_54_36 | ||||||
| 28042796 | 28042796 | PRJNA939415_P_NODE_55065_length_278_cov_4.858537_g54643_i0 | PRJNA939415 | 55065 | 278 | 4.858537 | 13.50673286 | Bacteria | 2 | Bacteria | Bacteria | 107 | 2.8399999999999998e-25 | NR | MBI2409741.1 | 2030810 | g54643 | i0 | 87 | 2.9136690647482 | 54 | 7 | 58.3 | 0 | 116 | 277 | 16 | 69 | MBI2409741.1 RIP metalloprotease [Candidatus Kaiserbacteria bacterium] | diamond | 810 | 108 | 0.990740740740741 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 28604140 | 28604140 | PRJNA939415_P_NODE_18427_length_363_cov_2.868966_g18007_i0 | PRJNA939415 | 18427 | 363 | 2.868966 | 10.41434658 | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_ | 2030810 | Bacteria | Bacteria | 59.7 | 1.66e-8 | NR | OGG47580.1 | 1798479 | g18007 | i0 | 45.5 | 0.545454545454545 | 66 | 35 | 54.5 | 1 | 2 | 199 | 56 | 120 | OGG47580.1 MAG: hypothetical protein A2761_00005 [Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_51_33] | diamond | 198 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPHIGHO2_01_FULL_51_33 | ||||||
| 28667428 | 28667428 | PRJNA939415_P_NODE_26427_length_310_cov_4.544304_g26005_i0 | PRJNA939415 | 26427 | 310 | 4.544304 | 14.0873424 | Candidatus Kaiserbacteria bacterium GW2 | 2030810 | Bacteria | Bacteria | 93.2 | 1.94e-21 | NR | KKW22924.1 | 1618671 | g26005 | i0 | 54.7 | 0.919354838709677 | 95 | 27 | 80.3 | 2 | 62 | 310 | 2 | 92 | KKW22924.1 MAG: hypothetical protein UY67_C0032G0006 [Candidatus Kaiserbacteria bacterium GW2011_GWA2_52_12] | diamond | 285 | 93.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium GW2011_GWA2_52_12 | ||||||
| 31668480 | 31668480 | PRJNA939415_P_NODE_54297_length_279_cov_3.038835_g53875_i0 | PRJNA939415 | 54297 | 279 | 3.038835 | 8.47834965 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 67 | 1.7e-10 | NR | MBI5470398.1 | 2030810 | g53875 | i0 | 51.6 | 1.40860215053763 | 62 | 30 | 66.7 | 0 | 5 | 190 | 1111 | 1172 | MBI5470398.1 hypothetical protein [Candidatus Kaiserbacteria bacterium] | diamond | 393 | 67 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 32206484 | 32206484 | PRJNA939415_P_NODE_88378_length_247_cov_0.885057_g87956_i0 | PRJNA939415 | 88378 | 247 | 0.885057 | 2.18609079 | Candidatus Kaiserbacteria bacterium RIFCSPLOWO2_ | 2030810 | Bacteria | Bacteria | 48.1 | 5.11e-4 | NR | OGG73828.1 | 1798513 | g87956 | i0 | 50.8 | 0.765182186234818 | 63 | 29 | 75.3 | 2 | 52 | 237 | 561 | 622 | OGG73828.1 MAG: hypothetical protein A3A40_02310, partial [Candidatus Kaiserbacteria bacterium RIFCSPLOWO2_01_FULL_54_20] | diamond | 189 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium RIFCSPLOWO2_01_FULL_54_20 | ||||||
| 32301643 | 32301643 | PRJNA939415_P_NODE_23199_length_322_cov_2.646586_g22778_i0 | PRJNA939415 | 23199 | 322 | 2.646586 | 8.52200692 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 46.6 | 0.00403 | NR | MBM3272343.1 | 2030810 | g22778 | i0 | 47.8 | 0.624223602484472 | 67 | 28 | 62.4 | 2 | 238 | 38 | 11 | 70 | MBM3272343.1 alpha/beta hydrolase [Candidatus Kaiserbacteria bacterium] | diamond | 201 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 32301646 | 32301646 | PRJNA939415_P_NODE_25399_length_310_cov_5.755274_g24977_i0 | PRJNA939415 | 25399 | 310 | 5.755274 | 17.8413494 | Candidatus Kaiserbacteria bacterium GW2 | 2030810 | Bacteria | Bacteria | 61.6 | 1.04e-8 | NR | KKW08000.1 | 1618669 | g24977 | i0 | 70.5 | 0.425806451612903 | 44 | 13 | 42.6 | 0 | 148 | 17 | 118 | 161 | KKW08000.1 MAG: hypothetical protein UY44_C0020G0001, partial [Candidatus Kaiserbacteria bacterium GW2011_GWA2_49_19] | diamond | 132 | 61.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium GW2011_GWA2_49_19 |
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);;