contig_metadata
9 rows where bioproject = "PRJNA1011844", tax_clade = "PVC group" and tax_phylum = "Kiritimatiellota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 157830 | 157830 | PRJNA1011844_P_NODE_87721_length_367_cov_7.231293_g79170_i0 | PRJNA1011844 | 87721 | 367 | 7.231293 | 26.53884531 | Kiritimatiellales bacterium | 2202731 | Bacteria | Bacteria | 52.8 | 0.035 | NTclustered | gi|1395159884|emb|LS478214.1| | 2202731 | g79170 | i0 | 100 | 0.0762942779291553 | 28 | 0 | 8 | 0 | 153 | 180 | 54 | 81 | Kiritimatiellales bacterium PDESU_01228 gene for sulfatase S1_27, strain F1 | blastn | 28 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellales | Kiritimatiellales bacterium | |||
| 27477142 | 27477142 | PRJNA1011844_P_NODE_166523_length_233_cov_12.625000_g157942_i0 | PRJNA1011844 | 166523 | 233 | 12.625 | 29.41625 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 44.3 | 0.00929 | NR | MBR1836084.1 | 2212473 | g157942 | i0 | 47.7 | 0.566523605150215 | 44 | 23 | 56.7 | 0 | 20 | 151 | 224 | 267 | MBR1836084.1 serine/threonine protein kinase [Kiritimatiellia bacterium] | diamond | 132 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28740215 | 28740215 | PRJNA1011844_P_NODE_64587_length_490_cov_8.424460_g56166_i0 | PRJNA1011844 | 64587 | 490 | 8.42446 | 41.279854 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 57 | 3.83e-6 | NR | MFT7518607.1 | 2212473 | g56166 | i0 | 34.1 | 1.61020408163265 | 132 | 67 | 77.8 | 5 | 477 | 97 | 191 | 307 | MFT7518607.1 glyoxylase-like metal-dependent hydrolase (beta-lactamase superfamily II) [Kiritimatiellia bacterium] | diamond | 789 | 57 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29087622 | 29087622 | PRJNA1011844_P_NODE_27088_length_1032_cov_13.714286_g12149_i1 | PRJNA1011844 | 27088 | 1032 | 13.714286 | 141.53143152 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 58.2 | 2.91e-5 | NR | MBQ6925387.1 | 2212473 | g12149 | i1 | 29.2 | 0.755813953488372 | 260 | 145 | 67.4 | 12 | 697 | 2 | 105 | 353 | MBQ6925387.1 leucine-rich repeat domain-containing protein [Kiritimatiellia bacterium] | diamond | 780 | 58.2 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30635012 | 30635012 | PRJNA1011844_P_NODE_96213_length_338_cov_3.867925_g87650_i0 | PRJNA1011844 | 96213 | 338 | 3.867925 | 13.0735865 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 44.3 | 0.0298 | NR | MBO7482391.1 | 2212473 | g87650 | i0 | 31 | 0.772189349112426 | 87 | 54 | 71.9 | 2 | 41 | 283 | 309 | 395 | MBO7482391.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 261 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30658964 | 30658964 | PRJNA1011844_P_NODE_108393_length_306_cov_5.184549_g99820_i0 | PRJNA1011844 | 108393 | 306 | 5.184549 | 15.86471994 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 124 | 1.78e-31 | NR | MDD4736365.1 | 2212473 | g99820 | i0 | 60.2 | 2.86274509803922 | 98 | 38 | 95.1 | 1 | 294 | 4 | 209 | 306 | MDD4736365.1 phosphatidylserine decarboxylase family protein [Kiritimatiellia bacterium] | diamond | 876 | 125 | 0.992 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31773090 | 31773090 | PRJNA1011844_P_NODE_44277_length_698_cov_4.844800_g36248_i0 | PRJNA1011844 | 44277 | 698 | 4.8448 | 33.816704 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 63.9 | 9.27e-8 | NR | HMP76048.1 | 2212473 | g36248 | i0 | 33.1 | 1.43553008595989 | 121 | 78 | 50.7 | 1 | 334 | 687 | 343 | 463 | HMP76048.1 adenylate/guanylate cyclase domain-containing protein [Kiritimatiellia bacterium] | diamond | 1002 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 31931263 | 31931263 | PRJNA1011844_P_NODE_54977_length_572_cov_10.705411_g46642_i0 | PRJNA1011844 | 54977 | 572 | 10.705411 | 61.23495092 | Pontiella sp. | 2837462 | Bacteria | Bacteria | 52.8 | 2.45e-4 | NR | WP_372809055.1 | 2837462 | g46642 | i0 | 47.6 | 0.660839160839161 | 63 | 30 | 33 | 1 | 552 | 364 | 234 | 293 | WP_372809055.1 mucoidy inhibitor MuiA family protein, partial [Pontiella sp.] | diamond | 378 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellales | Pontiellaceae | Pontiella | Pontiella sp. | |
| 32847397 | 32847397 | PRJNA1011844_P_NODE_107520_length_309_cov_1.038136_g98947_i0 | PRJNA1011844 | 107520 | 309 | 1.038136 | 3.20784024 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 49.3 | 4.06e-4 | NR | MBQ6010307.1 | 2212473 | g98947 | i0 | 51.1 | 1.18446601941748 | 45 | 21 | 42.7 | 1 | 138 | 7 | 132 | 176 | MBQ6010307.1 protein kinase [Kiritimatiellia bacterium] | diamond | 366 | 49.3 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia 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);;