contig_metadata
16 rows where bioproject = "PRJNA662254" and tax_phylum = "Candidatus Binatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1904508 | 1904508 | PRJNA662254_P_NODE_60122_length_244_cov_0.888889_g59471_i0 | PRJNA662254 | 60122 | 244 | 0.888889 | 2.16888916 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 160 | 7.44e-46 | NR | HEX4210849.1 | 2785449 | g59471 | i0 | 96.3 | 2.98770491803279 | 81 | 3 | 99.6 | 0 | 243 | 1 | 58 | 138 | HEX4210849.1 NADH-quinone oxidoreductase subunit NuoH [Candidatus Binataceae bacterium] | diamond | 729 | 160 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 9556877 | 9556877 | PRJNA662254_P_NODE_55088_length_246_cov_0.890173_g54437_i0 | PRJNA662254 | 55088 | 246 | 0.890173 | 2.18982558 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 134 | 6.22e-38 | NR | MDO8431982.1 | 2811406 | g54437 | i0 | 81.3 | 0.975609756097561 | 80 | 15 | 97.6 | 0 | 240 | 1 | 2 | 81 | MDO8431982.1 hypothetical protein [Candidatus Binatus sp.] | diamond | 240 | 134 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 12107740 | 12107740 | PRJNA662254_P_NODE_59130_length_244_cov_0.900585_g58479_i0 | PRJNA662254 | 59130 | 244 | 0.900585 | 2.1974274 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 154 | 1.59e-44 | NR | HVB80124.1 | 2785449 | g58479 | i0 | 86.3 | 1.9672131147541 | 80 | 11 | 98.4 | 0 | 242 | 3 | 143 | 222 | HVB80124.1 ADP-polyphosphate phosphotransferase [Candidatus Binataceae bacterium] | diamond | 480 | 154 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 23581104 | 23581104 | PRJNA662254_P_NODE_65859_length_241_cov_0.916667_g65208_i0 | PRJNA662254 | 65859 | 241 | 0.916667 | 2.20916747 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 153 | 1.0699999999999998e-41 | NR | HEX3409430.1 | 2785449 | g65208 | i0 | 93.8 | 3.95850622406639 | 80 | 5 | 99.6 | 0 | 241 | 2 | 123 | 202 | HEX3409430.1 potassium-transporting ATPase subunit KdpA [Candidatus Binataceae bacterium] | diamond | 954 | 153 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 26745120 | 26745120 | PRJNA662254_P_NODE_52961_length_247_cov_0.885057_g52310_i0 | PRJNA662254 | 52961 | 247 | 0.885057 | 2.18609079 | Bacteria | 2 | Bacteria | Bacteria | 142 | 4.21e-38 | NR | HWX18689.1 | 2838779 | g52310 | i0 | 78.8 | 1.95546558704453 | 80 | 17 | 97.2 | 0 | 6 | 245 | 323 | 402 | HWX18689.1 alpha-L-fucosidase [Candidatus Binatia bacterium] | diamond | 483 | 142 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27429325 | 27429325 | PRJNA662254_P_NODE_44843_length_251_cov_0.865169_g44192_i0 | PRJNA662254 | 44843 | 251 | 0.865169 | 2.17157419 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 134 | 1.9099999999999999e-34 | NR | HEY2104866.1 | 2785449 | g44192 | i0 | 75.9 | 0.99203187250996006 | 83 | 20 | 99.2 | 0 | 2 | 250 | 576 | 658 | HEY2104866.1 hypothetical protein [Candidatus Binataceae bacterium] | diamond | 249 | 134 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 28407944 | 28407944 | PRJNA662254_P_NODE_64046_length_242_cov_0.869822_g63395_i0 | PRJNA662254 | 64046 | 242 | 0.869822 | 2.10496924 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 129 | 1.01e-34 | NR | HUN58065.1 | 2785449 | g63395 | i0 | 93.8 | 0.991735537190083 | 80 | 5 | 99.2 | 0 | 3 | 242 | 140 | 219 | HUN58065.1 urea ABC transporter permease subunit UrtB [Candidatus Binataceae bacterium] | diamond | 240 | 129 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 28881422 | 28881422 | PRJNA662254_P_NODE_63608_length_242_cov_0.911243_g62957_i0 | PRJNA662254 | 63608 | 242 | 0.911243 | 2.20520806 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 55.8 | 8.31e-7 | NR | HYA34523.1 | 2785449 | g62957 | i0 | 37.3 | 2.80165289256198 | 75 | 43 | 93 | 2 | 226 | 2 | 114 | 184 | HYA34523.1 protease pro-enzyme activation domain-containing protein [Candidatus Binataceae bacterium] | diamond | 678 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 29240992 | 29240992 | PRJNA662254_P_NODE_50389_length_249_cov_0.875000_g49738_i0 | PRJNA662254 | 50389 | 249 | 0.875 | 2.17875 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 141 | 1.53e-38 | NR | HXN18423.1 | 2811406 | g49738 | i0 | 83.8 | 6.8433734939759 | 80 | 13 | 96.4 | 0 | 247 | 8 | 214 | 293 | HXN18423.1 SIS domain-containing protein [Candidatus Binatus sp.] | diamond | 1704 | 142 | 0.992957746478873 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 29418093 | 29418093 | PRJNA662254_P_NODE_51009_length_248_cov_0.880000_g50358_i0 | PRJNA662254 | 51009 | 248 | 0.88 | 2.1824 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 148 | 9.79e-43 | NR | HZI33596.1 | 2838779 | g50358 | i0 | 87.8 | 4.95967741935484 | 82 | 10 | 99.2 | 0 | 3 | 248 | 25 | 106 | HZI33596.1 urease subunit gamma [Candidatus Binatia bacterium] | diamond | 1230 | 148 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29670470 | 29670470 | PRJNA662254_P_NODE_52310_length_248_cov_0.880000_g51659_i0 | PRJNA662254 | 52310 | 248 | 0.88 | 2.1824 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 58.5 | 1.04e-7 | NR | MBF6571125.1 | 2785449 | g51659 | i0 | 40.3 | 0.810483870967742 | 67 | 40 | 81 | 0 | 41 | 241 | 1 | 67 | MBF6571125.1 sugar transferase [Candidatus Binataceae bacterium] | diamond | 201 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 30744967 | 30744967 | PRJNA662254_P_NODE_59354_length_244_cov_0.900585_g58703_i0 | PRJNA662254 | 59354 | 244 | 0.900585 | 2.1974274 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 144 | 5.129999999999998e-42 | NR | HZC21755.1 | 2838779 | g58703 | i0 | 81.3 | 0.983606557377049 | 80 | 15 | 98.4 | 0 | 240 | 1 | 48 | 127 | HZC21755.1 tlde1 domain-containing protein [Candidatus Binatia bacterium] | diamond | 240 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30997786 | 30997786 | PRJNA662254_P_NODE_48254_length_250_cov_0.870056_g47603_i0 | PRJNA662254 | 48254 | 250 | 0.870056 | 2.17514 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 73.6 | 5.59e-13 | NR | HEY7166015.1 | 2838779 | g47603 | i0 | 57.7 | 0.852 | 71 | 29 | 85.2 | 1 | 242 | 30 | 577 | 646 | HEY7166015.1 PQQ-dependent sugar dehydrogenase [Candidatus Binatia bacterium] | diamond | 213 | 73.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31819726 | 31819726 | PRJNA662254_P_NODE_52257_length_248_cov_0.880000_g51606_i0 | PRJNA662254 | 52257 | 248 | 0.88 | 2.1824 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 75.9 | 3.94e-14 | NR | HTD87750.1 | 2838779 | g51606 | i0 | 66.7 | 1.59677419354839 | 54 | 18 | 65.3 | 0 | 51 | 212 | 175 | 228 | HTD87750.1 thrombospondin type 3 repeat-containing protein [Candidatus Binatia bacterium] | diamond | 396 | 75.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32294804 | 32294804 | PRJNA662254_P_NODE_47939_length_250_cov_0.870056_g47288_i0 | PRJNA662254 | 47939 | 250 | 0.870056 | 2.17514 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 107 | 1.71e-27 | NR | HKV53238.1 | 2785449 | g47288 | i0 | 73.4 | 1.536 | 64 | 17 | 76.8 | 0 | 250 | 59 | 92 | 155 | HKV53238.1 cytochrome c [Candidatus Binataceae bacterium] | diamond | 384 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 32579338 | 32579338 | PRJNA662254_P_NODE_49479_length_249_cov_0.875000_g48828_i0 | PRJNA662254 | 49479 | 249 | 0.875 | 2.17875 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 161 | 1.75e-45 | NR | HEY1851703.1 | 2785449 | g48828 | i0 | 86.7 | 1 | 83 | 11 | 100 | 0 | 1 | 249 | 146 | 228 | HEY1851703.1 methylenetetrahydrofolate--tRNA-(uracil(54)-C(5))-methyltransferase (FADH(2)-oxidizing) TrmFO [Candidatus Binataceae bacterium] | diamond | 249 | 161 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae 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);;