contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA599026" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27111346 | 27111346 | PRJNA599026_S_NODE_61822_length_164_cov_0.886957_g61366_i0 | PRJNA599026 | 61822 | 164 | 0.886957 | 1.45460948 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 41.6 | 0.029 | NR | MFM9874552.1 | 2682144 | g61366 | i0 | 54.8 | 2.43292682926829 | 31 | 14 | 56.7 | 0 | 69 | 161 | 34 | 64 | MFM9874552.1 peptide-methionine (S)-S-oxide reductase MsrA [Fimbriimonadaceae bacterium] | diamond | 399 | 41.6 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 27553558 | 27553558 | PRJNA599026_S_NODE_54964_length_166_cov_0.871795_g54508_i0 | PRJNA599026 | 54964 | 166 | 0.871795 | 1.4471797 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 63.9 | 4.4e-10 | NR | MBC8104559.1 | 2033014 | g54508 | i0 | 89.7 | 0.704819277108434 | 39 | 4 | 70.5 | 0 | 49 | 165 | 15 | 53 | MBC8104559.1 (2Fe-2S)-binding protein [Armatimonadota bacterium] | diamond | 117 | 63.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27725402 | 27725402 | PRJNA599026_S_NODE_2844_length_564_cov_3.681553_g2414_i0 | PRJNA599026 | 2844 | 564 | 3.681553 | 20.76395892 | Bacteria | 2 | Bacteria | Bacteria | 77.4 | 7.83e-13 | NR | MBS1722917.1 | 2033014 | g2414 | i0 | 61.5 | 1.38829787234043 | 52 | 20 | 27.7 | 0 | 338 | 493 | 432 | 483 | MBS1722917.1 MmgE/PrpD family protein [Armatimonadota bacterium] | diamond | 783 | 77.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28501135 | 28501135 | PRJNA599026_S_NODE_61187_length_164_cov_0.886957_g60731_i0 | PRJNA599026 | 61187 | 164 | 0.886957 | 1.45460948 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 81.3 | 4.63e-17 | NR | MBW3622093.1 | 2033014 | g60731 | i0 | 87.2 | 0.859756097560976 | 47 | 6 | 86 | 0 | 23 | 163 | 1 | 47 | MBW3622093.1 response regulator transcription factor [Armatimonadota bacterium] | diamond | 141 | 81.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29038040 | 29038040 | PRJNA599026_S_NODE_53848_length_166_cov_0.871795_g53392_i0 | PRJNA599026 | 53848 | 166 | 0.871795 | 1.4471797 | Capsulimonadales bacterium | 2971800 | Bacteria | Bacteria | 77.4 | 7.78e-15 | NR | MDX1933915.1 | 2971800 | g53392 | i0 | 75.9 | 0.975903614457831 | 54 | 13 | 97.6 | 0 | 2 | 163 | 311 | 364 | MDX1933915.1 hypothetical protein [Capsulimonadales bacterium] | diamond | 162 | 77.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadales bacterium | ||||
| 29100989 | 29100989 | PRJNA599026_S_NODE_10008_length_309_cov_1.900000_g9552_i0 | PRJNA599026 | 10008 | 309 | 1.9 | 5.871 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 95.1 | 2.42e-20 | NR | MFN8219467.1 | 2682145 | g9552 | i0 | 86.7 | 0.883495145631068 | 45 | 6 | 43.7 | 0 | 86 | 220 | 357 | 401 | MFN8219467.1 deoxyribodipyrimidine photo-lyase [Fimbriimonadales bacterium] | diamond | 273 | 95.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 29763799 | 29763799 | PRJNA599026_S_NODE_28451_length_205_cov_1.878205_g27995_i0 | PRJNA599026 | 28451 | 205 | 1.878205 | 3.8503202500000002 | Chthonomonadales bacterium | 2282151 | Bacteria | Bacteria | 45.1 | 0.00339 | NR | MCW3053210.1 | 2282151 | g27995 | i0 | 36.1 | 0.892682926829268 | 61 | 39 | 89.3 | 0 | 22 | 204 | 260 | 320 | MCW3053210.1 phospholipase nuclease protein [Chthonomonadales bacterium] | diamond | 183 | 45.1 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadales bacterium | ||||
| 31216921 | 31216921 | PRJNA599026_S_NODE_46535_length_172_cov_1.243902_g46079_i0 | PRJNA599026 | 46535 | 172 | 1.243902 | 2.13951144 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 47.8 | 2.15e-4 | NR | MCW3097804.1 | 2739509 | g46079 | i0 | 51.9 | 1.86627906976744 | 52 | 24 | 90.7 | 1 | 1 | 156 | 60 | 110 | MCW3097804.1 family channel protein [Chthonomonadaceae bacterium] | diamond | 321 | 47.8 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 31375586 | 31375586 | PRJNA599026_S_NODE_51076_length_167_cov_0.864407_g50620_i0 | PRJNA599026 | 51076 | 167 | 0.864407 | 1.44355969 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 75.9 | 2.11e-14 | NR | MBW3636219.1 | 2033014 | g50620 | i0 | 66 | 0.952095808383233 | 53 | 17 | 95.2 | 1 | 167 | 9 | 238 | 289 | MBW3636219.1 ABC transporter ATP-binding protein [Armatimonadota bacterium] | diamond | 159 | 75.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31438643 | 31438643 | PRJNA599026_S_NODE_66676_length_162_cov_0.902655_g66220_i0 | PRJNA599026 | 66676 | 162 | 0.902655 | 1.4623011 | Armatimonadaceae bacterium | 2933160 | Bacteria | Bacteria | 87 | 3e-18 | NR | HVK06663.1 | 2933160 | g66220 | i0 | 73.6 | 0.981481481481482 | 53 | 14 | 98.1 | 0 | 3 | 161 | 793 | 845 | HVK06663.1 glycoside hydrolase family 38 C-terminal domain-containing protein [Armatimonadaceae bacterium] | diamond | 159 | 87 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonadaceae bacterium | |||
| 31547133 | 31547133 | PRJNA599026_S_NODE_24756_length_215_cov_2.162651_g24300_i0 | PRJNA599026 | 24756 | 215 | 2.162651 | 4.64969965 | Bacteria | 2 | Bacteria | Bacteria | 107 | 4.7100000000000006e-27 | NR | MEZ0324280.1 | 1936159 | g24300 | i0 | 94.5 | 1.53488372093023 | 55 | 3 | 76.7 | 0 | 167 | 3 | 1 | 55 | MEZ0324280.1 PIN domain-containing protein [Fimbriimonas sp.] | diamond | 330 | 108 | 0.990740740740741 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. |
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);;