contig_metadata
7 rows where bioproject = "PRJNA884104", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23813389 | 23813389 | PRJNA884104_S_NODE_60999_length_267_cov_1.628866_g60256_i0 | PRJNA884104 | 60999 | 267 | 1.628866 | 4.34907222 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 145 | 3.03e-39 | NR | MCK4917309.1 | 2035772 | g60256 | i0 | 75 | 9.80898876404494 | 88 | 22 | 98.9 | 0 | 3 | 266 | 299 | 386 | MCK4917309.1 adenosylhomocysteinase [Candidatus Omnitrophota bacterium] | diamond | 2619 | 145 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27844950 | 27844950 | PRJNA884104_S_NODE_36304_length_342_cov_0.858736_g35561_i0 | PRJNA884104 | 36304 | 342 | 0.858736 | 2.93687712 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 57.4 | 9.03e-7 | NR | MFH1846268.1 | 2035772 | g35561 | i0 | 33.7 | 1.68421052631579 | 95 | 61 | 81.6 | 1 | 12 | 290 | 1373 | 1467 | MFH1846268.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 576 | 57.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28223853 | 28223853 | PRJNA884104_S_NODE_81846_length_243_cov_1.811765_g81103_i0 | PRJNA884104 | 81846 | 243 | 1.811765 | 4.40258895 | Candidatus Kaelpia aquatica | 3041137 | Bacteria | Bacteria | 82 | 3.17e-18 | NR | MDP8253302.1 | 3041137 | g81103 | i0 | 66.7 | 0.666666666666667 | 54 | 18 | 66.7 | 0 | 55 | 216 | 27 | 80 | MDP8253302.1 30S ribosomal protein S19 [Candidatus Kaelpia aquatica] | diamond | 162 | 82 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Kaelpia | Candidatus Kaelpia aquatica | ||||
| 29052970 | 29052970 | PRJNA884104_S_NODE_18408_length_469_cov_3.257576_g17666_i0 | PRJNA884104 | 18408 | 469 | 3.257576 | 15.27803144 | root | 1 | Root_unresolved | Root_unresolved | 62.4 | 1.72e-8 | NR | MBU1999046.1 | 2035772 | g17666 | i0 | 34.1 | 1.01066098081023 | 82 | 52 | 51.2 | 1 | 248 | 9 | 1 | 82 | MBU1999046.1 MEDS domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 474 | 62.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29960622 | 29960622 | PRJNA884104_S_NODE_41491_length_322_cov_1.008032_g40748_i0 | PRJNA884104 | 41491 | 322 | 1.008032 | 3.24586304 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 45.8 | 0.007 | NR | MEW6101200.1 | 2035772 | g40748 | i0 | 40 | 0.512422360248447 | 55 | 32 | 50.3 | 1 | 296 | 135 | 329 | 383 | MEW6101200.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 165 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30790017 | 30790017 | PRJNA884104_S_NODE_63774_length_261_cov_1.228723_g63031_i0 | PRJNA884104 | 63774 | 261 | 1.228723 | 3.20696703 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 75.1 | 1.93e-13 | NR | MBN1872362.1 | 2035772 | g63031 | i0 | 48.1 | 3.81609195402299 | 81 | 42 | 93.1 | 0 | 258 | 16 | 507 | 587 | MBN1872362.1 molecular chaperone DnaK [Candidatus Omnitrophota bacterium] | diamond | 996 | 75.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31698970 | 31698970 | PRJNA884104_S_NODE_73537_length_248_cov_1.217143_g72794_i0 | PRJNA884104 | 73537 | 248 | 1.217143 | 3.01851464 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 48.1 | 5.17e-4 | NR | MFH1046421.1 | 2035772 | g72794 | i0 | 36.4 | 0.798387096774194 | 66 | 42 | 79.8 | 0 | 224 | 27 | 1991 | 2056 | MFH1046421.1 LamG-like jellyroll fold domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 198 | 48.1 | 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);;