contig_metadata
11 rows where bioproject = "PRJNA799842", tax_phylum = "Armatimonadota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4621955 | 4621955 | PRJNA799842_P_NODE_146944_length_249_cov_0.875000_g145371_i0 | PRJNA799842 | 146944 | 249 | 0.875 | 2.17875 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 108 | 8.22e-29 | NR | MBS1715389.1 | 2033014 | g145371 | i0 | 75.6 | 0.987951807228916 | 82 | 20 | 98.8 | 0 | 248 | 3 | 11 | 92 | MBS1715389.1 plasmid stabilization protein [Armatimonadota bacterium] | diamond | 246 | 108 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 10147050 | 10147050 | PRJNA799842_P_NODE_112268_length_276_cov_1.630542_g110695_i0 | PRJNA799842 | 112268 | 276 | 1.630542 | 4.50029592 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 361 | 3.7099999999999996e-95 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g110695 | i0 | 90.217 | 600.18115942029 | 276 | 27 | 100 | 0 | 1 | 276 | 27541 | 27266 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 165650 | 361 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 10147970 | 10147970 | PRJNA799842_P_NODE_58968_length_370_cov_1.720539_g57395_i0 | PRJNA799842 | 58968 | 370 | 1.720539 | 6.3659943 | Chthonomonas | 1077265 | Bacteria | Bacteria | 320 | 8.73e-83 | NTclustered | gi|526641997|ref|NR_103994.1| | 454171 | g57395 | i0 | 82.574 | 42.3621621621622 | 373 | 56 | 100 | 8 | 1 | 370 | 1302 | 1668 | Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence | blastn | 15674 | 320 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 17372908 | 17372908 | PRJNA799842_P_NODE_25554_length_583_cov_1.562745_g24005_i0 | PRJNA799842 | 25554 | 583 | 1.562745 | 9.11080335 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 741 | 0 | NTclustered | gi|2076449834|gb|CP075365.1| | 2682144 | g24005 | i0 | 90.104 | 168.6243567753 | 576 | 50 | 98 | 7 | 1 | 573 | 1878945 | 1878374 | MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome | blastn | 98308 | 741 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29169963 | 29169963 | PRJNA799842_P_NODE_135729_length_251_cov_0.865169_g134156_i0 | PRJNA799842 | 135729 | 251 | 0.865169 | 2.17157419 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 152 | 3.33e-41 | NR | HET6455089.1 | 2033014 | g134156 | i0 | 86.7 | 0.99203187250996006 | 83 | 11 | 99.2 | 0 | 2 | 250 | 317 | 399 | HET6455089.1 FAD-binding protein [Armatimonadota bacterium] | diamond | 249 | 152 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29737920 | 29737920 | PRJNA799842_P_NODE_190050_length_241_cov_0.916667_g188477_i0 | PRJNA799842 | 190050 | 241 | 0.916667 | 2.20916747 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 75.5 | 3.99e-15 | NR | MEN6357581.1 | 2033014 | g188477 | i0 | 51.3 | 0.946058091286307 | 76 | 35 | 94.6 | 1 | 13 | 240 | 5 | 78 | MEN6357581.1 GNAT family N-acetyltransferase [Armatimonadota bacterium] | diamond | 228 | 75.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30180297 | 30180297 | PRJNA799842_P_NODE_141752_length_250_cov_0.870056_g140179_i0 | PRJNA799842 | 141752 | 250 | 0.870056 | 2.17514 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 77.4 | 1.97e-14 | NR | HZP80030.1 | 2739509 | g140179 | i0 | 39.8 | 0.996 | 83 | 50 | 99.6 | 0 | 250 | 2 | 295 | 377 | HZP80030.1 copper amine oxidase N-terminal domain-containing protein [Chthonomonadaceae bacterium] | diamond | 249 | 77.4 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 30947880 | 30947880 | PRJNA799842_P_NODE_135334_length_251_cov_0.865169_g133761_i0 | PRJNA799842 | 135334 | 251 | 0.865169 | 2.17157419 | PVC group | 1783257 | Bacteria | Bacteria | 102 | 3.9599999999999997e-23 | NR | HTE21207.1 | 2033014 | g133761 | i0 | 62.5 | 3.81274900398406 | 80 | 30 | 95.6 | 0 | 12 | 251 | 486 | 565 | HTE21207.1 DUF1549 domain-containing protein [Armatimonadota bacterium] | diamond | 957 | 102 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31476241 | 31476241 | PRJNA799842_P_NODE_168316_length_245_cov_0.895349_g166743_i0 | PRJNA799842 | 168316 | 245 | 0.895349 | 2.19360505 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 51.2 | 1.2e-5 | NR | HEX2999303.1 | 2033014 | g166743 | i0 | 58.8 | 1.73877551020408 | 34 | 14 | 41.6 | 0 | 6 | 107 | 114 | 147 | HEX2999303.1 HD domain-containing protein [Armatimonadota bacterium] | diamond | 426 | 51.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31476256 | 31476256 | PRJNA799842_P_NODE_36636_length_474_cov_1.152120_g35065_i0 | PRJNA799842 | 36636 | 474 | 1.15212 | 5.4610488 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 139 | 1.78e-38 | NR | MBC8102672.1 | 2033014 | g35065 | i0 | 45.9 | 6.17088607594937 | 135 | 73 | 85.4 | 0 | 36 | 440 | 21 | 155 | MBC8102672.1 pyridoxamine 5'-phosphate oxidase family protein [Armatimonadota bacterium] | diamond | 2925 | 139 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32772110 | 32772110 | PRJNA799842_P_NODE_141740_length_250_cov_0.870056_g140167_i0 | PRJNA799842 | 141740 | 250 | 0.870056 | 2.17514 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 116 | 4.2e-28 | NR | MCB8932034.1 | 2739509 | g140167 | i0 | 63.9 | 0.996 | 83 | 30 | 99.6 | 0 | 2 | 250 | 5 | 87 | MCB8932034.1 alpha-mannosidase [Chthonomonadaceae bacterium] | diamond | 249 | 116 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae 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);;