contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA939415" and tax_phylum = "Candidatus Omnitrophota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2191570 | 2191570 | PRJNA939415_P_NODE_78802_length_255_cov_2.439560_g78380_i0 | PRJNA939415 | 78802 | 255 | 2.43956 | 6.220878 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 132 | 4.32e-34 | NR | MEI8344773.1 | 2035772 | g78380 | i0 | 76.8 | 24.4352941176471 | 82 | 19 | 96.5 | 0 | 248 | 3 | 232 | 313 | MEI8344773.1 magnesium-translocating P-type ATPase [Candidatus Omnitrophota bacterium] | diamond | 6231 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 26835390 | 26835390 | PRJNA939415_P_NODE_82581_length_251_cov_3.168539_g82159_i0 | PRJNA939415 | 82581 | 251 | 3.168539 | 7.95303289 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 43.1 | 0.00995 | NR | MBI4388134.1 | 2035772 | g82159 | i0 | 70.8 | 0.525896414342629 | 24 | 7 | 28.7 | 0 | 73 | 2 | 4 | 27 | MBI4388134.1 4a-hydroxytetrahydrobiopterin dehydratase [Candidatus Omnitrophota bacterium] | diamond | 132 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27151133 | 27151133 | PRJNA939415_P_NODE_90322_length_245_cov_2.453488_g89900_i0 | PRJNA939415 | 90322 | 245 | 2.453488 | 6.0110456 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 156 | 2.69e-46 | NR | MCL5098903.1 | 2035772 | g89900 | i0 | 84 | 0.991836734693878 | 81 | 13 | 99.2 | 0 | 2 | 244 | 70 | 150 | MCL5098903.1 DUF2490 domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 243 | 156 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29361933 | 29361933 | PRJNA939415_P_NODE_110669_length_203_cov_7.284615_g110247_i0 | PRJNA939415 | 110669 | 203 | 7.284615 | 14.78776845 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 52 | 1.15e-5 | NR | MFA5340053.1 | 2035772 | g110247 | i0 | 40.6 | 0.945812807881773 | 64 | 38 | 94.6 | 0 | 2 | 193 | 161 | 224 | MFA5340053.1 Gfo/Idh/MocA family oxidoreductase [Candidatus Omnitrophota bacterium] | diamond | 192 | 52 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29393552 | 29393552 | PRJNA939415_P_NODE_100489_length_234_cov_2.677019_g100067_i0 | PRJNA939415 | 100489 | 234 | 2.677019 | 6.26422446 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 92.4 | 6.83e-20 | NR | MDP2939829.1 | 2035772 | g100067 | i0 | 52 | 0.961538461538462 | 75 | 36 | 96.2 | 0 | 3 | 227 | 74 | 148 | MDP2939829.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 225 | 92.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29652695 | 29652695 | PRJNA939415_P_NODE_27510_length_310_cov_3.962025_g27088_i0 | PRJNA939415 | 27510 | 310 | 3.962025 | 12.2822775 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 44.7 | 0.014 | NR | MBI3315360.1 | 2035772 | g27088 | i0 | 53.7 | 0.919354838709677 | 41 | 15 | 39.7 | 1 | 1 | 123 | 204 | 240 | MBI3315360.1 DUF268 domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 285 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29968836 | 29968836 | PRJNA939415_P_NODE_60831_length_273_cov_1.720000_g60409_i0 | PRJNA939415 | 60831 | 273 | 1.72 | 4.6956 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 146 | 4.94e-39 | NR | MBI4970596.1 | 2035772 | g60409 | i0 | 78.7 | 6.85714285714286 | 89 | 19 | 97.8 | 0 | 3 | 269 | 212 | 300 | MBI4970596.1 efflux RND transporter permease subunit [Candidatus Omnitrophota bacterium] | diamond | 1872 | 146 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31454248 | 31454248 | PRJNA939415_P_NODE_90176_length_245_cov_2.982558_g89754_i0 | PRJNA939415 | 90176 | 245 | 2.982558 | 7.3072671 | Bacteria | 2 | Bacteria | Bacteria | 96.3 | 1.5e-23 | NR | PIQ84638.1 | 1974749 | g89754 | i0 | 56.3 | 1.97142857142857 | 80 | 34 | 96.7 | 1 | 242 | 6 | 7 | 86 | PIQ84638.1 MAG: hypothetical protein COV75_01170 [Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_0_20_63_9] | diamond | 483 | 97.1 | 0.991761071060762 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_0_20_63_9 | |||||
| 31921654 | 31921654 | PRJNA939415_P_NODE_83757_length_250_cov_3.401130_g83335_i0 | PRJNA939415 | 83757 | 250 | 3.40113 | 8.502825 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 78.6 | 1.69e-15 | NR | HOU37218.1 | 2035772 | g83335 | i0 | 65 | 0.72 | 60 | 21 | 72 | 0 | 191 | 12 | 1 | 60 | HOU37218.1 OmpA family protein [Candidatus Omnitrophota bacterium] | diamond | 180 | 78.6 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32301664 | 32301664 | PRJNA939415_P_NODE_38339_length_296_cov_5.179372_g37917_i0 | PRJNA939415 | 38339 | 296 | 5.179372 | 15.33094112 | Omnitrophica WOR_2 bacterium SM23_29 | 1703776 | Bacteria | Bacteria | 53.5 | 7.01e-7 | NR | KPK39610.1 | 1703776 | g37917 | i0 | 40.6 | 2.08783783783784 | 64 | 38 | 64.9 | 0 | 14 | 205 | 17 | 80 | KPK39610.1 MAG: hypothetical protein AMJ78_08260 [Omnitrophica WOR_2 bacterium SM23_29] | diamond | 618 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica WOR_2 bacterium SM23_29 | |||||
| 32844764 | 32844764 | PRJNA939415_P_NODE_34680_length_309_cov_3.228814_g34258_i0 | PRJNA939415 | 34680 | 309 | 3.228814 | 9.97703526 | Bacteria | 2 | Bacteria | Bacteria | 95.9 | 3.04e-22 | NR | HDZ77118.1 | 2035772 | g34258 | i0 | 44.1 | 2.46601941747573 | 93 | 49 | 87.4 | 1 | 38 | 307 | 78 | 170 | HDZ77118.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 762 | 95.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota 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);;