contig_metadata
8 rows where bioproject = "PRJNA611476", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26605225 | 26605225 | PRJNA611476_P_NODE_98021_length_246_cov_0.890173_g97230_i0 | PRJNA611476 | 98021 | 246 | 0.890173 | 2.18982558 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 147 | 3.2699999999999998e-40 | NR | MBQ6926561.1 | 2212473 | g97230 | i0 | 82.7 | 0.98780487804878 | 81 | 14 | 98.8 | 0 | 245 | 3 | 168 | 248 | MBQ6926561.1 AAA family ATPase [Kiritimatiellia bacterium] | diamond | 243 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 27648999 | 27648999 | PRJNA611476_P_NODE_89004_length_249_cov_0.863636_g88213_i0 | PRJNA611476 | 89004 | 249 | 0.863636 | 2.15045364 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 133 | 6.38e-34 | NR | MBR4251783.1 | 2212473 | g88213 | i0 | 72 | 0.987951807228916 | 82 | 23 | 98.8 | 0 | 247 | 2 | 523 | 604 | MBR4251783.1 endonuclease [Kiritimatiellia bacterium] | diamond | 246 | 133 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28059285 | 28059285 | PRJNA611476_P_NODE_82585_length_250_cov_0.870056_g81794_i0 | PRJNA611476 | 82585 | 250 | 0.870056 | 2.17514 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 47.4 | 9.47e-4 | NR | MBR1836912.1 | 2212473 | g81794 | i0 | 35.8 | 1.584 | 67 | 38 | 74.4 | 2 | 229 | 44 | 201 | 267 | MBR1836912.1 ATP-binding protein [Kiritimatiellia bacterium] | diamond | 396 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 28704008 | 28704008 | PRJNA611476_P_NODE_36307_length_349_cov_1.673913_g35516_i0 | PRJNA611476 | 36307 | 349 | 1.673913 | 5.84195637 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47 | 0.0041 | NR | MBQ3809287.1 | 2212473 | g35516 | i0 | 34.4 | 2.24355300859599 | 93 | 50 | 79.1 | 3 | 280 | 5 | 371 | 453 | MBQ3809287.1 DUF2341 domain-containing protein [Kiritimatiellia bacterium] | diamond | 783 | 47.4 | 0.991561181434599 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29258846 | 29258846 | PRJNA611476_P_NODE_116989_length_241_cov_0.916667_g116198_i0 | PRJNA611476 | 116989 | 241 | 0.916667 | 2.20916747 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 42.7 | 0.0374 | NR | MCS6770401.1 | 2212473 | g116198 | i0 | 50 | 0.448132780082988 | 36 | 18 | 44.8 | 0 | 109 | 2 | 187 | 222 | MCS6770401.1 Ig-like domain-containing protein [Kiritimatiellia bacterium] | diamond | 108 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 29479872 | 29479872 | PRJNA611476_P_NODE_84970_length_250_cov_0.870056_g84179_i0 | PRJNA611476 | 84970 | 250 | 0.870056 | 2.17514 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 98.6 | 2.69e-23 | NR | MCQ2390878.1 | 2212473 | g84179 | i0 | 75.4 | 0.732 | 61 | 15 | 73.2 | 0 | 67 | 249 | 4 | 64 | MCQ2390878.1 deoxyribose-phosphate aldolase [Kiritimatiellia bacterium] | diamond | 183 | 98.6 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 30333385 | 30333385 | PRJNA611476_P_NODE_106812_length_244_cov_0.900585_g106021_i0 | PRJNA611476 | 106812 | 244 | 0.900585 | 2.1974274 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 110 | 5.31e-26 | NR | MBQ6914916.1 | 2212473 | g106021 | i0 | 70 | 0.983606557377049 | 80 | 24 | 98.4 | 0 | 3 | 242 | 664 | 743 | MBQ6914916.1 hypothetical protein [Kiritimatiellia bacterium] | diamond | 240 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Kiritimatiellota | Kiritimatiellia | Kiritimatiellia bacterium | ||||
| 32546601 | 32546601 | PRJNA611476_P_NODE_99999_length_246_cov_0.878613_g99208_i0 | PRJNA611476 | 99999 | 246 | 0.878613 | 2.16138798 | Kiritimatiellia bacterium | 2212473 | Bacteria | Bacteria | 152 | 8.119999999999999e-43 | NR | MBQ3808990.1 | 2212473 | g99208 | i0 | 86.4 | 0.98780487804878 | 81 | 11 | 98.8 | 0 | 244 | 2 | 11 | 91 | MBQ3808990.1 glycosyltransferase family 4 protein [Kiritimatiellia bacterium] | diamond | 243 | 152 | 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);;