contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA811725" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5913363 | 5913363 | PRJNA811725_P_NODE_28245_length_291_cov_1.573394_g27999_i0 | PRJNA811725 | 28245 | 291 | 1.573394 | 4.57857654 | Meadowvirus AH04 | 3060193 | Viruses | Viruses | 217 | 9.03e-52 | NTclustered | gi|2438095778|ref|NC_070952.1| | 2869569 | g27999 | i0 | 84.071 | 2.02061855670103 | 226 | 34 | 77 | 2 | 67 | 291 | 242527 | 242303 | Erwinia phage AH04, complete genome | blastn | 588 | 217 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Meadowvirus | Meadowvirus AH04 | |||
| 13563620 | 13563620 | PRJNA811725_P_NODE_32391_length_273_cov_1.540000_g32145_i0 | PRJNA811725 | 32391 | 273 | 1.54 | 4.2042 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 353 | 6.14e-93 | NTclustered | gi|2053058458|tpg|BK024596.1| | 2832643 | g32145 | i0 | 90.11 | 57.2454212454212 | 273 | 26 | 100 | 1 | 1 | 273 | 5363 | 5092 | MAG TPA_asm: Caudoviricetes sp. isolate ctaIB11, partial genome | blastn | 15628 | 353 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13977894 | 13977894 | PRJNA811725_P_NODE_32451_length_273_cov_1.210000_g32205_i0 | PRJNA811725 | 32451 | 273 | 1.21 | 3.3033 | Viruses | 10239 | Viruses | Viruses | 377 | 3.64e-100 | NTclustered | gi|2067460891|gb|MW677512.1| | 2835969 | g32205 | i0 | 91.667 | 10.6263736263736 | 276 | 17 | 100 | 4 | 1 | 273 | 41822 | 41550 | Rhodobacter phage RcFrancesLouise, complete genome | blastn | 2901 | 377 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhodobacter phage RcFrancesLouise | |||||
| 14838152 | 14838152 | PRJNA811725_P_NODE_27152_length_296_cov_3.417040_g26906_i0 | PRJNA811725 | 27152 | 296 | 3.41704 | 10.1144384 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 143 | 1.59e-29 | NTclustered | gi|2914852300|gb|OR221708.1| | 2832643 | g26906 | i0 | 95.506 | 2.61824324324324 | 89 | 4 | 49 | 0 | 133 | 221 | 27661 | 27573 | MAG: Caudoviricetes sp. isolate MSP1326 genomic sequence | blastn | 775 | 143 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19936669 | 19936669 | PRJNA811725_P_NODE_30816_length_281_cov_1.269231_g30570_i0 | PRJNA811725 | 30816 | 281 | 1.269231 | 3.56653911 | Rhodobacter phage RcKvothe | 2970517 | Viruses | Viruses | 385 | 2.25e-102 | NTclustered | gi|2284663167|gb|OP009275.1| | 2970517 | g30570 | i0 | 91.697 | 9.8576512455516 | 277 | 23 | 99 | 0 | 5 | 281 | 20077 | 19801 | Rhodobacter phage RcKvothe, complete genome | blastn | 2770 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhodobacter phage RcKvothe | |||||
| 23762614 | 23762614 | PRJNA811725_P_NODE_37199_length_249_cov_0.875000_g36953_i0 | PRJNA811725 | 37199 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 270 | 5.72e-68 | NTclustered | gi|2056947620|tpg|BK022619.1| | 2832643 | g36953 | i0 | 89.352 | 1.85542168674699 | 216 | 21 | 86 | 2 | 1 | 215 | 13677 | 13463 | MAG TPA_asm: Caudoviricetes sp. isolate ctY7F3, partial genome | blastn | 462 | 270 | 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);;