contig_metadata
5 rows where analysis = "diamond", bioproject = "PRJNA330616" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28116770 | 28116770 | PRJNA330616_P_NODE_18465_length_196_cov_1.102041_g18056_i0 | PRJNA330616 | 18465 | 196 | 1.102041 | 2.16000036 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 90.5 | 1.29e-19 | NR | QHJ81265.1 | 2832643 | g18056 | i0 | 69.8 | 3.85714285714286 | 63 | 19 | 96.4 | 0 | 2 | 190 | 263 | 325 | QHJ81265.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 756 | 90.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30137402 | 30137402 | PRJNA330616_P_NODE_19512_length_191_cov_1.077465_g19103_i0 | PRJNA330616 | 19512 | 191 | 1.077465 | 2.05795815 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 84.3 | 3.87e-19 | NR | AXF51945.1 | 2832643 | g19103 | i0 | 76.5 | 0.801047120418848 | 51 | 12 | 80.1 | 0 | 37 | 189 | 1 | 51 | AXF51945.1 MAG: tail assembly chaperone [Caudoviricetes sp.] | diamond | 153 | 84.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31306877 | 31306877 | PRJNA330616_P_NODE_13775_length_224_cov_1.268571_g13366_i0 | PRJNA330616 | 13775 | 224 | 1.268571 | 2.84159904 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 99.4 | 7.08e-25 | NR | AXF51962.1 | 2832643 | g13366 | i0 | 84.5 | 0.776785714285714 | 58 | 9 | 77.7 | 0 | 3 | 176 | 64 | 121 | AXF51962.1 MAG: protein of unknown function DUF3168 [Caudoviricetes sp.] | diamond | 174 | 99.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31907896 | 31907896 | PRJNA330616_P_NODE_13677_length_225_cov_1.159091_g13268_i0 | PRJNA330616 | 13677 | 225 | 1.159091 | 2.60795475 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.5 | 2.1e-23 | NR | AXF51951.1 | 2832643 | g13268 | i0 | 93.8 | 0.64 | 48 | 3 | 64 | 0 | 146 | 3 | 1 | 48 | AXF51951.1 MAG: HNHc protein [Caudoviricetes sp.] | diamond | 144 | 95.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31939422 | 31939422 | PRJNA330616_P_NODE_31077_length_162_cov_0.902655_g30668_i0 | PRJNA330616 | 31077 | 162 | 0.902655 | 1.4623011 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 105 | 1.37e-24 | NR | DAV09132.1 | 2832643 | g30668 | i0 | 90.7 | 1 | 54 | 5 | 100 | 0 | 162 | 1 | 267 | 320 | DAV09132.1 MAG TPA: Portal protein [Caudoviricetes sp.] | diamond | 162 | 105 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes 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);;