contig_metadata
6 rows where bioproject = "PRJNA515078", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26649230 | 26649230 | PRJNA515078_P_NODE_18321_length_203_cov_1.409639_g18088_i0 | PRJNA515078 | 18321 | 203 | 1.409639 | 2.86156717 | Armatimonadota | 67819 | Bacteria | Bacteria | 65.9 | 9.78e-11 | NR | HXG23262.1 | 2282151 | g18088 | i0 | 43.3 | 6.82758620689655 | 67 | 38 | 99 | 0 | 201 | 1 | 80 | 146 | HXG23262.1 S1/P1 nuclease [Chthonomonadales bacterium] | diamond | 1386 | 65.9 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 26760554 | 26760554 | PRJNA515078_P_NODE_11921_length_258_cov_1.687783_g11688_i0 | PRJNA515078 | 11921 | 258 | 1.687783 | 4.35448014 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 73.2 | 1.01e-14 | NR | MBX3097920.1 | 2682144 | g11688 | i0 | 62.9 | 0.720930232558139 | 62 | 20 | 68.6 | 2 | 181 | 5 | 18 | 79 | MBX3097920.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 186 | 73.2 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29382472 | 29382472 | PRJNA515078_P_NODE_7749_length_331_cov_2.653061_g7516_i0 | PRJNA515078 | 7749 | 331 | 2.653061 | 8.78163191 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 50.4 | 1.89e-5 | NR | MBX3097920.1 | 2682144 | g7516 | i0 | 76.5 | 0.308157099697885 | 34 | 6 | 29 | 1 | 330 | 235 | 53 | 86 | MBX3097920.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 102 | 50.4 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29524132 | 29524132 | PRJNA515078_P_NODE_10810_length_273_cov_2.372881_g10577_i0 | PRJNA515078 | 10810 | 273 | 2.372881 | 6.47796513 | FCB group | 1783270 | Bacteria | Bacteria | 64.3 | 8.39e-10 | NR | MEZ0327545.1 | 1936159 | g10577 | i0 | 43.1 | 11.3406593406593 | 65 | 36 | 70.3 | 1 | 271 | 80 | 70 | 134 | MEZ0327545.1 hypothetical protein [Fimbriimonas sp.] | diamond | 3096 | 64.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 30867005 | 30867005 | PRJNA515078_P_NODE_24474_length_175_cov_2.268116_g24241_i0 | PRJNA515078 | 24474 | 175 | 2.268116 | 3.969203 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 41.6 | 0.0387 | NR | MBX3113767.1 | 2682144 | g24241 | i0 | 36.8 | 0.977142857142857 | 57 | 32 | 90.9 | 1 | 168 | 10 | 70 | 126 | MBX3113767.1 NADH:flavin oxidoreductase/NADH oxidase [Fimbriimonadaceae bacterium] | diamond | 171 | 41.6 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 31752188 | 31752188 | PRJNA515078_P_NODE_12657_length_250_cov_1.098592_g12424_i0 | PRJNA515078 | 12657 | 250 | 1.098592 | 2.74648 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 61.6 | 1.23e-10 | NR | MBX3097919.1 | 2682144 | g12424 | i0 | 55.1 | 0.588 | 49 | 22 | 58.8 | 0 | 8 | 154 | 1 | 49 | MBX3097919.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 147 | 61.6 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae 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);;