contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA909412" and tax_phylum = "Planctomycetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16551671 | 16551671 | PRJNA909412_P_NODE_1353_length_474_cov_3.337931_g1214_i0 | PRJNA909412 | 1353 | 474 | 3.337931 | 15.82179294 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 241 | 1.05e-74 | NR | NUQ35036.1 | 2026779 | g1214 | i0 | 64.6 | 5.6075949367088596 | 178 | 41 | 98.7 | 1 | 2 | 469 | 97 | 274 | NUQ35036.1 adenosylhomocysteinase [Planctomycetaceae bacterium] | diamond | 2658 | 241 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 26897966 | 26897966 | PRJNA909412_P_NODE_13481_length_160_cov_2.851240_g13340_i0 | PRJNA909412 | 13481 | 160 | 2.85124 | 4.561984 | Planctomycetaceae bacterium | 2026779 | Bacteria | Bacteria | 50.4 | 2.23e-5 | NR | MCE5340208.1 | 2026779 | g13340 | i0 | 47.4 | 2.1375 | 57 | 25 | 97.5 | 1 | 3 | 158 | 828 | 884 | MCE5340208.1 translation initiation factor IF-2 [Planctomycetaceae bacterium] | diamond | 342 | 50.4 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Planctomycetales | Planctomycetaceae | Planctomycetaceae bacterium | ||
| 27118987 | 27118987 | PRJNA909412_P_NODE_16222_length_152_cov_2.123894_g16081_i0 | PRJNA909412 | 16222 | 152 | 2.123894 | 3.22831888 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 90.5 | 9.5e-20 | NR | MCI0362746.1 | 2052180 | g16081 | i0 | 85.1 | 10.1052631578947 | 47 | 7 | 92.8 | 0 | 11 | 151 | 151 | 197 | MCI0362746.1 MmgE/PrpD family protein [Phycisphaerales bacterium] | diamond | 1536 | 90.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 29203609 | 29203609 | PRJNA909412_P_NODE_12169_length_163_cov_2.016129_g12028_i0 | PRJNA909412 | 12169 | 163 | 2.016129 | 3.28629027 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 80.5 | 5.94e-16 | NR | MBM3984144.1 | 2026780 | g12028 | i0 | 73.5 | 7.38036809815951 | 49 | 13 | 90.2 | 0 | 154 | 8 | 302 | 350 | MBM3984144.1 M20/M25/M40 family metallo-hydrolase [Planctomycetota bacterium] | diamond | 1203 | 80.5 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31478324 | 31478324 | PRJNA909412_P_NODE_3816_length_269_cov_1.073913_g3675_i0 | PRJNA909412 | 3816 | 269 | 1.073913 | 2.88882597 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 83.2 | 4.8e-17 | NR | MCB9913063.1 | 2026780 | g3675 | i0 | 55.7 | 2.63197026022305 | 79 | 34 | 88.1 | 1 | 267 | 31 | 171 | 248 | MCB9913063.1 SDR family oxidoreductase [Planctomycetota bacterium] | diamond | 708 | 83.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 31699578 | 31699578 | PRJNA909412_P_NODE_11217_length_171_cov_1.727273_g11076_i0 | PRJNA909412 | 11217 | 171 | 1.727273 | 2.95363683 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 41.2 | 0.0498 | NR | HZW05812.1 | 2052180 | g11076 | i0 | 50 | 0.631578947368421 | 36 | 14 | 56.1 | 1 | 52 | 147 | 40 | 75 | HZW05812.1 class I SAM-dependent methyltransferase [Phycisphaerales bacterium] | diamond | 108 | 41.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 32015861 | 32015861 | PRJNA909412_P_NODE_4978_length_234_cov_1.487179_g4837_i0 | PRJNA909412 | 4978 | 234 | 1.487179 | 3.47999886 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 71.2 | 3.05e-12 | NR | PCH78894.1 | 2026780 | g4837 | i0 | 46.7 | 0.961538461538462 | 75 | 40 | 96.2 | 0 | 234 | 10 | 545 | 619 | PCH78894.1 MAG: hypothetical protein COB96_04960 [Planctomycetota bacterium] | diamond | 225 | 71.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 32079118 | 32079118 | PRJNA909412_P_NODE_9478_length_174_cov_2.681481_g9337_i0 | PRJNA909412 | 9478 | 174 | 2.681481 | 4.66577694 | Phycisphaerales bacterium | 2052180 | Bacteria | Bacteria | 49.3 | 7.01e-5 | NR | MCH2162015.1 | 2052180 | g9337 | i0 | 40 | 1.86206896551724 | 55 | 31 | 91.4 | 1 | 8 | 166 | 359 | 413 | MCH2162015.1 MmgE/PrpD family protein [Phycisphaerales bacterium] | diamond | 324 | 49.3 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Phycisphaerae | Phycisphaerales | Phycisphaerales bacterium | |||
| 32427285 | 32427285 | PRJNA909412_P_NODE_1239_length_502_cov_3.231102_g1100_i0 | PRJNA909412 | 1239 | 502 | 3.231102 | 16.22013204 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 171 | 1.12e-48 | NR | MCD6378656.1 | 2026780 | g1100 | i0 | 52.5 | 1.91235059760956 | 160 | 75 | 95 | 1 | 486 | 10 | 84 | 243 | MCD6378656.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetota bacterium] | diamond | 960 | 171 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota 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);;