contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA928559" and tax_kingdom = "Loebvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27150767 | 27150767 | PRJNA928559_P_NODE_153102_length_284_cov_3.260664_g151533_i0 | PRJNA928559 | 153102 | 284 | 3.260664 | 9.26028576 | Inoviridae sp. | 2219103 | Viruses | Viruses | 74.7 | 1.2e-14 | NR | XOF04344.1 | 2219103 | g151533 | i0 | 50.6 | 0.834507042253521 | 79 | 39 | 83.5 | 0 | 28 | 264 | 1 | 79 | XOF04344.1 MAG: hypothetical protein [Inoviridae sp.] | diamond | 237 | 74.7 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 28288013 | 28288013 | PRJNA928559_P_NODE_219146_length_235_cov_2.938272_g217577_i0 | PRJNA928559 | 219146 | 235 | 2.938272 | 6.9049392 | Inoviridae sp. | 2219103 | Viruses | Viruses | 59.3 | 6.63e-9 | NR | XOF04344.1 | 2219103 | g217577 | i0 | 60 | 0.446808510638298 | 35 | 14 | 44.7 | 0 | 1 | 105 | 99 | 133 | XOF04344.1 MAG: hypothetical protein [Inoviridae sp.] | diamond | 105 | 59.3 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 28414643 | 28414643 | PRJNA928559_P_NODE_97646_length_361_cov_1.298611_g96077_i0 | PRJNA928559 | 97646 | 361 | 1.298611 | 4.68798571 | Inoviridae sp. | 2219103 | Viruses | Viruses | 66.2 | 3.66e-11 | NR | XOE96096.1 | 2219103 | g96077 | i0 | 56.1 | 0.947368421052632 | 57 | 25 | 47.4 | 0 | 173 | 3 | 1 | 57 | XOE96096.1 MAG: transcriptional regulator [Inoviridae sp.] | diamond | 342 | 66.2 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 29898607 | 29898607 | PRJNA928559_P_NODE_75411_length_407_cov_1.937126_g73842_i0 | PRJNA928559 | 75411 | 407 | 1.937126 | 7.88410282 | Tubulavirales sp. | 2833306 | Viruses | Viruses | 96.3 | 3.53e-20 | NR | XOE94303.1 | 2833306 | g73842 | i0 | 57.5 | 0.987714987714988 | 134 | 55 | 98.8 | 2 | 407 | 6 | 105 | 236 | XOE94303.1 MAG: hypothetical protein [Tubulavirales sp.] | diamond | 402 | 96.3 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Tubulavirales sp. | ||||
| 31889586 | 31889586 | PRJNA928559_P_NODE_125397_length_317_cov_3.831967_g123828_i0 | PRJNA928559 | 125397 | 317 | 3.831967 | 12.14733539 | Inoviridae sp. | 2219103 | Viruses | Viruses | 66.2 | 3.18e-11 | NR | XOF02953.1 | 2219103 | g123828 | i0 | 48.8 | 0.757097791798107 | 80 | 41 | 75.7 | 0 | 315 | 76 | 25 | 104 | XOF02953.1 MAG: hypothetical protein [Inoviridae sp.] | diamond | 240 | 66.2 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 32554489 | 32554489 | PRJNA928559_P_NODE_163099_length_274_cov_2.935323_g161530_i0 | PRJNA928559 | 163099 | 274 | 2.935323 | 8.04278502 | Inoviridae sp. | 2219103 | Viruses | Viruses | 153 | 6.34e-43 | NR | XOF00691.1 | 2219103 | g161530 | i0 | 87.2 | 0.854014598540146 | 78 | 10 | 85.4 | 0 | 274 | 41 | 78 | 155 | XOF00691.1 MAG: Zot-like toxin [Inoviridae sp.] | diamond | 234 | 153 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae 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);;