contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJDB9741" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4809760 | 4809760 | PRJDB9741_P_NODE_304_length_1585_cov_3.732422_g208_i0 | PRJDB9741 | 304 | 1585 | 3.732422 | 59.1588887 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 844 | 2.88e-305 | NR | MDR3405335.1 | 2510640 | g208 | i0 | 88.6 | 0.878233438485804 | 464 | 53 | 87.8 | 0 | 61 | 1452 | 1 | 464 | MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.] | diamond | 1392 | 844 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 27221947 | 27221947 | PRJDB9741_P_NODE_20083_length_178_cov_1.193798_g19766_i0 | PRJDB9741 | 20083 | 178 | 1.193798 | 2.12496044 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 62 | 2.42e-9 | NR | HEV7404525.1 | 2811408 | g19766 | i0 | 55.2 | 0.97752808988764 | 58 | 26 | 97.8 | 0 | 176 | 3 | 586 | 643 | HEV7404525.1 DUF1549 domain-containing protein [Chthoniobacteraceae bacterium] | diamond | 174 | 62 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 27790797 | 27790797 | PRJDB9741_P_NODE_26904_length_167_cov_2.050847_g26587_i0 | PRJDB9741 | 26904 | 167 | 2.050847 | 3.42491449 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 51.6 | 9.9e-6 | NR | MBK8092153.1 | 2026800 | g26587 | i0 | 87.1 | 0.55688622754491 | 31 | 4 | 55.7 | 0 | 75 | 167 | 630 | 660 | MBK8092153.1 protein kinase [Verrucomicrobiaceae bacterium] | diamond | 93 | 51.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28864130 | 28864130 | PRJDB9741_P_NODE_42428_length_154_cov_3.523810_g42111_i0 | PRJDB9741 | 42428 | 154 | 3.52381 | 5.4266674 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 40.4 | 0.0342 | NR | HEX3730387.1 | 2006848 | g42111 | i0 | 34.7 | 0.954545454545455 | 49 | 31 | 95.5 | 1 | 8 | 154 | 8 | 55 | HEX3730387.1 hypothetical protein [Opitutaceae bacterium] | diamond | 147 | 40.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 29053760 | 29053760 | PRJDB9741_P_NODE_13848_length_189_cov_1.107143_g13531_i0 | PRJDB9741 | 13848 | 189 | 1.107143 | 2.09250027 | Opitutus sp. | 1913982 | Bacteria | Bacteria | 43.9 | 0.00709 | NR | MBA3849253.1 | 1913982 | g13531 | i0 | 40.7 | 2.73015873015873 | 59 | 35 | 93.7 | 0 | 179 | 3 | 325 | 383 | MBA3849253.1 sugar tyrosine-protein kinase [Opitutus sp.] | diamond | 516 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 30506522 | 30506522 | PRJDB9741_P_NODE_30553_length_166_cov_0.871795_g30236_i0 | PRJDB9741 | 30553 | 166 | 0.871795 | 1.4471797 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 75.1 | 2.62e-14 | NR | MEN9402104.1 | 2026799 | g30236 | i0 | 69.8 | 1.8433734939759 | 53 | 16 | 95.8 | 0 | 161 | 3 | 147 | 199 | MEN9402104.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 306 | 75.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31169729 | 31169729 | PRJDB9741_P_NODE_27595_length_167_cov_0.864407_g27278_i0 | PRJDB9741 | 27595 | 167 | 0.864407 | 1.44355969 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 50.1 | 3.45e-5 | NR | HUL54344.1 | 2006848 | g27278 | i0 | 70.4 | 0.48502994011976 | 27 | 8 | 48.5 | 0 | 85 | 165 | 8 | 34 | HUL54344.1 phosphoenolpyruvate carboxykinase (GTP) [Opitutaceae bacterium] | diamond | 81 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 32119056 | 32119056 | PRJDB9741_P_NODE_19518_length_179_cov_1.176923_g19201_i0 | PRJDB9741 | 19518 | 179 | 1.176923 | 2.10669217 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 92.4 | 1.34e-20 | NR | HUR41831.1 | 2499141 | g19201 | i0 | 78 | 4.94413407821229 | 59 | 13 | 98.9 | 0 | 1 | 177 | 214 | 272 | HUR41831.1 malate dehydrogenase [Verrucomicrobiia bacterium] | diamond | 885 | 92.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32213926 | 32213926 | PRJDB9741_P_NODE_25318_length_170_cov_1.247934_g25001_i0 | PRJDB9741 | 25318 | 170 | 1.247934 | 2.1214878 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 87 | 3.41e-18 | NR | MCE2862490.1 | 2006848 | g25001 | i0 | 69.8 | 2.82352941176471 | 53 | 16 | 93.5 | 0 | 6 | 164 | 242 | 294 | MCE2862490.1 sialate O-acetylesterase [Opitutaceae bacterium] | diamond | 480 | 87 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae 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);;