contig_metadata
9 rows where bioproject = "PRJNA1233465" and tax_phylum = "Candidatus Hydrogenedentota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25945690 | 25945690 | PRJNA1233465b_S_NODE_185892_length_216_cov_1.221557_g184207_i0 | PRJNA1233465 | 185892 | 216 | 1.221557 | 2.63856312 | Candidatus Hydrogenedentales bacterium | 3120109 | Bacteria | Bacteria | 117 | 9.63e-29 | NR | MFA6242299.1 | 3120109 | g184207 | i0 | 80.6 | 2 | 72 | 14 | 100 | 0 | 1 | 216 | 40 | 111 | MFA6242299.1 UvrD-helicase domain-containing protein [Candidatus Hydrogenedentales bacterium] | diamond | 432 | 117 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentia | Candidatus Hydrogenedentales | Candidatus Hydrogenedentales bacterium | |||
| 32966938 | 32966938 | PRJNA1233465b_S_NODE_62162_length_326_cov_2.862816_g60477_i0 | PRJNA1233465 | 62162 | 326 | 2.862816 | 9.33278016 | Candidatus Hydrogenedentales bacterium | 3120109 | Bacteria | Bacteria | 81.3 | 2.96e-15 | NR | MFA6242299.1 | 3120109 | g60477 | i0 | 43.5 | 0.993865030674847 | 108 | 59 | 99.4 | 1 | 3 | 326 | 472 | 577 | MFA6242299.1 UvrD-helicase domain-containing protein [Candidatus Hydrogenedentales bacterium] | diamond | 324 | 81.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentia | Candidatus Hydrogenedentales | Candidatus Hydrogenedentales bacterium | |||
| 33000574 | 33000574 | PRJNA1233465b_S_NODE_238235_length_194_cov_1.613793_g236550_i0 | PRJNA1233465 | 238235 | 194 | 1.613793 | 3.13075842 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 85.1 | 2.84e-18 | NR | MDZ4860303.1 | 2030809 | g236550 | i0 | 58.1 | 0.958762886597938 | 62 | 26 | 95.9 | 0 | 188 | 3 | 122 | 183 | MDZ4860303.1 TylF/MycF/NovP-related O-methyltransferase [Candidatus Hydrogenedentota bacterium] | diamond | 186 | 85.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 33019323 | 33019323 | PRJNA1233465f_S_NODE_169884_length_190_cov_1.808511_g167604_i0 | PRJNA1233465 | 169884 | 190 | 1.808511 | 3.4361709 | Candidatus Hydrogenedentales bacterium | 3120109 | Bacteria | Bacteria | 79 | 3.08e-15 | NR | MFA6242299.1 | 3120109 | g167604 | i0 | 63 | 0.852631578947368 | 54 | 20 | 85.3 | 0 | 188 | 27 | 620 | 673 | MFA6242299.1 UvrD-helicase domain-containing protein [Candidatus Hydrogenedentales bacterium] | diamond | 162 | 79 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentia | Candidatus Hydrogenedentales | Candidatus Hydrogenedentales bacterium | |||
| 33070588 | 33070588 | PRJNA1233465f_S_NODE_231181_length_167_cov_1.932203_g228901_i0 | PRJNA1233465 | 231181 | 167 | 1.932203 | 3.22677901 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 77 | 1.09e-14 | NR | MCC6487429.1 | 2030809 | g228901 | i0 | 58.8 | 2.69461077844311 | 51 | 21 | 91.6 | 0 | 154 | 2 | 716 | 766 | MCC6487429.1 amino acid adenylation domain-containing protein [Candidatus Hydrogenedentota bacterium] | diamond | 450 | 77 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 33087866 | 33087866 | PRJNA1233465f_S_NODE_281230_length_151_cov_3.088235_g278950_i0 | PRJNA1233465 | 281230 | 151 | 3.088235 | 4.66323485 | Candidatus Hydrogenedentales bacterium | 3120109 | Bacteria | Bacteria | 47.8 | 1.83e-4 | NR | MFA6242298.1 | 3120109 | g278950 | i0 | 51 | 1.94701986754967 | 49 | 24 | 97.4 | 0 | 151 | 5 | 559 | 607 | MFA6242298.1 AAA family ATPase [Candidatus Hydrogenedentales bacterium] | diamond | 294 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentia | Candidatus Hydrogenedentales | Candidatus Hydrogenedentales bacterium | |||
| 33119455 | 33119455 | PRJNA1233465a_S_NODE_242391_length_162_cov_1.353982_g241117_i0 | PRJNA1233465 | 242391 | 162 | 1.353982 | 2.19345084 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 64.3 | 2.96e-10 | NR | MBX3177954.1 | 2030809 | g241117 | i0 | 56.9 | 8.53703703703704 | 51 | 22 | 94.4 | 0 | 160 | 8 | 473 | 523 | MBX3177954.1 hypothetical protein [Candidatus Hydrogenedentota bacterium] | diamond | 1383 | 64.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 33153629 | 33153629 | PRJNA1233465a_S_NODE_26216_length_372_cov_2.702786_g24942_i0 | PRJNA1233465 | 26216 | 372 | 2.702786 | 10.05436392 | Candidatus Hydrogenedentales bacterium | 3120109 | Bacteria | Bacteria | 81.3 | 5.09e-15 | NR | MFA6242299.1 | 3120109 | g24942 | i0 | 43.4 | 0.911290322580645 | 113 | 62 | 91.1 | 1 | 340 | 2 | 466 | 576 | MFA6242299.1 UvrD-helicase domain-containing protein [Candidatus Hydrogenedentales bacterium] | diamond | 339 | 81.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentia | Candidatus Hydrogenedentales | Candidatus Hydrogenedentales bacterium | |||
| 33171742 | 33171742 | PRJNA1233465d_S_NODE_136784_length_163_cov_1.833333_g135673_i0 | PRJNA1233465 | 136784 | 163 | 1.833333 | 2.98833279 | Candidatus Hydrogenedentales bacterium | 3120109 | Bacteria | Bacteria | 48.9 | 8.49e-5 | NR | MFA6242298.1 | 3120109 | g135673 | i0 | 51 | 0.938650306748466 | 51 | 25 | 93.9 | 0 | 163 | 11 | 559 | 609 | MFA6242298.1 AAA family ATPase [Candidatus Hydrogenedentales bacterium] | diamond | 153 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentia | Candidatus Hydrogenedentales | Candidatus Hydrogenedentales 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);;