contig_metadata
7 rows where bioproject = "PRJNA635397", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24105594 | 24105594 | PRJNA635397_P_NODE_19419_length_367_cov_1.363946_g18965_i0 | PRJNA635397 | 19419 | 367 | 1.363946 | 5.00568182 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 65.9 | 2.07e-11 | NR | RYD71399.1 | 2026800 | g18965 | i0 | 50.7 | 0.596730245231608 | 73 | 36 | 59.7 | 0 | 262 | 44 | 6 | 78 | RYD71399.1 MAG: hypothetical protein EOP84_24950, partial [Verrucomicrobiaceae bacterium] | diamond | 219 | 65.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 26891355 | 26891355 | PRJNA635397_P_NODE_40941_length_250_cov_0.870056_g40487_i0 | PRJNA635397 | 40941 | 250 | 0.870056 | 2.17514 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 62.4 | 4.89e-9 | NR | MEI6343602.1 | 2026799 | g40487 | i0 | 47.5 | 0.732 | 61 | 26 | 70.8 | 2 | 249 | 73 | 202 | 258 | MEI6343602.1 glycosyltransferase [Verrucomicrobiota bacterium] | diamond | 183 | 62.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27965262 | 27965262 | PRJNA635397_P_NODE_36205_length_263_cov_1.368421_g35751_i0 | PRJNA635397 | 36205 | 263 | 1.368421 | 3.59894723 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 112 | 1.15e-26 | NR | MDZ4742534.1 | 2026799 | g35751 | i0 | 64.6 | 1.87072243346008 | 82 | 29 | 93.5 | 0 | 262 | 17 | 94 | 175 | MDZ4742534.1 thiamine pyrophosphate-binding protein [Verrucomicrobiota bacterium] | diamond | 492 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28565250 | 28565250 | PRJNA635397_P_NODE_32927_length_276_cov_2.024631_g32473_i0 | PRJNA635397 | 32927 | 276 | 2.024631 | 5.58798156 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 152 | 2.2499999999999993e-43 | NR | RYD69104.1 | 2026800 | g32473 | i0 | 84.6 | 0.989130434782609 | 91 | 14 | 98.9 | 0 | 274 | 2 | 138 | 228 | RYD69104.1 MAG: MFS transporter, partial [Verrucomicrobiaceae bacterium] | diamond | 273 | 152 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 29998826 | 29998826 | PRJNA635397_P_NODE_39091_length_253_cov_0.866667_g38637_i0 | PRJNA635397 | 39091 | 253 | 0.866667 | 2.19266751 | Bacteria | 2 | Bacteria | Bacteria | 123 | 2.3e-31 | NR | PYJ03686.1 | 2026799 | g38637 | i0 | 73.5 | 3.88932806324111 | 83 | 22 | 98.4 | 0 | 3 | 251 | 141 | 223 | PYJ03686.1 MAG: hypothetical protein DME25_11515 [Verrucomicrobiota bacterium] | diamond | 984 | 124 | 0.991935483870968 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30365735 | 30365735 | PRJNA635397_P_NODE_8832_length_601_cov_1.886364_g8385_i0 | PRJNA635397 | 8832 | 601 | 1.886364 | 11.33704764 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 205 | 1.07e-61 | NR | RYD65414.1 | 2026800 | g8385 | i0 | 78.7 | 0.608985024958403 | 122 | 26 | 60.9 | 0 | 2 | 367 | 199 | 320 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 366 | 205 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30681026 | 30681026 | PRJNA635397_P_NODE_35313_length_266_cov_2.253886_g34859_i0 | PRJNA635397 | 35313 | 266 | 2.253886 | 5.99533676 | Limisphaera sp. | 2838792 | Bacteria | Bacteria | 43.5 | 0.0253 | NR | MEJ5238961.1 | 2838792 | g34859 | i0 | 32.5 | 0.93609022556391 | 83 | 55 | 93.6 | 1 | 14 | 262 | 135 | 216 | MEJ5238961.1 FIST N-terminal domain-containing protein [Limisphaera sp.] | diamond | 249 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Limisphaeraceae | Limisphaera | Limisphaera sp. |
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);;