contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA827593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9749718 | 9749718 | PRJNA827593_P_NODE_66548_length_243_cov_0.905882_g66249_i0 | PRJNA827593 | 66548 | 243 | 0.905882 | 2.20129326 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 96.3 | 4.6100000000000006e-21 | NR | HSR57216.1 | 2785449 | g66249 | i0 | 82 | 0.753086419753086 | 61 | 11 | 75.3 | 0 | 2 | 184 | 393 | 453 | HSR57216.1 IS66 family transposase [Candidatus Binataceae bacterium] | diamond | 183 | 96.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 13575051 | 13575051 | PRJNA827593_P_NODE_56511_length_263_cov_2.021053_g56212_i0 | PRJNA827593 | 56511 | 263 | 2.021053 | 5.31536939 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 134 | 1.4e-34 | NR | HUS25304.1 | 2838779 | g56212 | i0 | 73.6 | 0.992395437262357 | 87 | 22 | 99.2 | 1 | 261 | 1 | 264 | 349 | HUS25304.1 non-ribosomal peptide synthetase [Candidatus Binatia bacterium] | diamond | 261 | 134 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27528390 | 27528390 | PRJNA827593_P_NODE_19443_length_483_cov_2.695122_g19145_i0 | PRJNA827593 | 19443 | 483 | 2.695122 | 13.01743926 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 62.4 | 1.47e-8 | NR | HEV8716164.1 | 2838779 | g19145 | i0 | 50 | 0.31055900621118 | 50 | 25 | 31.1 | 0 | 168 | 19 | 6 | 55 | HEV8716164.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 150 | 62.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27812915 | 27812915 | PRJNA827593_P_NODE_65084_length_245_cov_1.017442_g64785_i0 | PRJNA827593 | 65084 | 245 | 1.017442 | 2.4927329 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 138 | 2.5499999999999998e-40 | NR | HUC87653.1 | 2838779 | g64785 | i0 | 80.2 | 0.991836734693878 | 81 | 16 | 99.2 | 0 | 3 | 245 | 6 | 86 | HUC87653.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 243 | 138 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29233589 | 29233589 | PRJNA827593_P_NODE_52309_length_275_cov_2.024752_g52010_i0 | PRJNA827593 | 52309 | 275 | 2.024752 | 5.568068 | Candidatus Binatales bacterium | 3107056 | Bacteria | Bacteria | 159 | 3.42e-43 | NR | MFI5353646.1 | 3107056 | g52010 | i0 | 87.8 | 0.981818181818182 | 90 | 11 | 98.2 | 0 | 275 | 6 | 197 | 286 | MFI5353646.1 VirB4 family type IV secretion/conjugal transfer ATPase [Candidatus Binatales bacterium] | diamond | 270 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binatales bacterium | ||||
| 29896724 | 29896724 | PRJNA827593_P_NODE_67631_length_241_cov_1.833333_g67332_i0 | PRJNA827593 | 67631 | 241 | 1.833333 | 4.41833253 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 94.7 | 2.8e-21 | NR | HVM85849.1 | 2838779 | g67332 | i0 | 76.4 | 0.684647302904564 | 55 | 13 | 68.5 | 0 | 167 | 3 | 1 | 55 | HVM85849.1 homocysteine S-methyltransferase family protein [Candidatus Binatia bacterium] | diamond | 165 | 94.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30149098 | 30149098 | PRJNA827593_P_NODE_29132_length_384_cov_2.038585_g28833_i0 | PRJNA827593 | 29132 | 384 | 2.038585 | 7.8281664 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 171 | 9.42e-49 | NR | HVN84295.1 | 2838779 | g28833 | i0 | 70.2 | 0.96875 | 124 | 36 | 96.9 | 1 | 373 | 2 | 160 | 282 | HVN84295.1 OprD family outer membrane porin [Candidatus Binatia bacterium] | diamond | 372 | 171 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30180851 | 30180851 | PRJNA827593_P_NODE_65652_length_244_cov_1.485380_g65353_i0 | PRJNA827593 | 65652 | 244 | 1.48538 | 3.6243272 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 125 | 3.0899999999999997e-32 | NR | HZV86114.1 | 2811406 | g65353 | i0 | 81 | 1.95491803278689 | 79 | 15 | 97.1 | 0 | 243 | 7 | 325 | 403 | HZV86114.1 ferritin-like domain-containing protein [Candidatus Binatus sp.] | diamond | 477 | 125 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 30307814 | 30307814 | PRJNA827593_P_NODE_56292_length_264_cov_1.361257_g55993_i0 | PRJNA827593 | 56292 | 264 | 1.361257 | 3.59371848 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 79.3 | 5.45e-16 | NR | WP_331963235.1 | 2811406 | g55993 | i0 | 80 | 0.568181818181818 | 50 | 10 | 56.8 | 0 | 150 | 1 | 9 | 58 | WP_331963235.1 TetR/AcrR family transcriptional regulator [Candidatus Binatus sp.] | diamond | 150 | 79.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 30442399 | 30442399 | PRJNA827593_P_NODE_51813_length_277_cov_1.352941_g51514_i0 | PRJNA827593 | 51813 | 277 | 1.352941 | 3.74764657 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 143 | 3.47e-39 | NR | HSV08005.1 | 2811406 | g51514 | i0 | 69.2 | 2.95667870036101 | 91 | 27 | 97.5 | 1 | 275 | 6 | 22 | 112 | HSV08005.1 agmatine deiminase family protein [Candidatus Binatus sp.] | diamond | 819 | 144 | 0.993055555555556 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 30591584 | 30591584 | PRJNA827593_P_NODE_32273_length_363_cov_1.006897_g31974_i0 | PRJNA827593 | 32273 | 363 | 1.006897 | 3.65503611 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 113 | 6.85e-29 | NR | HVA40400.1 | 2785449 | g31974 | i0 | 63 | 1.52066115702479 | 92 | 34 | 76 | 0 | 83 | 358 | 51 | 142 | HVA40400.1 M56 family metallopeptidase [Candidatus Binataceae bacterium] | diamond | 552 | 113 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 30717875 | 30717875 | PRJNA827593_P_NODE_10874_length_668_cov_3.305882_g10583_i0 | PRJNA827593 | 10874 | 668 | 3.305882 | 22.08329176 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 94.7 | 1.54e-20 | NR | HUA35734.1 | 2785449 | g10583 | i0 | 37.9 | 1.66616766467066 | 124 | 74 | 55.7 | 2 | 262 | 633 | 3 | 123 | HUA35734.1 SRPBCC domain-containing protein [Candidatus Binataceae bacterium] | diamond | 1113 | 94.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 30844492 | 30844492 | PRJNA827593_P_NODE_32874_length_359_cov_1.237762_g32575_i0 | PRJNA827593 | 32874 | 359 | 1.237762 | 4.44356558 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 104 | 2.73e-24 | NR | MEA2680644.1 | 2785449 | g32575 | i0 | 56.8 | 0.927576601671309 | 111 | 42 | 88.6 | 2 | 41 | 358 | 12 | 121 | MEA2680644.1 iron complex outerrane recepter protein [Candidatus Binataceae bacterium] | diamond | 333 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 31571655 | 31571655 | PRJNA827593_P_NODE_27556_length_397_cov_0.888889_g27257_i0 | PRJNA827593 | 27556 | 397 | 0.888889 | 3.52888933 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 111 | 1.15e-28 | NR | HTW88402.1 | 2785449 | g27257 | i0 | 63 | 1.22418136020151 | 81 | 30 | 61.2 | 0 | 397 | 155 | 35 | 115 | HTW88402.1 plastocyanin/azurin family copper-binding protein [Candidatus Binataceae bacterium] | diamond | 486 | 111 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 32204233 | 32204233 | PRJNA827593_P_NODE_43998_length_304_cov_2.904762_g43699_i0 | PRJNA827593 | 43998 | 304 | 2.904762 | 8.83047648 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 117 | 7.31e-30 | NR | HEV8718942.1 | 2838779 | g43699 | i0 | 63.7 | 1.00657894736842 | 102 | 34 | 98.7 | 2 | 3 | 302 | 62 | 162 | HEV8718942.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 306 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32489203 | 32489203 | PRJNA827593_P_NODE_46279_length_296_cov_1.381166_g45980_i0 | PRJNA827593 | 46279 | 296 | 1.381166 | 4.08825136 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 94 | 4.08e-20 | NR | HJU09470.1 | 2785449 | g45980 | i0 | 42.3 | 0.983108108108108 | 97 | 56 | 98.3 | 0 | 2 | 292 | 22 | 118 | HJU09470.1 hypothetical protein [Candidatus Binataceae bacterium] | diamond | 291 | 94 | 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);;