contig_metadata
6 rows where bioproject = "PRJNA1002570", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6103855 | 6103855 | PRJNA1002570_P_NODE_29905_length_267_cov_2.974227_g29710_i0 | PRJNA1002570 | 29905 | 267 | 2.974227 | 7.94118609 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 70.1 | 1.18e-11 | NR | MBI2435657.1 | 2030809 | g29710 | i0 | 45.3 | 1.60674157303371 | 75 | 38 | 84.3 | 1 | 4 | 228 | 101 | 172 | MBI2435657.1 carboxypeptidase regulatory-like domain-containing protein [Candidatus Hydrogenedentota bacterium] | diamond | 429 | 70.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 23104384 | 23104384 | PRJNA1002570_P_NODE_18079_length_299_cov_1.362832_g17884_i0 | PRJNA1002570 | 18079 | 299 | 1.362832 | 4.07486768 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 162 | 7.01e-44 | NR | HOZ48842.1 | 2030809 | g17884 | i0 | 74.7 | 4.8561872909699 | 99 | 25 | 99.3 | 0 | 297 | 1 | 402 | 500 | HOZ48842.1 DEAD/DEAH box helicase family protein [Candidatus Hydrogenedentota bacterium] | diamond | 1452 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 27950494 | 27950494 | PRJNA1002570_P_NODE_41785_length_244_cov_0.900585_g41590_i0 | PRJNA1002570 | 41785 | 244 | 0.900585 | 2.1974274 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 67 | 6.2e-11 | NR | MCC6697220.1 | 2030809 | g41590 | i0 | 39.7 | 5.7172131147541 | 78 | 47 | 95.9 | 0 | 7 | 240 | 119 | 196 | MCC6697220.1 transglutaminase family protein [Candidatus Hydrogenedentota bacterium] | diamond | 1395 | 67 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 30950870 | 30950870 | PRJNA1002570_P_NODE_23574_length_283_cov_1.128571_g23379_i0 | PRJNA1002570 | 23574 | 283 | 1.128571 | 3.19385593 | Candidatus Abyssobacteria bacterium SURF_17 | 2093361 | Bacteria | Bacteria | 43.5 | 0.0291 | NR | RJP66264.1 | 2093361 | g23379 | i0 | 34.9 | 0.879858657243816 | 83 | 51 | 84.8 | 2 | 33 | 272 | 239 | 321 | RJP66264.1 MAG: epoxyqueuosine reductase [Candidatus Abyssobacteria bacterium SURF_17] | diamond | 249 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Abyssobacteria | Candidatus Abyssobacteria bacterium SURF_17 | ||||
| 31171582 | 31171582 | PRJNA1002570_P_NODE_19595_length_291_cov_2.752294_g19400_i0 | PRJNA1002570 | 19595 | 291 | 2.752294 | 8.00917554 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 43.1 | 0.0462 | NR | MCC6490754.1 | 2030809 | g19400 | i0 | 65.6 | 0.329896907216495 | 32 | 11 | 33 | 0 | 277 | 182 | 439 | 470 | MCC6490754.1 hypothetical protein [Candidatus Hydrogenedentota bacterium] | diamond | 96 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 32310972 | 32310972 | PRJNA1002570_P_NODE_36739_length_250_cov_1.305085_g36544_i0 | PRJNA1002570 | 36739 | 250 | 1.305085 | 3.2627125 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 75.5 | 1.26e-13 | NR | MBL7646019.1 | 2030809 | g36544 | i0 | 55.8 | 2.772 | 77 | 34 | 92.4 | 0 | 247 | 17 | 1471 | 1547 | MBL7646019.1 tandem-95 repeat protein [Candidatus Hydrogenedentota bacterium] | diamond | 693 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota 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);;