contig_metadata
5 rows where bioproject = "PRJNA438111", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15737262 | 15737262 | PRJNA438111_P_NODE_74513_length_161_cov_7.189394_g73888_i0 | PRJNA438111 | 74513 | 161 | 7.189394 | 11.57492434 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 68.6 | 9.28e-12 | NR | MBU1864323.1 | 2035772 | g73888 | i0 | 78.6 | 0.782608695652174 | 42 | 9 | 78.3 | 0 | 34 | 159 | 11 | 52 | MBU1864323.1 3-phosphoshikimate 1-carboxyvinyltransferase [Candidatus Omnitrophota bacterium] | diamond | 126 | 68.6 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 25317027 | 25317027 | PRJNA438111_P_NODE_82080_length_156_cov_3.354331_g81455_i0 | PRJNA438111 | 82080 | 156 | 3.354331 | 5.23275636 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 86.3 | 9.38e-19 | NR | HRY86190.1 | 2035772 | g81455 | i0 | 74.5 | 1.96153846153846 | 51 | 13 | 98.1 | 0 | 2 | 154 | 145 | 195 | HRY86190.1 MBL fold metallo-hydrolase [Candidatus Omnitrophota bacterium] | diamond | 306 | 86.3 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28939299 | 28939299 | PRJNA438111_P_NODE_83028_length_155_cov_5.246032_g82403_i0 | PRJNA438111 | 83028 | 155 | 5.246032 | 8.1313496 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 78.2 | 3.57e-15 | NR | HAM40605.1 | 2035772 | g82403 | i0 | 70.2 | 0.909677419354839 | 47 | 14 | 91 | 0 | 15 | 155 | 46 | 92 | HAM40605.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 141 | 78.2 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30012893 | 30012893 | PRJNA438111_P_NODE_48031_length_184_cov_1.812903_g47406_i0 | PRJNA438111 | 48031 | 184 | 1.812903 | 3.33574152 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 85.9 | 1.04e-17 | NR | MFH1208801.1 | 2035772 | g47406 | i0 | 68.3 | 0.978260869565217 | 60 | 19 | 97.8 | 0 | 3 | 182 | 244 | 303 | MFH1208801.1 PD-(D/E)XK nuclease family protein [Candidatus Omnitrophota bacterium] | diamond | 180 | 85.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30265778 | 30265778 | PRJNA438111_P_NODE_17552_length_253_cov_3.857143_g16927_i0 | PRJNA438111 | 17552 | 253 | 3.857143 | 9.75857179 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 47 | 0.00128 | NR | MFH1441683.1 | 2035772 | g16927 | i0 | 46.2 | 3.54545454545455 | 52 | 28 | 61.7 | 0 | 161 | 6 | 329 | 380 | MFH1441683.1 hexokinase [Candidatus Omnitrophota bacterium] | diamond | 897 | 47 | 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);;