contig_metadata
10 rows where bioproject = "PRJNA382357", tax_clade = "PVC group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21477302 | 21477302 | PRJNA382357_P_NODE_95157_length_247_cov_5.150538_g94418_i0 | PRJNA382357 | 95157 | 247 | 5.150538 | 12.72182886 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 73.6 | 7.62e-15 | NR | MCG3176942.1 | 2035772 | g94418 | i0 | 96.9 | 0.388663967611336 | 32 | 1 | 38.9 | 0 | 180 | 85 | 1 | 32 | MCG3176942.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 96 | 73.6 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27137879 | 27137879 | PRJNA382357_P_NODE_74662_length_275_cov_2.439252_g73923_i0 | PRJNA382357 | 74662 | 275 | 2.439252 | 6.707943 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 58.9 | 1.12e-7 | NR | HOU36507.1 | 2035772 | g73923 | i0 | 58 | 1.63636363636364 | 50 | 21 | 54.5 | 0 | 157 | 8 | 578 | 627 | HOU36507.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 450 | 58.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27359767 | 27359767 | PRJNA382357_P_NODE_65043_length_292_cov_3.441558_g64304_i0 | PRJNA382357 | 65043 | 292 | 3.441558 | 10.04934936 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 100 | 8.97e-24 | NR | HAJ57042.1 | 2035772 | g64304 | i0 | 63.1 | 4.71575342465753 | 65 | 24 | 66.8 | 0 | 290 | 96 | 89 | 153 | HAJ57042.1 prolipoprotein diacylglyceryl transferase [Candidatus Omnitrophota bacterium] | diamond | 1377 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27391327 | 27391327 | PRJNA382357_P_NODE_19383_length_499_cov_5.958904_g18650_i0 | PRJNA382357 | 19383 | 499 | 5.958904 | 29.73493096 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 114 | 6.02e-26 | NR | MBI2095063.1 | 2035772 | g18650 | i0 | 50.5 | 0.619238476953908 | 103 | 51 | 61.9 | 0 | 186 | 494 | 564 | 666 | MBI2095063.1 DNA internalization-related competence protein ComEC/Rec2 [Candidatus Omnitrophota bacterium] | diamond | 309 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29081626 | 29081626 | PRJNA382357_P_NODE_35608_length_381_cov_3.762500_g34869_i0 | PRJNA382357 | 35608 | 381 | 3.7625 | 14.335125 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 199 | 1.6099999999999998e-56 | NR | PIQ84665.1 | 1974749 | g34869 | i0 | 84.6 | 2.47244094488189 | 104 | 16 | 81.9 | 0 | 365 | 54 | 555 | 658 | PIQ84665.1 MAG: hypothetical protein COV75_01110, partial [Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_0_20_63_9] | diamond | 942 | 201 | 0.990049751243781 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_0_20_63_9 | |||||
| 29695730 | 29695730 | PRJNA382357_P_NODE_79910_length_267_cov_1.262136_g79171_i0 | PRJNA382357 | 79910 | 267 | 1.262136 | 3.36990312 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 65.9 | 6.38e-11 | NR | MBU1125366.1 | 2035772 | g79171 | i0 | 73.3 | 1.02247191011236 | 45 | 12 | 50.6 | 0 | 136 | 2 | 36 | 80 | MBU1125366.1 16S rRNA (guanine(966)-N(2))-methyltransferase RsmD [Candidatus Omnitrophota bacterium] | diamond | 273 | 65.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31655200 | 31655200 | PRJNA382357_P_NODE_91677_length_251_cov_463.894737_g90938_i0 | PRJNA382357 | 91677 | 251 | 463.894737 | 1164.37578987 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 42.7 | 0.0316 | NR | MCG2704430.1 | 2035772 | g90938 | i0 | 37.9 | 0.693227091633466 | 58 | 31 | 63.3 | 1 | 48 | 206 | 66 | 123 | MCG2704430.1 flavodoxin family protein [Candidatus Omnitrophota bacterium] | diamond | 174 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31718555 | 31718555 | PRJNA382357_P_NODE_114157_length_228_cov_1.610778_g113418_i0 | PRJNA382357 | 114157 | 228 | 1.610778 | 3.67257384 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 53.1 | 1.74e-6 | NR | MBI3306512.1 | 2035772 | g113418 | i0 | 54.8 | 1.42105263157895 | 62 | 27 | 81.6 | 1 | 1 | 186 | 49 | 109 | MBI3306512.1 50S ribosomal protein L9 [Candidatus Omnitrophota bacterium] | diamond | 324 | 53.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32446537 | 32446537 | PRJNA382357_P_NODE_47779_length_335_cov_2.007299_g47040_i0 | PRJNA382357 | 47779 | 335 | 2.007299 | 6.72445165 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 95.9 | 4.6e-21 | NR | MDD4899485.1 | 2035772 | g47040 | i0 | 75 | 0.501492537313433 | 56 | 14 | 50.1 | 0 | 168 | 1 | 233 | 288 | MDD4899485.1 iron ABC transporter permease [Candidatus Omnitrophota bacterium] | diamond | 168 | 95.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32824742 | 32824742 | PRJNA382357_P_NODE_169140_length_174_cov_4.663717_g168401_i0 | PRJNA382357 | 169140 | 174 | 4.663717 | 8.11486758 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 45.4 | 0.0017 | NR | MDD4293891.1 | 2035772 | g168401 | i0 | 52.4 | 4.13793103448276 | 42 | 18 | 72.4 | 1 | 31 | 156 | 542 | 581 | MDD4293891.1 elongation factor G [Candidatus Omnitrophota bacterium] | diamond | 720 | 45.4 | 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);;