contig_metadata
13 rows where bioproject = "PRJNA561138" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15848079 | 15848079 | PRJNA561138_P_NODE_9973_length_405_cov_0.927711_g9778_i0 | PRJNA561138 | 9973 | 405 | 0.927711 | 3.75722955 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 153 | 8.01e-42 | NR | MCW5936656.1 | 2682144 | g9778 | i0 | 65.4 | 0.985185185185185 | 133 | 46 | 98.5 | 0 | 401 | 3 | 204 | 336 | MCW5936656.1 competence/damage-inducible protein A [Fimbriimonadaceae bacterium] | diamond | 399 | 153 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 19671445 | 19671445 | PRJNA561138_P_NODE_11276_length_385_cov_0.987179_g11081_i0 | PRJNA561138 | 11276 | 385 | 0.987179 | 3.80063915 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 190 | 4.7799999999999996e-54 | NR | MBX3095578.1 | 2682144 | g11081 | i0 | 72.9 | 1.00519480519481 | 129 | 34 | 99.7 | 1 | 384 | 1 | 420 | 548 | MBX3095578.1 type IIA DNA topoisomerase subunit B [Fimbriimonadaceae bacterium] | diamond | 387 | 190 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 26618169 | 26618169 | PRJNA561138_P_NODE_11361_length_384_cov_0.990354_g11166_i0 | PRJNA561138 | 11361 | 384 | 0.990354 | 3.80295936 | Bacteria | 2 | Bacteria | Bacteria | 137 | 1.73e-39 | NR | MBS1724622.1 | 2033014 | g11166 | i0 | 70.5 | 6.4296875 | 88 | 26 | 68.8 | 0 | 113 | 376 | 3 | 90 | MBS1724622.1 30S ribosomal protein S6 [Armatimonadota bacterium] | diamond | 2469 | 138 | 0.992753623188406 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26920891 | 26920891 | PRJNA561138_P_NODE_11062_length_388_cov_0.977778_g10867_i0 | PRJNA561138 | 11062 | 388 | 0.977778 | 3.79377864 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 160 | 1.81e-44 | NR | MDH4388776.1 | 1936159 | g10867 | i0 | 58.6 | 2.05670103092783 | 133 | 51 | 99.7 | 1 | 1 | 387 | 221 | 353 | MDH4388776.1 family 16 glycosylhydrolase [Fimbriimonas sp.] | diamond | 798 | 160 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 27931926 | 27931926 | PRJNA561138_P_NODE_18825_length_300_cov_1.017621_g18630_i0 | PRJNA561138 | 18825 | 300 | 1.017621 | 3.052863 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 80.1 | 4.98e-15 | NR | MCG9895705.1 | 2682144 | g18630 | i0 | 48.3 | 0.87 | 87 | 45 | 87 | 0 | 40 | 300 | 196 | 282 | MCG9895705.1 phosphodiester glycosidase family protein [Fimbriimonadaceae bacterium] | diamond | 261 | 80.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 28215828 | 28215828 | PRJNA561138_P_NODE_14486_length_344_cov_1.136531_g14291_i0 | PRJNA561138 | 14486 | 344 | 1.136531 | 3.90966664 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 194 | 1.01e-58 | NR | MCG9894575.1 | 2682144 | g14291 | i0 | 86.8 | 0.994186046511628 | 114 | 15 | 99.4 | 0 | 1 | 342 | 199 | 312 | MCG9894575.1 BMP family ABC transporter substrate-binding protein [Fimbriimonadaceae bacterium] | diamond | 342 | 194 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29763040 | 29763040 | PRJNA561138_P_NODE_11511_length_382_cov_0.996764_g11316_i0 | PRJNA561138 | 11511 | 382 | 0.996764 | 3.80763848 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 111 | 1.73e-25 | NR | WP_084179588.1 | 1005039 | g11316 | i0 | 45.4 | 1.87696335078534 | 119 | 65 | 93.5 | 0 | 21 | 377 | 394 | 512 | WP_084179588.1 3-hydroxyacyl-CoA dehydrogenase/enoyl-CoA hydratase family protein [Fimbriimonas ginsengisoli] | diamond | 717 | 111 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 30363865 | 30363865 | PRJNA561138_P_NODE_9812_length_407_cov_1.152695_g9617_i0 | PRJNA561138 | 9812 | 407 | 1.152695 | 4.69146865 | Chthonomonas sp. | 2282153 | Bacteria | Bacteria | 71.6 | 1.44e-11 | NR | MBL8047377.1 | 2282153 | g9617 | i0 | 36.1 | 0.877149877149877 | 119 | 76 | 87.7 | 0 | 3 | 359 | 131 | 249 | MBL8047377.1 tetratricopeptide repeat protein [Chthonomonas sp.] | diamond | 357 | 71.6 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas sp. | ||
| 31216110 | 31216110 | PRJNA561138_P_NODE_2895_length_727_cov_1.048930_g2714_i0 | PRJNA561138 | 2895 | 727 | 1.04893 | 7.6257211 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 194 | 5.71e-58 | NR | MBM3472706.1 | 2033014 | g2714 | i0 | 64.9 | 1.12654745529574 | 134 | 47 | 55.3 | 0 | 83 | 484 | 97 | 230 | MBM3472706.1 hypothetical protein [Armatimonadota bacterium] | diamond | 819 | 194 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31596310 | 31596310 | PRJNA561138_P_NODE_6836_length_475_cov_0.957711_g6642_i0 | PRJNA561138 | 6836 | 475 | 0.957711 | 4.54912725 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 101 | 2.3699999999999998e-23 | NR | MCU0316661.1 | 2682144 | g6642 | i0 | 44.4 | 1.61684210526316 | 126 | 69 | 79.6 | 1 | 381 | 4 | 4 | 128 | MCU0316661.1 DNA repair protein RadC [Fimbriimonadaceae bacterium] | diamond | 768 | 101 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 31659141 | 31659141 | PRJNA561138_P_NODE_11217_length_386_cov_0.907348_g11022_i0 | PRJNA561138 | 11217 | 386 | 0.907348 | 3.50236328 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 148 | 7.73e-41 | NR | MFI5386885.1 | 2682145 | g11022 | i0 | 57.7 | 0.955958549222798 | 123 | 52 | 95.6 | 0 | 1 | 369 | 199 | 321 | MFI5386885.1 mevalonate kinase [Fimbriimonadales bacterium] | diamond | 369 | 148 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 32038988 | 32038988 | PRJNA561138_P_NODE_12178_length_373_cov_1.023333_g11983_i0 | PRJNA561138 | 12178 | 373 | 1.023333 | 3.81703209 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 176 | 2.99e-51 | NR | MBS1722963.1 | 2033014 | g11983 | i0 | 71.3 | 0.981233243967828 | 122 | 35 | 98.1 | 0 | 1 | 366 | 97 | 218 | MBS1722963.1 site-specific integrase [Armatimonadota bacterium] | diamond | 366 | 176 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32324067 | 32324067 | PRJNA561138_P_NODE_17679_length_311_cov_0.970588_g17484_i0 | PRJNA561138 | 17679 | 311 | 0.970588 | 3.01852868 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 109 | 2.66e-28 | NR | MCG9895400.1 | 2682144 | g17484 | i0 | 62.6 | 0.954983922829582 | 99 | 37 | 95.5 | 0 | 15 | 311 | 12 | 110 | MCG9895400.1 NADH-quinone oxidoreductase subunit K [Fimbriimonadaceae bacterium] | diamond | 297 | 109 | 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);;