contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJEB29441" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27033200 | 27033200 | PRJEB29441_P_NODE_30682_length_189_cov_1.450000_g30241_i0 | PRJEB29441 | 30682 | 189 | 1.45 | 2.7405 | Flavobacterium phage vB_FspP_elemoA_7-9A | 2743781 | Viruses | Viruses | 85.1 | 7.59e-20 | NR | YP_010108879.1 | 2743781 | g30241 | i0 | 72.6 | 0.984126984126984 | 62 | 17 | 98.4 | 0 | 2 | 187 | 21 | 82 | YP_010108879.1 hypothetical protein KNV10_gp49 [Flavobacterium phage vB_FspP_elemoA_7-9A] | diamond | 186 | 85.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Elemovirus | Elemovirus elemoA | ||||
| 28043998 | 28043998 | PRJEB29441_P_NODE_27465_length_200_cov_1.688742_g27024_i0 | PRJEB29441 | 27465 | 200 | 1.688742 | 3.377484 | Pseudomonas phage vB_PaeM_USP_18 | 2743937 | Viruses | Viruses | 49.7 | 4.15e-6 | NR | QLI49465.1 | 2743937 | g27024 | i0 | 57.4 | 0.705 | 47 | 20 | 70.5 | 0 | 169 | 29 | 12 | 58 | QLI49465.1 hypothetical protein vBPaeMUSP18_64 [Pseudomonas phage vB_PaeM_USP_18] | diamond | 141 | 49.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage vB_PaeM_USP_18 | |||||
| 28549387 | 28549387 | PRJEB29441_P_NODE_40267_length_166_cov_0.871795_g39826_i0 | PRJEB29441 | 40267 | 166 | 0.871795 | 1.4471797 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 45.1 | 3.33e-4 | NR | CAB4135515.1 | 2100421 | g39826 | i0 | 67.9 | 0.506024096385542 | 28 | 9 | 50.6 | 0 | 1 | 84 | 59 | 86 | CAB4135515.1 HNHc domain containing protein [uncultured Caudovirales phage] | diamond | 84 | 45.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29432941 | 29432941 | PRJEB29441_P_NODE_43390_length_164_cov_0.886957_g42949_i0 | PRJEB29441 | 43390 | 164 | 0.886957 | 1.45460948 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 47.8 | 5.32e-5 | NR | CAB4154580.1 | 2100421 | g42949 | i0 | 84 | 0.457317073170732 | 25 | 4 | 45.7 | 0 | 70 | 144 | 93 | 117 | CAB4154580.1 hypothetical protein UFOVP651_12 [uncultured Caudovirales phage] | diamond | 75 | 47.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31392260 | 31392260 | PRJEB29441_P_NODE_39576_length_167_cov_0.864407_g39135_i0 | PRJEB29441 | 39576 | 167 | 0.864407 | 1.44355969 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 72 | 6.31e-13 | NR | CAB4128986.1 | 2100421 | g39135 | i0 | 61 | 1.58083832335329 | 41 | 16 | 73.7 | 0 | 135 | 13 | 1239 | 1279 | CAB4128986.1 hypothetical protein UFOVP112_119 [uncultured Caudovirales phage] | diamond | 264 | 72 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31487171 | 31487171 | PRJEB29441_P_NODE_21576_length_228_cov_1.139665_g21135_i0 | PRJEB29441 | 21576 | 228 | 1.139665 | 2.5984362 | Leptolyngbya phage Lbo-JY46 | 3128135 | Viruses | Viruses | 86.3 | 1.31e-17 | NR | XAI97313.1 | 3128135 | g21135 | i0 | 56.2 | 0.960526315789474 | 73 | 32 | 96.1 | 0 | 3 | 221 | 196 | 268 | XAI97313.1 hypothetical protein [Leptolyngbya phage Lbo-JY46] | diamond | 219 | 86.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Leptolyngbya phage Lbo-JY46 | |||||
| 32018204 | 32018204 | PRJEB29441_P_NODE_38558_length_167_cov_1.728814_g38117_i0 | PRJEB29441 | 38558 | 167 | 1.728814 | 2.88711938 | Felixounavirus | 1198140 | Viruses | Viruses | 66.2 | 5.69e-12 | NR | YP_009621722.1 | 2060124 | g38117 | i0 | 47.1 | 4.63473053892216 | 51 | 27 | 91.6 | 0 | 1 | 153 | 12 | 62 | YP_009621722.1 HNH endonuclease [Salmonella phage BPS17W1] | diamond | 774 | 66.6 | 0.993993993993994 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Andersonviridae | Felixounavirus | Felixounavirus BPS17W1 |
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);;