contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA857857" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27687302 | 27687302 | PRJNA857857_P_NODE_49644_length_242_cov_0.911243_g49195_i0 | PRJNA857857 | 49644 | 242 | 0.911243 | 2.20520806 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 77 | 3.17e-14 | NR | CAB4196488.1 | 2100421 | g49195 | i0 | 53.3 | 1.95867768595041 | 75 | 34 | 91.7 | 1 | 224 | 3 | 534 | 608 | CAB4196488.1 Parallel beta-helix repeat [uncultured Caudovirales phage] | diamond | 474 | 77 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27971024 | 27971024 | PRJNA857857_P_NODE_32645_length_269_cov_1.178571_g32196_i0 | PRJNA857857 | 32645 | 269 | 1.178571 | 3.17035599 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 119 | 1.64e-29 | NR | CAB4197062.1 | 2100421 | g32196 | i0 | 66.7 | 1.92936802973978 | 84 | 28 | 93.7 | 0 | 269 | 18 | 148 | 231 | CAB4197062.1 Intein C-terminal splicing region [uncultured Caudovirales phage] | diamond | 519 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29486401 | 29486401 | PRJNA857857_P_NODE_52130_length_241_cov_0.916667_g51681_i0 | PRJNA857857 | 52130 | 241 | 0.916667 | 2.20916747 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 123 | 3.2699999999999995e-31 | NR | CAB4131239.1 | 2100421 | g51681 | i0 | 70.3 | 2.76348547717842 | 74 | 22 | 92.1 | 0 | 241 | 20 | 133 | 206 | CAB4131239.1 COG3969 Predicted phosphoadenosine phosphosulfate sulfotransferase [uncultured Caudovirales phage] | diamond | 666 | 123 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29991964 | 29991964 | PRJNA857857_P_NODE_50691_length_242_cov_0.899408_g50242_i0 | PRJNA857857 | 50691 | 242 | 0.899408 | 2.17656736 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 71.6 | 2.47e-12 | NR | DAT50809.1 | 2832643 | g50242 | i0 | 73.3 | 1.11570247933884 | 45 | 12 | 55.8 | 0 | 108 | 242 | 1 | 45 | DAT50809.1 MAG TPA: minor tail protein [Caudoviricetes sp.] | diamond | 270 | 71.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32331721 | 32331721 | PRJNA857857_P_NODE_40959_length_248_cov_0.880000_g40510_i0 | PRJNA857857 | 40959 | 248 | 0.88 | 2.1824 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 98.6 | 2.37e-22 | NR | CAB4138111.1 | 2100421 | g40510 | i0 | 55 | 0.967741935483871 | 80 | 36 | 96.8 | 0 | 245 | 6 | 174 | 253 | CAB4138111.1 hypothetical protein UFOVP328_304 [uncultured Caudovirales phage] | diamond | 240 | 98.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32836193 | 32836193 | PRJNA857857_P_NODE_48520_length_243_cov_0.905882_g48071_i0 | PRJNA857857 | 48520 | 243 | 0.905882 | 2.20129326 | Roseobacter phage RDJL Phi 1 | 562742 | Viruses | Viruses | 92.4 | 4.9e-20 | NR | YP_004421853.1 | 562742 | g48071 | i0 | 60 | 0.925925925925926 | 75 | 30 | 92.6 | 0 | 19 | 243 | 162 | 236 | YP_004421853.1 ribonuclease III [Roseobacter phage RDJL Phi 1] | diamond | 225 | 92.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Xiamenvirus | Xiamenvirus RDJL1 |
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);;